I have a two controls on my web app. The first is a textbox that
users are to fill in the employee id (control id is "EmplID1". The
second is a gridview that should display information from a table
based on the employee id that is keyed into the textbox.
For some reason when I view the app in a browser when I key in an
employee id into the textbox it doesn't display the data from the
gridview. I used the Test Query function when configuring my data
source and used the same employee id that I key in the textbow in the
browser.
I'm not sure what I'm doing wrong or what else I need to do. I've
attached my code.
<%@ Page Language="VB" AutoEventWireup="false"
CodeFile="Default.aspx.vb" Inherits="_Default" %>
<%@ Register Assembly="EclipseWebSolutions.DatePicker"
Namespace="EclipseWebSolutions.DatePicker"
TagPrefix="cc1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://
www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"; >
<head runat="server">
<title>Untitled Page</title>
<link href="Timecard.css" rel="stylesheet" type="text/css" />
</head>
<body>
<form id="DisplayResults" runat="server">
<div>
<table style="width: 712px">
<tr>
<td style="width: 20%;">
Employee ID</td>
<td id="EmplID" style="width: 30%;">
<asp:TextBox ID="EmplID1" runat="server"
Width="81%"></asp:TextBox>
</td>
</tr>
</table>
<hr />
<br />
<br />
<asp:Label ID="Label1" runat="server" Font-Bold="True"
Text="Records Added:" Width="242px"></asp:Label><br />
<hr />
<asp:GridView ID="GridView1" runat="server"
AutoGenerateColumns="False" DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="INSTAT" HeaderText="INSTAT"
SortExpression="INSTAT" />
<asp:BoundField DataField="INCONO" HeaderText="INCONO"
SortExpression="INCONO" />
<asp:BoundField DataField="INDVNO" HeaderText="INDVNO"
SortExpression="INDVNO" />
<asp:BoundField DataField="INEENO" HeaderText="INEENO"
SortExpression="INEENO" />
<asp:BoundField DataField="INCKTY" HeaderText="INCKTY"
SortExpression="INCKTY" />
<asp:BoundField DataField="INERCD" HeaderText="INERCD"
SortExpression="INERCD" />
<asp:BoundField DataField="INWKNO" HeaderText="INWKNO"
SortExpression="INWKNO" />
<asp:BoundField DataField="INDYWK" HeaderText="INDYWK"
SortExpression="INDYWK" />
<asp:BoundField DataField="INGLAN" HeaderText="INGLAN"
SortExpression="INGLAN" />
<asp:BoundField DataField="INJBNO" HeaderText="INJBNO"
SortExpression="INJBNO" />
<asp:BoundField DataField="INJCDI" HeaderText="INJCDI"
SortExpression="INJCDI" />
<asp:BoundField DataField="INCSTY" HeaderText="INCSTY"
SortExpression="INCSTY" />
<asp:BoundField DataField="INRGHR" HeaderText="INRGHR"
SortExpression="INRGHR" />
<asp:BoundField DataField="INOVHR" HeaderText="INOVHR"
SortExpression="INOVHR" />
<asp:BoundField DataField="INOTHR" HeaderText="INOTHR"
SortExpression="INOTHR" />
<asp:BoundField DataField="INOTTY" HeaderText="INOTTY"
SortExpression="INOTTY" />
<asp:BoundField DataField="INDTWE" HeaderText="INDTWE"
SortExpression="INDTWE" />
<asp:BoundField DataField="INDPNO" HeaderText="INDPNO"
SortExpression="INDPNO" />
<asp:BoundField DataField="NOTES" HeaderText="NOTES"
SortExpression="NOTES" />
<asp:BoundField DataField="USERID" HeaderText="USERID"
SortExpression="USERID" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:CMSConnectionString2 %>"
SelectCommand="SELECT * FROM [Timecard] WHERE ([INEENO] =
@INEENO)">
<SelectParameters>
<asp:ControlParameter ControlID="EmplID1"
Name="INEENO" PropertyName="Text" Type="Decimal" />
</SelectParameters>
</asp:SqlDataSource>
</div>
</form>
</body>
</html>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web
Services,.NET Remoting" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/DotNetDevelopment
You may subscribe to group Feeds using a RSS Feed Reader to stay upto date
using following url
<a href="http://feeds.feedburner.com/DotNetDevelopment";>
http://feeds.feedburner.com/DotNetDevelopment</a>
-~----------~----~----~----~------~----~------~--~---
