01.string sql = "Insert Into Dept_master(deptId,siteId) " +
02. " Values(@deptId,@siteId) ; " +
03. "Insert Into Dept_Detail(deptId,deptName) " +
04. " Values(@deptId,@deptDesc) ";
05. SqlCommand cmd = new SqlCommand(sql, conn);
06. cmd.Parameters.AddWithValue("deptId", SqlDbType.VarChar).Value = deptId.ToString();
07. cmd.Parameters.AddWithValue("siteId", SqlDbType.VarChar).Value = siteId.ToString();
08. cmd.Parameters.AddWithValue("deptDesc", SqlDbType.VarChar).Value = deptDesc.ToString();
09. conn.Open();
10. int i = cmd.ExecuteNonQuery();
11. conn.Close();
12. return i;
