April 25, 2011

To Save Data in ASP.Net

SaveCallDetails(Request.QueryString["CID"].ToString(), txtTel1.Text, txtTel2.Text, ddlSecDisp.SelectedValue.ToString(),Session["UserID"].ToString(), DateTime.Now.ToString(), txtRemarks.Text);

private void SaveCallDetails(string CID, string Tel1, string Tel2, string DID,string EnterBy, string CallDateTime, string Remarks)
{
SqlConnection conSave = new SqlConnection(ConfigurationManager.ConnectionStrings["MPDB"].ConnectionString);
conSave.Open();

SqlCommand cmdSave = new SqlCommand("spSaveCallDetails", conSave);
cmdSave.CommandType = CommandType.StoredProcedure;

cmdSave.Parameters.AddWithValue("@CID",CID);
cmdSave.Parameters.AddWithValue("@TEL1",Tel1);
cmdSave.Parameters.AddWithValue("@TEL2",Tel2);
cmdSave.Parameters.AddWithValue("@DID", DID);
cmdSave.Parameters.AddWithValue("@ENTERBY",EnterBy);
cmdSave.Parameters.AddWithValue("@CALLDT",CallDateTime);
cmdSave.Parameters.AddWithValue("@REM", Remarks);

cmdSave.ExecuteNonQuery();

}

No comments:

Post a Comment