这是我的数据库连接方式:
private string strConnection = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0}\\CommFuntion/db1.mdb", Application.StartupPath);
private OleDbDataAdapter myAdapter;
private DataSet myds;
private DataTable mytb;
private DataSet dss = new DataSet();
private OleDbConnection _SConn;
//_SConn=new OleDbConnection(strConnection);
//public OleDbConnection getConn()
//{
// string connstr = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0}\\CommFuntion/DebetContrl.mdb", Application.StartupPath);
// OleDbConnection tempconn = new OleDbConnection(connstr);
// return (tempconn);
//}
public OleDbConnection SConn
{
get {
return _SConn;
}
set {
_SConn = value; }
}
public Pfunction()
{
_SConn = new OleDbConnection(strConnection);
} #region 打开关闭连接 Open(),Close()
/// <summary>
/// 打开数据库连接
/// </summary>
public void Open()
{
//_SConn = new OleDbConnection(strConnection);
if (_SConn.State == ConnectionState.Closed)
_SConn.Open();
} /// <summary>
/// 关闭数据库连接
/// </summary>
public void Close()
{
if (_SConn.State == ConnectionState.Open)
{
_SConn.Close();
//_SConn.Dispose();
}
}然后是我insert代码
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = Func.SConn;
cmd.CommandText = "insert into [Tb_Customerinfo]([CID],[CName]) values('" + textBox1.Text + "','" + textBox2.Text + "')";
Func.Open();
cmd.ExecuteNonQuery();
Func.Close();
麻烦大家帮我看看,到底哪里错了,只能查询不能添加和删除,谢谢,很急,在线等的
private string strConnection = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0}\\CommFuntion/db1.mdb", Application.StartupPath);
private OleDbDataAdapter myAdapter;
private DataSet myds;
private DataTable mytb;
private DataSet dss = new DataSet();
private OleDbConnection _SConn;
//_SConn=new OleDbConnection(strConnection);
//public OleDbConnection getConn()
//{
// string connstr = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0}\\CommFuntion/DebetContrl.mdb", Application.StartupPath);
// OleDbConnection tempconn = new OleDbConnection(connstr);
// return (tempconn);
//}
public OleDbConnection SConn
{
get {
return _SConn;
}
set {
_SConn = value; }
}
public Pfunction()
{
_SConn = new OleDbConnection(strConnection);
} #region 打开关闭连接 Open(),Close()
/// <summary>
/// 打开数据库连接
/// </summary>
public void Open()
{
//_SConn = new OleDbConnection(strConnection);
if (_SConn.State == ConnectionState.Closed)
_SConn.Open();
} /// <summary>
/// 关闭数据库连接
/// </summary>
public void Close()
{
if (_SConn.State == ConnectionState.Open)
{
_SConn.Close();
//_SConn.Dispose();
}
}然后是我insert代码
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = Func.SConn;
cmd.CommandText = "insert into [Tb_Customerinfo]([CID],[CName]) values('" + textBox1.Text + "','" + textBox2.Text + "')";
Func.Open();
cmd.ExecuteNonQuery();
Func.Close();
麻烦大家帮我看看,到底哪里错了,只能查询不能添加和删除,谢谢,很急,在线等的
解决方案 »
- Socket编程:C#连接VC服务器的问题。
- 在主窗体A中调用B窗体中的一个类函数B.f(),该函数将A窗体中的一个文本框T里赋值一个字符串,但主窗体A显示出来以后,文本框T却是空的,是哪儿的问题?
- C# 如何做成Windows服务(急。。。。。)
- 初级问题,大家帮忙看下100分
- 请教一个很长时间都没解决的Webbrowser问题
- 怎么得到打开当前窗体的窗体?注:WinForm,多谢
- 动态添加TabPage的问题
- DataGrid分页的问题
- 在winForm中如何实现DataGrid的多行表头
- 半個月了.還沒能找到解決方案,我想做數据庫的朋友都會碰到的問題.如何能在dataGrid中先显示一张有几十万条数据的表的一小部分,载入内存
- C#如何调用Delphi7编写的dll获得返回值为字符串类型的数组
- C#基于桌面COMBOBOX操作问题
catch调试,看看是何错误,连接是否打开