using System;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
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.Xml.Linq;namespace WebApplication1
{
public class DBOperation
{ static public DataTable DBOperate(string SQLString)
{
string CONN = "Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=test;Integrated Security=SSPI";
string DBEdit = "UPDATE,INSERT,DELETE";
OleDbConnection oleconn = new OleDbConnection(CONN);
OleDbCommand cmd = new OleDbCommand(SQLString, oleconn);
cmd.CommandType = CommandType.Text;
string[] sTokens = SQLString.Split(' ');
if (DBEdit.Contains(sTokens[0].ToUpper()))
{
oleconn.Open();
cmd.ExecuteNonQuery();
oleconn.Close();
return null;
}
else
{
DataSet objectDataSet = new DataSet();
OleDbDataAdapter adapter = new OleDbDataAdapter();
adapter.TableMappings.Add("Tabel", "TEMP");
adapter.SelectCommand = cmd;
oleconn.Open();
cmd.ExecuteNonQuery();
oleconn.Close();
adapter.Fill(objectDataSet);
return objectDataSet.Tables["TEMP"];
}
}
}
}
using System.Data;
using System.Data.OleDb;
using System.Configuration;
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.Xml.Linq;namespace WebApplication1
{
public class DBOperation
{ static public DataTable DBOperate(string SQLString)
{
string CONN = "Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=test;Integrated Security=SSPI";
string DBEdit = "UPDATE,INSERT,DELETE";
OleDbConnection oleconn = new OleDbConnection(CONN);
OleDbCommand cmd = new OleDbCommand(SQLString, oleconn);
cmd.CommandType = CommandType.Text;
string[] sTokens = SQLString.Split(' ');
if (DBEdit.Contains(sTokens[0].ToUpper()))
{
oleconn.Open();
cmd.ExecuteNonQuery();
oleconn.Close();
return null;
}
else
{
DataSet objectDataSet = new DataSet();
OleDbDataAdapter adapter = new OleDbDataAdapter();
adapter.TableMappings.Add("Tabel", "TEMP");
adapter.SelectCommand = cmd;
oleconn.Open();
cmd.ExecuteNonQuery();
oleconn.Close();
adapter.Fill(objectDataSet);
return objectDataSet.Tables["TEMP"];
}
}
}
}
判断database的连接状态,看是否成功连接了软思 http://www.zs760.net
这里有详细的说明
在这段代码处加个断点跟踪一下
select * from table insert into table values(....);
ServerVersion = “oleconn.ServerVersion”引发了“System.InvalidOperationException”类型的异常