StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p><strong>Use DataAdapter to fill DataSet instead of DataReader</strong>, that you can easily bind to your gridview as shown below:</p> <pre><code> Dim DS As DataSet Dim MyConnection As SqlConnection Dim MyDataAdapter As SqlDataAdapter 'Create a connection to the SQL Server. MyConnection = New SqlConnection("server=(local);database=pubs;Trusted_Connection=yes") 'Create a DataAdapter, and then provide the name of the stored procedure. MyDataAdapter = New SqlDataAdapter("GetAuthorsByLastName", MyConnection) 'Set the command type as StoredProcedure. MyDataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure 'Create and add a parameter to Parameters collection for the stored procedure. MyDataAdapter.SelectCommand.Parameters.Add(New SqlParameter("@au_lname", _ SqlDbType.VarChar, 40)) 'Assign the search value to the parameter. MyDataAdapter.SelectCommand.Parameters("@au_lname").Value = Trim(txtLastName.Text) 'Create and add an output parameter to Parameters collection. MyDataAdapter.SelectCommand.Parameters.Add(New SqlParameter("@RowCount", _ SqlDbType.Int, 4)) 'Set the direction for the parameter. This parameter returns the Rows returned. MyDataAdapter.SelectCommand.Parameters("@RowCount").Direction = ParameterDirection.Output DS = New DataSet() 'Create a new DataSet to hold the records. MyDataAdapter.Fill(DS, "AuthorsByLastName") 'Fill the DataSet with the rows returned. 'Get the number of rows returned, and then assign it to the Label control. 'lblRowCount.Text = DS.Tables(0).Rows.Count().ToString() & " Rows Found!" lblRowCount.Text = MyDataAdapter.SelectCommand.Parameters(1).Value & " Rows Found!" 'Set the data source for the DataGrid as the DataSet that holds the rows. Grdauthors.DataSource = DS.Tables("AuthorsByLastName").DefaultView 'Bind the DataSet to the DataGrid. 'NOTE: If you do not call this method, the DataGrid is not displayed! Grdauthors.DataBind() MyDataAdapter.Dispose() 'Dispose of the DataAdapter. MyConnection.Close() 'Close the connection. </code></pre> <p><a href="http://support.microsoft.com/kb/306574" rel="nofollow">How to call SQL Server stored procedures in ASP.NET by using Visual Basic .NET</a></p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload