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); }