How to make a simple loop until last record

Israel

6y825Learn iOS Programming

Hi,

I would like to do a Loop with these codes. But I need to explain very well what I try to do.

1) On my form I have a Datagrid, one TextBox and a Button

2) I have a table name “Test”with a 2 columns (Company_name and Company). This table have 5 records

3) After displaying each “Company” its should send all company’s names into one table named “Receive”

Let’s see what I do. Its works but without with loop:

Company_name Company

--------------------- ------------

Andrews Company1

McSean Company2

Nokia Company2

TelCell Company1

Flex Company1

conn.Open();
SqlCommand cmd1 = conn.CreateCommand();
cmd1.CommandType = CommandType.Text;
cmd1.CommandText = "select * from Test where company = @company;
var param1 = new SqlParameter("@company", SqlDbType.NChar);
param1.Value = txtBoxCompany.Text;
{
cmd1.Parameters.Add(param1);
cmd1.Parameters.Add(param2);
}
cmd1.ExecuteNonQuery();
DataTable dt1 = new DataTable();
SqlDataAdapter da1 = new SqlDataAdapter(cmd1);
da1.Fill(dt1);
conn.Close();
dgvTest.DataSource = dt1;
Then after displaying the result on my datagrid its should send in block names of company on other table “Receive”
string myConnectionString;
myConnectionString = "Data Source = (LocalDB)\\MSSQLLocalDB; AttachDbFilename=C:\\Test\\WindowsFormsApplication1\\App_datas\\Accounting.mdf;Integrated Security = True;Integrated Security = True";
using (var con = new SqlConnection())
{
con.ConnectionString = myConnectionString;
con.Open();
using (var cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = @"INSERT INTO Test (company_name, company) SELECT company_name, company FROM test where company = @company";
cmd.Parameters.AddWithValue("@company", txtBox_company.Text);
cmd.ExecuteNonQuery();
}
con.Close();
}
Console.WriteLine("Done.");

But all of these should doing as a loop one by one record until read and transfering the last record. Many thanx.

2 Replies

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

Israel6y ago
I need make this very clear please.
1. The problem here is to make the eclipse for one big reason: from one click I need automatiic readind code filtring each record.
Fro example:
On one click, its filter the first record of the column "Company1". Then its will display all names from "Company_name" belonging to "company1". But its can't refilter another time "company1". Why? Because its already be filtered. Then its will pass to the next record "company2", etc doing like that.
After to do this eclipse what will happen? its jump to the next codes for transfering the datas filtered.
Each data founded into column "company_name" after a filter its transfer at the same time.
I would like to say that my codes work perfectly but its doesnt do as I explained now.
Let's see if its start to filter "company1" its will display Andrews, telCel and Flex (These three names will be transfered to the table "Receive" at once). The next is "company2" (McSean and Nokia). But its can't filter "company1" again because he already be filtered.
Company_name Company
------------------ ------------
Andrews Company1
McSean Company2
Nokia Company2
TelCell Company1
Flex Company1
0
Gowtham Ramar6y ago
Try this one method. i think this was your saying.
conn.Open();
SqlCommand cmd1 = conn.CreateCommand();
cmd1.CommandType = CommandType.Text;
cmd1.CommandText = "select * from Test where company = @company;
var param1 = new SqlParameter("@company", SqlDbType.NChar);
param1.Value = txtBoxCompany.Text;
{
cmd1.Parameters.Add(param1);
}
cmd1.ExecuteNonQuery();
DataTable dt1 = new DataTable();
SqlDataAdapter da1 = new SqlDataAdapter(cmd1);
da1.Fill(dt1);
conn.Close();
dgvTest.DataSource = dt1;
myConnectionString = "Data Source = (LocalDB)\\MSSQLLocalDB; AttachDbFilename=C:\\Test\\WindowsFormsApplication1\\App_datas\\Accounting.mdf;Integrated Security = True;Integrated Security = True";
for(int i=0;i
using (var con = new SqlConnection())
{
con.ConnectionString = myConnectionString;
con.Open();
using (var cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = @"INSERT INTO Test (company_name, company) SELECT company_name, company FROM test where company = @company";
cmd.Parameters.AddWithValue("@company", dt1.Rows[i]["company"].ToString());
cmd.ExecuteNonQuery();
}
con.Close();
}
}
Console.WriteLine("Done.");
0