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)
{
int
i;
i++;
if
(i < ds.Tables[0].Rows.Count)
{
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();
}
else
{
MessageBox.Show("This
is Your Last Record");
}
}
Step 8: for previous record, write
this code:
private
void btnprevious_Click(object
sender, EventArgs e)
{
int
i;
i--;
if
(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();
}
else
{
MessageBox.Show("This
is Your first Record");
}
}
Step 9: for last record, write this code:
private
void btnLast_Click(object
sender, EventArgs e)
{
int
i;
i =
ds.Tables[0].Rows.Count - 1;
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();
}