How to spruce up, enhance, and add row update, item delete to standard GrivView?
Question
All replies
-
User288213138 posted
Hi rogersbr,
https://docs.microsoft.com/en-us/aspnet/web-forms/overview/presenting-and-managing-data/model-binding/sorting-paging-and-filtering-data would be a great reference, but the original solution is not available, Microsoft seems to have fewer VB
Looking for a reference on VB (Visual Basic) .net and the Gridview, framework is version 4.5.2
C # code can be converted into VB code and vice versa. you can use this tool: http://converter.telerik.com/
Exception: Both DataSource and DataSourceID are defined on GridView1. Remove one definitionThis error is usually because you have bound 2 data sources to the GridView, one is the SqlDataSource control, and the other is bound in the code behind. You just need to use one of them.
This demo for you as a reference:
Search Customer: <asp:TextBox ID="txtSearch" runat="server"></asp:TextBox> <asp:Button Text="Search" runat="server" OnClick="Search" /> <hr /> <asp:GridView ID="gvCustomers" runat="server" AutoGenerateColumns="false" AllowPaging="true" OnPageIndexChanging="gvCustomers_PageIndexChanging" PageSize="3"> <Columns> <asp:BoundField DataField="CustomerId" HeaderText="CustomerId" ItemStyle-Width="150" /> <asp:BoundField DataField="Name" HeaderText="Name" ItemStyle-Width="150" /> <asp:BoundField DataField="Country" HeaderText="Country" ItemStyle-Width="150" /> </Columns> </asp:GridView> Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) If Not IsPostBack Then SearchCustomers() End If End Sub Private Sub SearchCustomers() Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString Using con As SqlConnection = New SqlConnection(constr) Using cmd As SqlCommand = New SqlCommand() Dim sql As String = "SELECT CustomerId, Name, Country FROM Customers" If Not String.IsNullOrEmpty(txtSearch.Text.Trim()) Then sql += " WHERE Name LIKE @Name + '%'" cmd.Parameters.AddWithValue("@Name", txtSearch.Text.Trim()) End If cmd.CommandText = sql cmd.Connection = con Using sda As SqlDataAdapter = New SqlDataAdapter(cmd) Dim dt As DataTable = New DataTable() sda.Fill(dt) gvCustomers.DataSource = dt gvCustomers.DataBind() End Using End Using End Using End Sub Protected Sub Search(ByVal sender As Object, ByVal e As EventArgs) SearchCustomers() End Sub Protected Sub gvCustomers_PageIndexChanging(ByVal sender As Object, ByVal e As GridViewPageEventArgs) gvCustomers.PageIndex = e.NewPageIndex SearchCustomers() End SubThe result:
If you still have questions, please share your code.
Best regards,
Sam
