DataGridViewComboBoxCell dgvcbc = new DataGridViewComboBoxCell();
            foreach (string name in grades)
            {
                dgvcbc.Items.Add(name);
            }
            e.Row.Cells["Grades"] = dgvcbc;

The code you are trying is correct.

Can you post more code.

---

Thanks, A.m.a.L | [Remember to click "mark as answered" when you get a correct reply to your question]

try
{
    this.Validate();
    this.yourBindingSource.EndEdit();      this.yourTableAdapter.Update(this.yourDataSet.YourDataTable);
    MessageBox.Show("Update successful");
}
catch (System.Exception ex)
{
    MessageBox.Show("Update failed");
}

see this article it will help you to know how to update dataset changes in the database

http://msdn.microsoft.com/en-us/library/system.data.common.dataadapter.update.aspx

this.Validate();
this.yourBindingSource.EndEdit();
this.yourTableAdapter.Update(this.yourDataSet.YourDataTable);



This upper code i would like to put into private void buttonSave(object sender, EventArgs e)

- is that OK?
----------------------------------------------------------------------------------------------------

The 1st code in the form_Load:

DataGridViewComboBoxColumn col = new
 DataGridViewComboBoxColumn();
for 
 (int 
mygrade = 5; mygrade <=10; mygrade++)
{
  col.Items.Add(mygrade);
}
col.DataPropertyName = "Grade";
col.HeaderText = "Grade";
col.DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing; // or ComboBox


this
.dataGridView1.Columns.Add(col);


Is this ok? I mean that I have something in a form_Load and the other in the Button1_Click?
Because the save have to happen while changing and pressing a "Save" button.

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 seminarska4

{

public partial class PregledOsebja : Form

{

SqlConnection povezava;

public PregledOsebja()

{

InitializeComponent();

}

private void PregledOsebja_Load(object sender, EventArgs e)

{

string p = @"Data Source=.\SQLEXPRESS;AttachDbFilename=D:\Informatika\PRO2\Seminarska4\baza_NET.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True" ;

povezava = new SqlConnection (p);

comboBoxOsebje.Items.Add("Študenti" );

comboBoxOsebje.Items.Add("Učitelji" );

listBoxIzbira.Visible = false ;

dataGridView1.Visible = false ;

dataGridView1.RowHeadersVisible = false ;

// 1. Combobox in dataGridView for Ocena (eng-Grade):

DataGridViewComboBoxColumn ocena = new DataGridViewComboBoxColumn ();

for (int grade = 5; grade <= 10; grade++)

{

ocena.Items.Add(grade);

}

ocena.DataPropertyName = "Ocena" ;

ocena.HeaderText = "Ocena" ;

ocena.Width = 48;

ocena.DisplayStyle = DataGridViewComboBoxDisplayStyle .Nothing;

this .dataGridView1.Columns.Add(ocena);

// 2. Combobox in dataGridView for ime (eng-Student`s name):

// DataGridViewComboBoxColumn ime = new DataGridViewComboBoxColumn();

// 3. Combobox in dataGridView for DatumVnosa (eng-Insert date):

// DataGridViewComboBoxColumn DatumVnosa = new DataGridViewComboBoxColumn();

}

private void buttonShrani_Click(object sender, EventArgs e)

{

DataSet dataset = new DataSet ();

povezava.Open();

SqlDataAdapter adapter = new SqlDataAdapter ();

string poizvedba = "SELECT Ocena FROM Ocene" ; //Select Grade From Grades"

adapter.SelectCommand = new SqlCommand (poizvedba, povezava);

SqlCommandBuilder builder = new SqlCommandBuilder (adapter);

adapter.Fill(dataset);

//HERE GOES THE CODE?? what code?

adapter.UpdateCommand = builder.GetUpdateCommand();

adapter.Update(dataset);

povezava.Close();

//return dataset;

}

}

}

Would you take a look at this code and tell me what do to more? How to do code for saving back into db.

private void buttonShrani_Click(object sender, EventArgs e)

