firebird & .net provider

protected System.Web.UI.WebControls.DataGrid DataGrid1;
protected System.Web.UI.WebControls.TextBox TextBox1;
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.Button Button1;

private void Page_Load(object sender, System.EventArgs e)
{
	if(!IsPostBack)
	{
		BindData();
	}
}

private void BindData()
{
	FbConnectionStringBuilder cs = new FbConnectionStringBuilder();

	cs.DataSource = "localhost";
	cs.UserID     = "SYSDBA";
	cs.Password     = "masterkey";
	cs.Database     = "C:\\Program Files\\Firebird\\data.fdb";

	string connectionString = cs.ToString();


	FbConnection connection = new FbConnection(connectionString);                    
	connection.Open();                    

	string selectQuery = "SELECT ID, NOME FROM TESTE";
	FbDataAdapter da = new FbDataAdapter(selectQuery,connection);
	
	DataSet ds = new DataSet();
	da.Fill(ds);
	DataGrid1.DataSource = ds;
	DataGrid1.DataBind();
			

	connection.Close();

}

private void Button1_Click(object sender, System.EventArgs e)
{
	if(TextBox1.Text!= string.Empty)
	{
		FbConnectionStringBuilder cs = new FbConnectionStringBuilder();

		cs.DataSource = "localhost";
		cs.UserID     = "SYSDBA";
		cs.Password     = "masterkey";
		cs.Database     = "C:\\Program Files\\Firebird\\data.fdb";

		string connectionString = cs.ToString();

		FbConnection connection = new FbConnection(connectionString);                    
		connection.Open();                    
		FbTransaction transaction = connection.BeginTransaction();

		string newName = Server.HtmlEncode(TextBox1.Text.Trim());
		string insertQuery = "INSERT INTO TESTE(NOME) Values('" + newName + "')";
		
		FbCommand command = new FbCommand(insertQuery, connection, transaction);    

		command.ExecuteNonQuery();

		transaction.Commit();

		connection.Close();

		TextBox1.Text = string.Empty;
		BindData();
	}

}