How to display tabledata in sqlserver in a HTMLFILE

hi,
In web.config file under appsettings
SqlServer VALUE="YOUR SQLSERVER CONNCETIONSTRING" >

no need to use xml....

you can store the value in any control...
like

if (sqlred["a"] != null)
{

//if you want to dtore the value in text box do like this
textbox1.text = sqlred["a"].tostring();
}
if (sqlred["b"] != null)
{
textbox2.text = sqlred["b"].tostring();
}

thanks jitendra but i dont have a label control in html page tell me the procedure for the task understandably

What type of program? ASP, WPF, Windows Forms or something else?

How is the HTML page created?

hi,

   
       
           
           
           
       
       
           
           
           
       

       
   

code behind page.........

    private void Editing(string hdnvalue)
    {
        string selectquery = "";
        selectquery = "select a,b,c,d,e,f FROM  xyz;
        SqlConnection sqlcon = new SqlConnection(ConfigurationManager.AppSettings["SqlServer"]);

        SqlCommand sqlcomm = new SqlCommand();
        sqlcomm = sqlcon.CreateCommand();
        sqlcomm.CommandType = CommandType.Text;
        sqlcomm.CommandText = selectquery;
        sqlcon.Open();
        SqlDataReader sqlred = null;
        sqlred = sqlcomm.ExecuteReader();

        if (sqlred.Read())
        {
            if (sqlred["a"] != null)
            {
                Label1.Text = sqlred["a"].ToString();
            }
            if (sqlred["b"] != null)
            {
                Label2.Text = sqlred["b"].ToString();
            }
            if (sqlred["c"] != null)
            {
                Label3.Text = sqlred["c"].ToString();
            }
            if (sqlred["d"] != null)
            {
                Label4.Text = sqlred["d"].ToString();
            }
            if (sqlred["e"] != null)
            {
                Label5.SelectedValue = sqlred["e"].ToString();
            }
            if (sqlred["f"] != null)
            {
                Label6.Text = sqlred["f"].ToString();
            }
        }
        sqlcomm.Dispose();
        sqlcon.Close();
    }

write tblvaluesfromdatabase.visible=true;  in ur event(ex: page_load or button click)



modify this code to your requirement..........

i hope it help you...........

please give me reply