Click here to Skip to main content
15,867,750 members
Home / Discussions / C#
   

C#

 
QuestionWhere to find .NET compatible languages? Pin
Zibar12-Oct-02 5:21
sussZibar12-Oct-02 5:21 
AnswerRe: Where to find .NET compatible languages? Pin
Stephane Rodriguez.12-Oct-02 9:57
Stephane Rodriguez.12-Oct-02 9:57 
GeneralProgress Bar in a status panel... Pin
Richard Smith11-Oct-02 13:45
Richard Smith11-Oct-02 13:45 
GeneralRe: Progress Bar in a status panel... Pin
leppie12-Oct-02 10:54
leppie12-Oct-02 10:54 
GeneralRe: Try this. Pin
Masaaki Onishi12-Oct-02 11:32
Masaaki Onishi12-Oct-02 11:32 
GeneralRe: Progress Bar in a status panel... Pin
Nick Parker12-Oct-02 17:24
protectorNick Parker12-Oct-02 17:24 
GeneralRe: Progress Bar in a status panel... Cheaters! Pin
Richard Smith13-Oct-02 2:53
Richard Smith13-Oct-02 2:53 
GeneralDeclaration error. Pin
suresh_sathya11-Oct-02 0:43
suresh_sathya11-Oct-02 0:43 
When i run this program,it says Must declare the variable '@Country'.

What should i do.

string selectSQL = "SELECT CustomerID, CompanyName FROM ustomers WHERE Country = @Country AND City = @City";
OleDbConnection nwindConn = new OleDbConnection("Provider=SQLOLEDB;Data Source=localhost;" +
"Integrated Security=SSPI;Initial Catalog=northwind;");
OleDbDataAdapter custDA = new OleDbDataAdapter();

OleDbCommand selectCMD = new OleDbCommand(selectSQL, nwindConn);
custDA.SelectCommand = selectCMD;

// Add parameters and set values.
selectCMD.Parameters.Add("@Country", OleDbType.VarChar, 15).Value = "UK";
selectCMD.Parameters.Add("@City", OleDbType.VarChar, 15).Value = "London";
DataSet custDS = new DataSet();
custDA.Fill(custDS, "Customers");

GeneralRe: Declaration error. Pin
Paul Riley11-Oct-02 0:50
Paul Riley11-Oct-02 0:50 
GeneralRe: Declaration error. Pin
suresh_sathya11-Oct-02 1:18
suresh_sathya11-Oct-02 1:18 
GeneralRe: Declaration error. Pin
Paul Riley11-Oct-02 1:23
Paul Riley11-Oct-02 1:23 
GeneralRe: Declaration error. Pin
Paul Riley11-Oct-02 1:34
Paul Riley11-Oct-02 1:34 
GeneralRe: Declaration error. Pin
leppie11-Oct-02 9:35
leppie11-Oct-02 9:35 
GeneralRe: Declaration error. Pin
Paul Riley11-Oct-02 10:13
Paul Riley11-Oct-02 10:13 
GeneralRe: Declaration error. Pin
Daniel Turini11-Oct-02 1:38
Daniel Turini11-Oct-02 1:38 
GeneralRe: Declaration error. Pin
Luis Alonso Ramos11-Oct-02 9:40
Luis Alonso Ramos11-Oct-02 9:40 
GeneralRe: Declaration error. Pin
leppie11-Oct-02 10:03
leppie11-Oct-02 10:03 
GeneralFinding the * Pin
Nnamdi Onyeyiri10-Oct-02 5:52
Nnamdi Onyeyiri10-Oct-02 5:52 
GeneralRe: Finding the * Pin
Daniel Turini10-Oct-02 6:01
Daniel Turini10-Oct-02 6:01 
GeneralRe: Finding the * Pin
Nnamdi Onyeyiri10-Oct-02 6:01
Nnamdi Onyeyiri10-Oct-02 6:01 
GeneralRe: Finding the * Pin
David Stone10-Oct-02 14:03
sitebuilderDavid Stone10-Oct-02 14:03 
GeneralRe: Finding the * Pin
Eric Gunnerson (msft)11-Oct-02 10:52
Eric Gunnerson (msft)11-Oct-02 10:52 
GeneralRe: Finding the * Pin
David Stone11-Oct-02 13:48
sitebuilderDavid Stone11-Oct-02 13:48 
GeneralEmail header Pin
Tomas Petricek9-Oct-02 12:11
Tomas Petricek9-Oct-02 12:11 
GeneralRe: Email header Pin
leppie9-Oct-02 12:50
leppie9-Oct-02 12:50 

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.