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 you will deal result set? How do you sort a dataset?If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?

1054

---

How can we serialize the dataset object?

1051

---

How do you update a dataset in ado.net and how do you update database through dataset?

968

---

What you mean by filtering of data?

1013

---

If we are not returning any records from the database, which method is to be used?

1369

---

What is dataset object? Explain the various objects in dataset.

1079

---

What are the advantages of oledb compared with other classes?

2840

---

What is the use of Dataview?

1192

---

Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.

1184

---

How to pass multiple tables in datasets simultaneously?

1114

---

What are the advantages of ado.net?

958

---

What is difference between executenonquery and executequery?

1021

---

What is ado.net in mvc?

976

---

What is ado.net connection?

1022

---

How do you update database through dataset?

1024

---