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

More Search Options

RSS Available

• Re: Data Tables -- BASICS

  I'm getting the following error "Invalid usage of aggregate function Sum() and Type: String." with this line of code: dr("TotalHours") = SourceTable.Compute("SUM(" & AggregateColumn & ")", (GroupByColumn & " = '") + dr(GroupByColumn) & "'") Also, to incorporate my filter dtblTimesheet.Select("EEID<>'310' AND DateIn>=#08/12/2009# AND DateIn<=#08/25/2009#", "EELastName, DateIn"

  Posted to Data Presentation Controls (Forum) by rvaldivia001 on 8/20/2009

• Re: Data Tables -- BASICS

  My error was that my colum was defined as a string vs. decimal. So, I got all that working, I got my filtering working, and now my last piece which I can't figure out is the syntax for the GroupByColumn. I have 2 columns (and potentially at times 3 columns) to group by. Do I separate each by a space or by an AND? or, am I totally missing it. THANKS for your help and patience.

  Posted to Data Presentation Controls (Forum) by rvaldivia001 on 8/20/2009

• Re: Data Tables -- BASICS

  THANKS SO MUCH!!!! THIS IS GREAT CODE!! And, I learned a lot. i didn't realize it was going to be so complicated. But THanks again!!!

  Posted to Data Presentation Controls (Forum) by rvaldivia001 on 8/20/2009

• Re: Data Tables -- BASICS

  I figured it out!! THANKS!!! That was a bit challenging.

  Posted to Data Presentation Controls (Forum) by rvaldivia001 on 8/20/2009

• Data Tables -- BASICS

  I have a flat file that I'm reading into a data table that I've created. How do retrieve the data? ie, select? HEre is some basic code: Dim dtblMyTable as new data.datatable dtblMyTable.columns.add(New data.datacolumn("Employee") dim rowout as data.datarow read a row rowOut("Employee") = columns(0) dtblMyTable.rows.add(rowout) Now, I need to select all employees who's last name is "ABC" and bind to a gridview how do I do this?

  Posted to Data Presentation Controls (Forum) by rvaldivia001 on 8/19/2009

• Re: Data Tables -- BASICS

  So, I'm getting different errors, first if I use the following code, I get a syntax error on dtblTimeSheet.Select("DateIn...") that states "Value of type 1-dimensional array of system.data.datarow cannot be converted to system.data.datarow. And on the rows.length I get a syntax error that says length is not a member of system.data.datarow Dim rows As DataRow = dtblTimesheet.Select("DateIn>=#08/12/2009# and DateIn<=#08/25/2009#") Dim BindDt As DataTable = dtblTimesheet

  Posted to Data Presentation Controls (Forum) by rvaldivia001 on 8/19/2009

• Re: Data Tables -- BASICS

  BINGO!!!! THANKS!!! With regards to the Select is it possible to do multiple selection criteria along with Summing? So, for example dt.Select("EEID='310' AND DateIn >= #08/12/2009#") I get the following error: "Min (6207) must be less than or equal to max (-1) in a Range object."

  Posted to Data Presentation Controls (Forum) by rvaldivia001 on 8/19/2009

• Re: Data Tables -- BASICS

  That Sum totals. I'm looking to aggregate on Date?

  Posted to Data Presentation Controls (Forum) by rvaldivia001 on 8/19/2009

• Re: Data Tables -- BASICS

  That's going to get the max or the count based on a date. I'm looking to Sum hours by date. So, if the tables has the following data: 1, David, 08/12/2009, 3.5 1, David, 08/12/2009, 4.0 1, David, 08/13/2009, 5 1, David, 08/14/2009, 3 1, David, 08/14/2009, 4.5 Then my result would 1, David, 08/12/2009, 7.5 1, David, 08/13,2009, 5 1, David, 08/14/2009, 7.5

  Posted to Data Presentation Controls (Forum) by rvaldivia001 on 8/19/2009

• grid refresh

  After I've updated a row in a grid via a formview or detailview how do I refresh the grid? I do a databind, though it doesn't refresh the grid. I'm building the grid via a selection from a ddlb.

  Posted to Data Presentation Controls (Forum) by rvaldivia001 on 8/9/2009