CodeVerge.Net Beta


   Explore    Item Entry   Register  Login  
Microsoft News
Asp.Net Forums
IBM Software
Borland Forums
Adobe Forums
Novell Forums

ASP.NET Web Hosting – 3 Months Free!
Zone: > NEWSGROUP > Asp.Net Forum > visual_studio.visual_web_developer_2008_express Tags:
Item Type: NewsGroup Date Entered: 12/14/2007 9:11:22 PM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
(NR, 0)
XPoints: N/A Replies: 3 Views: 51 Favorited: 0 Favorite
Can Reply:  No Members Can Edit: No Online: Yes
4 Items, 1 Pages 1 |< << Go >> >|
mhash1
Asp.Net User
Multiple text box query with data grid.12/14/2007 9:11:22 PM

0/0

Hi,

 I have a very simple sql database  and using datagrid based on the view (sum on payment, group on date and time, floor number)  with two text box query (text box 1 = floorNbr     textbox 2 = PymentDateTm). Soonest I ugpraded to full release of vw developer 2008. My query does not work correctly. I can seach the datagrid with only text box query but not with 2. Here is the code.

<%@ Page Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false" CodeFile="t1est.aspx.vb" Inherits="t1est" title="Untitled Page" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<p>

<br />

<asp:TextBox ID="Floor_Number" runat="server"></asp:TextBox>

<br />

<br />

<asp:TextBox ID="Payment_date" runat="server"></asp:TextBox>

<br />

<br />

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"

DataSourceID="SqlDataSource1">

<Columns>

<asp:BoundField DataField="Floor_Number" HeaderText="Floor_Number"

SortExpression="Floor_Number" />

<asp:BoundField DataField="Payment_Recieved" HeaderText="Payment_Recieved"

SortExpression="Payment_Recieved" />

<asp:BoundField DataField="Payment_date" HeaderText="Payment_date"

SortExpression="Payment_date" />

<asp:CommandField />

</Columns>

</asp:GridView>

<asp:SqlDataSource ID="SqlDataSource1" runat="server"

ConnectionString="<%$ ConnectionStrings:receipts %>"

SelectCommand="SELECT [Floor_Number], [Payment_Recieved], [Payment_date] FROM [CHECK TOTAL BETWEEN DATES] WHERE (([Floor_Number] = @Floor_Number) AND ([Payment_date] = @Payment_date))">

<SelectParameters>

<asp:ControlParameter ControlID="Floor_Number" DefaultValue="3"

Name="Floor_Number" PropertyName="Text" Type="String" />

<asp:ControlParameter ControlID="Payment_date" DefaultValue="10/27/2007"

Name="Payment_date" PropertyName="Text" Type="DateTime" />

</SelectParameters>

</asp:SqlDataSource>

</p>

</asp:Content>

 

Appreciate for help.

 
Samu Zhang - MS
Asp.Net User
Re: Multiple text box query with data grid.12/18/2007 6:50:49 AM

0/0

Hi mhash1 ,

I have tested a solution which is similar to yours using vs2008 and it works fine on my pc.

How can I reproduce the error?

Sincerely,
Samu Zhang
Microsoft Online Community Support

Please remember to click ?Mark as Answer? on the post that helps you, and to click ?Unmark as Answer? if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
mhash1
Asp.Net User
Re: Multiple text box query with data grid.12/18/2007 3:10:37 PM

0/0

Do you think I am missing something on my machine after upgrading to .net 3.5 and v2008. Code is very simple and straightforward. I even tried on a seperate databse but still query with two text boxes does not work at all but with one text box works fine. Did you find any thing wrong with my code ?.

 

thanks

hashmi

 
Samu Zhang - MS
Asp.Net User
Re: Multiple text box query with data grid.12/19/2007 5:31:13 AM

0/0

Hi mhash1,

I can not find anything wrong with your code and I can not re-produce the error.

Please double check to see if the two values you typed in textbox (Floor_Number,Payment_date) exist in one row concurrently .  

Sincerely,
Samu Zhang
Microsoft Online Community Support

Please remember to click ?Mark as Answer? on the post that helps you, and to click ?Unmark as Answer? if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
4 Items, 1 Pages 1 |< << Go >> >|


Free Download:

