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 |
Explain convert.tostring and i.tostring method?
how to get sum of two numbers in vb.net?
14 Answers Factorial, Paul Infotech, Satyam,
What are the different types of Lock available in Visual Basic?
What’s the difference between private and shared assembly?
What is misl code?
what is vb.net
how to save items in gridview and the form name is vendor rating?
How can we remove handlers at run time?
what r the properties should be given to set method?
IT openings for Experienced candiates for Java / .NET
What are the parts of the visual basic control?
What is strong name in .net assembly?
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)