HERE POSITION OPEN IS HARDCODED.HOW TO WRITE CODE FOR IT SO THAT IT COULD BE SELECTED BY SOME PARAMETERS?------------------</

Question

1.50/5 (2 votes)

See more:

//----------------------------------------------------------------------------------------------------------------------------------------------------
//To retrieve RRMaster Details
//----------------------------------------------------------------------------------------------------------------------------------------------------
if (objUploadDetailsDataClass.RRFileName.Trim().EndsWith(".xlsx"))
{
strConnectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=\"Excel 12.0 Xml;HDR=YES\";", objUploadDetailsDataClass.RRFileName);
}
else if (objUploadDetailsDataClass.RRFileName.Trim().EndsWith(".xls"))
{
strConnectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=\"Excel 8.0;HDR=Yes\";", objUploadDetailsDataClass.RRFileName);
}
SQLConn = new OleDbConnection(strConnectionString);
SQLConn.Open();
OleDbDataAdapter SQLAdapter = new OleDbDataAdapter();
OleDbCommand selectCMD = new OleDbCommand(objUploadDetailsDataClass.RRQuery(), SQLConn);
selectCMD.Parameters.AddWithValue("@Position Fulfillment Status", "Position Open"); selectCMD.Parameters.AddWithValue("@CTP Yes/No", "Yes");
// selectCMD.Parameters.AddWithValue("@Month", DateTime.Now.Year.ToString());
SQLAdapter.SelectCommand = selectCMD;
DataSet objDataset1 = new DataSet();
SQLAdapter.Fill(objDataset1);
RRdt = objDataset1.Tables[0];

Posted 14-Feb-11 17:09pm

Member 7673456

Add a Solution

Comments

Sandeep Mewara 14-Feb-11 23:48pm

Why your title is in bold? Please dont use all CAPS, its considered shouting.

Toli Cuturicu 15-Feb-11 1:27am

Don't SHOUT!
Use <pre lang="cs">...</pre> tags!

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Answer 1 · 2011-02-14T17:15:00

Have a look at the sample below. Here two parameters @Country and @City are used.
Each of these has the type varchar associated with it.

OleDbDataAdapter da = new OleDbDataAdapter();
  OleDbCommand cmd;
  OleDbParameter parm;
  // Create the SelectCommand.
  cmd = new OleDbCommand("SELECT * FROM Customers " +
                       "WHERE Country = @Country AND City = @City", conn);
  cmd.Parameters.Add("@Country", OleDbType.VarChar, 15);
  cmd.Parameters.Add("@City", OleDbType.VarChar, 15);
  da.SelectCommand = cmd;
  // Create the UpdateCommand.
  cmd = new OleDbCommand("UPDATE Customers SET CustomerID = @CustomerID, CompanyName = @CompanyName " +
                       "WHERE CustomerID = @oldCustomerID", conn);
  cmd.Parameters.Add("@CustomerID", OleDbType.Char, 5, "CustomerID");
  cmd.Parameters.Add("@CompanyName", OleDbType.VarChar, 40, "CompanyName");
  parm = cmd.Parameters.Add("@oldCustomerID", OleDbType.Char, 5, "CustomerID");
  parm.SourceVersion = DataRowVersion.Original;
  da.UpdateCommand = cmd;
  return da;

Have a look at this[^] msdn link for more information.