Click here to Skip to main content
15,923,087 members
Home / Discussions / Database
   

Database

 
AnswerRe: Exception with Access Database on Windows Vista Pin
Jerry Hammond23-Aug-08 7:40
Jerry Hammond23-Aug-08 7:40 
Questionsql count Pin
bapu288923-Aug-08 3:49
bapu288923-Aug-08 3:49 
AnswerRe: sql count Pin
Mycroft Holmes23-Aug-08 23:05
professionalMycroft Holmes23-Aug-08 23:05 
GeneralRe: sql count Pin
bapu288923-Aug-08 23:24
bapu288923-Aug-08 23:24 
GeneralRe: sql count Pin
Blue_Boy24-Aug-08 10:10
Blue_Boy24-Aug-08 10:10 
AnswerRe: sql count Pin
NeverHeardOfMe24-Aug-08 11:42
NeverHeardOfMe24-Aug-08 11:42 
AnswerRe: sql count Pin
bapu288924-Aug-08 21:57
bapu288924-Aug-08 21:57 
Questionneed help with SQL Pin
Sujay chakraborty22-Aug-08 21:46
Sujay chakraborty22-Aug-08 21:46 
hello,

this is a sql statement that i m trying to use in a Window application in .NET.

query:
<pre>string selCmd = "SELECT eInfo.EmpID, eInfo.Name, lInfo.LeaveEnteredOn, lInfo.LeaveFrom, lInfo.LeaveTo, lInfo.LeaveType" +
"FROM lmsEmpInfo AS eInfo INNER JOIN lmsLeaveInfo AS lInfo ON lInfo.EmpID = eInfo.EmpID" +
"WHERE (lInfo.LeaveGranted = 0)";</pre>

the problem is this query works fine when i m running it on the SQL server management studio, but gives an error of "Incorrect syntax near AS", when i try to execute it with the following code:

<code>
SqlDataAdapter myAd = new SqlDataAdapter();
SqlConnection myCon = new SqlConnection();
DataSet myDs = new DataSet();
myCon.ConnectionString = Properties.Settings.Default.LeaveMgmtConnectionString.ToString();
myAd.SelectCommand = new SqlCommand(selCmd, myCon);
myAd.Fill(myDs, "Recent_Leaves");</code>

Please help me to rectify this mistake......... I would also like to have suggestions on
How can i change the entire row collection of a DataGridView with the SelectedIndexChange event of a combobox and that too according to query that is being fired at the same event

any help or assistance is greatly appreciated!!

regards
AnswerRe: need help with SQL Pin
www.Developerof.NET22-Aug-08 22:17
www.Developerof.NET22-Aug-08 22:17 
QuestionRe: need help with SQL Pin
Sujay chakraborty23-Aug-08 21:19
Sujay chakraborty23-Aug-08 21:19 
AnswerRe: need help with SQL Pin
Paul Conrad23-Aug-08 7:29
professionalPaul Conrad23-Aug-08 7:29 
GeneralRe: need help with SQL Pin
Kanniah23-Aug-08 20:22
Kanniah23-Aug-08 20:22 
GeneralRe: need help with SQL Pin
Pete O'Hanlon24-Aug-08 11:11
mvePete O'Hanlon24-Aug-08 11:11 
QuestionSQL query to copy table from one database into another database Pin
ankswe22-Aug-08 19:24
ankswe22-Aug-08 19:24 
AnswerRe: SQL query to copy table from one database into another database Pin
Mycroft Holmes22-Aug-08 19:41
professionalMycroft Holmes22-Aug-08 19:41 
GeneralRe: SQL query to copy table from one database into another database Pin
Jerry Hammond23-Aug-08 7:37
Jerry Hammond23-Aug-08 7:37 
GeneralRe: SQL query to copy table from one database into another database Pin
Mycroft Holmes23-Aug-08 13:48
professionalMycroft Holmes23-Aug-08 13:48 
QuestionConnecting to custom database [modified] Pin
ASPnoob22-Aug-08 17:31
ASPnoob22-Aug-08 17:31 
AnswerRe: Connecting to custom database Pin
Mycroft Holmes22-Aug-08 19:47
professionalMycroft Holmes22-Aug-08 19:47 
QuestionExpansion advice Pin
David Kalkwarf22-Aug-08 16:16
David Kalkwarf22-Aug-08 16:16 
AnswerRe: Expansion advice Pin
FyreWyrm22-Aug-08 18:01
FyreWyrm22-Aug-08 18:01 
GeneralRe: Expansion advice Pin
David Kalkwarf23-Aug-08 5:35
David Kalkwarf23-Aug-08 5:35 
AnswerRe: Expansion advice Pin
Mycroft Holmes22-Aug-08 19:58
professionalMycroft Holmes22-Aug-08 19:58 
GeneralRe: Expansion advice Pin
David Kalkwarf23-Aug-08 5:09
David Kalkwarf23-Aug-08 5:09 
GeneralRe: Expansion advice Pin
Mycroft Holmes23-Aug-08 13:46
professionalMycroft Holmes23-Aug-08 13:46 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.