Urgent-Guys-Refreshing Datagrid on the network ?

Posted Date: 17 Jul 2006 Posted By: Habib Member Level: Bronze Points: 2 Responses: 1

I have made a systematical software using vb.net 2005 and SQL server 2000 ..okay...so i have the database on the server and three clients connected to this database through connectionstring ..now the ? is when one of the clients update or insert data ....i want a code who would Refresh the main database so any client would have the updated data on his Datagrid ?because i wrote the refresh after every Operation but i want in any operation came from the clients or the server user would refresh all the datagrid Data ?can any one help am available for more ????....Thanks advance

Responses

Author: Vara Prasad 01 Sep 2006

Member Level: Silver

Rating:

Points: 2

this may help u

dim da as new oledbdataadapter
dim ds as new dataset
Dim dv As New dataview

open the con

da=new oledbdataadapter("select * from tablename",con)
da.fill(ds,"tablename")

ds=new dataset("tablename",da)
to update datagrid

Public Sub GridData()
ds.Clear()
da.Fill(ds, "User1")
End Sub

Post Reply

This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.

	Next : Urgent-Guys-Refreshing Datagrid on the network ?
	Previous : How to create Dll fines
	Return to Discussion Forum
	Post New Message
	Category: Visual Studio

Related Messages

dotNet Slackers

About Us Contact Us Privacy Policy Terms Of Use