Running a simple loop for displaying and saving once

Israel

6y727Learn iOS Programming

Hi,

I have one table and two tools:

“TblCompany”

“txtAccountNumber”

“btnRun”

My table looks like this:

ID | Account | Name

1 5.6 Selling

2 3.5 Bying

3 1.4 Mobile

I wrote some codes that make a normal and simple filter. The target filter is one the column “Account”.

Then why I’am doing to resolv it? I put each ID number inside of my codes and copy/paste the same block of codes to filter the next ID number to make the operation. But there is a problem? This table is growing up every day and its becoming little bit havy when processing. Then how can I do to make a one way loop until the latest record of my table displaying one by one the next account’s number that will be saved later and so on.

Please see my codes:

string connectionString = "Data Source = (LocalDB)\\MSSQLLocalDB; AttachDbFilename=C:\\Flex\\Accounting.mdf;Integrated Security = True";
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
string commandString = "select top 1 * from tblTest1 where ID='" + txtID.Text + "' order by ID DESC";
SqlCommand sqlCmd = new SqlCommand(commandString, conn);
SqlDataReader read = sqlCmd.ExecuteReader();
if (read.HasRows)
{
while (read.Read())
{
txtAccount.Text = read["Account"].ToString();
txtName.Text = read["Name"].ToString();
}
}
else
{
}
read.Close();
conn.Close();
conn = new SqlConnection"Data Source = (LocalDB)\\MSSQLLocalDB; AttachDbFilename=C:\\Flex\\Accounting.mdf;Integrated Security = True";);
if (conn.State != ConnectionState.Open)
conn.Open();
SqlCommand comm = new SqlCommand();
comm.Connection = conn;
SqlParameter account = new SqlParameter("@account", SqlDbType.Varchar);
SqlParameter name = new SqlParameter("@name", SqlDbType.Varchar);
comm.Parameters.Add(account);
comm.Parameters.Add(name);
account.Value = txtAccount.Text;
name.Value = txtName.Text;
comm.Connection = conn;
comm.CommandText = "insert into tblTest2 ([account],[name])values(@account,@name)";
{
{
try
{
comm.ExecuteNonQuery();
}
finally
{
conn.Close();
}

2 Replies

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

Israel6y ago
What I wrote is here. Even it's a big mess its works as a loop (starting from the first datagrid's row until the latest one). Just to let's understand what I need to do.

I have two buttons (1 and 2).
//Unfortunaly after doing all the job its gives this error message pointing on this line:
//txtDebit.Text = row.Cells["debit"].Value.ToString();
//Error message:
//Additional information:
//Reference object not defined for one instance of object
//Into the Button1:
private void button1_Click(object sender, EventArgs e)
{
if (dgvDiario.Rows.Count >= 0)
{
int i = dgvDiario.CurrentRow.Index + 0;
if (i >= -1 && i < dgvDiario.Rows.Count)
dgvDiario.CurrentCell = dgvDiario.Rows[i].Cells[0];
DataGridViewRow row = this.dgvDiario.Rows[this.dgvDiario.SelectedCells[0].RowIndex + 1];
if (row != null)
{
txtDebit.Text = row.Cells["debit"].Value.ToString();
txtCredit.Text = row.Cells["credit"].Value.ToString();
if (dgvDiario.Rows.Count >= 0)
{
int i1 = dgvDiario.CurrentRow.Index + 0;
if (i1 >= -1 && i1 < dgvDiario.Rows.Count)
dgvDiario.CurrentCell = dgvDiario.Rows[i1].Cells[0];
}
if (dgvDiario.Rows.Count >= 1)
{
int i2 = dgvDiario.CurrentRow.Index + 1;
if (i2 >= -1 && i2 < dgvDiario.Rows.Count)
dgvDiario.CurrentCell = dgvDiario.Rows[i2].Cells[0];
button2.PerformClick(); //Before to pass to the next row its save then so one.
if (dgvDiario.Rows.Count >= 0)
{
int i3 = dgvDiario.CurrentRow.Index + 0;
if (i3 >= -1 && i3 < dgvDiario.Rows.Count)
dgvDiario.CurrentCell = dgvDiario.Rows[i3].Cells[0];
DataGridViewRow row1 = this.dgvDiario.Rows[this.dgvDiario.SelectedCells[0].RowIndex + 1];
if (row1 != null)
{
txtDebit.Text = row1.Cells["debit"].Value.ToString();
txtCredit.Text = row1.Cells["credit"].Value.ToString();
if (dgvDiario.Rows.Count >= 0)
{
int i4 = dgvDiario.CurrentRow.Index + 0;
if (i4 >= -1 && i4 < dgvDiario.Rows.Count)
dgvDiario.CurrentCell = dgvDiario.Rows[i4].Cells[0];
}
if (dgvDiario.Rows.Count >= 1)
{
int i5 = dgvDiario.CurrentRow.Index + 1;
if (i5 >= -1 && i5 < dgvDiario.Rows.Count)
dgvDiario.CurrentCell = dgvDiario.Rows[i5].Cells[0];
}
}
//Into the Button2:
private void button2_Click(object sender, EventArgs e)
{
conn = new SqlConnection("Data Source = (LocalDB)\\MSSQLLocalDB; AttachDbFilename=C:\\Flexit_GovFAA\\Forcas_Armadas_Angolanas\\App_Datas\\FlexAccounting.mdf;Integrated Security = True");
comm = new SqlCommand();
if (conn.State != ConnectionState.Open)
conn.Open();
SqlCommand comm1 = new SqlCommand();
comm1.Connection = conn;
SqlParameter debit = new SqlParameter("@debit", SqlDbType.VarChar);
comm1.Parameters.Add(debit);
debit.Value = txtDebit.Text;
comm1.Connection = conn;
comm1.CommandText = "insert into testRazao ([debit])values(@debit)";
{
//if (MessageBox.Show("Tens certeza de guardar os dados?", "Janela de gravação", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
try
{
comm1.ExecuteNonQuery();
}
finally
{
//dgvDiario.CurrentCell = dgvDiario.Rows[dgvDiario.Rows.Count - 1].Cells[0];
conn.Close();
button1.PerformClick();
}
Israel6y ago
My problem is I need to use two separated table (1 and 2). The first one displaying record one by one from the first until the last one. While Displaying each one and saving each data into table2. It's very important this solution. I need to learn or to know how to resolv it please. It's capital for me. Thanx!