Update Data Code with the help of Id taken from Query String or from
other Parameter
Step by Step
:
1.
Take Id from Query String which come from other page ( for example from GridView Edit Button in GridView
Command Event by [ e.CommandArgument ]
in the
region of [ e.Command Name ]
2.
This Process
is same as Insert Process accept it take another paramer for Id which will be
put in Sql Procedure with where clause.
Code:
//Update
Button Code
protected void btnUpdate_Click(object sender, ImageClickEventArgs
e)
{
try
{
/*******************************Updation********************************/
objProp.EventTitle = txtEventTitle.Text.Trim();
objProp.EventDate = Convert.ToDateTime(txtEventDate.Text);
objProp.ClientID = Convert.ToInt32(Session["clientId"]);
objProp .EventId =Convert.ToInt32(Request.QueryString["id"]);
ClsEvent objEvent = new ClsEvent();
bool IsDone=objEvent .UpadteEvent(objProp );
if (!IsDone)
{
Response.Redirect("message.aspx?EventIsOpen=true&id=73");
}
else
lblError.Text = "Error Occure";
/*******************************End***************************************/
}
catch (Exception
ex)
{
lblError.Text = "<b>Following Error
Found<p>" + ex + "</p></b>";
}
}
//Update
Button Code
public bool UpadteEvent(ClsEventProp objProp)
{
bool IsDone;
ClsEventDB objDB = new ClsEventDB();
IsDone =
objDB.UpadteEvent(objProp);
return IsDone;
}
//Update
Button Code
internal bool UpadteEvent(ClsEventProp objProp)
{
SqlParameter[] param ={
new SqlParameter ("@EventId",objProp.EventId ),
new SqlParameter ("@EventTitle",objProp .EventTitle ),
new SqlParameter ("@EventDate",objProp .EventDate ),
new SqlParameter ("@ClientId",objProp .ClientID )
};
return ClsDataLayer.GetScaler("sp_Update_Event", param);
}
//Main
Datalayer Code
[
When return true false for confirmation of right execution ]
internal static bool GetScaler(string
ProcName, SqlParameter[] param)
{
bool IsDone;
SqlConnection cn = GetConnection();
SqlCommand cmd = new
SqlCommand(ProcName, cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cn.Open();
SqlParameter returnValue = new SqlParameter("returnValue", SqlDbType.Int);
returnValue.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(returnValue);
foreach (SqlParameter
par in param)
{
cmd.Parameters.Add(par);
}
cmd.ExecuteNonQuery();
IsDone =
Convert.ToBoolean(returnValue.Value);
cn.Close();
cn.Dispose();
return IsDone;
}
[
When return int result for taking value which is return by stroed procedure]
public static int InsertUpdate(String
p, SqlParameter[] param)
{
int id;
SqlConnection conn = GetConnection();
SqlCommand cmd = new
SqlCommand(p, conn);
try
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
conn.Open();
SqlParameter returnvalue = new
SqlParameter("returnvalue",
SqlDbType.Int);
returnvalue.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(returnvalue);
foreach (SqlParameter
para in param)
{
cmd.Parameters.Add(para);
}
cmd.ExecuteNonQuery();
id =
Convert.ToInt32(returnvalue.Value);
return id;
}
catch (Exception
ex)
{
throw ex;
}
finally
{
cmd.Dispose();
conn.Close();
}
}
