That is the namespace of my project. You will need to change it to yours. On 9/16/05, sas0riza <[EMAIL PROTECTED]> wrote: > I get an error: > > Parser Error > Description: An error occurred during the parsing of a resource > required to service this request. Please review the following > specific parse error details and modify your source file > appropriately. > > Parser Error Message: Could not load > type 'Playground.SearchDataGrid'. > > Source Error: > > > Line 1: <%@ Page Language="vb" autoeventwireup="false" > codebehind="SearchDataGrid.aspx.vb" > Inherits="Playground.SearchDataGrid" %> > Line 2: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 > Transitional//EN"> > Line 3: <html> > > > > > > --- In [email protected], "sas0riza" > <[EMAIL PROTECTED]> wrote: > > Oh okay, I gotcha. Thanks. > > > > What's the advantage/disadvantage using inline vs. behind code? > > > > > > --- In [email protected], Dean Fiala > > <[EMAIL PROTECTED]> wrote: > > > You have the code from my previous post > > > Create a file > > > Paste in the code > > > > > > On 9/16/05, sas0riza <[EMAIL PROTECTED]> wrote: > > > > What is it though? Don't I need the file in order for the code > to > > > > work? > > > > > > > > --- In [email protected], Dean Fiala > > > > <[EMAIL PROTECTED]> wrote: > > > > > Yes, > > > > > <%@ Page Language="vb" AutoEventWireup="false" > > > > > Codebehind="SearchDataGrid.aspx.vb" > > > > > Inherits="Playground.SearchDataGrid"%> > > > > > > > > > > On 9/16/05, sas0riza <[EMAIL PROTECTED]> wrote: > > > > > > What's the codebehing? SearchDataGrid.aspx.vb? > > > > > > > > > > > > > > > > > > --- In [email protected], Dean Fiala > > > > > > <[EMAIL PROTECTED]> wrote: > > > > > > > Yes, you will have to code that yourself, but it doesn't > > cause > > > > any > > > > > > > change to how the grid pages and searches, only has to > how > > you > > > > > > create > > > > > > > the first column. > > > > > > > > > > > > > > On 9/16/05, sas0riza <[EMAIL PROTECTED]> wrote: > > > > > > > > Also I forgot to mention that in my datagrid, the first > > > > column is > > > > > > > > clickable in that when I click on a last name, the > record > > > > > > > > information is editable on another page on a form. > Would > > this > > > > > > case > > > > > > > > any changes? > > > > > > > > > > > > > > > > Thanks. > > > > > > > > > > > > > > > > --- In [email protected], Dean > Fiala > > > > > > > > <[EMAIL PROTECTED]> wrote: > > > > > > > > > Here's code for a page that fills a datagrid and > lets > > you > > > > > > search > > > > > > > > for > > > > > > > > > either first or last name and lets you page. Html > > > > follows... > > > > > > > > > > > > > > > > > > Imports System.Data.SqlClient > > > > > > > > > Public Class SearchDataGrid > > > > > > > > > Inherits System.Web.UI.Page > > > > > > > > > > > > > > > > > > #Region " Web Form Designer Generated Code " > > > > > > > > > > > > > > > > > > 'This call is required by the Web Form Designer. > > > > > > > > > <System.Diagnostics.DebuggerStepThrough()> > Private > > Sub > > > > > > > > InitializeComponent() > > > > > > > > > > > > > > > > > > End Sub > > > > > > > > > Protected WithEvents txtFirst As > > > > > > > > System.Web.UI.WebControls.TextBox > > > > > > > > > Protected WithEvents txtLast As > > > > > > > > System.Web.UI.WebControls.TextBox > > > > > > > > > Protected WithEvents dg As > > > > > > System.Web.UI.WebControls.DataGrid > > > > > > > > > Protected WithEvents btn As > > > > > > System.Web.UI.WebControls.Button > > > > > > > > > > > > > > > > > > 'NOTE: The following placeholder declaration is > > > > required > > > > > > by the > > > > > > > > > Web Form Designer. > > > > > > > > > 'Do not delete or move it. > > > > > > > > > Private designerPlaceholderDeclaration As > > System.Object > > > > > > > > > > > > > > > > > > Private Sub Page_Init(ByVal sender As > > System.Object, > > > > ByVal > > > > > > e As > > > > > > > > > System.EventArgs) Handles MyBase.Init > > > > > > > > > 'CODEGEN: This method call is required by > the > > Web > > > > Form > > > > > > > > Designer > > > > > > > > > 'Do not modify it using the code editor. > > > > > > > > > InitializeComponent() > > > > > > > > > End Sub > > > > > > > > > > > > > > > > > > #End Region > > > > > > > > > > > > > > > > > > Private Sub Page_Load(ByVal sender As > > System.Object, > > > > ByVal > > > > > > e As > > > > > > > > > System.EventArgs) Handles MyBase.Load > > > > > > > > > 'Put user code to initialize the page here > > > > > > > > > If Not Page.IsPostBack Then > > > > > > > > > BindGrid() > > > > > > > > > End If > > > > > > > > > End Sub > > > > > > > > > > > > > > > > > > Private Sub btn_Click(ByVal sender As > > System.Object, > > > > ByVal > > > > > > e As > > > > > > > > > System.EventArgs) Handles btn.Click > > > > > > > > > dg.CurrentPageIndex = 0 > > > > > > > > > BindGrid() > > > > > > > > > End Sub > > > > > > > > > > > > > > > > > > Private Sub BindGrid() > > > > > > > > > dg.DataSource = GetCustomer() > > > > > > > > > dg.DataBind() > > > > > > > > > End Sub > > > > > > > > > > > > > > > > > > Private Function GetCustomer() As DataTable > > > > > > > > > Dim SQL As String > > > > > > > > > Dim WHERE As String = "" > > > > > > > > > SQL = "SELECT * FROM Customers" > > > > > > > > > If txtFirst.Text.Length > 0 Then > > > > > > > > > WHERE = " WHERE FirstName LIKE '%" & > > > > txtFirst.Text > > > > > > > > & "%'" > > > > > > > > > End If > > > > > > > > > If txtLast.Text.Length > 0 Then > > > > > > > > > If WHERE.Length = 0 Then > > > > > > > > > WHERE = " WHERE " > > > > > > > > > Else > > > > > > > > > WHERE &= " AND " > > > > > > > > > End If > > > > > > > > > WHERE &= "LastName LIKE '%" & > txtLast.Text > > > > & "%'" > > > > > > > > > End If > > > > > > > > > > > > > > > > > > Dim conn As SqlConnection = New > > > > > > > > > SqlConnection(ConfigurationSettings.AppSettings > > > > ("connString")) > > > > > > > > > Dim cmd As SqlCommand = New SqlCommand(SQL & > > WHERE, > > > > > > conn) > > > > > > > > > Dim da As SqlDataAdapter = New SqlDataAdapter > > (cmd) > > > > > > > > > Dim dt As DataTable = New DataTable > > > > > > > > > da.Fill(dt) > > > > > > > > > Return dt > > > > > > > > > End Function > > > > > > > > > > > > > > > > > > Private Sub dg_PageIndexChanged(ByVal source As > > Object, > > > > > > ByVal > > > > > > > > e As > > > > > > > > > > System.Web.UI.WebControls.DataGridPageChangedEventArgs) > > > > Handles > > > > > > > > > dg.PageIndexChanged > > > > > > > > > dg.CurrentPageIndex = e.NewPageIndex > > > > > > > > > BindGrid() > > > > > > > > > End Sub > > > > > > > > > End Class > > > > > > > > > > > > > > > > > > <%@ Page Language="vb" AutoEventWireup="false" > > > > > > > > > Codebehind="SearchDataGrid.aspx.vb" > > > > > > > > > Inherits="Playground.SearchDataGrid"%> > > > > > > > > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 > > > > Transitional//EN"> > > > > > > > > > <HTML> > > > > > > > > > <HEAD> > > > > > > > > > <title>SearchDataGrid</title> > > > > > > > > > > > > > > > > > > </HEAD> > > > > > > > > > <body> > > > > > > > > > <form id="Form1" method="post" > > > > runat="server"> > > > > > > > > > <table> > > > > > > > > > <tr> > > > > > > > > > <td><table> > > > > > > > > > > > > <tr> > > > > > > > > > > > > > > > > > <td>First:</td> > > > > > > > > > > > > > > > > > <td><asp:TextBox ID="txtFirst" > > > > > > > > Runat="server"></asp:TextBox></td> > > > > > > > > > > > > > > > > > <td>Last:</td> > > > > > > > > > > > > > > > > > <td><asp:TextBox ID="txtLast" > > > > > > > > Runat="server"></asp:TextBox></td> > > > > > > > > > > > > > > > > > <td><asp:Button ID="btn" Text="Search" > > > > > > > > Runat="server"></asp:Button></td> > > > > > > > > > > > > </tr> > > > > > > > > > > </table> > > > > > > > > > </td> > > > > > > > > > </tr> > > > > > > > > > <tr> > > > > > > > > > > <td><asp:DataGrid > > > > id="dg" > > > > > > > > runat="server" AllowPaging="True" > > > > > > > > > AllowSorting="True" AutoGenerateColumns="False" > > > > > > > > > > > > > > > PageSize="5"> > > > > > > > > > > > > > <Columns> > > > > > > > > > > > > > > > > > <asp:BoundColumn DataField="FirstName" > > > > > > > > > SortExpression="FirstName" ReadOnly="True" > > > > > > > > > HeaderText="First"></asp:BoundColumn> > > > > > > > > > > > > > > > > > <asp:BoundColumn DataField="LastName" > > > > > > > > > SortExpression="LastName" ReadOnly="True" > > > > > > > > > HeaderText="Last"></asp:BoundColumn> > > > > > > > > > > > > > > > > > <asp:BoundColumn DataField="EmailAddress" > > > > > > > > > SortExpression="EmailAddress" ReadOnly="True" > > > > > > > > > HeaderText="Email"></asp:BoundColumn> > > > > > > > > > > > > > > > </Columns> > > > > > > > > > > > > > > > <PagerStyle > > > > > > > > Mode="NumericPages"></PagerStyle> > > > > > > > > > > > > > > > </asp:DataGrid></td> > > > > > > > > > </tr> > > > > > > > > > </table> > > > > > > > > > </form> > > > > > > > > > </body> > > > > > > > > > </HTML> > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > > > Dean Fiala > > > > > > > > > Very Practical Software, Inc > > > > > > > > > http://www.vpsw.com > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > > Dean Fiala > > > > > > > Very Practical Software, Inc > > > > > > > http://www.vpsw.com > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > Dean Fiala > > > > > Very Practical Software, Inc > > > > > http://www.vpsw.com > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > Dean Fiala > > > Very Practical Software, Inc > > > http://www.vpsw.com > > > > > > > Yahoo! Groups Links > > > > > > > >
-- Dean Fiala Very Practical Software, Inc http://www.vpsw.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
