Recent content by chilly442

I was able to take what you suggested above and make it work. I just placed the code in the Page_Load Event, and then call it inside the RowDataBound Event. There is probably a better way to do this (and a cleaner way) but this will work for now. StringBuilder str = new StringBuilder("...

I had a look around and couldn't come up with a way to keep the grid from doing a trim. I'll give your solution a shot and see what I can come up with. Thanks for the help! Thanks, Chilly442 ---------------------------------------

So I loop through the dtEvents DataTable and get the values that I need. I do some checking, which I have left out. Then I build the dtMaster_Events DataTable and bind that to the Grid. I tried: sC4 = new String(' ', 20); //=== And a few variations of: String sSpace = " "; sC4 = sSpace +...

I am attempting to build a text report from data that is loaded into a GridView. The GridView is populated from a DataTable which is filled with data from a query. Each column is required to be a fixed number of spaces or characters. The problem that I am having is there are a few columns in...

I have a dashboard that is supposed to run 24 hours a day to display last hours data for power generation. Values are pulled from oracle and refreshed to the pages every hour to keep the data current. A rotator changes the page every 45 seconds using a timer control. At this time I have a...

After doing a bit more research into this, I was looking on Microsoft's site and found the following: http://msdn.microsoft.com/en-us/library/system.data.oracleclient(v=VS.100).aspx Looks like OracleClient is going to go away in future versions. Thanks, Chilly442...

I have been using ODBC to connect and query data from Oracle. I had a co-worker tell me that he doesn't think that I should be using ODBC, and that he uses OracleClient. What is/are the benefits to using one or the other? Am I better off using one and not the other? Using ODBC is what I...

It is stored as a Date. Thanks for taking the time to help me. Thanks, Chilly442 --------------------------------------- If I lived anywhere else I'd be Sunny442

When I run the following query, it returns dates that are before 2010 and I am not sure why. SELECT * FROM Events WHERE (Unit = 'D5') AND StartTime >= TO_DATE('01/01/2010', 'MM/DD/YYYY') Is this because the Oracle DB has the dates stored as "MM/dd/yyyy HH:MM:SS"? If so what do I need to...

I am converting an application that was written in VB to C#. I am trying to test this query to pull data from Oracle. This query gives me anything = or > STime, but ignores the year. So if STime = 01/01/2010 12:00:00 I get 01/01/1998 12:00:00, 03/03/1995 11:00:00 I need anything that is...

In your query you need to tell it to pull the values as a number. In Oracle it is: To_Number(ID) Thanks, Chilly442 --------------------------------------- If I lived anywhere else I'd be Sunny442

Looking for advice for the best solution: I have an Excel file that users enter monthly data into. Users will leave the file open and then go to lunch, or leave for the weekend. So other users are not able to get into the file and do their work. What is the best soluion to prevent or fix...

After a bit more searching I found this: TextBox1.Attributes.Add("onkeydown", "return (event.keyCode!=13);") If placed in the PageLoad it takes care of my problem. Thanks to all who tried to help. Sorry it took so long to post this. Thanks, Chilly442...

Try something like this: Sub GridView1_RowUpdating(ByVal sender As Object, ByVal e As GridViewUpdateEventArgs) Dim strVehicle As String = DirectCast(GridView1.Rows(e.RowIndex).Cells(2).Controls(0), TextBox).Text Dim strNotes As String =...

I am still new to this as well. jbenson001 Why not? What is the downfall? Just curious. Thanks, Chilly442 --------------------------------------- If I lived anywhere else I'd be Sunny442