How to Insert between record

Israel

Hi,

There is any way to insert a record as it’s possible with edit if you want to edit a table from datagrid. For example I need to insert between row nº 3 and 4 a record. How can do this:

ID Date Account

//Insert here

When I need to edit a some rows I do this:

conn = new SqlConnection("Data Source = (LocalDB)\\MSSQLLocalDB; AttachDbFilename=C:\\xxx\\xx\\App_Datas\\test.mdf;Integrated Security = True");
comm = new SqlCommand();
if (conn.State != ConnectionState.Open)
conn.Open();
SqlCommand comm1 = new SqlCommand();
comm1.Connection = conn;
SqlParameter dat = new SqlParameter("@dat", SqlDbType.Date);
SqlParameter account = new SqlParameter("@account", SqlDbType.VarChar);
SqlParameter ID = new SqlParameter("@ID", SqlDbType.Int);
comm1.Parameters.Add(dat);
comm1.Parameters.Add(account);
comm1.Parameters.Add(ID);
data.Value = dtDate.Text;
conta.Value = txtAccount.Text;
ID.Value = lblID.Text;
comm1.Connection = conn;
comm1.CommandText = "UPDATE test1 SET date = @date, account = @ account, WHERE (ID = @ID)";
{
if (MessageBox.Show("Do you want to insert this record?", "Insert Record", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
try
{
comm1.ExecuteNonQuery();
}
finally
{
dgvTest.CurrentCell = dgvTest.Rows[dgvTest.Rows.Count - 1].Cells[0];
conn.Close(); }
}

2 Replies

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

Rajanikant Hawaldar6y ago
as Sanghdeep said you can insert rows in between directly in database table but if want to achieve you can do it with workaround follow below steps
Retrive data from that table and store in dataset using DataAdapter do change as your need and update back to database.
Another way retrive data and fill to datagridview control so you can insert rows in this control change as you need then before save data to database table truncate table then save.
Sanghdeep Sanghratne6y ago
You can not insert a row between two existing rows. Only add it to the end of the table. If you want to arrange data in specific order, then you should select the data from the table, and explicitly specify an ORDER BY clause.