How to bind datagrid

[kuldeep singh sethi]

Hi All


Plz give me code how to bind datagrid with dataset. And one thing more i want that is i want to submit Roll No . at enquiry.aspx page and now after click on submit i want to redirect that page to result.aspx page. and in this page i want all the information about perticular candidate. so how it will do. plz guide me.


Regards
Kuldeep singh sethi

[rekha030]

store the roll number in some session variable
session["RollNo"]=rollno;
if the dataset is populating from database then make the following code

SqlConnection conn = new SqlConnection();
conn.ConnectionString = "integrated security=SSPI;SERVER=Your ServerNAME;DATABASE=Your Database Name;Connect Timeout=2;";
string cmdtext = "select * from TABLE NAME where ROLLNUMBER(your table field name)='"+session["RollNo"].toString()+"'";
conn.Open();
SqlCommand cmd = new SqlCommand(cmdtext, conn);
DataSet ds = new DataSet();
SqlDataAdapter sar = new SqlDataAdapter();
sar.SelectCommand = cmd;
sar.Fill(ds);

DataGrid1.DataSource = ds;
DataGrid1.DataBind();

if you want to do it visually

right click the smart tag of datagrid
choose datasourse as new datasource;
select database from the datasource configuration wizard.
click new connection button .
from the add connection window select servername and select windows authentication.
choose the database name and click ok.
then from the datasource configuration wizard click next.
select the radiobutton specify columns from a table or view.check the fields you want.and the click the where button.
from the add where clause window select the field name of your table eg.rollno;
select the source dropdownlist as session.
give the session name in the session field;
click ok;

[kuldeep singh sethi]

store the roll number in some session variable
session["RollNo"]=rollno;
if the dataset is populating from database then make the following code

SqlConnection conn = new SqlConnection();
conn.ConnectionString = "integrated security=SSPI;SERVER=Your ServerNAME;DATABASE=Your Database Name;Connect Timeout=2;";
string cmdtext = "select * from TABLE NAME where ROLLNUMBER(your table field name)='"+session["RollNo"].toString()+"'";
conn.Open();
SqlCommand cmd = new SqlCommand(cmdtext, conn);
DataSet ds = new DataSet();
SqlDataAdapter sar = new SqlDataAdapter();
sar.SelectCommand = cmd;
sar.Fill(ds);

DataGrid1.DataSource = ds;
DataGrid1.DataBind();

if you want to do it visually

right click the smart tag of datagrid
choose datasourse as new datasource;
select database from the datasource configuration wizard.
click new connection button .
from the add connection window select servername and select windows authentication.
choose the database name and click ok.
then from the datasource configuration wizard click next.
select the radiobutton specify columns from a table or view.check the fields you want.and the click the where button.
from the add where clause window select the field name of your table eg.rollno;
select the source dropdownlist as session.
give the session name in the session field;
click ok;

Thanks a lot

Sir i am handling one another problem. I have installed .net 2003 and sqlserver 2000. Now i have made a login page. and also i have make a table in sqlserver.
but when i am running the application and putting username and password in the login fields then instead of going to Index.aspx page it shows a error "login failed for user 'Welcome\ IUSR ' " and show highlighted this line which is "Objcon.open();". So Plz help me for it


Regards

Kuldeep singh sethi

[rekha030]

I think the problem is in your sql server authentication.
if you had a userid and password for sqlserver specify that in the connection string as userid="Your userid" password="Your Password"
otherwise use the same connection string and check the database name and servername;

[kuldeep singh sethi]

I think the problem is in your sql server authentication.
if you had a userid and password for sqlserver specify that in the connection string as userid="Your userid" password="Your Password"
otherwise use the same connection string and check the database name and servername;

Thanks a lot to help me

keep in touch allways

kuldeep singh sethi