Geeks Talk

Prepare for your Next Interview




Fetch the details about particular person from database

This is a discussion on Fetch the details about particular person from database within the VB.NET forums, part of the Software Development category; I want to fetch the details about particular person from database by giving input in VB. For eg, If i give a name like 'Susi' in textbox of vb, it ...


Go Back   Geeks Talk > Software Development > VB.NET

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 06-05-2007
Junior Member
 
Join Date: Feb 2007
Location: Salem
Posts: 11
Thanks: 0
Thanked 4 Times in 2 Posts
Subashini.Ramasamy is on a distinguished road
Fetch the details about particular person from database

I want to fetch the details about particular person from database by giving input in VB.

For eg, If i give a name like 'Susi' in textbox of vb, it should fetch and display the corresponding details from database to VB.

Can you just clarrify my doubts as soon as possible.
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 06-06-2007
Contributing Member
 
Join Date: May 2007
Location: bangalore
Posts: 65
Thanks: 3
Thanked 8 Times in 6 Posts
hari.nattuva is on a distinguished road
Re: Fetch the details about particular person from database

I am sending one example code for u just try that it will work...first import the System.data.sqlclient

1. Place one textbox and one datagrid in form
2. Dim cn as new SqlConnection("connection string")
Dim da as new SqlDataAdapter("select * from tablename where columname='TextBox1.Text' ",cn)
Dim ds as new DataSet
da.fill(ds,"tablename")
DataGrid1.DataSource=ds.tables("tablename")


I hope it will work if not give me a reply and post what errors u r getting.......
Reply With Quote
Reply

  Geeks Talk > Software Development > VB.NET


Thread Tools
Display Modes


Similar Threads

Thread Thread Starter Forum Replies Last Post
Details of emp having the 788th highest salary Geek_Guest SQL 8 01-24-2008 09:57 AM
Traits of a Self-Confident Person Lokesh M Personality Development 0 04-17-2007 12:07 PM
L&T Placement Details 10th April 2007 Lokesh M Interviews 0 04-13-2007 12:04 PM
Fetch a new record inserted using MM01 Geek_Guest SAP R/3 0 04-13-2007 08:43 AM
Details about Firewall timmy HTML & CSS 2 07-20-2006 12:01 PM


All times are GMT -4. The time now is 05:12 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright © 2008 GeekInterview.com. All Rights Reserved