Operations on the datagridview

1. display data in the datagridview in textbox

  Private   Void Lvwline_click ( Object Sender, eventargs E)
{
Txtline. Text =   This . Lvwline. selecteditems [ 0 ]. Subitems [ 0 ]. Text. tostring ();
Txtlinedescription. Text =   This . Lvwline. selecteditems [ 0 ]. Subitems [ 2 ]. Text. tostring ();
}

2. display the data in the database in the datagridview.

Attach the SQL statement to strsql. (Note: "N" must be added when Chinese characters are inserted in the English version of the operating system. Otherwise, garbled characters may occur)

String Strsql =   " Insert into Ut (username, enname, chname, telenumber, Department) "
+   " Values (' "   + Txtusername. Text. Trim () +   " ',' "   + Txtenname. Text. Trim ()
+   " ', N' "   + Txtchname. Text. Trim () +   " ',' " + Txttelenumber. Text. Trim ()
+   " ',' "   + Txtdepartment. Text. Trim () +   " ') " ;

Run the preceding SQL statement to display the inserted data in the database ut.

Datatable dt = New Datatable ();
DT = Dodb. executereturnless (strsql );

The data in the database ut is displayed in the datagridview:

Datagridview. Se se = DT

To delete data from the datagridview, you only need to change the data in strsql.