Search results for query: *

Good call Mark! In case you all are interested, here's the final code that worked for me: Protected Sub GridViewInceptionToDateExpenseReport_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles...

Jason, thanks again for your response. So, it may be a hack, but I'd love to use this code: Format("{0:c}", Convert.ToDouble(e.Row.Cells(i).Text)) Unfortunately, the "null" fields that are being passed are causing this to error out. I get this error: "Input string was not in a correct...

That's what I usually do, but I ran into this sitution due to some strange user requirements. The report I'm trying to display in this gridview is the output of an access crosstab query that has an uncertain amount of columns. Having autogenerated columns is the only way I can think to display...

Jason, I appreciate the response. I've tried seraching for a good coding example on the internet, but have come up short. Can you help me out with what I'll need to code to get this formatting working? Thanks!

I'm trying to format an autogenerated column in a gridview and I'm not sure why my current code isn't working. My results display without error, but without any formatting. Please help! Here's the code: GridViewInceptionToDateExpenseReport_RowDataBound(ByVal sender As Object, ByVal e As...

I'm not sure, I'll give it a try though...

Yeah, I know practically I could just run this normally, throw this in a pivot table and get my disired results. The problem is I would like to take the results of this query and use it as a datasource for a gridview control on a webform. So my options here are kind of limited...

I have three tables in a relational database: User, Expense, and ExpenseDescription. User Table Fields: UserID, Name, Age Expense Table Fields: ExpenseID, Amount, ExpenseDescriptionID, UserID ExpenseDescription Fields: ExpenseDescriptionID, Description Problem: I need to write a summary...

Hi All, I'm considering setting up an internal website for my department at work. This site would be used for retrieval of data from databases throughout the company's infrastructure and other odds and ends. I'm trying to get an idea of what kind of hardware and software I would need to budget...

I looked through all of the examples on the web for relating tables to join them and they all were a little tough to understand. This may not be the best way to do this, but it's definitely very readable and it works. Maybe this will help someone in my situation... Sub JoinTables(ByRef...

Thanks!

Here's the situation: I have two DB connections ConnA (DB2) and ConnB (SQL Server). I need to bind a datagrid to the results of a query which joins a table from ConnA to a table from ConnB. Can someone please tell me how I should be going about this? I'm relatively new to asp.net so I'm only...

Yeah, I know this is a bad idea, but sometimes you have to work with what you're given. Thank you all for your help.

kaht, That method does work for the data set mentioned above, but the problem comes in a situation where there are 2 or more similar totals in both tables. I would like to return a row for each successful match, rather than just one. tcsbiz/AlexCuse, The reason why i have these requirements is...

I have two tables from unrelated systems. The only common field for the tables is an amount field. I would like to return a result set of which amounts match, without repeating any match. For example: Table A Table B ID Amount ID Amount ----------------...

There's a lot great info on this thread. Thanks everyone!

This a different solution I've found elsewhere in case anyone is interested: SELECT A.Golfer, avg(A.Score) FROM TableName A WHERE (Select count(*) From TableName B where B.Golfer = A.Golfer and B.Score<A.Score) <= 2 GROUP BY a.Golfer ORDER BY AVG(A.score) Thanks for your help Borislav!

My table above is actually a view of several tables. Is there a way I can add that IDENTITY column to my view so this code will work?

I have a table that lists Golf round scores like this: Golfer Score -------------- 1 85 1 100 1 77 1 99 2 110 2 33 I need to create a query that results in the average of each golfer's lowest 3 scores. I'm at a loss with this. I was hoping...

Thanks George, that is slick. I'll definitely do that.