想Access插入数据(批量),在VS直接运行数据成功插入,但若发布后远程操作(通过IP),则数据没有插入。我将通过IP操作的Access路径显示出来,确认服务器路径是对的,可就是不成功,哪位知道给指点一下。
C# code:
public static bool UpdataDb(DataTable dt, string tableName)
{
bool flag = false;
Cdatabase AccessDb = new Cdatabase();
try
{
string sqlText = "delete from " + tableName;
if (AccessDb.RunSQLcmd(sqlText))
{
string sqlcmd = "Insert Into " + tableName
+ " (Id, Name, userName, EdtDateTime,PathServer) values (@pId, @pName, @pUserName, @pEdtDt, @pPahtServer)";
OleDbDataAdapter MyAdapter = new OleDbDataAdapter();
OleDbCommand cmd = new OleDbCommand(sqlcmd, (OleDbConnection)AccessDb.GetConn());
MyAdapter.InsertCommand = cmd;
cmd.Parameters.Add("@pId", OleDbType.VarChar, 10);
cmd.Parameters.Add("@pName", OleDbType.VarChar, 20);
cmd.Parameters.Add("@pUserName", OleDbType.VarChar);
cmd.Parameters.Add("@pEdtDt", OleDbType.Date, 10);
cmd.Parameters.Add(&qu