Tags

[bhuvanesh gupta]

hai friends pls tell me hoe to get data from DB i know to create form and database connection but i dont know how to get a data..........................

[sean lopez]

Try it out here http://www.eggheadcafe.com/community/aspne...rom-ms-acc.aspx

[shamsudeen khan]

hai friends pls tell me hoe to get data from DB i know to create form and database connection but i dont know how to get a data..........................

Hi friend..just give this code a try..the table name is customer..here wen u give the customer name in one text box u will get the corresponding cid,address etc in the corresponding text boxes

con.Open();
str = "Select * from customer where(cname='" + textBox1.Text + "')";

cmd = new SqlCommand(str, con);
dr = cmd.ExecuteReader();
if(dr.HasRows)
{
while (dr.Read())
{
textBox2.Text = dr["cid"].ToString();
textBox3.Text = dr["address"].ToString();
textBox4.Text = dr["landline"].ToString();
textBox5.Text = dr["mobile"].ToString();
textBox6.Text = dr["email"].ToString();
}
con.close();
dr.close();
}

[ranganathanvp]

Hi friend..just give this code a try..the table name is customer..here wen u give the customer name in one text box u will get the corresponding cid,address etc in the corresponding text boxes

con.Open();
str = "Select * from customer where cname= @custname";

cmd = new SqlCommand(str, con);
cmd.Paramaters.Add(new SqlParameter("@custname" + textBox1.Text));

// make it a habit to use above command as its more secure than the one in prev post.

dr = cmd.ExecuteReader();

if(dr.HasRows)
{
while (dr.Read())
{
textBox2.Text = dr["cid"].ToString();
textBox3.Text = dr["address"].ToString();
textBox4.Text = dr["landline"].ToString();
textBox5.Text = dr["mobile"].ToString();
textBox6.Text = dr["email"].ToString();
}
}

dr.close();
con.close();

}

just made some changes to the above code...

[aquarius]

Good I like it. This is very useful thread for asp.net developers. It contains useful information. Thanks for sharing it with me.

[Egerton John]

Hey...

Its a nice information that you have shared here..I am much happy to see all of these coding because this can be helpful to me for further posting...