You searched for the word(s): userid:624235

More Search Options

RSS Available

• Re: Aggregate functions in multiple tables

  Sorry for late reply, please see the following for tables and key columns: Table - Sales SalesNo PK Table - SalesItem SalesItemNo PK SalesNo FK ItemCode Qty Price Table - SalesPayment SalesPaymentNo PK SalesNo FK Amount

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by gtrfinger on 1/23/2007

• Re: Aggregate functions in multiple tables

  All the column names are unique in these three tables except the foreign key, SalesNo. There is no difference happening here... :( I guess I have to add two more columns in the Sales table and programmatically insert/update the TotalBill & TotalPayment just to have the grid with these two information available. Or should I, the other way round, programatically calculate them when retriving the resultset for the grid? Which one is the better way in the sense of processing performance? I think

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by gtrfinger on 1/12/2007

• Aggregate functions in multiple tables

  Hi, need help in this statement here. I have three tables here, i.e. Sales, SalesItem, & SalesPmt. I want to display a grid that shows the Total Bill and Total Payment amounts. My try is like this: SELECT SalesNo, SUM(Price*Qty) AS TotalBill, SUM(Payment) AS TotalPayment FROM ... GROUP BY.... No syntax error or whatever found, but the result of the total amounts is incorrect. Say the data of the respective table below: SalesItem No Qty Price 1 1 5.00 2 2 12.00 3 4 3.50 SalesPayment No Amount

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by gtrfinger on 1/12/2007

• Re: Validate a control in an iframe

  >> I personally wouldn't use this kind of structure (iframes etc), ... What method will you recommend then? As long as page won't reload to itself excepting submiting, as this will save me a lot of troubles... Your suggestion works, but I want something like a popup upon submiting, instead of showing error when page already starts reloading... My user has a slow network infrastructure, and it takes seconds just to load pages. That's why I am avoiding unnecesary page loads. Thanks again.

  Posted to Web Forms (Forum) by gtrfinger on 1/7/2007

• Validate a control in an iframe

  Anyone of you ever validate a server control that is in an iframe? My scenario as below: This is the parent page to add a sales record, Sales_Action.aspx The source of an iframe in this page, is a page that is used to add/remove sales items, Sales_Action_Items.aspx (I did this to avoid whole page postback while user adding/removing sales items. Only the page in the iframe will post back.) One of the controls (in the iframe) for validation is the txtDiscountAmount, criteria: cannot be more than the

  Posted to Web Forms (Forum) by gtrfinger on 1/6/2007

• Re: storing a collection of business objects on presubmit.

  Thanks for your answer

  Posted to State Management (Forum) by gtrfinger on 12/22/2006

• storing a collection of business objects on presubmit.

  Hi all, I am having a doubt here. I have a little web app here for my user to manage the daily sales transaction. On creating new, or updating existing sales records, I will be storing the sales items, a collection of business objects, in asp.net built in session objects before user submits the record. Am I doing the right way? is there any other better way? Considering this app will be implemented in a multi-user environment. Does this matter at all? Thanks

  Posted to State Management (Forum) by gtrfinger on 12/19/2006

• Re: Using a Database Data Source with the ReportViewer Web Server Control in Local Processing Mode

  I finally found a way to "fix" it, but does not work all the time~~~ In my asp.net application, in the bin folder, there are a couple of dll components. After I cut all of them and paste to a safe place, the Website Data Source window will be back in functioning, at least showing the "your project has no data source" information. Then I restore the dll files one by one. After restoring each dll file, I will refresh the Website Data Source window to see if it is still working,

  Posted to Visual Web Developer 2005 Express (Forum) by gtrfinger on 10/16/2006

• Re: Using a Database Data Source with the ReportViewer Web Server Control in Local Processing Mode

  Hi, I am facing the same problem. But I am using Business objects as the data source for a local report. The Website Data Source window suddenly becomes empty without a reason. I have undone everything I did but does not help. Feel so sad that Visual Web Developer has failed to at least indicate what has gone wrong so that we know from where to look for the problem... Have you found your solution anyway?

  Posted to Visual Web Developer 2005 Express (Forum) by gtrfinger on 10/15/2006

• Empty Website Data Source windown

  Hi all, I am Visual Web Developer user and facing a problem when I am creating a local report (.rdlc) file. I am using Business objects as the Data Source for this report. It was working perfectly until all the items in the Website Data Source window suddenly "disappeared". The "Add New Data Source" button on this window is also disabled. Now the window is just like a blank box only. And I can't continue working with the report file like this... I have tried undoing what I

  Posted to Visual Web Developer 2005 Express (Forum) by gtrfinger on 10/15/2006