Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using System.Collections.Generic;
- using System.ComponentModel;
- using System.Data;
- using System.Drawing;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- using System.Windows.Forms;
- using System.Data.OleDb;
- namespace WindowsFormsApp3
- {
- public partial class Form1 : Form
- {
- OleDbDataAdapter DANorthwind;
- OleDbCommandBuilder commandbuilder;
- DataTable DTSuppliers = new DataTable();
- DataRow dtsuppliersRow;
- String Connstr, dbname;
- String sqlstr;
- int rowpos = 0;
- public Form1()
- {
- InitializeComponent();
- }
- private void btnexit_Click(object sender, EventArgs e)
- {
- Application.Exit();
- }
- private void btnnext_Click(object sender, EventArgs e)
- {
- if (rowpos >= DTSuppliers.Rows.Count -1) {
- return;
- } else
- {
- rowpos += 1;
- }
- txt1.Text = Convert.ToString(DTSuppliers.Rows[rowpos]["Supplier_ID"]);
- txt2.Text = Convert.ToString(DTSuppliers.Rows[rowpos]["Company_Name"]);
- if (DTSuppliers.Rows[rowpos]["Phone"] == null)
- {
- txt3.Text = "NULL";
- } else { txt3.Text = Convert.ToString(DTSuppliers.Rows[rowpos]["Phone"]);
- }
- }
- private void btnlast_Click(object sender, EventArgs e)
- {
- if (rowpos <= 0)
- {
- return;
- }
- else
- {
- rowpos -= 1;
- }
- txt1.Text = Convert.ToString(DTSuppliers.Rows[rowpos]["Supplier_ID"]);
- txt2.Text = Convert.ToString(DTSuppliers.Rows[rowpos]["Company_Name"]);
- if (DTSuppliers.Rows[rowpos]["Phone"] == null)
- {
- txt3.Text = "NULL";
- }
- else
- {
- txt3.Text = Convert.ToString(DTSuppliers.Rows[rowpos]["Phone"]);
- }
- }
- private void btnupdate_Click(object sender, EventArgs e)
- {
- int changes;
- DANorthwind = new OleDbDataAdapter(sqlstr, Connstr);
- commandbuilder = new OleDbCommandBuilder(DANorthwind);
- changes = DANorthwind.Update(DTSuppliers);
- }
- private void CBAuthor_SelectedIndexChanged(object sender, EventArgs e)
- {
- rowpos = CBAuthor.SelectedIndex;
- txt1.Text = Convert.ToString(DTSuppliers.Rows[rowpos]["Supplier_ID"]);
- txt2.Text = Convert.ToString(DTSuppliers.Rows[rowpos]["Company_Name"]);
- if (DTSuppliers.Rows[rowpos]["Phone"] == null)
- {
- txt3.Text = "NULL";
- }
- else
- {
- txt3.Text = Convert.ToString(DTSuppliers.Rows[rowpos]["Phone"]);
- }
- }
- private void Form1_Load(object sender, EventArgs e)
- {
- this.suppliersTableAdapter.Fill(this.northwindDataSet.Suppliers);
- dbname = "Northwind.mdb";
- Connstr = "Provider=Microsoft.Jet.OLEDB.4.0;" +
- "Data Source = " + dbname;
- sqlstr = "Select * from Suppliers;";
- DANorthwind = new OleDbDataAdapter(sqlstr, Connstr);
- DANorthwind.Fill(DTSuppliers);
- CBAuthor.DataSource = DTSuppliers;
- CBAuthor.DisplayMember = DTSuppliers.Columns[1].ColumnName;
- CBAuthor.ValueMember = DTSuppliers.Columns[0].ColumnName;
- if (DTSuppliers.Rows.Count > 0)
- {
- txt1.Text = Convert.ToString(DTSuppliers.Rows[rowpos]["Supplier_ID"]);
- txt2.Text = Convert.ToString(DTSuppliers.Rows[rowpos]["Company_Name"]);
- txt3.Text = Convert.ToString(DTSuppliers.Rows[rowpos]["Phone"]);
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement