How to working database connection

Thanks,
T.Saravanan

Thanks,
T.Saravanan

//add this namespace

using System.SqlClient;



            SqlConnection con;

            int abc= 0;

            con = new SqlConnection("server=SERVER-NAME;user id=USERNAME;password=PASSWORD;database=DBNAME");

            con.Open();

            SqlCommand cmd;

            SqlDataReader rdr;

            cmd = new SqlCommand("Your Command",con);

            rdr=cmd.ExecuteReader();

            datagridID.DataSource()=rdr;

            datagrid.DataBind();

Thanks,
Radha Srikanth

LP MER

Thanks,
Radha Srikanth