hello

Sunday, 24 July 2011

how pass perametres in storprocedure

   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();

        }

No comments:

Post a Comment