Expand|Select|Wrap|Line Numbers
- 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 WindowsFormsApplication1
- {
- public partial class Form1 : Form
- {
- public Form1()
- {
- InitializeComponent();
- }
- private void maskedTextBox2_MaskInputRejected(object sender, MaskInputRejectedEventArgs e)
- {
- }
- System.Data.SqlClient.SqlConnection con;
- DataSet ds1;
- System.Data.SqlClient.SqlDataAdapter da;
- int MaxRows = 0;//defined for the next button interface work
- int inc = 0;//defined for the next button interface work
- private void Form1_Load(object sender, EventArgs e)
- {
- con = new System.Data.SqlClient.SqlConnection();
- ds1 = new DataSet();
- con.ConnectionString ="Data Source=.\\SQLEXPRESS;AttachDbFilename=C:\\Documents and Settings\\Tevhit OKUR\\Belgelerim\\Visual Studio 2010\\Projects\\WindowsFormsApplication1\\WindowsFormsApplication1\\PHYTONDB1.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
- con.Open();
- string sql = "SELECT * From PHYTONTB1";
- da = new System.Data.SqlClient.SqlDataAdapter(sql, con);
- da.Fill(ds1, "Workers");
- NavigateRecords();
- MaxRows = ds1.Tables["Workers"].Rows.Count;//MaxRows will contain a count of how many Rows are in the Dataset called ds1.
- con.Close();
- con.Dispose();
- }
- private void NavigateRecords()
- {
- DataRow dRow=ds1.Tables["Workers"].Rows[inc];//default value inc=0 point to 0 for next button used
- maskedTextBox2.Text = dRow.ItemArray.GetValue(1).ToString();
- maskedTextBox3.Text = dRow.ItemArray.GetValue(2).ToString();
- maskedTextBox4.Text = dRow.ItemArray.GetValue(3).ToString();
- maskedTextBox5.Text = dRow.ItemArray.GetValue(4).ToString();
- }
- private void groupBox1_Enter(object sender, EventArgs e)
- {
- }
- private void button7_Click(object sender, EventArgs e)
- {
- if (inc > 0)// Back interface control when you push geri button it will decrease one row from Database
- {
- inc--;//decrease inc value
- NavigateRecords();//this method used for taking ready data from dataset to form why we called
- }
- else
- {
- MessageBox.Show("ilk kayıt");
- }
- }
- private void maskedTextBox3_MaskInputRejected(object sender, MaskInputRejectedEventArgs e)
- {
- }
- private void maskedTextBox4_MaskInputRejected(object sender, MaskInputRejectedEventArgs e)
- {
- }
- private void maskedTextBox5_MaskInputRejected(object sender, MaskInputRejectedEventArgs e)
- {
- }
- private void maskedTextBox6_MaskInputRejected(object sender, MaskInputRejectedEventArgs e)
- {
- }
- private void textBox1_TextChanged(object sender, EventArgs e)
- {
- }
- private void button6_Click(object sender, EventArgs e)
- {
- if (inc != MaxRows - 1)//button sonraki MaxRows - 1 It's because of the Rows[inc] line in our NavigateRecords method. The count for Rows starts at zero its for next button
- {
- inc++;//if cond satisfied increment 1 for next button
- NavigateRecords();//this method used for taking ready data from dataset to form why we called
- }
- else
- {
- MessageBox.Show("son kayıt");
- }
- }
- private void button4_Click(object sender, EventArgs e)
- {
- if (inc != 0)//button ilk kayıt it is checking easly inc value is equal to zero because we should go to the first record if it id not just assigning to inc value to zero can call NavigateRecord method because its creates record on the dataset
- {
- inc = 0;
- NavigateRecords();
- }
- MessageBox.Show("bilgi! Bu sizin Kaydettiğiniz İlk Kayıttır");
- }
- private void button3_Click(object sender, EventArgs e)
- {
- if (inc != MaxRows - 1)//button son kayıt it is used for interface last record interface we know that last record in database MaxRow-1 value we just check if not just we assign inc value to MaxRow-1 to equal
- {
- inc = MaxRows - 1;
- NavigateRecords();
- }
- MessageBox.Show("bilgi! Bu sizin Kaydettiğiniz Son Kayıttır");
- }
- private void btnAddNew_Click(object sender, EventArgs e)
- {
- maskedTextBox2.Clear();
- maskedTextBox3.Clear();
- maskedTextBox4.Clear();
- maskedTextBox5.Clear();
- }
- private void btnSave_Click(object sender, EventArgs e)
- {
- System.Data.SqlClient.SqlCommandBuilder cb;
- cb = new System.Data.SqlClient.SqlCommandBuilder(da);
- DataRow dRow = ds1.Tables["Workers"].NewRow();
- dRow[1]= maskedTextBox2.Text;
- dRow[2]= maskedTextBox3.Text;
- dRow[3]= maskedTextBox4.Text;
- dRow[4]= maskedTextBox5.Text;
- ds1.Tables["Workers"].Rows.Add(dRow);
- MaxRows = MaxRows + 1;
- inc = MaxRows - 1;
- da.Update(ds1, "Workers");//THİS LİNE GİVES ERROR Connection Property has not been initialized
- MessageBox.Show("SUCCESS!!!!");
- }
- }
- }