No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
16 Posted Topics
 | I had c# application that has registration form and another from that user use to sigin in into my application i wonder how to check if user its register or not my login form has to textbox username and passpwrd and im trying this code i gusse its wrong can … |
| | hi all I had make this samll method to insert data from c# forms into my oracle database the code processed fine but when I go to sql developers software to check if the record has been inserted or not I found nothing... so whats wrong with it please thanks … |
| | hey all I just need someone who can explian to me what the ESCAPE keyword does here ?? nd what the deference if I remove it ?? SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA\_%' ESCAPE ''; note working on the sample database SQL developers  |
| | hey all Im using SQL Developers version 1.1.3 and I want to totally remove it I sareched alot about an offical way to remove it but I found veryone remove its folder so I go though it but now when I want to install the software agian... I am getting …  |
| | I made that small project that contains this small database and I want to know how I can get data form this small database using the primary key (Student ID) [here is screenshot for my database table ](http://www.4shared.com/photo/8bS4gVZ9/Capture.html?) [and here is screenshot for the find form ](http://www.4shared.com/photo/ICP8DUKZ/Capture1.html?) anyone can point … |
| | I create small database and I want to show all information about the students when a techer enter Students ID I caret my database using visual studio 2008 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim constr as new OleDb.OleDbConnection constr.ConnectionString = "Provider=localhost;data source=C:\USERS\USER\DOCUMENTS\VISUAL STUDIO …  |
| | hi all I want to write a visual C# programs that delete all files and folders in specific directory but leave the parents directory like temp file C:\Users\user\AppData\Local\Temp MSN cache C:\Users\user\AppData\Local\Microsoft\Windows Live\Contacts etc etc... but I need some help I had read the msdn library http://msdn.microsoft.com/en-us/library/fxeahc5f.aspx anyone could help me …  |
| | I used these two queries for this database and the resutl was the same in both case so what the purpose of "persons.firstname" or "orders.ordername" what the difference ?? select** persons.firstname**,orders.ordername from persons inner join orders on persons.p_id=orders.p_id select **firstname,ordername** from persons inner join orders on persons.p_id=orders.p_id CREATE TABLE Persons … |
| | I want to select persons who has orders =<150 tried this query but of course it wrong anyone can point me to the correct one ? using Oracle or SQL select firstname,cost from persons,orders where cost=100 group by firstname CREATE TABLE Persons ( P_Id int NOT NULL PRIMARY KEY, FirstName … |
| | Please everyone share a query for all as SQL Exercises 1. nested SQL statements  |
| | What I want to do is to select the orders that are hapened in 2001 ONLY which is "order3" here whats the SQL statment shlould be written HOW I can catch the year part from this full date ??? CREATE TABLE Persons ( P_Id int NOT NULL PRIMARY KEY, FirstName …  |
| | hey I have table that has date column and I want to select just all the sales that hapen in the first three month between 1/1/2012 to 30/3/2012 How I am able to do this select query ?? |
| | hi I need expliantion of Joins types and as much as example for it Thanks |
| | I did not really understand the benifit of the alias clause... this was in the w3shools tatourial with alias SELECT po.OrderID, p.LastName, p.FirstName FROM Persons AS p, Product_Orders AS po WHERE p.LastName='Hansen' AND p.FirstName='Ola' with out alias SELECT Product_Orders.OrderID, Persons.LastName, Persons.FirstName FROM Persons, Product_Orders WHERE Persons.LastName='Hansen' AND Persons.FirstName='Ola' why we … |
| | I have test to get a job in banking anyone cloud give me something could help me ? the position is about doing some query on database the exam will foucs on SQL help in nested SQL statements like nested select ? whats tuning ? put result into new table … |
| | this css file wont work on firefox and chrome but works fine on IE anyone can tell me why ? caption { color:#33CC00; font-style:bold; } p { font-family:"Times New Roman"; font-size:16px; text-align:center; } and here is the first HTML file that the caption class should works <html> <head> <link href="styles/mystyles.css" … |
The End.