Answer Posted / bala

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;


namespace WindowsFormsApplication4
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();

}

private void button1_Click(object sender, EventArgs
e)
{
String ConnectionString = "Data
Source=ServerName;Initial Catalog=DatabaseName;Integrated
Security=true";
String Query = "insert into tablename values('"
+ textBox1.Text + "')";
SqlConnection Con = new SqlConnection
(ConnectionString) ;
Con.Open();
SqlCommand Cmd = new SqlCommand(Query, Con);
Cmd.ExecuteNonQuery();
Cmd.Dispose();
Con.Close();

}
}
}

Can we do database operations without using any of the ado.net objects?

932

---

Explain the difference between data reader and data set?

869

---

How to create dynamic gridview?

978

---

Can datareader hold data from multiple tables?

1114

---

What are the data providers in ADO.NET framework?

972

---

Which is faster dataset or datareader?

901

---

What is the difference between SqlCommand and SqlCommandBuilder?

998

---

What is the purpose of using adodb?

900

---

Which is better entity framework or ado.net?

969

---

Explain why edit is not possible in repeater?

988

---

Define partial class?

900

---

What is the default Timeout for SqlCommand.CommandTimeout property?

954

---

What is ole access?

883

---

Explain the advantages and disadvantages of using datalist?

1026

---

What is ado data control?

934

---