Sir, I am now in a ADO.NET Program There are Two Forms in My Program 1) frmClass and frmDivision
I want your help in the functions of frmDivision. here is frmClass:-
and here is the frmDivision So these are my forms. now My Task is :- 1) Save className and divisionName to frmDivision and tbl_Division by btn_Save_Click event please send me the code t 2) Update the dataGridView1 Data by cell_Double_Click event of dataGridView1 in frmDivision here are the task I done in this program:- className has been passed to comboBox in the frmDivision
here is my database Stored procedure to save the data in frmDivision:-
ALTER PROCEDURE divisionAdd@divisionName nvarchar(20),@classId numeric(18,0) AS if not exists(select divisionName from tbl_Division where divisionName=@divisionName) begin insert into tbl_Division(divisionName,classId) values(@divisionName,@classId) end RETURN
this stored procedure is been called in SpDivision.here the spDivsion function to save the data in frmDivision:-
public void divisionAdd(divisionInfo infodivision) { try { if (sqlCon.State == ConnectionState.Closed) { sqlCon.Open(); } SqlCommand sqlCmd = new SqlCommand("divisionAdd", sqlCon); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.Add("@divisionName", SqlDbType.NVarChar).Value = infodivision.divisionName; sqlCmd.Parameters.Add("@classId", SqlDbType.Decimal).Value = infodivision.classId; int incount = sqlCmd.ExecuteNonQuery(); if (incount > 0) { MessageBox.Show("Saved Successfully"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { sqlCon.Close(); } }
This function is been called in frmDivision.cs.here is the code:-
private void btnSave_Click(object sender, EventArgs e) { divisionSp spdivision = new divisionSp(); divisionInfo info = new divisionInfo(); info.classId = decimal.Parse(cmbClassName.SelectedValue.ToString()); // here I geetinan error. see the error next to the function info.divisionName = txtDivisionName.Text; spdivision.divisionAdd(info); divisionGridFill(); }
So I want your help in this error.
My tbl_Division columns are:- divisionId(pk),divisionName,classId(fk)
The code in infoDivision class is:-
class divisionInfo { public decimal divisionId { get; set; } public string divisionName { get; set; } public decimal classId { get; set; } }
So Please help me in the following functions:-
1) save the className and divisionName to the frmDivision and to the tbl_Division
2) Update the datagridView1 data bt cellDoubleClick event