{

povezava.Open();

SqlDataAdapter dataAdapter = new SqlDataAdapter ();

string poizvedba = "SELECT Ocena FROM Ocene" ;

dataAdapter.SelectCommand = new SqlCommand (poizvedba, povezava);

SqlCommandBuilder commBuilder = new SqlCommandBuilder (dataAdapter);

DataSet dataSet = new DataSet ();

adapter.Fill(dataSet);

ocena.DataSource = dataSet.Tables["Ocena" ];

try

{

this .Validate();

this .dataGridView1.EndEdit();

this .yourTableAdapter.Update(this .yourDataSet.YourDataTable);

MessageBox .Show("Update successful" );

}

catch (System.Exception ex)

{

MessageBox .Show("Update failed" );

}

adapter.UpdateCommand = builder.GetUpdateCommand();

adapter.Update(dataset);

povezava.Close();

//return dataset;

}

this.dataGridView1.EndEdit();

this.yourTableAdapter.Update(this.yourDataSet.YourDataTable);

What to do in case that I don`t have a tableAdapter? What to do then? Insteda od table adapter I have a query ( an sql statement, which get the required filds out of the database). And what would be the "yourDataSet" and "YourDataTable" in my case?

This is my 1st time that I`ve experianced to work and changing dataGrid. So, I would really appreciate some help! I know you guys can help me. Thx

this error occured becaue you didn't retrieve the primary key from the data base, if you have it return it in the select statement

debug you application and trace it to the line after dataAdapter.InsertCommand = commBuilder.GetInsertCommand(); and dataAdapter.UpdateCommand = commBuilder.GetUpdateCommand(); , then check what is the insert and update command text, maybe it's wrong.

SqlConnection povezava;
        DataSet dataSet;
        SqlDataAdapter dataAdapter;
        SqlCommandBuilder commBuilder;

        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            string p = "Data Source=sqlserver;Initial Catalog=Wael;User ID=sa;Password=sa";
            povezava = new SqlConnection(p);

            comboBox1.Items.Add("Student");
            comboBox1.Items.Add("Ueitel");
             //Combobox v dataGridView za OCENA - in izbira vseh mo‍nih ocen:           

            DataGridViewComboBoxColumn ocena = new DataGridViewComboBoxColumn();
            for (int grade = 5; grade <= 10; grade++)
            {
                ocena.Items.Add(grade);
            }
           ocena.DataPropertyName = "Ocena";
           ocena.HeaderText = "Ocena";
           ocena.Width = 48;
           ocena.DisplayStyle = DataGridViewComboBoxDisplayStyle.Nothing;
           this.dataGridView1.Columns.Add(ocena);

           string poizvedba = "SELECT ItemNumber,ItemName FROM Items";
           dataSet = new DataSet();
           dataAdapter = new SqlDataAdapter();
           
           commBuilder = new SqlCommandBuilder(dataAdapter);
           dataAdapter.SelectCommand = new SqlCommand(poizvedba, povezava);
           dataAdapter.Fill(dataSet, "Items");
           dataGridView1.DataSource = dataSet.Tables["Items"]; 
        }

        private void button1_Click(object sender, EventArgs e)
        {
            dataAdapter.InsertCommand = commBuilder.GetInsertCommand();
            dataAdapter.UpdateCommand = commBuilder.GetUpdateCommand();
            try
            {
                Validate();
                dataGridView1.EndEdit();
                dataAdapter.Update(dataSet,"Items");
                //dataAdapter.Update(dataSet, "Ocena");
                MessageBox.Show("Update successful");
            }
            catch (System.Exception ex)
            {
                MessageBox.Show(ex.Message, "Update failed");
            }
            povezava.Close();
        }

Hi Mitja,

> How to do coding for to remove the old and replace it with the new selected grade?

Use TableAdapter or DataAdapter to save changes back to DB. Please read the following MSDN documents on how to configurate data adapters or table adapters.

"Data Adapter Configuration Wizard"
http://msdn.microsoft.com/en-us/library/kb6bw5z5(VS.71).aspx

"How to: Create TableAdapters"
http://msdn.microsoft.com/en-us/library/6sb6kb28(VS.80).aspx

Hope this helps.

Sincerely,
Linda Liu