I have used the same steps that you have used on your sample for inserting, deleting and updating.
this is my code
private String strConnString = ConfigurationManager.ConnectionStrings["CustomerConnectionString2"].ConnectionString;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindData();
}
}
private void BindData()
{
string strQuery = "select Complaint_id, Registered_by,Customer, Status,Category,Sub_Category, Items, Start_Date, Title, Engineer_on_site, Location, Engineer_on_call, Urgency, Impact, Priority, Closed_date, Description" +
" from Complaint_Register";
SqlCommand cmd = new SqlCommand(strQuery);
GridView1.DataSource = GetData(cmd);
GridView1.DataBind();
}
private DataTable GetData(SqlCommand cmd)
{
DataTable dt = new DataTable();
SqlConnection con = new SqlConnection(strConnString);
SqlDataAdapter sda = new SqlDataAdapter();
cmd.CommandType = CommandType.Text;
cmd.Connection = con;
con.Open();
sda.SelectCommand = cmd;
sda.Fill(dt);
return dt;
}
protected void OnPaging(object sender, GridViewPageEventArgs e)
{
BindData();
GridView1.PageIndex = e.NewPageIndex;
GridView1.DataBind();
}
protected void AddNewCustomer(object sender, EventArgs e)
{
string Cid = ((TextBox)GridView1.FooterRow.FindControl("txtCid")).Text;
string RB = ((TextBox)GridView1.FooterRow.FindControl("txtRB")).Text;
string Cus = ((TextBox)GridView1.FooterRow.FindControl("txtCus")).Text;
string Status = ((TextBox)GridView1.FooterRow.FindControl("txtStatus")).Text;
string Cat = ((TextBox)GridView1.FooterRow.FindControl("txtCat")).Text;
string SCat = ((TextBox)GridView1.FooterRow.FindControl("txtItems")).Text;
string Items = ((TextBox)GridView1.FooterRow.FindControl("txtSD")).Text;
string SD = ((TextBox)GridView1.FooterRow.FindControl("txtRB")).Text;
string Title = ((TextBox)GridView1.FooterRow.FindControl("txtTitle")).Text;
string EOS = ((TextBox)GridView1.FooterRow.FindControl("txtEOS")).Text;
string Loc = ((TextBox)GridView1.FooterRow.FindControl("txtLoc")).Text;
string EOC = ((TextBox)GridView1.FooterRow.FindControl("txtEOC")).Text;
string URG = ((TextBox)GridView1.FooterRow.FindControl("txtURG")).Text;
string Imp = ((TextBox)GridView1.FooterRow.FindControl("txtImp")).Text;
string Pri = ((TextBox)GridView1.FooterRow.FindControl("txtPri")).Text;
string CD= ((TextBox)GridView1.FooterRow.FindControl("txtCD")).Text;
string Des= ((TextBox)GridView1.FooterRow.FindControl("txtDes")).Text;
SqlConnection con = new SqlConnection(strConnString);
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "insert into Complaint_Register(Complaint_id, Registered_by, Customer, Status,Category,Sub_Category, Items, Start_Date, Title, Engineer_on_site, Location, Engineer_on_call, Urgency, Impact, Priority, Closed_date, Description) " +
"values(@Complaint_id, @Registered_by, @Customer ,@Status,@Category,@Sub_Category,@Items, @Start_Date, @Title, @Engineer_on_site, @Location, @Engineer_on_call, @Urgency, @Impact, @Priority, @Closed_date, @Description);" +
"select Complaint_id, Registered_by, Status,Category,Sub_Category, Items, Start_Date, Title, Engineer_on_site, Location, Engineer_on_call, Location, Urgency, Impact, Priority, Closed_date, Description";
cmd.Parameters.Add("@Complaint_id", SqlDbType.VarChar).Value = Cid;
cmd.Parameters.Add("@Registered_by", SqlDbType.VarChar).Value = RB;
cmd.Parameters.Add("@Customer", SqlDbType.VarChar).Value = Cus;
cmd.Parameters.Add("@Status", SqlDbType.VarChar).Value = Status;
cmd.Parameters.Add("@Category", SqlDbType.VarChar).Value = Cat;
cmd.Parameters.Add("@SCat", SqlDbType.VarChar).Value = SCat;
cmd.Parameters.Add("@Items", SqlDbType.VarChar).Value = Items;
cmd.Parameters.Add("@Start_Date", SqlDbType.VarChar).Value = SD;
cmd.Parameters.Add("@Title", SqlDbType.VarChar).Value = Title;
cmd.Parameters.Add("@Engineer_on_site", SqlDbType.VarChar).Value = EOS;
cmd.Parameters.Add("@Location", SqlDbType.VarChar).Value = Loc;
cmd.Parameters.Add("@Engineer_on_call", SqlDbType.VarChar).Value = EOC;
cmd.Parameters.Add("@Urgency", SqlDbType.VarChar).Value = URG;
cmd.Parameters.Add("@Impact", SqlDbType.VarChar).Value = Imp;
cmd.Parameters.Add("@Priority", SqlDbType.VarChar).Value = Pri;
cmd.Parameters.Add("@Closed_date", SqlDbType.VarChar).Value = CD;
cmd.Parameters.Add("@Description", SqlDbType.VarChar).Value = Des;
GridView1.DataSource = GetData(cmd);
GridView1.DataBind();
}
protected void DeleteCustomer(object sender, EventArgs e)
{
LinkButton lnkRemove = (LinkButton)sender;
SqlConnection con = new SqlConnection(strConnString);
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "delete from Complaint_Register where " +
"Complaint_id=@Complaint_id;" +
"select Complaint_id, Registered_by, Customer, Status,Category,Sub_Category, Items, Start_Date, Title, Engineer_on_site, Location, Engineer_on_call, Urgency, Impact, Priority, Closed_date, Description from Complaint_Register";
cmd.Parameters.Add("@Complaint_id", SqlDbType.VarChar).Value = lnkRemove.CommandArgument;
GridView1.DataSource = GetData(cmd);
GridView1.DataBind();
}
protected void EditCustomer(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
BindData();
}
protected void CancelEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
BindData();
}
protected void UpdateCustomer(object sender, GridViewUpdateEventArgs e)
{
string Cid = ((Label)GridView1.Rows[e.RowIndex].FindControl("lblCid")).Text;
string RB = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtRB")).Text;
string Cus = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtCus")).Text;
string Status = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtStatus")).Text;
string Cat = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtCat")).Text;
string SCat = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtSCat")).Text;
string Items = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtItems")).Text;
string SD = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtSD")).Text;
string Title = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtTitle")).Text;
string EOS = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtEOS")).Text;
string Loc = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtLoc")).Text;
string EOC = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtEOC")).Text;
string URG = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtURG")).Text;
string Imp = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtImp")).Text;
string Pri = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtPri")).Text;
string CD = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtCD")).Text;
string Des = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtDes")).Text;
SqlConnection con = new SqlConnection(strConnString);
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "update Complaint_Register set Registered_by = @Registered_by, Customer = @Customer, Status = @Status,Category = @Category,Sub_Category = @Sub_Category, Items = @items, Start_Date = @Start_Date, Title, Engineer_on_site = @Engineer_on_site, Location = @Location, Engineer_on_call = @Engineer_on_call , Urgency = @Urgency, Impact = @Impact, Priority = @Priority, Closed_date = @Closed_date, Description = @Description " +
"where Complaint_id=@Complaint_id;" +
"select Complaint_id, Registered_by, Customer, Status,Category,Sub_Category, Items, Start_Date, Title, Engineer_on_site, Location, Engineer_on_call, Urgency, Impact, Priority, Closed_date, Description from Complaint_Register";
// cmd.Parameters.Add("@CustomerID", SqlDbType.VarChar).Value = CustomerID;
cmd.Parameters.Add("@Complaint_id", SqlDbType.VarChar).Value = Cid;
cmd.Parameters.Add("@Registered_by", SqlDbType.VarChar).Value = RB;
cmd.Parameters.Add("@Customer", SqlDbType.VarChar).Value = Cus;
cmd.Parameters.Add("@Status", SqlDbType.VarChar).Value = Status;
cmd.Parameters.Add("@Category", SqlDbType.VarChar).Value = Cat;
cmd.Parameters.Add("@SCat", SqlDbType.VarChar).Value = SCat;
cmd.Parameters.Add("@Items", SqlDbType.VarChar).Value = Items;
cmd.Parameters.Add("@Start_Date", SqlDbType.VarChar).Value = SD;
cmd.Parameters.Add("@Title", SqlDbType.VarChar).Value = Title;
cmd.Parameters.Add("@Engineer_on_site", SqlDbType.VarChar).Value = EOS;
cmd.Parameters.Add("@Location", SqlDbType.VarChar).Value = Loc;
cmd.Parameters.Add("@Engineer_on_call", SqlDbType.VarChar).Value = EOC;
cmd.Parameters.Add("@Urgency", SqlDbType.VarChar).Value = URG;
cmd.Parameters.Add("@Impact", SqlDbType.VarChar).Value = Imp;
cmd.Parameters.Add("@Priority", SqlDbType.VarChar).Value = Pri;
cmd.Parameters.Add("@Closed_date", SqlDbType.VarChar).Value = CD;
cmd.Parameters.Add("@Description", SqlDbType.VarChar).Value = Des;
GridView1.EditIndex = -1;
GridView1.DataSource = GetData(cmd);
GridView1.DataBind();
}
}It is deleting the data but not updating the data,it sticks to the same data after clicking on the update button...kindly see the code and help me out