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

}
}
}

What are the advantages using ado.net?

1027

---

What are the advantages of using datalist?

998

---

How to Read, Add, Update and Delete record in Entity Framework ?

1030

---

What is the difference between connected and disconnected environment?

1097

---

What is ole in excel?

931

---

What is linq and entity framework?

995

---

Which database is the ado.net sql connection object designed for?

1030

---

differance between ADO vs ADO.Net?

1051

---

Explain the namespaces in which .net has the data functionality class.

1070

---

Is ado.net an orm?

952

---

How do you connect to sql server database without using sqlclient?

1095

---

What are all the different methods under sqlcommand?

976

---

What is the use of Dataview?

1121

---

How can you add or remove rows from the datatable object of dataset?

1017

---

What are the difference between readonly vs. Const?

1002

---