Getting data from the SQL server to a textbox

Hi,

Thanks for your comments

regard -- Vj

You could just do the query in the Page_Load as suggested, and populate the TextBox that way.

For example, here is an example using the Northwind sample database:

    protected void Page_Load(object sender, EventArgs e)
    {
        using (SqlConnection cn = new SqlConnection(WebConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString))
        {
            SqlCommand cmd = new SqlCommand("SELECT LastName FROM Employees WHERE (EmployeeID = 1)", cn);
            cn.Open();
            TextBox1.Text = cmd.ExecuteScalar().ToString();
        }
    }

Thanks -- Vj

inside the sdr, does

'cus' means the name of the table

'int' means the sql data type

'CustomerName' means the field name

am i getting it right?

It is very simple.Just read the data from table using data reader and and assign the data in textbox. I have given the code below.

 if (sdrData.HasRows)
                {
                    if (sdrData.Read())
                    {
                        txtCustomerID.Text = sdrData["cus_vch_Id"].ToString();
                        txtCustomerName.Text = sdrData["cus_vch_CustomerName"].ToString();
                        txtAddress.Text = sdrData["cus_vch_Address"].ToString();
                        txtCity.Text = sdrData["cus_vch_City"].ToString();
                        txtState.Text = sdrData["cus_vch_State"].ToString();
                        txtZip.Text = sdrData["cus_int_Zip"].ToString();
                        txtTelephone.Text = sdrData["cus_vch_Telephone"].ToString();
                        txtFax.Text = sdrData["cus_vch_Fax"].ToString();
                        txtEmail.Text = sdrData["cus_vch_Email"].ToString();
                        txtWebsite.Text = sdrData["cus_vch_WebsiteAddress"].ToString();
                        txtUserLicences.Text = sdrData["cus_int_MaximumNoLicenses"].ToString();
}
}