Hi there I have a Acess database. On my windows form I have a dataGridView, the dataGridView is not bound to the database, I search for a serial number from a txtBox and fill the dataGridView with the found information, all this is working ok but I cannot update the database to refelect the changes made in dataGridView.. Please could comeone help as I am new to c#.....
using System;
using System.Data;
using System.Diagnostics;
using System.Collections.Generic;
using System.Drawing;
using System.Windows.Forms;
using System.Data.OleDb;
using System.Globalization;
namespace stripdown
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
int mCount = 0;
System.Data.OleDb.OleDbConnection con;
System.Data.OleDb.OleDbDataAdapter da;
System.Data.OleDb.OleDbCommandBuilder cb;
DataSet ds1;
DataRow dr1;
private void Form1_Load(object sender, EventArgs e)
{
con = new System.Data.OleDb.OleDbConnection();
ds1 = new DataSet();
con.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\";
string sql = "SELECT * From CraigsFault";
da = new System.Data.OleDb.OleDbDataAdapter(sql, con);
con.Open();
da.Fill(ds1, "CraigsFault");
con.Close();
con.Dispose();
}
private void btnFind_Click(object sender, EventArgs e)
{
con.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\";
string sql = "SELECT * From CraigsFault";
da = new System.Data.OleDb.OleDbDataAdapter(sql, con);
con.Open();
da.Fill(ds1, "CraigsFault");
con.Close();
con.Dispose();
string searchFor = txtFind.Text;
int results = 0;
DataRow[] returnedRows;
returnedRows = ds1.Tables["CraigsFault"].Select("PRODUCT_1='" + searchFor + "'");
results = returnedRows.Length;
if (results > 0)
do
{
dr1 = returnedRows[mCount];
dataGridView1.Rows.Add(dr1[5], dr1[6], dr1[4], dr1[1], dr1[13]);
mCount++;
}
while (results > mCount);
}
private void btnUpdate_Click(object sender, EventArgs e)
{
da.UpdateCommand = cb.GetUpdateCommand();
da.InsertCommand = cb.GetInsertCommand();
da.DeleteCommand = cb.GetDeleteCommand();
da.Update(ds1, "CraigsFault");
}
}
}
Vijaya KadiyalaPosted Mar 11, 2009, 12:14 PM
Hi
Are you getting any errors?? does the use the has the privilege to update??
Thanks -- Vijaya Kadiyala
CGPosted Mar 10, 2009, 7:27 AM
Bechir BejaouiPosted Mar 9, 2009, 3:06 PM
enum ConnectionMode
{
oledb,odbc,sqlserver
}
private void PopulateDataGrid(DataGridView dgw,string ConnectionString,string query, ConnectionMode connectionMode)
{
if (connectionMode == ConnectionMode.oledb)
{
using (System.Data.OleDb.OleDbConnection cn = new System.Data.OleDb.OleDbConnection(ConnectionString))
{
try
{
cn.Open();
System.Data.OleDb.OleDbCommand sc = new System.Data.OleDb.OleDbCommand(query, cn);
System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter(sc);
System.Data.DataSet ds = new System.Data.DataSet();
da.Fill(ds);
dgw.DataSource = ds.Tables[0];
}
catch (Exception ex)
{
//TO DO: write the code here to handle error
}
finally
{
cn.Close();
}
}
}
if (connectionMode == ConnectionMode.odbc)
{
using (System.Data.Odbc.OdbcConnection cn = new System.Data.Odbc.OdbcConnection(ConnectionString))
{
try
{
cn.Open();
System.Data.Odbc.OdbcCommand sc = new System.Data.Odbc.OdbcCommand(query, cn);
System.Data.Odbc.OdbcDataAdapter da = new System.Data.Odbc.OdbcDataAdapter(sc);
System.Data.DataSet ds = new System.Data.DataSet();
da.Fill(ds);
dgw.DataSource = ds.Tables[0];
}
catch (Exception ex)
{
//TO DO: write the code here to handle error
}
finally
{
cn.Close();
}
}
}
if (connectionMode == ConnectionMode.sqlserver)
{
using (System.Data.SqlClient.SqlConnection cn = new System.Data.SqlClient.SqlConnection(ConnectionString))
{
try
{
cn.Open();
System.Data.SqlClient.SqlCommand sc = new System.Data.SqlClient.SqlCommand(query, cn);
System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(sc);
System.Data.DataSet ds = new System.Data.DataSet();
da.Fill(ds);
dgw.DataSource = ds.Tables[0];
}
catch (Exception ex)
{
//TO DO: write the code here to handle error
}
finally
{
cn.Close();
}
}
}
}