hey friends,
Firstly I pick the records from the database into the
DataGridView, Then I want that If I made any changes to the
records in the GridView & Click on Update Button, Changes
are Reflected into the main Database .Plz do reply back
Answers were Sorted based on User's Feedback
Answer / muzi
If you know sql, use UPDATE query..:-)
if dont
then
UPDATE [TableName] SET Field1 = @param1, Field2 = @param2,
Field3 = @param3 WHERE [ID] = @paramID
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / veena
yes. we can update the data if we write a update command in program
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / saravanan
it is very simple..write insert delete update querey in
datagrid events
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / guest
If you are working with Sql Server database then provider
specific class named sqlcommandbuilder is available with
your sql server provider.This command will call the update
method of datadapter object ,which will update the contents
of your dataset and the same will be displayed in your
datagrid ,which inturn will reflect the changes in database.
| Is This Answer Correct ? | 1 Yes | 3 No |
How would you implement inheritance using vb.net?
What is the difference b/w Readonly Variable and Constant Variable?
Explain cls?
What is the main use of a namespace?
Explain about garbage collection?
What is the difference between Dataset and Recordset?
What is vb.net used for?
Explain public assembly?
code for export,import,save,update,delete ?
Which class allows an element to be accessed using unique key?
thak you Mr Govind for replying to my question. My next question is that how to retrieve image stored in an SQL server table and assign it to any image control or picture control using VB.net
What is the source code for display the picture in button click event?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)