Re: Update cu DatagridView

ignatandrei — Sat, 14 Aug 2010 14:33:15 GMT

fa-i din nou bind-ul ca sa isi traga datele...

Update cu DatagridView

tuxman — Sat, 14 Aug 2010 10:55:59 GMT

Am urmatorul cod:

private void button1_Click(object sender, EventArgs e)
        {
            string connString = @"server = eu\sqlexpress;
                                  Database = Punctaje.mdf;
                                  trusted_connection = True;
                                  AttachDbFileName = C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Punctaje.mdf;";

            //DataGridViewCell cell = this.dataGridView1.CurrentCell;

          //string sql2 = "UPDATE Studenti SET Nume='" +cell.Value.ToString()+ "' ";

            SqlConnection conn = null;
            SqlDataReader reader2 = null;
            using (conn = new SqlConnection(connString))
            {
                conn.Open();

                SqlCommand cmd2 = new SqlCommand(sql2, conn);
                reader2 = cmd2.ExecuteReader();
                reader2.Close();
            }

        }

Dupa ce modific date in datagridview si apoi apas pe button1, vreau ca sa se updateze datele si in datagridview. Cum scriu codul ?
Va multumesc anticipat pentru raspuns.

Database APIs

Re: Update cu DatagridView

Update cu DatagridView