code for displaying data in textboxes from database

Srinivas Rao

11y1.1kLearn iOS Programming

I need a code for displaying the data when click on search button. THE DESIGHN IS LIKE THIS

textbox1___Name

textbox2___Address

textbox3___Age

textbox 4___Education

textbox5____Email

button ---search.

so, wt I need is the textbox1 has a dropdownlist, wen I select a name from the dropdownlist

and click on search button, the related data of textbox1 has to show automatically in the remaining textboxes by retriving data from database.

the project code should be in windows form.

pls send the code,

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Krishna Rajput Singh11y ago
hello Srinivas Rao below find your answer i hope solve your problme

http://stackoverflow.com/questions/14113025/how-to-display-data-from-database-into-textbox-and-update-it

https://www.youtube.com/watch?v=VTS-modwYSA

I suppose you want ...

string strConn = "Data Source=localhost;initial catalog=Northwind;UID=sa;pwd=sa";SqlConnection conn = new SqlConnection(strConn);
conn.Open();
string strSQL = "SELECT CustomerID FROM Customers";
SqlCommand cmd = new SqlCommand(strSQL, conn);
SqlDataReader dtr = cmd.ExecuteReader();
while (dtr.Read())
{
textBox1.Text = str.GetString(0);
textBox2.Text = str.GetString(1);
textBox3.Text = str.GetString(2);
...
}
dtr.Close();
conn.Close();
Priyaranjan K S11y ago
Hi Srinivas,

You may use the below code . Make appropriate changes. Below code shows how to pass in a particular user name and query his related data and show in text box and labels .

private void getData(string user)
{
DataTable dt = new DataTable();
SqlConnection connection = new SqlConnection("YOUR CONNECTION STRING HERE");
connection.Open();
SqlCommand sqlCmd = new SqlCommand("SELECT * from TABLE1 WHERE UserID = @username", connection);
SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCmd);
sqlCmd.Parameters.AddWithValue("@username",user);
sqlDa.Fill(dt);
if (dt.Rows.Count > 0)
{
TextBox1.Text = dt.Rows[0]["ColumnName1"].ToString(); //Where ColumnName is the Field from the DB that you want to display
TextBox2.Text = dt.Rows[0]["ColumnName2"].ToString();
Label1.Text = dt.Rows[0]["ColumnName3"].ToString();
Label2.Text = dt.Rows[0]["ColumnName4"].ToString();
}
connection.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack){
// Pass your text box 1 value
string userName = TextBox1.Text;
getData(userName);
}
}

Thanks,
Priyan

If you found this useful Please Accept this as Answer