Delete:
protected void GridViewSample_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
Label CustID = (Label)GridViewSample.Rows[e.RowIndex].FindControl("lblCustID");
using (SqlConnection Sqlcon = new SqlConnection(strCon))
{
using (SqlCommand cmd = new SqlCommand())
{
Sqlcon.Open();
cmd.Connection = Sqlcon;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_Customer";
cmd.Parameters.Add(new SqlParameter("@pvchCustId", SqlDbType.Int));
cmd.Parameters.Add(new SqlParameter("@pvchAction", SqlDbType.VarChar, 50));
cmd.Parameters.Add(new SqlParameter("@pvchCreatedBy", SqlDbType.VarChar, 50));
cmd.Parameters.Add("@pIntErrDescOut", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters["@pvchAction"].Value = "delete";
cmd.Parameters["@pvchCustId"].Value = Convert.ToInt32(CustID.Text.ToString());
cmd.Parameters["@pvchCreatedBy"].Value = "Admin";
cmd.ExecuteNonQuery();
int retVal = (int)cmd.Parameters["@pIntErrDescOut"].Value;
}
}
GridViewSample.EditIndex = -1;
LoadData();
lblMessage.Text = "Record deleted successfully!";
}
insert:
protected void GridViewSample_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("Insert"))
{
int retVal=0;
TextBox Name = (TextBox)GridViewSample.FooterRow.FindControl("txt AddCustName");
TextBox Address1 = (TextBox)GridViewSample.FooterRow.FindControl("txt AddCustAdres1");
TextBox Address2 = (TextBox)GridViewSample.FooterRow.FindControl("txt AddCustAdres2");
TextBox Phone = (TextBox)GridViewSample.FooterRow.FindControl("txt AddCustPhone");
TextBox Email = (TextBox)GridViewSample.FooterRow.FindControl("txt AddEmail");
using (SqlConnection Sqlcon = new SqlConnection(strCon))
{
using (SqlCommand cmd = new SqlCommand())
{
Sqlcon.Open();
cmd.Connection = Sqlcon;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_Customer";
cmd.Parameters.Add(new SqlParameter("@pvchAction", SqlDbType.VarChar, 50));
cmd.Parameters.Add(new SqlParameter("@pvchCustName", SqlDbType.VarChar, 100));
cmd.Parameters.Add(new SqlParameter("@pvchustaddress1", SqlDbType.VarChar, 100));
cmd.Parameters.Add(new SqlParameter("@pvchustaddress2", SqlDbType.VarChar, 100));
cmd.Parameters.Add(new SqlParameter("@pvchCustPhone", SqlDbType.VarChar, 100));
cmd.Parameters.Add(new SqlParameter("@pvchCustEmail", SqlDbType.VarChar, 100));
cmd.Parameters.Add(new SqlParameter("@pvchCreatedBy", SqlDbType.VarChar, 100));
cmd.Parameters.Add("@pIntErrDescOut", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters["@pvchAction"].Value = "insert";
cmd.Parameters["@pvchCustName"].Value = Name.Text.Trim();
cmd.Parameters["@pvchustaddress1"].Value = Address1.Text.Trim();
cmd.Parameters["@pvchustaddress2"].Value = Address2.Text.Trim();
cmd.Parameters["@pvchCustPhone"].Value = Phone.Text.Trim();
cmd.Parameters["@pvchCustEmail"].Value = Email.Text.Trim();
cmd.Parameters["@pvchCreatedBy"].Value = "Admin";
cmd.ExecuteNonQuery();
retVal = (int)cmd.Parameters["@pIntErrDescOut"].Value;
}
}
if (retVal == 2)
{
lblMessage.Text = "Customer name or Email ID aready exist!";
}
else
{
GridViewSample.EditIndex = -1;
LoadData();
lblMessage.Text = "Record inserted successfully!";
}
}
}
update:
protected void GridViewSample_RowEditing(object sender, GridViewEditEventArgs e)
{
GridViewSample.EditIndex = e.NewEditIndex;
LoadData();
}
protected void GridViewSample_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Label Custid = (Label)GridViewSample.Rows[e.RowIndex].FindControl("lblCustID");
TextBox Name = (TextBox)GridViewSample.Rows[e.RowIndex].FindControl("txtCustName");
TextBox Address1 = (TextBox)GridViewSample.Rows[e.RowIndex].FindControl("txtCustAddres1");
TextBox Address2 = (TextBox)GridViewSample.Rows[e.RowIndex].FindControl("txtCustAddres2");
TextBox Phone = (TextBox)GridViewSample.Rows[e.RowIndex].FindControl("txtCustPhone");
TextBox Email = (TextBox)GridViewSample.Rows[e.RowIndex].FindControl("txtEmail");
using (SqlConnection Sqlcon = new SqlConnection(strCon))
{
using (SqlCommand cmd = new SqlCommand())
{
Sqlcon.Open();
cmd.Connection = Sqlcon;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_Customer";
cmd.Parameters.Add(new SqlParameter("@pvchAction", SqlDbType.VarChar, 50));
cmd.Parameters.Add(new SqlParameter("@pvchCustId", SqlDbType.Int));
cmd.Parameters.Add(new SqlParameter("@pvchCustName", SqlDbType.VarChar, 100));
cmd.Parameters.Add(new SqlParameter("@pvchustaddress1", SqlDbType.VarChar, 100));
cmd.Parameters.Add(new SqlParameter("@pvchustaddress2", SqlDbType.VarChar, 100));
cmd.Parameters.Add(new SqlParameter("@pvchCustPhone", SqlDbType.VarChar, 100));
cmd.Parameters.Add(new SqlParameter("@pvchCustEmail", SqlDbType.VarChar, 100));
cmd.Parameters.Add(new SqlParameter("@pvchCreatedBy", SqlDbType.VarChar, 100));
cmd.Parameters.Add("@pIntErrDescOut", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters["@pvchAction"].Value = "update";
cmd.Parameters["@pvchCustId"].Value = Convert.ToInt32(Custid.Text.ToString());
cmd.Parameters["@pvchCustName"].Value = Name.Text.Trim();
cmd.Parameters["@pvchustaddress1"].Value = Address1.Text.Trim();
cmd.Parameters["@pvchustaddress2"].Value = Address2.Text.Trim();
cmd.Parameters["@pvchCustPhone"].Value = Phone.Text.Trim();
cmd.Parameters["@pvchCustEmail"].Value = Email.Text.Trim();
cmd.Parameters["@pvchCreatedBy"].Value = "Admin";
cmd.ExecuteNonQuery();
int retVal = (int)cmd.Parameters["@pIntErrDescOut"].Value;
}
}
GridViewSample.EditIndex = -1;
LoadData();
lblMessage.Text = "Record updated successfully!";
}
|