Books:
ADO.NET Cookbook Authors: Bill Hamilton, Pages: 605, Published: 2003
How to Do Everything with Microsoft Office Access 2003 Authors: Virginia Andersen, Pages: 556, Published: 2003
ADO.NET: The Complete Reference Authors: Michael Otey, Denielle Otey, Pages: 935, Published: 2003
Comprehensive Informatics Practices XII Authors: unknown, Pages: 0, Published: -1
Sams Teach Yourself ASP.NET in 21 Days Authors: Chris Payne, Pages: 1104, Published: 2002
Introduction to Programming with Visual Basic .NET Authors: Gary J. Bronson, David A. Rosenthal, Pages: 756, Published: 2004
MCAD/MCSD: Developing XML Web Services and Server Components with Visual C# . NET and the . NET Framework Authors: Amit Kalani, Ed Tittel, Pages: 1040, Published: 2003
Microsoft Access 2000 - Illustrated Introductory: European Edition Authors: Lisa Friedrichsen, Pages: 224, Published: 2001
Microsoft Office Access 2007: The Complete Reference Authors: Virginia Andersen, Pages: 775, Published: 2007
How to Do Everything with Microsoft Office Access 2007 Authors: Virginia Andersen, Pages: 1024, Published: 2006

Web:
Datagrid sql query - ITtoolbox Groups Feb 19, 2008 ... Ignore this text box. It is used to detect spammers. ... I am facing following problem with sql query for DataGrid control ( ...
Multiple Database Query Analyzer Download VSI Systems Software Multiple Database Query Analyze Sql Access - Download Multiple Database ... Data output can be viewed in Plain Text or a Data Grid. ...
CodeProject: Multiple Column Dropdownlist for the ASP.NET DataGrid ... An article on multiple column dropdownlists for the ASP.NET DataGrid. C#, Windows, . .... (For e.g., to display the second column "LastName" in the textbox, ...
Multiple Column Dropdownlist for the ASP.NET DataGrid / ASP.NET ... (For e.g., to display the second column "LastName" in the textbox, set DataValueField =2.) If your DataGrid is inside the " Table / Div / Span ", then make ...
databinding | binding data to a datagrid control We can use simple data binding to map the text property of a textbox control to ... DataGrid, This control can display data from multiple records as well as ...
can't assign datagrid datakey with multiple PK from DB table - ASP ... //Assign datagrid textbox control values to corresponding dataset columns ... query that populates the dataset that's used to populate the datagrid - AND, ...
DataGrid.ItemCommand Event (System.Web.UI.WebControls) For bound columns, the edited value is stored in a TextBox. .... Add other cases here, if there are multiple ButtonColumns in ' the DataGrid control. ...
Distributed multi-join query processing in data grids Query processing in data grids is a difficult issue due to the ... Yang, D.H., Li, J.Z. and Rasool, Q., Join algorithm using multiple replicas in data grid. ...
How to display a datagrid in multiple tab pages - ITtoolbox Groups May 14, 2008 ... Ignore this text box. It is used to detect spammers. ... a list of suppliers and their outstanding invoices in multiple tabs in a datagrid. ...
Download Multiple Database Query Analyzer 2.1 Free Trial ... Multiple Database Query Analyzer Supports queries with different types of databases. ... Data output can be viewed in Plain Text or a Data Grid. ...

Videos:
Literate functional testing Google London Test Automation Conference (LTAC) Google Tech Talks September 7th, 2006 Presenters: Robert Chatley and Tom White




Search This Site:










v web 2008 install issue

visual web developement server error

create & download document at runtime

visual web devloper locks up on exit

copy web site stoped working

error in the visual web developer 2008 express..

can't add ajax extensions 1.0 to vwd 2008 toolbox

how to publish a vwdee site

when orcas express beta1 will release

where can i find...

adjusting image size changes size of entire table

web site administration tool - web site not found

page code file not resolving page web controls visual web developer 2008

'view in browser' - error: can't display the web page

visual web developer problem with appcrash

wcf .net 3.5: orcas intellisense

when i hit absolute in the format menu to move a control it also changes the size of that control

is it possible to configure visual studio 2008 beta express editions to use asp 2.0 instead of 3.5

vwd closes when trying to go to design mode

vwd 2008 and nested masterpages

layout menu option missing

creating a new project

framework error

i.e. nuisance how i do stop message "runtime error has occured. do you wish to debug?"

error installing vw82008 express

commercial use of express versions

how to open new tab?

how to open dynamic pages on content area (masterpage)

report addin for vswd 2008

vwd 2008 - layout tool bar from vwd 2005
  Privacy | Contact Us
All Times Are GMT