Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. cojiro

    format autogenerated column in gridview

    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...
  2. cojiro

    format autogenerated column in gridview

    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...
  3. cojiro

    format autogenerated column in gridview

    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...
  4. cojiro

    format autogenerated column in gridview

    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!
  5. cojiro

    format autogenerated column in gridview

    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...
  6. cojiro

    SQL Query with Dynamic Columns Question

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

    SQL Query with Dynamic Columns Question

    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...
  8. cojiro

    SQL Query with Dynamic Columns Question

    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...
  9. cojiro

    Need advice on planning departmental asp.net website

    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...
  10. cojiro

    Query with tables from Multiple Connections

    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...
  11. cojiro

    Query with tables from Multiple Connections

    Thanks!
  12. cojiro

    Query with tables from Multiple Connections

    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...
  13. cojiro

    SQL Matching Query Question

    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.
  14. cojiro

    SQL Matching Query Question

    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...
  15. cojiro

    SQL Matching Query Question

    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 ----------------...
  16. cojiro

    SQL Problem with Top 3

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

    SQL Problem with Top 3

    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!
  18. cojiro

    SQL Problem with Top 3

    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?
  19. cojiro

    SQL Problem with Top 3

    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...
  20. cojiro

    Join table with Else Clause

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

Part and Inventory Search

Back
Top