Answer / sachin gupta

it consist
1. data source(Server)
2. database(Initial Catalog)
3. user name(Uid)
4. password(Pwd)
5. Integrated Security
6. Provider

Answer / ansu kamar

it consist of
data source
database
user name
password

Answer / hardit singh

sqlconnection con=new sqlconnection
("server=localhost;database=testdb;uid=sa;pwd=sa;");

Answer / m.chandran

Connection String for SQL Server consist of:
1.Data Source or server= “.”; or "Localhost" or "127.0.0.1" or "serverNameinstanceName" or "N/W SQL server IP Address" Server instance.
2.Initial Catalog or database = “DATABASE_NAME”;
Either3.Uid=”UserID for SQL server” and Password= “Password for SQL server”;
ORIntegrated Security=”True”; Use Windows security

optional
5.Provider Name =”System.Data.SqlClient”;

Explain acid properties?

4 Answers  

---

differences between ADO and ADO.NET

0 Answers   Microsoft,

---

Explain the advantages and disadvantages of using datalist?

0 Answers  

---

What is a database provider?

2 Answers   BioSys,

---

What are the connected and disconnected modes in ado.net?

0 Answers  

---

What is variable view?

0 Answers  

---

What is the key feature of ADO.NET compared to ADO ?

3 Answers   TCS,

---

How To Update A Column In A DataGrid Using C#.NET? I am getting InvalidCastException as (Specified cast is not valid) while updating 2nd column in a datagrid? Id,firstname,lastname are the three columns of my datagrid respectively. I wanted to edit the second column(lastname) and update it. I did the following code in DataGrid's updatecommand(),but failed to update ! Int varid=(int)DataGrid1.DataKeys[e.Item.ItemIndex]; TextBox lnm=(TextBox)e.Item.Cells[2].Controls[0]; string str=lnm.Text ; SqlCommand cmd=new SqlCommand("update customer set lastname='" + str + "' where id=" + varid + "",con); cmd.ExecuteNonQuery(); DataGrid1.EditItemIndex=- 1; DataGrid1.DataBind();

2 Answers   Mind Tree, TCS,

---

What does ole stand for in excel?

0 Answers  

---

What is defaultview in datatable?

0 Answers  

---

What are the classes in System.Data.Common Namespace?

0 Answers  

---

How to enable and disable connection pooling?

0 Answers  

---