any basic example on gridview

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    SOLVED : any basic example on gridview

    Any basic example on how to populate a gridview programatically -> vb.net if you can and how to set the nice features that it offers?
    Thank you.

    vb code :
     Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
            If Not IsPostBack Then
                Store1.DataSource = querydbdata("SELECT * FROM local_stoc")
                Store1.DataBind()
            End If
        End Sub
        Public Function querydbdata(ByVal xxx As String) As DataTable
            Dim mydatatable As New DataTable
            Try
                myconnection = New MySqlConnection(myconnstr)
                Dim myadapter As New MySqlDataAdapter(xxx, myconnection)
                myconnection.Open()
                myadapter.Fill(mydatatable)
                myconnection.Dispose()
            Catch ex As Exception
                ' mydatatable.Columns.Add()
                ' mydatatable.Rows.Add()
                ' mydatatable.Rows(0)(0) = ex.Message.ToString
            End Try
            Return mydatatable
        End Function
    aspx page
    <%@ Page Language="vb" AutoEventWireup="false" CodeBehind="Default.aspx.vb" Inherits="WebApplication2.WebForm1" %>
    
    <%@ Register assembly="Ext.Net" namespace="Ext.Net" tagprefix="ext" %>
    
    <!DOCTYPE html>
    
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head runat="server">
        <title></title>
    </head>
    <body>
        <form id="form1" runat="server">
        <div>
        
            <ext:ResourceManager ID="ResourceManager1" runat="server" />
            <ext:Window ID="Window1" runat="server" Collapsible="true" Height="185" Icon="Application" Title="Title" Width="350">
                <Items>
                </Items>
            </ext:Window>
           
        
          
            <ext:GridPanel ID="GridPanel1" runat="server" Height="300" Title="Title">
                <Store>
                      <ext:Store ID="Store1" runat="server">
                          <Model>
                              <ext:Model runat="server" >
    
                              </ext:Model>
                          </Model>
            </ext:Store>
                </Store>
                <View>
                    <ext:GridView ID="GridView1" runat="server" TrackOver="false" />
    </View>
                <ColumnModel runat="server" >
    
                </ColumnModel>
            </ext:GridPanel>
           
        
        </div>
        </form>
    </body>
    </html>
    not working...
    Last edited by stonegate; Oct 26, 2012 at 7:51 AM. Reason: SOLVED

Similar Threads

  1. Visual Basic.Net Help
    By leonelcra in forum 2.x Help
    Replies: 0
    Last Post: Oct 17, 2012, 1:31 AM
  2. Basic MVC Plumbing
    By Patrick_G in forum 2.x Help
    Replies: 3
    Last Post: May 25, 2012, 7:15 PM
  3. Replies: 2
    Last Post: Nov 04, 2011, 6:06 PM
  4. Error in example PropertyGrid > Basic > Overview
    By george.paoli in forum Bugs
    Replies: 1
    Last Post: Nov 17, 2010, 9:05 PM
  5. Getting Started Basic Example
    By tarekahf in forum 1.x Help
    Replies: 3
    Last Post: Nov 09, 2009, 1:17 AM

Posting Permissions