C#

dj_jeff wrote:

connection to a MS SQL 2005

dj_jeff wrote:

The table itself has a field which is automatically a primary key with autoincrement functionality.

led mike wrote:

Microsoft cleverly hides that information in the documentation[^]

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace DummyProject
{
	public partial class frmTest : Form
	{
		SqlDataAdapter dataAdapter;
		DataTable table;
		SqlCommandBuilder commandBuilder;
		
		public frmTest()
		{
			InitializeComponent();
		}

		private void updateGridView()
		{
			this.Validate();
			tblLangBindingSource.EndEdit();
			dataAdapter.Update(table);
		}
		
		private void frmTest_Load(object sender, EventArgs e)
		{
			string strCon = "Data Source=MyServer;Initial Catalog=MyDB;User ID=MyUser;Password=MyPass;";
			string strSQL = "select LangId AS ID, LangName AS Name FROM tbl_Lang";
			dataAdapter = new SqlDataAdapter(strSQL, strCon);
			commandBuilder = new SqlCommandBuilder(dataAdapter);

			// Populate a new data table and bind it to the BindingSource.
			table = new DataTable();
			table.Locale = System.Globalization.CultureInfo.InvariantCulture;
			dataAdapter.Fill(table);
			tblLangBindingSource.DataSource = table;

			// Resize the DataGridView columns to fit the newly loaded content.
			dataGridView1.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);

			// you can make it grid readonly.
			//dataGridView1.ReadOnly = true;  

			// finally bind the data to the grid
			dataGridView1.DataSource = tblLangBindingSource;
			bindingNavigator1.BindingSource = tblLangBindingSource;
		}

		private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e)
		{
			this.updateGridView();
		}

		private void dataGridView1_RowsRemoved(object sender, DataGridViewRowsRemovedEventArgs e)
		{
			this.updateGridView();
		}

		private void dataGridView1_RowsAdded(object sender, DataGridViewRowsAddedEventArgs e)
		{
			this.updateGridView();
		}

		private void bindingNavigatorDeleteItem_Click(object sender, EventArgs e)
		{
			foreach(DataGridViewRow dgvr in dataGridView1.SelectedRows)
			{
				dataGridView1.Rows.RemoveAt(dgvr.Index);
			}

			this.updateGridView();
		}
	}
}

dj_jeff wrote:

The document samples refer to a manual insert and console display.

dj_jeff wrote:

but can't make this handling easier.

praveenvkumarv wrote:

is it necessary that the client machine

Brij wrote:

create an applicationpool with rights as LocalSystem and assign this pool to site you have deployed