public static void saveStudent(DataVariables objStu) { string DBCon = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; string Stuproc = "Insert_Student"; SqlParameter ps_id = new SqlParameter("@S_ID", SqlDbType.VarChar); ps_id.Value = objStu.Stus_id; SqlParameter ps_name = new SqlParameter("@S_name", SqlDbType.VarChar); ps_name.Value = objStu.Stus_name; SqlParameter ps_dept = new SqlParameter("@dept_name", SqlDbType.VarChar); ps_dept.Value = objStu.Strdept_name; SqlConnection connect = new SqlConnection(DBCon); try { connect.Open(); SqlCommand cmd1 = new SqlCommand(); cmd1.Connection = connect; cmd1.CommandType = CommandType.StoredProcedure; cmd1.CommandText = Stuproc; cmd1.Parameters.Add(ps_id); cmd1.Parameters.Add(ps_name); cmd1.Parameters.Add(ps_dept); cmd1.ExecuteNonQuery(); } catch (Exception) { throw; } }
protected void txtsub_Click(object sender, EventArgs e) { DataVariables objStu = new DataVariables(); objStu.Stus_id = txts_id.Text; objStu.Stus_name = txts_name.Text; objStu.Strdept_name = txts_dept.Text; DataInput.saveStudent(objStu); Response.Write("New Student is Created"); }
protected void txtsubmit_Click(object sender, EventArgs e) { DataVariables objcreate = new DataVariables(); objcreate.Strdept_name = txtdept.Text; objcreate.Strbuilding = txtbuilding.Text; objcreate.Intbudget = txtbudget.Text; DataInput.saveDept(objcreate); Response.Write("New Department is Created"); }
protected void txtsubmit1_Click(object sender, EventArgs e) { DataVariables objins = new DataVariables(); objins.Insi_id = txti_id.Text; objins.Stri_name = txti_name.Text; objins.Strdept_name = txti_dept.Text; objins.Inssalary = txti_salary.Text; DataInput.saveIns(objins); Response.Write("New Instructor is Created"); }
public static void saveIns(DataVariables objins) { string DBCon = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; string Insproc = "Insert_Instructor"; SqlParameter pi_id = new SqlParameter("@I_ID", SqlDbType.VarChar); pi_id.Value = objins.Insi_id; SqlParameter pi_name = new SqlParameter("@I_NAME", SqlDbType.VarChar); pi_name.Value = objins.Stri_name; SqlParameter psalary = new SqlParameter("@salary", SqlDbType.VarChar); psalary.Value = objins.Inssalary; SqlParameter pdept_name = new SqlParameter("@dept_name", SqlDbType.VarChar); pdept_name.Value = objins.Strdept_name; SqlConnection con = new SqlConnection(DBCon); try { con.Open(); SqlCommand cm = new SqlCommand(); cm.Connection = con; cm.CommandType = CommandType.StoredProcedure; cm.CommandText = Insproc; cm.Parameters.Add(pi_id); cm.Parameters.Add(pi_name); cm.Parameters.Add(pdept_name); cm.Parameters.Add(psalary); cm.ExecuteNonQuery(); } catch (Exception) { throw; } }
public static void saveDept(DataVariables objtest) { string DBCon = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; string Deptproc = "Insert_Department"; SqlParameter pdept_name = new SqlParameter("@dept_name", SqlDbType.VarChar); pdept_name.Value = objtest.Strdept_name; SqlParameter pbuilding = new SqlParameter("@building", SqlDbType.VarChar); pbuilding.Value = objtest.Strbuilding; SqlParameter pbudget = new SqlParameter("@budget", SqlDbType.VarChar); pbudget.Value = objtest.Intbudget; SqlConnection conn = new SqlConnection(DBCon); try { conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = Deptproc; cmd.Parameters.Add(pdept_name); cmd.Parameters.Add(pbuilding); cmd.Parameters.Add(pbudget); cmd.ExecuteNonQuery(); } catch (Exception) { throw; } }