Search results for query: *

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

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

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

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

I custom build some graphs in my code behind on a report page. The user selects a unit and a date range and I run a query to populate the graphs. Now the boss wants to have a button that will run all the graphs and copy them into a powerpoint presentation. Our production server does not have...

I have a connection string defined as follows: <connectionStrings> <add name="Con" connectionString="Driver={Microsoft ODBC for Oracle};Server=xxxx;Uid=xxxx;Pwd=xxxx;" providerName="System.Data.ODBC"/> </connectionStrings> No matter where I put this in the web config file I get an...

After a user logs in to my application, I need to grab some info from the header and assign those values to variables. This is what I have right now: UserName = Request.Headers("UserID") RoleID = Request.Headers("RoleCode") UserName and RoleID are strings that are passed through out the...

I need to grab three values from a table and store them into variables. I have tried a few variation of the following but am not getting what I need. Try Con.Open() Dim sql As New StringBuilder(1024) Dim objcmd As New OdbcCommand(sql.ToString, Con)...

I have a user selected start time and a user selected end time defined as follows: Public STime As Date = Format(MyDate, "MM/dd/yyyy") Public ETime As Date = Format(MyDate, "MM/dd/yyyy") Public MyDate As Date So the user selects dates from calendars, and the Unit comes from a dropdown list. I...

I have a web form with dropdown boxes that users select from. No matter where you are in the form, if the enter key is pressed, it takes the user back to the Login Screen. I just want the enter key to do nothing, and force the user to click the "Submit" button on the page. I have tried to use...

I have a menu that I define as follows: <asp:Menu ID="Menu1" runat="server" BackColor="Silver" DynamicHorizontalOffset="2" Font-Names="Verdana" ForeColor="Black" Font-Size="7pt" StaticSubMenuIndent="10px" BorderColor="Black" BorderStyle="Solid" BorderWidth="1px"> <Items> <asp:MenuItem...

I need to fill a dataset with values that are calculated in VB code. Is this even possible? OR do you have to run a query to fill a dataset? Any help is worth a star! Thanks, Chilly442

I need to loop through every minute of a time range to test against another value. How would I start with EventS, and loop through each minute until EventS = EventE (regardless of how long the duration is)? I can't get the minute to increment. This is the format that I use for the times. Dim...

Is it possible to build a custom library (.dll) for Excel? If so can someone point me in the right direction? Thanks, chilly442

If I run the following SELECT statement it works until the "OR". It returns selected unit, accepted, notification, and OutageType = U1. If I add the "OR", then it also returns anything (different units, ones that are not accepted) that has a OutageType = U2. SELECT * FROM(Events) WHERE(Unit...

I need to count how many rows are in a table, and then return that value to a textbox on a web form. Didn't find anything online that helped with this problem. I guess what I really need is to get the number of rows via a query like: SELECT Count(*) FROM Events But then how do I store that...

I am getting the error: System.Data.OleDb.OleDbException: No value given for one or more required parameters. Here is my code. <asp:GridView ID="GridView1" runat="server" Font-Size="X-Small" AutoGenerateColumns="False" OnRowEditing="GridView1_RowEditing"...

Getting this error. Is that a front end or a VB issue? The GridView 'GridView1' fired event RowUpdating which wasn't handled. Here is the .aspx code: <asp:GridView ID="GridView1" AllowSorting="true" AllowPaging="true" Runat="server" AutoGenerateEditButton="true"...

Is there a way to get a text box to show * , rather than the actual password that is typed? In VBA, you can set the PasswordChar property to *. How do you do this in VB? Thanks for the help! Chilly442