AW: GridView mit zur Entwicklungszeit unbekannter Datenquelle (SQL-Tabelle) BEARBEITEN

VBinius — Sun, 19 Sep 2010 07:23:54 GMT

GridView dynamisch laden / GridView Zelleninhalt auslesen / GridView Update in Code-Datei / GridView Validierung in Code-Datei

----------------------------------------------------------------------------------------------------------------------------------------------------------

Salü, folgendes dürfte dein Problem lösen:

Erstelle eine Datenbank "TestDB"

Erstelle eine Tabelle tblTest

CREATE TABLE [dbo].[tblTest](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](50) NULL,
[ShortName] [varchar](20) NULL,
CONSTRAINT [PK_tblTest] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

----------------------------------------------------------------------------------------------------------------------------------------------------------

In der web.config:

</connectionStrings>

----------------------------------------------------------------------------------------------------------------------------------------------------------

Füge in deiner Seite folgendes ein (HTML):

<asp:Label ID="lblError" runat="server" ForeColor="Red"></asp:Label>

<br />

<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True">

<asp:ListItem Value="0">ID und Name</asp:ListItem>

<asp:ListItem Value="1">ID und ShortName</asp:ListItem>

</asp:DropDownList>

<asp:Label ID="Label1" runat="server"></asp:Label>

<br />

<asp:GridView ID="GridView1" runat="server"

DataKeyNames="ID" DataSourceID="SqlDataSource1"

EmptyDataText="Es sind keine Datensätze zum Anzeigen vorhanden."

AllowPaging="True" AllowSorting="True"

PageSize="2">

<asp:CommandField ShowEditButton="True" />

</Columns>

</asp:GridView>

<asp:SqlDataSource ID="SqlDataSource1" runat="server"

ConnectionString="<%$ ConnectionStrings:ConnectionString1 %>" >

</asp:SqlDataSource>

----------------------------------------------------------------------------------------------------------------------------------------------------------

Hier der Code dazu:

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

If Page.IsPostBack = False Then

GridView_Fill()

End If

End Sub

Private Sub GridView_Fill()

' GridView dynamisch laden

SqlDataSource1.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings("ConnectionString1").ToString

SqlDataSource1.ProviderName = System.Configuration.ConfigurationManager.ConnectionStrings("ConnectionString1").ProviderName.ToString

SqlDataSource1.SelectParameters.Clear()

Dim SQL As String

If DropDownList1.SelectedIndex = 0 Then

SQL = "SELECT ID, Name FROM tblTest"

Else

SQL = "SELECT ID, ShortName FROM tblTest"

End If

SqlDataSource1.SelectCommand = SQL

SqlDataSource1.SelectCommandType = SqlDataSourceCommandType.Text

GridView1.DataBind()

lblError.Text = ""

Label1.Text = ""

End Sub

Protected Sub DropDownList1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DropDownList1.SelectedIndexChanged

lblError.Text = ""

Label1.Text = ""

GridView_Fill()

End Sub

Protected Sub GridView1_RowEditing(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewEditEventArgs) Handles GridView1.RowEditing

If GridView1.Rows(e.NewEditIndex).Cells(2).Text = "Hallo" Then

e.Cancel = True

lblError.Text = "Sie können diesen Datensatz nicht ändern. Das ist einfach so ;-)"

End If

GridView_Fill()

Label1.Text = "'" & GridView1.Rows(e.NewEditIndex).Cells(2).Text & "' bearbeiten ..." ' GridView Zelleninhalt auslesen:

End Sub

Protected Sub GridView1_RowUpdating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewUpdateEventArgs) Handles GridView1.RowUpdating

' GridView Validierung:

lblError.Text = ""

If CType(GridView1.Rows(GridView1.EditIndex).Cells(2).Controls(0), TextBox).Text = "Hallo" Then

lblError.Text = "Name: Verboten ist 'Hallo' :-)))))))"

End If

If lblError.Text <> "" Then

e.Cancel = True

End If

' GridView Update

Dim SQL As String

If DropDownList1.SelectedIndex = 0 Then

SQL = "UPDATE tblTest SET Name = ltrim(rtrim(@Name)) where ID = @ID"

Else

SQL = "UPDATE tblTest SET ShortName = ltrim(rtrim(@ShortName)) where ID = @ID"

End If

SqlDataSource1.UpdateCommand = SQL

SqlDataSource1.UpdateCommandType = SqlDataSourceCommandType.Text

SqlDataSource1.UpdateParameters.Clear()

If DropDownList1.SelectedIndex = 0 Then

' Name

Dim Name As New ControlParameter()

Name.Name = "Name"

Name.Type = TypeCode.String

Name.ControlID = CType(GridView1.Rows(GridView1.EditIndex).Cells(2).Controls(0), TextBox).UniqueID

Name.PropertyName = "Text"

SqlDataSource1.UpdateParameters.Add(Name)

Else

' ShortName

Dim ShortName As New ControlParameter()

ShortName.Name = "ShortName"

ShortName.Type = TypeCode.String

ShortName.ControlID = CType(GridView1.Rows(GridView1.EditIndex).Cells(2).Controls(0), TextBox).UniqueID

ShortName.PropertyName = "Text"

SqlDataSource1.UpdateParameters.Add(ShortName)

End If

End Sub

Protected Sub GridView1_RowCancelingEdit(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCancelEditEventArgs) Handles GridView1.RowCancelingEdit

GridView_Fill()

End Sub

Protected Sub GridView1_RowUpdated(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewUpdatedEventArgs) Handles GridView1.RowUpdated

GridView_Fill()

End Sub

' Sortieren und Paging:

Protected Sub GridView1_Sorting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewSortEventArgs) Handles GridView1.Sorting

GridView_Fill()

End Sub

Protected Sub GridView1_PageIndexChanging(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewPageEventArgs) Handles GridView1.PageIndexChanging

GridView_Fill()

End Sub

----------------------------------------------------------------------------------------------------------------------------------------------------------

Viel Spaß!

----------------------------------------------------------------------------------------------------------------------------------------------------------

Search results matching tags 'VB.NET', 'ASP.NET.Net', and 'dynamischer Inhalt'

AW: GridView mit zur Entwicklungszeit unbekannter Datenquelle (SQL-Tabelle) BEARBEITEN