Interested to Buy Any Domain ? << Click Here >> for more details...
What is sequence of code in retrieving data from database ?
- 3 Answers
- 15010 Views
- Accenture, BirlaSoft, I also Faced
- E-Mail Answers
Answer Posted / payal
//In this answer there is sqlserver
/*i write this code in vb.net with windows applications and
use sql server provider*/
//first need namespace
system.data.sqlclient
//need connection,command,connection string
dim sqlcmd as sqlcommand
dim sqlcon as sqlconnection
dom da as sqldataadaptor
dim ds as dataset
dim constr as sting="user
password=sss;datasource=sds;initial catalog=fgf"
/*connection string give all details about database
connection initial catalog means data base name and data
source is sqlserver name,user id and password also*/
//open connection and pass connection string
sqlcon=new sqlconnection(constr)
sqlcon.open()
//create new object of command with new keyword
sqlcmd=new sqlcommand("select * from tablename",sqlcon)
/*data adapter is mediater between the data base and data
set because dataset is work in disconneted mode.*/
da=new sqldataadaptor(sqlcmd)
/*data adapter fetch query to data base and get answer and
fil the dataset using fill*/
da.fill(ds)
/*there is datagird which i use for display data on
form.data from dataset i use this bind to datagrid*/
datagird.datasource=ds.tables("table name")
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is ado object model?
What is the use of Dataview?
how you will deal result set? How do you sort a dataset?If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?
How can we perform transactions in .net?
What is the difference between Command and CommandBuilder object?
Does entity framework use ado.net?
What is the procedure to call a Stored Procedure of Back End in ADO (ActiveX Data Object) and RDO (Remote Data Objects)?
What do you mean by ‘batch updates’?
What are the benefits of ADO.NET?
What is datasource in ado.net?
What do you know about ado.net's objects?
What is the use of SqlCommand object?
What is difference between ado.net and asp net?
Which method in OLEDBAdapter is used to populate dataset with records?
What is the difference between DataReader and DataSet in ADO.NET?
