Value & this part will show the error as below Error 1 Operator '&' cannot be applied to operands of type 'string' and 'object' C:\Documents and Settings\gts\My Documents\Visual Studio 2005\First\Windows Application3\Form1128 35 Windows Application3 please help to how to solve this problem The item "obj\Debug\Welcome. Sql Connection Dim com As New Sql Command Dim adap As New Sql Data Adapter Dim ds As New Data Set con = New Sql Connection("data source=niqotine;initial catalog=record;uid=sa;pwd=mindworks") con. Command Text = "insert into User Info values('" txtname.
That way, when you delete a row, the function will: 1) Clear the gridview 2) Fill the gridview If you make the code modular, you will not have to worry about having to recode it everytime.
Command Text = " INSERT INTO Login (Staff_Id, Staff_Username) VALUES ('" txt Id. Text "')" What you can do, is place all of the code that retreives the data for the gridview ( The select statement and data adapter ) into a custom function that you can call.
NET EF, select ‘Employee’ table created in SQL Server using the script.
This code first searches the selected Employee row using LINQ.
Execute Non Query() adap = New Sql Data Adapter("select * from User Info", con) adap.