7,712
社区成员
发帖
与我相关
我的任务
分享
public int? UpdateCreate(string sql, OleDbParameter param)
{
sql = "CREATE TABLE 默认表名([列1] TEXT(50),[列2] TEXT(50),[列3] TEXT(50))";
ole_connection = new OleDbConnection(conn_str);
OleDbCommand cmd = new OleDbCommand(sql, ole_connection);
try
{
ole_connection.Open();
return cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
string errorInfo = "调用public static int Update()方法时出错";
Log.ErrLog(errorInfo + ex.Message, 1, true);
return null;
}
finally
{ ole_connection.Close(); }
}
public int? UpdateCreate(string sql, OleDbParameter param)
{
sql = "CREATE TABLE ?([列1] TEXT(50),[列2] TEXT(50),[列3] TEXT(50))";
ole_connection = new OleDbConnection(conn_str);
OleDbCommand cmd = new OleDbCommand(sql, ole_connection);
try
{
ole_connection.Open();
OleDbParameter parameter = new OleDbParameter("@表名", "预备表名");
cmd.Parameters.Add(parameter);
return cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
string errorInfo = "调用public static int Update()方法时出错";
Log.ErrLog(errorInfo + ex.Message, 1, true);
return null;
}
finally
{ ole_connection.Close(); }
}