Step 1: Firstly create a database in
SQL Server 2008.
Example: db2
Step 2: create table in that database.
Example: emp
Step 3: Open VS 2010. Then new project -> Windows Form Application.
Step 4: Design this format
Step 5: Firstly create connection and show the table in DataGrid:
Add namespace Using System.Data.Sqlclient.
namespace
WindowsFormsApplication1
{
public partial
class Form1 :
Form
{
public Form1()
{
InitializeComponent();
}
SqlDataAdapter da;
DataSet ds;
DataRow dr;
private void button1_Click(object sender, EventArgs e)
{
da = new SqlDataAdapter("select * from emp1", "database=db2; server=LENOVO-PC\\SQLEXPRESS; Integrated Security=True");
ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
}
Step 6: Then we want 1st record of table in textboxes, so write this code:
private void btnFirst_Click(object sender, EventArgs e)
{
int i = 0;
textBox1.Text = ds.Tables[0].Rows[i][0].ToString();
textBox2.Text = ds.Tables[0].Rows[i][1].ToString();
textBox3.Text = ds.Tables[0].Rows[i][2].ToString();
}
Step 7: for next record, write this code
private void btnNxt_Click(object sender, EventArgs e)
Join the conversation! Your thoughts help the community grow.