Employers - Post Free Jobs
Forum guidelines
AuthorQuestion
Save from DataGridView c# to database
Posted on: 03 May 2013
Is there tutorils videos about this thing ?

AuthorReply
Satyapriya Nayak
  • 1
  • 0
accepted
Re: Save from DataGridView c# to database
Posted on: 03 May 2013   Accepted Answer
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.OleDb;
namespace Insertdata_from_datagrid__dbcsharp
{
    public partial class Form1 : Form
    {
        string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dsn"];
        OleDbCommand com;
        OleDbDataAdapter oledbda;
        DataSet ds;
        string str;
      

        public Form1()
        {
            InitializeComponent();
        }

        private void btn_insert_Click(object sender, EventArgs e)
        {

            for (int i = 0; i < dataGridView1.Rows.Count-1; i++)
            {
         
                str = @"INSERT INTO student1(sid,sname,smarks,saddress) VALUES ('" + dataGridView1.Rows[i].Cells["sid"].Value + "', '" + dataGridView1.Rows[i].Cells["sname"].Value + "'," + dataGridView1.Rows[i].Cells["smarks"].Value + ",'" + dataGridView1.Rows[i].Cells["saddress"].Value + "');";
                try
                {
                    using (OleDbConnection con = new OleDbConnection(ConnectionString))
                    {
                        using (com = new OleDbCommand(str, con))
                        {
                            con.Open();
                            com.ExecuteNonQuery();
                        }
                    }
                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }

            }
            label1.Text = "Records inserted successfully";
        }

        private void bindgrid()
        {
            OleDbConnection con = new OleDbConnection(ConnectionString);
            con.Open();
            str = "select * from student";
            com = new OleDbCommand(str, con);
            oledbda = new OleDbDataAdapter(com);
            ds = new DataSet();
            oledbda.Fill(ds, "student");
            dataGridView1.DataMember = "student";
            dataGridView1.DataSource = ds;
            con.Close();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            bindgrid();
        }
    }
}


If this post helps you mark it as answer
Thanks

Re: Save from DataGridView c# to database
Posted on: 04 May 2013  
Tank you my dear ,but after I fill the cells how can I save it ? and after I save it how can I see it ?
Re: Save from DataGridView c# to database
Posted on: 04 May 2013  
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.OleDb;

namespace Update_delete_datagridview
{
    public partial class Form1 : Form
    {
       OleDbDataAdapter oledbda;
       OleDbCommandBuilder olcb;
       DataTable dataTable;
       BindingSource bindingSource;
       string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dsn"];
       string str;

        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {

            OleDbConnection con = new OleDbConnection(ConnectionString);
            con.Open();
            str = "SELECT * FROM student";
         
            oledbda = new OleDbDataAdapter(str, con);
            olcb = new OleDbCommandBuilder(oledbda);
            dataTable = new DataTable();
            oledbda.Fill(dataTable);
            con.Close();
            bindingSource = new BindingSource();
            bindingSource.DataSource = dataTable;
            dataGridView1.DataSource = bindingSource;
            dataGridView1.Columns[0].Visible = false;
        }

        private void btnaddupdate_Click(object sender, EventArgs e)
        {
            try
            {
                oledbda.Update(dataTable);
            }
            catch (Exception exceptionObj)
            {
                MessageBox.Show(exceptionObj.Message.ToString());
            }
            MessageBox.Show("Records updated");

        }

        private void btndelete_Click(object sender, EventArgs e)
        {
            try
            {
                dataGridView1.Rows.RemoveAt(dataGridView1.CurrentRow.Index);
                oledbda.Update(dataTable);
            }
            catch (Exception exceptionObj)
            {
                MessageBox.Show(exceptionObj.Message.ToString());
            }
            MessageBox.Show("Records Deleted");
        }

      
    }
}


If this post helps you mark it as answer
Thanks

Re: Save from DataGridView c# to database
Posted on: 04 May 2013  
Thank you very much , can you tell me how can I see all records that I save it .
Employers - Post Free Jobs

SPONSORED BY

Offshore Software and Database Development
MCN is your source for developing solutions involving websites, mobile apps, cloud-computing, databases, BI, back-end services and processes and client-server applications.