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 |
Name some of the features present in vb 2005?
What is different between web.config and machine.config and where it will be ?
how to connect crystal report with vb.net ?
What is the use of assembly?
So you know which dll is used for microsoft .net run time?
Describe about visual basic.net?
Explain i.tostring method?
what are the advantages and diadvantages of active reports over crystal reports ?
Define naming convention?
I want to reduce my CPU Usage when I am querying the Database for records. Now my Winform App(in VB.Net) suddenly Jumps to 100% CPU Usage when i query for records from sql server database. I want this Usage to be less. Any help is appreciated
Difference between a sub and a function?
How vb implements the disconnected architecture as like vb.net?
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)