Comments by harsh_deep (Top 18 by date)

thanks a lot

thanks a lot...

i had tried this.. i enabled full control right for this folder.. still it giving problem..i dnt knw whats wrong with this...

i had tried this.. i enabled full control right for this folder.. still it giving problem..i dnt knw whats wrong with this...

i had tried this.. i enabled full control right for this folder.. still it giving problem..i dnt knw whats wrong with this...

:( i had un checked it den uploaded again..but still same problem.. :(

done..bt still having error can you plz provide me the code..

sir i had done wat abhinav said but still these errors is blowing my mind....help...plz

still having the error....>>

Syntax error (missing operator) in query expression '10thper>='55' AND 12thper>='55' AND aggregate>='55'AND backlog<='0' AND academicgap<='0''.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Syntax error (missing operator) in query expression '10thper>='55' AND 12thper>='55' AND aggregate>='55'AND backlog<='0' AND academicgap<='0''.

Source Error:

Line 146: DataSet ds = new DataSet();
Line 147: adp.SelectCommand = cmd1;
Line 148: adp.Fill(ds);
Line 149: DataTable dt = ds.Tables[0];
Line 150: OleDbDataReader dr = cmd1.ExecuteReader();

plz.......provide me the right query...

still having the error :(

Syntax error (missing operator) in query expression '10thper>='55' AND 12thper>='55' AND aggregate>='55'AND backlog<='0' AND academicgap<='0''.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Syntax error (missing operator) in query expression '10thper>='55' AND 12thper>='55' AND aggregate>='55'AND backlog<='0' AND academicgap<='0''.

Source Error:

Line 146: DataSet ds = new DataSet();
Line 147: adp.SelectCommand = cmd1;
Line 148: adp.Fill(ds);
Line 149: DataTable dt = ds.Tables[0];
Line 150: OleDbDataReader dr = cmd1.ExecuteReader();

now after editing the code like....>>>>
{
OleDbConnection cn = new OleDbConnection();
cn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=E:\placement cell\project.mdb";
cn.Open();
string sql1 = "select name from student where 10thper>='" + DropDownList3.Text + "' AND 12thper>='" + DropDownList4.Text + "' AND aggregate>='" + DropDownList5.Text + "' AND backlog<='" + DropDownList6.Text + "' AND academicgap<='" + DropDownList7.Text + "'";
System.Data.OleDb.OleDbCommand cmd1 = new System.Data.OleDb.OleDbCommand(sql1, cn);
System.Data.OleDb.OleDbDataAdapter adp = new OleDbDataAdapter();
DataSet ds = new DataSet();
adp.SelectCommand = cmd1;
adp.Fill(ds);
DataTable dt = ds.Tables[0];
OleDbDataReader dr = cmd1.ExecuteReader();
while (dr.Read() == true)
{
GridView1.DataSource = dt;
}
cn.Close();
}
i got this type of error....>>
Syntax error (missing operator) in query expression '10thper>='55' AND 12thper>='55' AND aggregate>='55' AND backlog<='0' AND academicgap<='0''.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Syntax error (missing operator) in query expression '10thper>='55' AND 12thper>='55' AND aggregate>='55' AND backlog<='0' AND academicgap<='0''.

Source Error:

Line 146: DataSet ds = new DataSet();
Line 147: adp.SelectCommand = cmd1;
Line 148: adp.Fill(ds);
Line 149: DataTable dt = ds.Tables[0];
Line 150: OleDbDataReader dr = cmd1.ExecuteReader();

thanks...orignalGriff
i am new to programing thanks for the suggestion ..

i had done it..but having the same error..