Insert, Update, Delete with DataGridView Control in C# (Windows Application)? [Resolved]

Hi,
see this code

public partial class DataTrialForm : Form

    {

        private String connectionString = null;

        private SqlConnection sqlConnection = null;

        private SqlDataAdapter sqlDataAdapter = null;

        private SqlCommandBuilder sqlCommandBuilder = null;

        private DataTable dataTable = null;

        private BindingSource bindingSource = null;

        private String selectQueryString = null;



        public DataTrialForm()

        {

            InitializeComponent();

        }



        private void DataTraiForm_Load(object sender, EventArgs e)

        {

            

            sqlConnection = new SqlConnection("data source=SEZ-WS-137\\SQLEXPRESS2008;initial catalog=AttendanceData;user id=sa;password=pass");

            selectQueryString = "select top 20 * from Attendance  order by punchtime asc";



            sqlConnection.Open();



            sqlDataAdapter = new SqlDataAdapter(selectQueryString, sqlConnection);

            sqlCommandBuilder = new SqlCommandBuilder(sqlDataAdapter);



            dataTable = new DataTable();

            sqlDataAdapter.Fill(dataTable);

            bindingSource = new BindingSource();

            bindingSource.DataSource = dataTable;



            dataGridViewTrial.DataSource = bindingSource;

            

            // to hide Identity column

            dataGridViewTrial.Columns[0].Visible = false;

        }



        private void addUpadateButton_Click(object sender, EventArgs e)

        {

            try

            {

                sqlDataAdapter.Update(dataTable);

            }

            catch (Exception exceptionObj)

            {

                MessageBox.Show(exceptionObj.Message.ToString());

            }

        }



        private void deleteButton_Click(object sender, EventArgs e)

        {

            try

            {

               dataGridViewTrial.Rows.RemoveAt(dataGridViewTrial.CurrentRow.Index);

               sqlDataAdapter.Update(dataTable);

            }

            catch (Exception exceptionObj)

            {

               MessageBox.Show(exceptionObj.Message.ToString());

            }

        }

    }

Blessy Baby
Digitalmesh Softech pvt Ltd
https://blessybaby.wordpress.com/

Sudheep.grandhe, if this helps please login to Mark As Answer. | Alert Moderator

Hi Sudheep,

Please check this link http://khanrahim.wordpress.com/2010/04/10/insert-update-delete-with-datagridview-control-in-c-windows-application/ .

Blessy Baby
Digitalmesh Softech pvt Ltd
https://blessybaby.wordpress.com/

Sudheep.grandhe, if this helps please login to Mark As Answer. | Alert Moderator

Hi,

private void addUpadateButton_Click(object sender, EventArgs e)

{

try

{

sqlDataAdapter.Update(dataTable);// when i was trying to type the code as sqldataadapter.update-update will not coming in intellices

}

catch (Exception exceptionObj)

{

MessageBox.Show(exceptionObj.Message.ToString());// same problem

}

}

Best,
Sudheep.

Sudheep.grandhe, if this helps please login to Mark As Answer. | Alert Moderator

Hi,

you can changes values in rows of grid. After change any value and click on the button, that change will reflect in grid and db. try this
also select any row and click delete button that row will disappear

Blessy Baby
Digitalmesh Softech pvt Ltd
https://blessybaby.wordpress.com/

Sudheep.grandhe, if this helps please login to Mark As Answer. | Alert Moderator

Hi,

I don't want to write the database code on the window page, i want write code in a class and accessing that class code on the page.

So, how is it possible ?

suppose if used there same code then it through error.

Sudheep.grandhe, if this helps please login to Mark As Answer. | Alert Moderator

can i get one sample windows application.(C# & ASP .net)
i m beginner for windows application so need to help from some ready made sample project.

Sudheep.grandhe, if this helps please login to Mark As Answer. | Alert Moderator

When i click on Add\update button, a dialog box showing syntax error INSERT INTO and when i click on Delete button it also shows a dialog "Dynamic SQL generation for the DeleteCommand is not supported against a SelectCommand that does not return any key column information"
why it is happening like please give me reply..

Sudheep.grandhe, if this helps please login to Mark As Answer. | Alert Moderator