Answer / kalirajan

// Declare Namespace as ur Lang...
In c#

Using System.Data.SqlClient;

//connection

SqlConnection con = new
SqlConnection("server=localhost;database=Grid_Db;uid=sa;pwd=;");

con.Open();

SqlCommand cmd = new SqlCommand("select * from Gtid_Tbl",con);

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

da.Fill(ds);

GridView1.DataSource = ds;
GridView1.DataBind();

Answer / khalid

// Declare Namespace as ur Lang...
In c#

Using System.Data.SqlClient;

//connection
//If u provide uname & passwd to ur Database then this state //is true
SqlConnection con = new
SqlConnection("server=localhost;database=urDB_Name;uid=sa;pwd=;");
//else
SqlConnection con = new
SqlConnection("server=localhost;database=urDB_Name;");

con.Open();
if(con!=null)
msgbox("Connection sucessfully Done!");
else
msgbox("Sorry!Connection sucessfully is not Done!");

I am fresh graduate, trained in C# .net. How do i answer when interview ask me , Where do you see yourself within 5 years from now?

2 Answers  

---

Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?

0 Answers  

---

How would you connect to database using .NET?

0 Answers  

---

What is microsoft ado?

0 Answers  

---

Explain the ADO . Net Architecture ?

3 Answers  

---

Can we load multiple tables in a dataset?

0 Answers  

---

What is data relation?

0 Answers  

---

If we want to connect to many databases in dataaccess layer such as MSAccess,Sql server,oracle means not to a particular database depends on condition we have to connect to appropriate database in this scenario if we without changing code Ho wdo you handle this situation?

4 Answers   Honeywell,

---

What is the provider and namespaces being used to access oracle database?

5 Answers   E2E, Microsoft,

---

How many major types of connection objects in ADO.NET?

0 Answers   MCN Solutions,

---

How to you declare connection strings and how to you make use of web.config ?

3 Answers   MMTS,

---

What is ado control?

0 Answers  

---