SQL Parameters only with oleDbDataAdapter, oleDbConnection and DataSet

[Robert Muchacki]

Hello.

I have a Stored Procedure, in which I use parameters, lets say "@test". How
can I in ,NET Visual C#, using only oleDbDataAdapte r, oleDbConnection and a
DataSet display rows in a simple datagrid, e.g. putting "acme" under @test?
Is there any possiblity? If not, then how can I manage that in another way,
e.g. after pressing a button? What kind of objects should I use and how?
Alle the descriptions I've found, don't seem to work (or maybe I don't
understand something). Any help / ideas?

Greetings,

MuchaR

[codewriter]

Re: SQL Parameters only with oleDbDataAdapte r, oleDbConnection and DataSet

From you posting it is not clear what you are tryig to do.
Is "@test" input or output paramater? And what do you meam by putting "acme"
under "@test"?
How do you populate your data grid? Binding?

"Robert Muchacki" <mucharek@go2.p l> wrote in message
news:bgis7c$jr3 $1@atlantis.new s.tpi.pl...[color=blue]
> Hello.
>
> I have a Stored Procedure, in which I use parameters, lets say "@test".[/color]
How[color=blue]
> can I in ,NET Visual C#, using only oleDbDataAdapte r, oleDbConnection and[/color]
a[color=blue]
> DataSet display rows in a simple datagrid, e.g. putting "acme" under[/color]
@test?[color=blue]
> Is there any possiblity? If not, then how can I manage that in another[/color]
way,[color=blue]
> e.g. after pressing a button? What kind of objects should I use and how?
> Alle the descriptions I've found, don't seem to work (or maybe I don't
> understand something). Any help / ideas?
>
> Greetings,
>
> MuchaR
>
>[/color]

[codewriter]

Re: SQL Parameters only with oleDbDataAdapte r, oleDbConnection and DataSet

From you posting it is not clear what you are tryig to do.
Is "@test" input or output paramater? And what do you meam by putting "acme"
under "@test"?
How do you populate your data grid? Binding?

"Robert Muchacki" <mucharek@go2.p l> wrote in message
news:bgis7c$jr3 $1@atlantis.new s.tpi.pl...[color=blue]
> Hello.
>
> I have a Stored Procedure, in which I use parameters, lets say "@test".[/color]
How[color=blue]
> can I in ,NET Visual C#, using only oleDbDataAdapte r, oleDbConnection and[/color]
a[color=blue]
> DataSet display rows in a simple datagrid, e.g. putting "acme" under[/color]
@test?[color=blue]
> Is there any possiblity? If not, then how can I manage that in another[/color]
way,[color=blue]
> e.g. after pressing a button? What kind of objects should I use and how?
> Alle the descriptions I've found, don't seem to work (or maybe I don't
> understand something). Any help / ideas?
>
> Greetings,
>
> MuchaR
>
>[/color]

[Robert Muchacki]

Re: SQL Parameters only with oleDbDataAdapte r, oleDbConnection and DataSet

Hello.
[color=blue]
> How do you populate your data grid? Binding?[/color]

I do it this way:

sqlDataAdapter1 .Fill(dataset1)

I underdstand that there may be many ways to accomplish this.

Greetings,

MuchaR

[Robert Muchacki]

Re: SQL Parameters only with oleDbDataAdapte r, oleDbConnection and DataSet

Hello.
[color=blue]
> How do you populate your data grid? Binding?[/color]

I do it this way:

sqlDataAdapter1 .Fill(dataset1)

I underdstand that there may be many ways to accomplish this.

Greetings,

MuchaR