How to code a new sqlcode or get inside a TableAdapter?

Hiber Tadeo Moreno Tovilla

Hi all, i need to get a new SQL code inside a Tabla adapter, my Table and the adapter are inside of a DataSet named=DsMainFactuExpress, example:

Table: Cliente
Adapter:ClientesTableAdapter

My ClientesTableAdapter SelectCommand have the next Code:
CommandText=SELECT     ApellidoPat, ApellidoMat, Nombres, Telefono, TelCel, RFC, CURP, NoSeguro
FROM         Clientes
WHERE     (Nombre LIKE @PNombres)

CommadType=Text

Till here everything is ok, but Now i need to retrieve the data from a ButtonClick event here is my code:

Firts of all here is My Previus Function string connection:
ConexionGeneral ConexionBd = new ConexionGeneral(); <
private void Button1_Click(object sender, EventArgs e)
            {
           DsMainFactuExpressTableAdapters.ClientesTableAdapter TClientes = new DsMainFactuExpressTableAdapters.ClientesTableAdapter();
            TClientes.Connection.ConnectionString = ConexionBd.RutaConexionIniBD();
            TClientes.Adapter.SelectCommand.Parameters.Add("@Nombre", "Hiber");
            TClientes.Adapter.SelectCommand.ExecuteScalar();
            TClientes.Fill(this.DsClientes.Clientes);
      }

When i click appears this exception:
TClientes.Adapter.SelectCommand.Parameters.Add("@Nombre", "Hiber"); <<<<<<< Use the new Keyword to create a object instance

So My Question is how can i create a new instance?
or How can i get to my parameter to filter my table?

I'm Using Firebird Database and VS C# 2008, i'm new in C# i come from Delphi
Thank you.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sam Hobbs16y ago
I am not sure I understand what you did to fix the problem but filling the form with data by calling ClientesTableAdapter.FillByClientesNombres is probably what I meant when I said that a "TableAdapter is often used for binding to a form". I assume that ClientesTableAdapter is bound to the form, or at least the control(s) in the form.
Hiber Tadeo Moreno Tovilla16y ago
Oh Tanx SAM i resolved my problem in diferent way, i just created a new SQLquery inside the Dataset--->> TablaAdapterClientes: FillByClientesNombre, and then i put this in my Form:

this.ClientesTableAdapter.FillByClientesNombres(this.ClientesDataSet.Clientes,EdtParam.Text);

Thank Ya.
Sam Hobbs16y ago
A TableAdapter is often used for binding to a form.

When I use a TableAdapter to process a table in some other manner, I usually create it as a member of a form; I do not create it as an object local to a function.

Also, for TableAdapters the parameters are usually specified in the3 configuration of the TableAdapter. Are you sure you must alter the select statement for the TableAdapter? You can specify parameters in the TableAdapter and that would make what you are doing much simpler.