dotnetspider.com
Login Login    Register      

TutorialsForumCareer DevelopmentResourcesReviewsJobsInterviewCommunitiesProjectsTraining

Subscribe to Subscribers
Talk to Webmaster
Tony John

Facebook
Google+
Twitter
LinkedIn
Online MembersMatt M
premkumar
naveensanagasetti
baskar
More...
Join our online Google+ community for Bloggers, Content Writers and Webmasters




Forums » .NET » Visual Studio »

Urgent-Guys-Refreshing Datagrid on the network ?


Posted Date: 17 Jul 2006      Posted By:: Habib     Member Level: Bronze    Member Rank: 0     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

#73136    Author: Vara Prasad      Member Level: Silver      Member Rank: 0     Date: 01/Sep/2006   Rating: 2 out of 52 out of 5     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:

Related Messages



Follow us on Twitter: https://twitter.com/dotnetspider

Active Members
TodayLast 7 Daysmore...

Awards & Gifts
Email subscription
  • .NET Jobs
  • .NET Articles
  • .NET Forums
  • Articles Rss Feeds
    Forum Rss Feeds


    About Us    Contact Us    Copyright    Privacy Policy    Terms Of Use    Revenue Sharing sites   Advertise   Talk to Tony John
    Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India
    2005 - 2012 All Rights Reserved.
    .NET and other trademarks mentioned in this site belong to Microsoft and other respective trademark owners.
    Articles, tutorials and all other content offered here is for educational purpose only.
    We are not associated with Microsoft or its partners.