| Author: mahalakshmi 30 Sep 2008 | Member Level: Gold | Rating:  Points: 6 |
hi,
pageload()
{
OleDbConnection con=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("~/App_Data/jdb.mdb"));
OleDbCommand com = new OleDbCommand("select * from tbl", con);
con.Open();
OleDbDataReader data= com.ExecuteReader();
while (data.Read())
{
t1.text=data["fieldname1"].ToString();
t2.text=data["fieldname2"].ToString();
}
conn.close()
}
or
pageload()
{
OleDbConnection con=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("~/App_Data/jdb.mdb"));
OleDbCommand com = new OleDbCommand("select * from tbl", con);
con.Open();
OleDbDataReader data= com.ExecuteReader();
data.Read()
t1.text=data["fieldname1"].ToString();
t2.text=data["fieldname2"].ToString();
conn.close()
}
or
use datacontrols like datagrid,repeater,...
bind db value with controls like
<asp:TextBox id="t1" Text='<%Eval("fieldname")%>' runat="server"/>
happy programming.
|
| Author: SATHIYENTHIRA BOOPATHY.H 30 Sep 2008 | Member Level: Bronze | Rating: Points: 3 |
Hi,
You can try like the following code.
OledbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source="+Server.MapPath("~/App_Data"/student.mdb"));
OledbCommand comm = new OledbCommand("select name,rollno,grade from stud where rollno=1125");
conn.Open();
OledbDataReader reader = comm.ExecuteReader();
while(reader.Read())
{
name.Text = reader["name"].ToString();
rollno.Text = reader["rollno"].ToString();
grade.Text = reader["grade"].ToString();
}
conn.Close();
Thanks & Regards
H.Sathiyenthira Boopathy
|