Wrox Programmer Forums
|
VB.NET General VB.NET discussions for issues that don't fall into other VB.NET forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB.NET section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 12th, 2006, 12:42 PM
Authorized User
 
Join Date: Apr 2006
Posts: 79
Thanks: 1
Thanked 0 Times in 0 Posts
Send a message via AIM to anujrathi Send a message via MSN to anujrathi Send a message via Yahoo to anujrathi
Default Problem with DataGrid

Hi Friends,

 In VB.NET windows application, I want to update my database using datagrid.
means whenever a user enters the data in the datagrid, it should be updated in the database also.

I m using disconnected archi. means with SqlDataAdapter. If possible then pls give necessary details.
 
Old July 22nd, 2006, 06:35 AM
vbn vbn is offline
Authorized User
 
Join Date: May 2005
Posts: 23
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,

Create a table structure and instantiate the Datatable. Add column to the data table structure.

you bin this table to a datagrid.

After you accept the data, You can update the database using update method of the DataAdapter. This method is responsible for examining the RowState property of each of the DataRow objects in the Rows collection. The RowsCollection is a member of each of the DataTable objects contained in the Tables collection of the dataset.

Ex: myAdapter.Update(myDataSet.GetChanges,"Table1")

You can refer this Title: Database programming using VB.net and Sql server 2000"

Regards
bhar









Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with datagrid Shishir ASP.NET 1.0 and 1.1 Professional 1 January 6th, 2007 09:01 AM
Datagrid Problem monika.vasvani ASP.NET 1.0 and 1.1 Professional 1 December 5th, 2006 03:09 AM
DataGrid Problem anujrathi VB.NET 2002/2003 Basics 2 June 15th, 2006 02:18 AM
DataGrid Problem anujrathi ASP.NET 2.0 Basics 1 June 12th, 2006 03:52 PM
Datagrid problem dotnetprogrammer VS.NET 2002/2003 1 February 17th, 2005 05:11 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.