OledbConnection con=new oleDbconnection("Connection String"); OleDbdataadapter da=new OleDbdataadapter("select MyID from MyTable",con); Dataset ds=new Dataset(); da.fill(ds,"d"); DataTable dt=ds.Tables["d"]; for(int i=0;i<dt.rows.count;i++)> { DataRow dr=dt.Rows[i]; con.open(); Oledbcommand cmd=new OleDbcommand("insert into MyTable (MyId) values ((dr[i].ToString()).SubString(2)) where MyId='"+dr[i].ToString()+"'",con); cmd.ExecuteNonQuery(); con.close(); } over...At One step U can Replace all The Data In Your Table.. Hope This Will Help You..
V
varma suresh
@varma suresh
Posts
-
Spliting a String -
Smtp server?hi.. Write Your IP address..or System name To Know IP Address 1) click START button 2)click on RUN 3)type cmd 4) type ipconfig hope this will help you
-
Load Report failedhi, ReportDocument rd=new ReportDocument(); rd.Load("Cryatalreport"); ///write rd.Close();//put this line too hope this will help U
-
Asp.net Gridview header [modified]in aspx page add itemtemplet