.NET (Core and Framework)

GridView.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
GridView.ClearSelection(); // or GridView.ClearSelection(1, 1, true); to select cell 1 on row 1

I are Troll

tims81 wrote:

Thanks, but I still get the index out of range exception when calling the above code.
i can't use "GridView.ClearSelection(1, 1, true)" either as i am told that that method is inaccessible due to its protection level.

GridView.Sort(GridView.Columns[1], ListSortDirection.Descending);
GridView.Rows[0].Selected = true;

I are Troll

private void Form1_Load(object sender, System.EventArgs e) 
{
	DataTable dt = new DataTable("employee");
	dt.Columns.Add("firstname");
	dt.Columns.Add("lastname");
	dt.Rows.Add("john", "doe");
	dt.Rows.Add("johnny", "walker");		

	dataGridView1.DataSource = dt;
}
void HandleClick(object sender, EventArgs e)
{
	dataGridView1.ClearSelection();
	if (dataGridView1.Rows.Count > 0)
		dataGridView1.Rows[0].Selected = true;
}

tims81 wrote:

The entire event handler is kinda big with different sub methods

I are Troll

GridView.Select();
GridView.ClearSelection();
GridView.Rows[0].Selected = true;

GridView.Sort(GridView.Columns[1], ListSortDirection.Descending);

tims81 wrote:

but it still only shows the first row selected but then continues from the original row when using the arrow keys. did your code still work after trying a sort operation like:

private void Form1_Load(object sender, System.EventArgs e) 
{
	DataTable dt = new DataTable("employee");
	dt.Columns.Add("firstname");
	dt.Columns.Add("lastname");
	dt.Rows.Add("john", "doe");
	dt.Rows.Add("johnny", "walker");		

	dataGridView1.DataSource = dt;
	dataGridView1.Sort(dataGridView1.Columns[1], ListSortDirection.Descending);
}
void HandleClick(object sender, EventArgs e)
{
	dataGridView1.ClearSelection();
	if (dataGridView1.Rows.Count > 0)
        {
                // Highlight the row;
		dataGridView1.Rows[0].Selected = true;

                // Move the input-focus rectangle;
	        dataGridView1.CurrentCell = dataGridView1.Rows[0].Cells[0];
        }
}

I are Troll

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\Sadsign.mdb;User Id=admin;Password=;

Dim con As New OleDb.OleDbConnection
Dim inc As Integer
Dim MaxRows As Integer
Dim ds As New DataSet
Dim da As OleDb.OleDbDataAdapter
Dim sql As String
Dim dt As DataTable



Private Sub Sampler_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

ds = new DataSet("dataSet");
dt = new DataTable("Contacts");
ds.Tables.Add(dt);
con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + _
"Data Source = c:\Sadsign.mdb"
con.Open()

sql = "SELECT * FROM Names"
da = New OleDb.OleDbDataAdapter(sql, con)


da.Fill(dt, "contacts")
'con.Close()
'MaxRows = ds.Tables("contacts").Rows.Count
'inc = -1

End Sub

Private Sub Sampler_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

      ds = New DataSet("dataSet")
      dt = New DataTable()
      ds.Tables.Add(dt)
      con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + _
      "Data Source = c:\Sadsign.mdb"
      con.Open()

      sql = "SELECT * FROM [Names]"
      da = New OleDb.OleDbDataAdapter(sql, con)

      da.Fill(dt)
      'con.Close()
      'MaxRows = ds.Tables("contacts").Rows.Count
      'inc = -1

  End Sub

da = New OleDb.OleDbDataAdapter(sql, con)
        cb = New OleDb.OleDbCommandBuilder(da)
        Dim newRow As DataRow
        newRow = ds.Tables("employeeTable").NewRow
        ds.Tables("employeeTable").Rows.Add(newRow)
        newRow.Item("Position") = comboPosition.Text
        newRow.Item("Last_Name") = txtLastName.Text
        newRow.Item("First_Name") = txtFirstName.Text


        da.Update(ds, "employeeTable")

dfan23 wrote:

Now I know that Name/Names are not valid as variable names.

dfan23 wrote:

If would you mine sir I would like to ask how to add a new row
to my database then how to update the changes made into the database.
I have a code for adding a new row but still got error in updating it.