public void saveaddress1(string _LEDGERCODE, string _GRCODE, string _NAME, string _ADD1, string _ADD2, string _ADD3, string _city, string _State, string _PIN, string _PHONE, string _MOBILE, string _EmailId, string _UserId, string _WorkTime)
{
SqlConnection con = new SqlConnection(connection.connect);
con.Open();
SqlParameter[] parm = new SqlParameter[14];
parm[0] = new SqlParameter("@LEDGERCODE", _LEDGERCODE);
parm[1] = new SqlParameter("@GRCODE", _GRCODE);
parm[2] = new SqlParameter("@NAME", _NAME);
parm[3] = new SqlParameter("@ADD1", _ADD1);
parm[4] = new SqlParameter("@ADD2", _ADD2);
parm[5] = new SqlParameter("@ADD3", _ADD3);
parm[6] = new SqlParameter("@city", _city);
parm[7] = new SqlParameter("@State", _State);
parm[8] = new SqlParameter("@PIN", _PIN);
parm[9] = new SqlParameter("@PHONE", _PHONE);
parm[10] = new SqlParameter("@MOBILE", _MOBILE);
parm[11] = new SqlParameter("@EmailId", _EmailId);
parm[12] = new SqlParameter("@UserId", _UserId);
parm[13] = new SqlParameter("@WorkTime", _WorkTime);
SqlCommand com = new SqlCommand("saveaddress", con);
com.CommandType = CommandType.StoredProcedure;
for (int i = 0; i < 14; i++)
{
com.Parameters.Add(parm[i]);
}
com.ExecuteNonQuery();
con.Close();
}
{
SqlConnection con = new SqlConnection(connection.connect);
con.Open();
SqlParameter[] parm = new SqlParameter[14];
parm[0] = new SqlParameter("@LEDGERCODE", _LEDGERCODE);
parm[1] = new SqlParameter("@GRCODE", _GRCODE);
parm[2] = new SqlParameter("@NAME", _NAME);
parm[3] = new SqlParameter("@ADD1", _ADD1);
parm[4] = new SqlParameter("@ADD2", _ADD2);
parm[5] = new SqlParameter("@ADD3", _ADD3);
parm[6] = new SqlParameter("@city", _city);
parm[7] = new SqlParameter("@State", _State);
parm[8] = new SqlParameter("@PIN", _PIN);
parm[9] = new SqlParameter("@PHONE", _PHONE);
parm[10] = new SqlParameter("@MOBILE", _MOBILE);
parm[11] = new SqlParameter("@EmailId", _EmailId);
parm[12] = new SqlParameter("@UserId", _UserId);
parm[13] = new SqlParameter("@WorkTime", _WorkTime);
SqlCommand com = new SqlCommand("saveaddress", con);
com.CommandType = CommandType.StoredProcedure;
for (int i = 0; i < 14; i++)
{
com.Parameters.Add(parm[i]);
}
com.ExecuteNonQuery();
con.Close();
}
No comments:
Post a Comment