Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
karthikeyan.marlen
Starting Member
16 Posts |
 Posted - 2011-05-25 : 02:23:52
|
| HiI am using the following query to retrieve records with respect to the date from a access db table,but i am getting the error as "No value given for one or more required parameters" the c# coding is "string dats = DateTime.Now.ToShortDateString(); //string Qry = "Select *,st_Date as dateonly from schedule where sd_EndDate > '" + DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss") + "' order by st_Date asc"; string Qry = "Select * from schedule where sd_Date= '#" + dats + "#'"; string constrs = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("~/App_Data/polimerdb.mdb"); OleDbConnection conn = new OleDbConnection(constrs); conn.Open(); // OleDbCommand comm1 = new OleDbCommand(Qry, conn); OleDbDataAdapter dap = new OleDbDataAdapter(Qry,conn); //dap.SelectCommand = comm1; DataSet ds=new DataSet(); dap.Fill(ds,"schedule");"please clear me regarding this issuekarthikeyan |
|
|
jfarrugia
Yak Posting Veteran
55 Posts |
Posted - 2011-05-25 : 04:53:03
|
| at which line is the exception being triggered? Also, you might need to post this in a forum related to C# queries.Where software development knowledge meets the reader |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-05-30 : 07:08:01
|
| It means that one or more parameters did not receives valuesMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
"No value given for one or more requirements"