Dear brothers, C # update database

jeremyekin

I want to put DataSet wd = new DataSet ();
                sda.Fill (ds, "yfls");
The data is inserted into another table, but the ID column is not required. The ID in the inserted table is automatically generated.
Masters help.

drizzt_xia

this.dataGridView1.Columns.Remove ("ID"); // Remove ID column in DATAGRIDVIEW

jeremyekin

private void yflsDataBind ()
        {
            // conndata ();
            // SqlConnection con = new SqlConnection ("server = 192.168.23.212; database = databank; uid = sa; pwd = 123456");
            try
            {
                con.Open ();
                SqlDataAdapter yfwd = new SqlDataAdapter ("select yfdb.wendu as dbwd, yfzb.wendu as zbwd from yfdb, yfzb where yfdb.ID = yfzb.ID", con);
                DataSet wd = new DataSet ();
                yfwd.Fill (wd, "yfwd");
                // Binding data to the DataGridView
                // Requires receiving window creation. . .
                
                MyInvoke wdInvoke = new MyInvoke (yfwdBindDataGridView);
               
                this.BeginInvoke (wdInvoke, new object [] {wd});
            }
I take the data from the database, and then put it into another database, I want the data in yfwd, ds.Tables
["yfls"]. Rows [0] ["ID"]
["yfls"]. Rows [0] ["lasu"]
["yfls"]. Rows [0] ["wendu"]
["yfls"]. Rows [0] ["DateTime"]
Put into another table, the basic structure of the target is the same, but the ID column should be automatically generated instead of stored in the database.
 // SqlConnection con = new SqlConnection ("server = 192.168.35.115; database = LZdata; uid = sa; pwd = 123456");
// The database is different but the tables are the same, how to write next ---------------------------------- ----,
How should I save las, wendu, and DateTime of yfls to the yf table of LZdata as historical data? The ID of yfls is unchanged (he is an operation to update a row), so it cannot be inserted directly into the yf table. I can only ask for his last three columns

kalian2000

In this case, if it is not troublesome, do a loop and insert it one by one ...

jeremyekin

Insert only one piece of data at a time, the key statements will not be written, beginners! !! !! !! Master help,

deathking

Not using PB ?????

qwer000

foreach (datarow oldrow in sourceDataSet.Tables [0] .Rows)
{
DataRow newRow = targetDataSet.Tables [0] .newRow ();
newRow ["columnname"] = oldrow ["columnname"];
.....
targetDataSet.Tables [0] .Rows.add (newRow);
}

qwer000

In fact, it may be solved by a single SQL statement. I do n’t know the specific needs of the landlord.

jeremyekin

My question is on the third floor.

kalian2000

I don't quite understand what the landlord means. If it is inserted one by one, is there any problem?

When building a table in the database, are there any self-incrementing columns in the table? Identity in sqlserver, sequence in oracle

For example, if there is a table student in sqlserver, and two fields sid and sname, if sid is self-incrementing ...

create table student (sid int identity (1,1), sname varchar (20));

insert:

insert into student (sname) values ​​('aaa');
insert into student (sname) values ​​('bbb');
...

The same is true in the program, you just need to get the columns other than the auto-increment column and insert it.


I wonder if I misunderstood what the landlord meant?