protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable dt = DBLogic.FetchAllRecord();
DropDownList1.DataSource = dt;
DropDownList1.DataTextField = "userid";
DropDownList1.DataValueField = "userid";
DropDownList1.DataBind();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
DataTable dt = DBLogic.FetchAllRecord();
GridView1.DataSource = dt;
GridView1.DataBind();
/* SqlConnection con = null;
* try
* {
* con = DBLogic.GetConnection();
*
* String query = "select * from reg ";
*
* //create the SqlDataAdapter object
* SqlDataAdapter da = new SqlDataAdapter(query, con);
*
* //create the object Dataset
* DataSet ds = new DataSet();
*
* //Call the fill Method and pass the
* //DataSet object
* da.Fill(ds);
*
* //get the no of tables dataset contains
* DataTable dt = ds.Tables[0];
*
* //bind the dataset table with the GridView
* GridView1.DataSource = dt;
* GridView1.DataBind();
* }
* catch (Exception err)
* {
* Label1.Text = err.Message;
* }
* finally
* {
* if (con != null)
* {
* con.Close();
* }
* }*/
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = null;
try
{
con = DBLogic.FetchAllRecord();
con.Open();
//build a query
String query = "delete from reg where userid ='" + txtuserid.Text + "'";
SqlCommand com = new SqlCommand(query, con);
//call the method of command object
int result = com.ExecuteNonQuery();
if (result > 0)
{
Label2.Text = "Record DELETED successfully";
}
else
{
Label2.Text = "NO Record FOUND";
}
}
catch (Exception err)
{
Label2.Text = err.Message;
}
finally
{
if (con != null)
{
con.Close();
}
}
}
