What is sequence of code in retrieving data from database ?
- 3 Answers
- 13658 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 are the Features of a dataset
How can you identify whether or not any changes are made to the DataSet object since it was last loaded?
What are good ado.net object to replace to ado recordset object.
How do you merge 2 datasets into the third dataset in a simple manner?
How can we perform transactions in .net?
What are the advantages and drawbacks of using ado.net?
How can we add/remove row's in "datatable" object of "dataset"?
What are the types of databinding?
Which name space is used to get assembly details?
What is disconnected architecture in ado.net?
Which is faster dataset or datareader?
What is a column variable?
What is ole in excel?
Define Execute Scalar?
What is the namespaces being used to access oracle database?
