Не могу вывести данные из таблицы в DataGrid.
Все примеры, которые я нашел, не помогают.
Подскажите, пожалуйста, как это делать в visual studio.net
Или пошлите ссылку на детальное руководство.Спосиба

aspcode

Public Class WebForm1
Inherits System.Web.UI.Page
Protected WithEvents SqlConnection1 As System.Data.SqlClient.SqlConnection
Protected WithEvents SqlSelectCommand1 As System.Data.SqlClient.SqlCommand
Protected WithEvents SqlInsertCommand1 As System.Data.SqlClient.SqlCommand
Protected WithEvents SqlUpdateCommand1 As System.Data.SqlClient.SqlCommand
Protected WithEvents SqlDeleteCommand1 As System.Data.SqlClient.SqlCommand
Protected WithEvents SqlDataAdapter1 As System.Data.SqlClient.SqlDataAdapter
Protected WithEvents favorit As System.Web.UI.WebControls.DataGrid
Protected WithEvents DataSet11 As WebApplication15.DataSet1

#Region " Web Form Designer Generated Code "

'This call is required by the Web Form Designer.
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
Me.SqlConnection1 = New System.Data.SqlClient.SqlConnection()
Me.DataSet11 = New WebApplication15.DataSet1()
Me.SqlSelectCommand1 = New System.Data.SqlClient.SqlCommand()
Me.SqlInsertCommand1 = New System.Data.SqlClient.SqlCommand()
Me.SqlUpdateCommand1 = New System.Data.SqlClient.SqlCommand()
Me.SqlDeleteCommand1 = New System.Data.SqlClient.SqlCommand()
Me.SqlDataAdapter1 = New System.Data.SqlClient.SqlDataAdapter()
CType(Me.DataSet11, System.ComponentModel.ISupportInitialize).BeginInit()
'
'SqlConnection1
'
Me.SqlConnection1.ConnectionString = "data source=eaex5d;initial catalog=bookmark;integrated security=SSPI;persist " & _
"security info=False;workstation id=EAEX500OLD;packet size=4096"
'
'DataSet11
'
Me.DataSet11.DataSetName = "DataSet11"
Me.DataSet11.Locale = New System.Globalization.CultureInfo("en-US")
Me.DataSet11.Namespace = "http://www.tempuri.org/DataSet1.xsd"
'
'SqlSelectCommand1
'
Me.SqlSelectCommand1.CommandText = "SELECT bookmark_id, bookmark_description, bookmark_url FROM favorit3"
Me.SqlSelectCommand1.Connection = Me.SqlConnection1
'
'SqlInsertCommand1
'
Me.SqlInsertCommand1.CommandText = "INSERT INTO favorit3(bookmark_id, bookmark_description, bookmark_url) VALUES (@bo" & _
"okmark_id, @bookmark_description, @bookmark_url); SELECT bookmark_id, bookmark_d" & _
"escription, bookmark_url FROM favorit3 WHERE (bookmark_id = @bookmark_id)"
Me.SqlInsertCommand1.Connection = Me.SqlConnection1
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@bookmark_id", System.Data.SqlDbType.UniqueIdentifier, 16, "bookmark_id"))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@bookmark_description", System.Data.SqlDbType.VarChar, 10, "bookmark_description"))
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@bookmark_url", System.Data.SqlDbType.VarChar, 10, "bookmark_url"))
'
'SqlUpdateCommand1
'
Me.SqlUpdateCommand1.CommandText = "UPDATE favorit3 SET bookmark_id = @bookmark_id, bookmark_description = @bookmark_" & _
"description, bookmark_url = @bookmark_url WHERE (bookmark_id = @Original_bookmar" & _
"k_id) AND (bookmark_description = @Original_bookmark_description OR @Original_bo" & _
"okmark_description IS NULL AND bookmark_description IS NULL) AND (bookmark_url =" & _
" @Original_bookmark_url OR @Original_bookmark_url IS NULL AND bookmark_url IS NU" & _
"LL); SELECT bookmark_id, bookmark_description, bookmark_url FROM favorit3 WHERE " & _
"(bookmark_id = @bookmark_id)"
Me.SqlUpdateCommand1.Connection = Me.SqlConnection1
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@bookmark_id", System.Data.SqlDbType.UniqueIdentifier, 16, "bookmark_id"))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@bookmark_description", System.Data.SqlDbType.VarChar, 10, "bookmark_description"))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@bookmark_url", System.Data.SqlDbType.VarChar, 10, "bookmark_url"))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_bookmark_id", System.Data.SqlDbType.UniqueIdentifier, 16, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "bookmark_id", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_bookmark_description", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "bookmark_description", System.Data.DataRowVersion.Original, Nothing))
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_bookmark_url", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "bookmark_url", System.Data.DataRowVersion.Original, Nothing))
'
'SqlDeleteCommand1
'
Me.SqlDeleteCommand1.CommandText = "DELETE FROM favorit3 WHERE (bookmark_id = @Original_bookmark_id) AND (bookmark_de" & _
"scription = @Original_bookmark_description OR @Original_bookmark_description IS " & _
"NULL AND bookmark_description IS NULL) AND (bookmark_url = @Original_bookmark_ur" & _
"l OR @Original_bookmark_url IS NULL AND bookmark_url IS NULL)"
Me.SqlDeleteCommand1.Connection = Me.SqlConnection1
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_bookmark_id", System.Data.SqlDbType.UniqueIdentifier, 16, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "bookmark_id", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_bookmark_description", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "bookmark_description", System.Data.DataRowVersion.Original, Nothing))
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_bookmark_url", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "bookmark_url", System.Data.DataRowVersion.Original, Nothing))
'
'SqlDataAdapter1
'
Me.SqlDataAdapter1.ContinueUpdateOnError = True
Me.SqlDataAdapter1.DeleteCommand = Me.SqlDeleteCommand1
Me.SqlDataAdapter1.InsertCommand = Me.SqlInsertCommand1
Me.SqlDataAdapter1.SelectCommand = Me.SqlSelectCommand1
Me.SqlDataAdapter1.TableMappings.AddRange(New System.Data.Common.DataTableMapping() {New System.Data.Common.DataTableMapping("Table", "favorit3", New System.Data.Common.DataColumnMapping() {New System.Data.Common.DataColumnMapping("bookmark_id", "bookmark_id"), New System.Data.Common.DataColumnMapping("bookmark_description", "bookmark_description"), New System.Data.Common.DataColumnMapping("bookmark_url", "bookmark_url")})})
Me.SqlDataAdapter1.UpdateCommand = Me.SqlUpdateCommand1
CType(Me.DataSet11, System.ComponentModel.ISupportInitialize).EndInit()

End Sub

Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
' Load the Data Grid Control
InitializeComponent()
End Sub

#End Region

Private Sub Form_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
' Load the Data Grid Control
DataSet11.Clear()
SqlDataAdapter1.Fill(DataSet11, "favorit3")

End Sub

Private Sub SqlDataAdapter1_RowUpdated(ByVal sender As System.Object, ByVal e As System.Data.SqlClient.SqlRowUpdatedEventArgs) Handles SqlDataAdapter1.RowUpdated

End Sub
End Class

html code

<%@ Page Language="vb" AutoEventWireup="false" Codebehind="WebForm1.aspx.vb" Inherits="WebApplication15.WebForm1"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<title>WebForm1</title>
<meta name="GENERATOR" content="Microsoft Visual Studio.NET 7.0">
<meta name="CODE_LANGUAGE" content="Visual Basic 7.0">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<asp:DataGrid id=favorit style="Z-INDEX: 101; LEFT: 80px; POSITION: absolute; TOP: 24px" runat="server" DataSource="<%# DataSet11 %>" DataMember="favorit3" Width="408px" AllowSorting="True" Height="232px" AllowPaging="True">
</asp:DataGrid>
</form>
</body>
</HTML>

To Артист Спосибо за помощь