displaying data in textboxe fetched from database sqlserver

Question

how to show the data in textbox fetched from database either it can be sqlserver or oracle

Ramesh Maruthi · Answer

string Command = Select Personname from persontable SqlConnection Conn = new SqlConnection(Connection_String); SqlCommand Comm1 = new SqlCommand(Command Conn); Conn.Open(); SqlDataReader DR1 = Comm1.ExecuteReader(); if (DR1.Read()) { textBox.Text = DR1.GetValue(0).ToString(); } Conn.Close();