Oct 24, 2012, 7:18 PM
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 :
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