Data Binding in C#

Question

Sir I am doing a C# data binding Program. I have some error in it and I wish that you will solve that. If you think you can please reply and i will send you the form and database.

Iftikar Hussain · Answer

Hi Please provide more details. like from where you are trying to bind it etc. Regards Iftikar

Iftikar Hussain · Answer

put the break point in save function and see weather your changes is getting updated successfully or not. And also after saving the sp is getting the result or not Regards Iftikar

Bineesh VP · Answer

I am not getting any error by save button click but the function not giving me the result I expect I used the same button for Save and Update. when I click in dgvClass the text of btnSave changes to Update. please do the repair in the code I given

Iftikar Hussain · Answer

What error you are getting while updating the data and in which method Regards Iftikar

Bineesh VP · Answer

Ok then I am uploading the databse file and the forms being copied here this is My form named frmClas:- using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Data; using System.Data.SqlClient; using System.Windows.Forms; namespace work { class classSp : DBConnection { public void classAdd(classInfo infoclass)/* infoclass(public decimal classId(get;set)public string className(get;set;)public int NoOfseats(get;set) */ { try { if (sqlCon.State == ConnectionState.Closed) { sqlCon.Open(); } SqlCommand sqlcmd = new SqlCommand(classAdd sqlCon);/* please inspect in database*/ sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Add(@className SqlDbType.NVarChar 20).Value = infoclass.className; sqlcmd.Parameters.Add(@noOfseats SqlDbType.Decimal).Value = infoclass.noOfseats; int incount = sqlcmd.ExecuteNonQuery(); if (incount > 0) { MessageBox.Show(Saved Successfully); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { sqlCon.Close(); } } public void classEdit(classInfo infoclass)// to update { try { if (sqlCon.State == ConnectionState.Closed) { sqlCon.Open(); } SqlCommand sqlcmd = new SqlCommand(classEdit sqlCon); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Add(@classId SqlDbType.Decimal).Value = infoclass.classId; sqlcmd.Parameters.Add(@className SqlDbType.NVarChar 20).Value = infoclass.className; sqlcmd.Parameters.Add(@noOfseats SqlDbType.Int).Value = infoclass.noOfseats; int incount = sqlcmd.ExecuteNonQuery(); if (incount > 0) { MessageBox.Show(Updated Sucessfully); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlCon.Close(); } } public DataTable classviewAll() //to fill the data in dgvClass in form load event { DataTable sqlDt = new DataTable(); SqlDataAdapter sqlDA = new SqlDataAdapter(classviewAll sqlCon); sqlDA.SelectCommand.CommandType = CommandType.StoredProcedure; sqlDA.Fill(sqlDt); return sqlDt; } public classInfo classView(decimal decclassId) // to show the data in both textbox in the event of dgvClass_CellDoubleClick-Event { classInfo infoclass = new classInfo(); SqlDataReader sqlRdr = null; try { if (sqlCon.State == ConnectionState.Closed) { sqlCon.Open(); } SqlCommand sqlcmd = new SqlCommand(classView sqlCon); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Add(@classId SqlDbType.Decimal).Value = decclassId; sqlRdr = sqlcmd.ExecuteReader(); while (sqlRdr.Read()) { infoclass.classId = decimal.Parse(sqlRdr[classId].ToString()); infoclass.className = sqlRdr[className].ToString(); infoclass.noOfseats = int.Parse(sqlRdr[noOfseats].ToString()); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlCon.Close(); } return infoclass; } } } this is Sp class coding and the frmclass.cs is following:- using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace work { public partial class frmclass : Form { protected SqlConnection sqlCon=new SqlConnection(@Data Source=.\SQLEXPRESS;AttachDbFilename=G:\SQL Server\DBSchoolDetails.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True); public int Incount; public frmclass() { InitializeComponent(); } private void txtClassName_KeyDown(object sender KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { txtNoofSeats.Focus(); txtClassName.BackColor = Color.LightBlue; } } private void txtNoofSeats_KeyDown(object sender KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { txtClassName.Focus(); txtNoofSeats.BackColor = Color.LightBlue; } if (e.KeyCode == Keys.Back) { if (txtNoofSeats.Text==string.Empty) { txtClassName.Focus(); } } } private void btnClear_Click(object sender EventArgs e) { clear(); txtClassName.BackColor = Color.Empty; txtNoofSeats.BackColor = Color.Empty; txtClassName.Focus(); } private void btnClose_Click(object sender EventArgs e) { if (MessageBox.Show(Do You want to Quit? Message MessageBoxButtons.YesNo MessageBoxIcon.Question) == DialogResult.Yes) { this.Close(); } } private void txtNoofSeats_KeyPress(object sender KeyPressEventArgs e) { if(!char.IsNumber(e.KeyChar)) { e.Handled=true; } if (e.KeyChar == '\b') { e.Handled = false; } } private void txtClassName_KeyPress(object sender KeyPressEventArgs e) { if (!char.IsLetter(e.KeyChar)) { e.Handled = true; } if (e.KeyChar == '\b') { e.Handled = false; } } public void classviewAll() { classSp spclass = new classSp(); DataTable dt = new DataTable(); dt = spclass.classviewAll(); dgvClass.DataSource = dt; } public void clear() { txtClassName.Clear(); txtNoofSeats.Clear(); btnSave.Text = Save; txtsearch.Clear(); } public void saveoredit() { if (txtClassName.Text == string.Empty && txtNoofSeats.Text == string.Empty) { MessageBox.Show(Please enter the values of Class Name School MessageBoxButtons.OK MessageBoxIcon.Information); txtClassName.Focus(); } else if (txtClassName.Text != string.Empty && txtNoofSeats.Text == string.Empty) { MessageBox.Show(Please enter the value no of seats School MessageBoxButtons.OK MessageBoxIcon.Information); txtNoofSeats.Focus(); } else if (txtClassName.Text == string.Empty && txtNoofSeats.Text != string.Empty) { MessageBox.Show(please enter the class name School MessageBoxButtons.OK MessageBoxIcon.Information); txtClassName.Focus(); } else if (Convert.ToInt32(txtNoofSeats.Text) == 0) { MessageBox.Show(Zero not allowed School MessageBoxButtons.OK MessageBoxIcon.Information); txtNoofSeats.Focus(); } } private void btnSave_Click(object sender EventArgs e) { classInfo infoclass = new classInfo(); classSp spclass = new classSp(); if (btnSave.Text == Save) { if (txtClassName.Text.Trim() != string.Empty && txtNoofSeats.Text.Trim() != string.Empty) { infoclass.className = txtClassName.Text; if (txtNoofSeats.Text.Trim() != string.Empty) { infoclass.noOfseats = decimal.Parse(txtNoofSeats.Text); } else { infoclass.noOfseats = 0; } spclass.classAdd(infoclass); classviewAll(); } else { txtClassName.Focus(); } } if (btnSave.Text == Update) { decimal decclassId = decimal.Parse(dgvClass.CurrentRow.Cells[0].Value.ToString()); infoclass.classId = decclassId; infoclass.className = txtClassName.Text; infoclass.noOfseats = decimal.Parse(txtNoofSeats.Text); spclass.classEdit(infoclass); classviewAll(); } } private void frmclass_Load(object sender EventArgs e) { classviewAll(); } private void dgvClass_CellDoubleClick(object sender DataGridViewCellEventArgs e) { classInfo infoClass = new classInfo(); classSp spClass = new classSp(); infoClass = spClass.classView(decimal.Parse(dgvClass.CurrentRow.Cells[0].Value.ToString())); txtClassName.Text = infoClass.className; txtNoofSeats.Text = infoClass.noOfseats.ToString(); btnSave.Text = Update; } private void btnSave_KeyDown(object sender KeyEventArgs e) { classInfo infoclass = new classInfo(); classSp spclass = new classSp(); if (e.Control && e.KeyCode == Keys.S) { if (e.KeyCode == Keys.Enter) { if (btnSave.Text == Save) { spclass.classAdd(infoclass); } } } else spclass.classEdit(infoclass); } private void btnClose_KeyDown(object sender KeyEventArgs e) { if (e.KeyCode == Keys.Alt && e.KeyCode == Keys.F4) { if (MessageBox.Show(Do You want to Quit Message MessageBoxButtons.YesNo MessageBoxIcon.Warning) == DialogResult.Yes) { this.Close(); } } } private void dgvClass_DataBindingComplete(object sender DataGridViewBindingCompleteEventArgs e) { dgvClass.ClearSelection(); } } } So here I am illustrate what is I need from this form:- 1) button save click: save the data(I did) 2) form load event: loading the data into dgvClass(I did) 3) dgvClas_Double Click: display the data in concerned textboxes( I did) 4) update the data by click save button(I want your help in this coding)

Iftikar Hussain · Answer

at least provide me the main logic from where you are getting data from db and binding it. you can paste it your post only Regards Iftikar

Sanjeeb Lenka · Answer

copy paste your code directly here

Bineesh VP · Answer

Sir I have a problem in uploading in this reply. The form and database comes about 7 MB. have this problem has any solution?