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")

What is row state?

982

---

What is an ado?

984

---

Explain ODP.net

1003

---

What are the advantages of using datalist?

1003

---

How to pass multiple tables in datasets simultaneously?

1058

---

What does ado stand for in ado.net?

1105

---

What is executequery?

949

---

Which object is used to add relationship between two Datatables?

1046

---

How to work with disconnected data - the dataset and sqldataadapter?

987

---

What is difference between datagridview and datagrid control in winforms?

1030

---

What is the default Timeout for SqlCommand.CommandTimeout property?

1013

---

How to bind the controls(best practice) comboboxes to the data in the dataset?

1049

---

What is microsoft ado?

1007

---

What DataReader class do in ADO.NET ?

1096

---

What is ado.net object model?

988

---