private void delete_Click(object sender, EventArgs e)
{
DataProviderFactory factory =
DataProviderFactory.CreateDataProviderFactory(
DataProviderFactory.DatabaseProviderName);
IDbConnection connection;
connection = factory.CreateConnection();
connection.ConnectionString = DataProviderFactory.ConnectionString;
IDbCommand command;
command = factory.CreateCommand();
command.Connection = connection;
command.CommandType = CommandType.Text;
command.CommandText = DeleteUserSql;
connection.Open();
IDataParameter id = command.CreateParameter();
id.ParameterName = "@Id";
id.Value = this.id.Text;
id.DbType = DbType.Int16;
command.Parameters.Add(id);
command.ExecuteNonQuery();
connection.Close();
}
public static DataProviderFactory CreateDataProviderFactory(
String providerName)
{
DataProviderFactory concreteFactory = null;
switch (providerName)
{
case DataProviderFactory.MsSqlProviderName:
concreteFactory = new MsSqlProviderFactory();
break;
case DataProviderFactory.OracleProviderName:
concreteFactory = new OracleProviderFactory();
break;
case DataProviderFactory.OleDbProviderName:
concreteFactory = new OleDbProviderFactory();
break;
}
return(concreteFactory);
}
