我将编辑文本框的值,但我发现有一个问题。
protected void btn_edit_Click(object sender, EventArgs e)
{
DatabaseConnector con = new DatabaseConnector().CreateInstance();
SqlCommand com = new SqlCommand("UPDATE tbl_BinCardManager SET ItemName = @ItemName WHERE ItemNo = @ItemNo");
com.Parameters.Add("@ItemName",sqlDbType.VarChar);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
错误1:
当前上下文中不存在名称为'sqlDbType'的变量
错误2:
'ERPSystem.DatabaseConnector'不包含定义为'Open'的方法,且没有接受类型为'ERPSystem.DatabaseConnector'的第一个参数的扩展方法'Open'(是否缺少using指令或程序集引用?)
我的DBConnector类如下:
class DatabaseConnector
{
private DatabaseConnector databaseConnector;
private string connectionString = "Data Source=lernlap;Initial Catalog=ERPSystemDB;User ID=sa;Password=sa123";
public DatabaseConnector()
{
}
private SqlConnection connection;
private bool Connect()
{
try
{
connection = new SqlConnection(connectionString);
connection.Open();
return true;
}
catch(Exception) {
return false;
}
}
internal DatabaseConnector CreateInstance()
{
if (databaseConnector == null)
{
databaseConnector = new DatabaseConnector();
databaseConnector.Connect();
}
return databaseConnector;
}
DatabaseConnector
-- 你可能想读一下这个:https://dev59.com/a2kw5IYBdhLWcg3ws8xj#9707060 - Austin Salonennew DatabaseConnector().CreateInstance()
结构让我感到不舒服。 - Mr Lister