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();

}
}
}

How to add a javaScript function in a datagrid?

1066

---

What are the ado.net objects?

895

---

What is the purpose of using adodb?

912

---

What are the benefits of ADO.NET?

1074

---

Where is adodb dll located?

925

---

What is the use of Dataview?

1074

---

What is sqldatasource?

887

---

Which object holds only data and does not interact with data source?

918

---

What is the use of SqlCommandBuilder?

1157

---

What is difference in record set and dataset?

1001

---

If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?

1010

---

What is the full form of ado?

947

---

What do you know about ADO.NET's objects and methods?

909

---

differences between ADO and ADO.NET

1040

---

Do you use stored procedure in ado.net?

1000

---