in the webconfig Define connection string
<appSettings>
<add key="linkbuilding" value="server=.;database=linkbuilding; uid=sa;pwd=sa123;"/>
</appSettings>
public void binddaashboard()
{
string query = "select * from commontask ";
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["linkbuilding"].ToString().Trim());
SqlCommand da = new SqlCommand(query, con);
SqlDataAdapter cmd = new SqlDataAdapter(da);
DataTable ds = new DataTable();
cmd.Fill(ds);
if (ds.Rows.Count > 0)
{
Deletetask.DataSource = ds;
Deletetask.DataBind();
}
else
{
ShowNoResultFound(ds, Deletetask);
}
}
ER sandeep chourasia
sandeepchrs@yahoo.com (on facebook)
http://www.aspnetcodes.com/
Pankaj.dhingra07, if this helps please login to Mark As Answer. | Alert Moderator