Binding the database to the datagrid

  • Thread starter Thread starter yasodhai
  • Start date Start date
Y

yasodhai

Hi,
I retrieved the value of the session varible SID and i convert it to
the integer variable called sid. I thought of retrieving the rows
which correspond to this varible "sid"

string secid=Session["SID"].ToString();
int sid=Convert.ToInt32(secid);

Hence I have to pass the variable "sid" to the where clause in the
select statement. I used "&" but it displays error message "Incorrect
Syntax near &".


SqlDataAdapter Fld = new SqlDataAdapter("select * from Fielddet where
SectionID=&sid& ", myConnection);
try
{
myConnection.Open();
}
catch(Exception e)
{
Console.WriteLine(e.ToString());
}

DataSet Fldds=new DataSet();
Fld.Fill(Fldds,"Fielddet");
DataGrid_Fields.DataSource=Fldds.Tables["Fielddet"];
DataGrid_Fields.DataBind();
myConnection.Close();

Kindly help me how to do this..

Thanks & Regards,
Yasodhai
 
Hi,
I retrieved the value of the session varible SID and i convert it to
the integer variable called sid. I thought of retrieving the rows
which correspond to this varible "sid"

string secid=Session["SID"].ToString();
int sid=Convert.ToInt32(secid);

Hence I have to pass the variable "sid" to the where clause in the
select statement. I used "&" but it displays error message "Incorrect
Syntax near &".

SqlDataAdapter Fld = new SqlDataAdapter("select * from Fielddet where
SectionID=&sid& ", myConnection);
try
{
myConnection.Open();
}
catch(Exception e)
{
Console.WriteLine(e.ToString());
}

DataSet Fldds=new DataSet();
Fld.Fill(Fldds,"Fielddet");
DataGrid_Fields.DataSource=Fldds.Tables["Fielddet"];
DataGrid_Fields.DataBind();
myConnection.Close();

Kindly help me how to do this..

Thanks & Regards,
Yasodhai
Click to expand...

This

"select * from Fielddet where SectionID=&sid& "

is wrong.

Must be something like

"select * from Fielddet where SectionID=" + secid

or

"select * from Fielddet where SectionID=" + sid.ToString()
 
Thank you very much. Its working fine.


Thanks & Regards,
Yaso

Hi,
I retrieved the value of the session varible SID and i convert it to
the integer variable called sid. I thought of retrieving the rows
which correspond to this varible "sid"
Click to expand...
string secid=Session["SID"].ToString();
int sid=Convert.ToInt32(secid);
Click to expand...
Hence I have to pass the variable "sid" to the where clause in the
select statement. I used "&" but it displays error message "Incorrect
Syntax near &".
Click to expand...
SqlDataAdapter Fld = new SqlDataAdapter("select * from Fielddet where
SectionID=&sid& ", myConnection);
try
{
myConnection.Open();
}
catch(Exception e)
{
Console.WriteLine(e.ToString());
}
Click to expand...
DataSet Fldds=new DataSet();
Fld.Fill(Fldds,"Fielddet");
DataGrid_Fields.DataSource=Fldds.Tables["Fielddet"];
DataGrid_Fields.DataBind();
myConnection.Close();
Click to expand...
Kindly help me how to do this..
Click to expand...
Thanks & Regards,
Yasodhai
Click to expand...

This

"select * from Fielddet where SectionID=&sid& "

is wrong.

Must be something like

"select * from Fielddet where SectionID=" + secid

or

"select * from Fielddet where SectionID=" + sid.ToString()- Hide quoted text -

- Show quoted text -
Click to expand...
 
Back
Top