updating a datagrid view

Hi Friend ,

Here is What you want I have also included Project Files So you can take reference if you don't understand by just reading code :) download link is At bottom of post

don't forget to mark "Do you like this answer" please it will give me some credits :)

namespace WindowsFormsApplication17
{
    public partial class Form1 : Form
    {
        DataSet ds;
        public Form1()
        {
            InitializeComponent();
        }
 
        private void Form1_Load(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True");
            con.Open();
            SqlCommand comm = new SqlCommand("Select * from Users",con);
            SqlDataAdapter da = new SqlDataAdapter(comm);
            ds = new DataSet();
            da.Fill(ds, "vtable");
            dataGridView1.DataSource = ds.Tables[0];
            con.Close();
         }
 
        private void btnUpdate_Click(object sender, EventArgs e)
        {
            DataSet DataSetwithModifiedRows = ds.GetChanges();
            DataTable dt = DataSetwithModifiedRows.Tables[0];
 
            foreach (DataRow r in dt.Rows)
            {
                string Username = r[0].ToString();
                string Password = r[1].ToString();
 
                SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True");
                con.Open();
                SqlCommand comm = new SqlCommand("update Users set Password=@password where username=@username", con);
                comm.Parameters.AddWithValue("@Username", Username);
                comm.Parameters.AddWithValue("@password", Password);
                comm.ExecuteNonQuery();
                con.Close(); 
           }
            MessageBox.Show("Data Updated!!");
 
        }
    }
}

Download Project Files

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kirtan Patel17y ago
Friend,

Just Execute All the Code Again that is in Form Load Event

or make one Function of all the Code in Form Load and Call that Function after Updating /Inserting Data so Grid view Will Show New Records
0
Pel17y ago
Hi Kirtan
thank you for the reply, but what if i am adding a new record in the datagridview. I wanted to use the dataadapter update and sqlcmdbuilder options to generate the respective update, insert or delete commands.
Regards
Pel
0
Kirtan Patel17y ago
Hi Friend ,

Here is What you want I have also included Project Files So you can take reference if you don't understand by just reading code :) download link is At bottom of post

don't forget to mark "Do you like this answer" please it will give me some credits :)

namespace WindowsFormsApplication17
{
    public partial class Form1 : Form
    {
        DataSet ds;
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True");
            con.Open();
            SqlCommand comm = new SqlCommand("Select * from Users",con);
            SqlDataAdapter da = new SqlDataAdapter(comm);
            ds = new DataSet();
            da.Fill(ds, "vtable");
            dataGridView1.DataSource = ds.Tables[0];
            con.Close();
         }

        private void btnUpdate_Click(object sender, EventArgs e)
        {
            DataSet DataSetwithModifiedRows = ds.GetChanges();
            DataTable dt = DataSetwithModifiedRows.Tables[0];

            foreach (DataRow r in dt.Rows)
            {
                string Username = r[0].ToString();
                string Password = r[1].ToString();

                SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True");
                con.Open();
                SqlCommand comm = new SqlCommand("update Users set Password=@password where username=@username", con);
                comm.Parameters.AddWithValue("@Username", Username);
                comm.Parameters.AddWithValue("@password", Password);
                comm.ExecuteNonQuery();
                con.Close();
           }
            MessageBox.Show("Data Updated!!");

        }
    }
}

Download Project Files
0
Roei Bar17y ago
if you are bounded to datatable then its no problem

once you click on the updatebutton just call again the

grid.dataBind()

in order for it to get the new changes
0