Execute SQL Server View

  • Thread starter Thread starter RP
  • Start date Start date
R

RP

I have to pass two parameters to an SQL Server view query and then
execute the view. I also want to show the results on DataGridView. How
to do this?
 
RP,

You will have to create a SqlCommand which has the parameters for your
select statement (Views are the same as tables, you don't pass parameters to
them). Once you do that, you can pass the command to a SqlDataAdapter which
fills a DataSet, and then bind the DataSet to the DataGridView.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Selecting a row ID from datagrid 1
SQL Server Scripts : List all tables name that contain particularcolumn name using SQL Query 1
Am I disturbing a machine in production floor if I access its database remotely? 4
Access stripping decimal places in query 1
Invalid Column Name Sql-Error :Executing a stored procedure 1
Web Service Dataset to a Internal SQL Server 2
How to force DataGridView to update itself in compliance with underlying DataSource ? 2
Show DataReader results in DataGridView 0

Back
Top