PDA

View Full Version : مشکل در درج اطلاعات فرم در DataBase Access



neo1989021
یک شنبه 29 اسفند 1389, 12:31 عصر
دوستان فرمی رو برای بروز رسانی یک دیتا بیس اکسس طراحی کردم که با مشکل فوق مواجه شدم:

متن ارور:
> App_Web_dgxmbxb9.dll!Panel.Button6_Click(object sender = {Text = "submite"}, System.EventArgs e = {System.EventArgs}) Line 49 + 0xb bytes C#



سورس کدهام:

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data.OleDb;
using System.Xml.Linq;
public partial class Panel : System.Web.UI.Page
{

protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button2_Click(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
}
protected void Button2_Click1(object sender, EventArgs e)
{
if (TextBox1.Text == "a")
{
Panel1.Visible = false;
Panel2.Visible = true;
}
}
protected void Button6_Click(object sender, EventArgs e)
{
string strSql;
string strCon;
DataSet ds = new DataSet();
OleDbConnection Con = new OleDbConnection();
OleDbDataAdapter da = new OleDbDataAdapter();
DataRow newRow;
OleDbCommandBuilder cb = new OleDbCommandBuilder();
strCon = "Provider = Microsoft.Jet.OLEDB.4.0;" + "Data Source = |DataDirectory|/News.mdb";
strSql = "Select * from News";
Con.Open();
da = new OleDbDataAdapter(strSql, Con);
da.Fill(ds, "News");
newRow = ds.Tables["News"].NewRow();
newRow["News"] = TextBox3.Text;
newRow["Date"] = TextBox4.Text;
newRow["Code"] = TextBox5.Text;
ds.Tables["News"].Rows.Add(newRow);
cb = new OleDbCommandBuilder(da);
da.InsertCommand = cb.GetInsertCommand();
da.Update(ds, "News");
Con.Close();
}
}