Search results for query: *

Thanks for the reply. I guess there isn't going to be a way for me to do it totally dynamically, huh? Oh well. Thanks again!

I have a report that shows information for products (product name, number, cost, sell, etc). Each product can have one, or several, colors attached to it, with a quantity for each color. So, if there are 4 colors attached to one product, I'll get 4 records returned for that product; one for...

That's what I was thinking I was going to have to do. I've never used a gridview control, and generally don't work with bound controls, so I wanted to make sure I wasn't missing something. Thanks!

Here's why I'm not sure it's that simple. What I need is to display a "master site" record. What they want to see is this "master site" record, and then have the ability to click a link/button/whatever next to the record to have the "child site" record(s) associated with that "master site"...

ASP.NET/VB.NET 2.0 I have a webform that has a gridview bound to a stored proc using the SQLDataSource. I need to set the visible property of records based on a value in the datasource. My initial thougt (when I thought it was bound to a dataset) was to do a select against the datatable, and...

Thanks much, but now I have to make it a bit more complex... Ok, so we have this select * from table1 where table1.name = table2.name and table1.date = table2.date and (table1.type like 'blue' and table2.type_id = 4 OR table1.type like 'red' and table2.type_id = 2) Now, what would...

Ok, that makes sense. If I needed to check 2 situations like this would it be Select * from table1 where table1.type like 'blue' and table2.type_id = 4 OR table1.type like 'red' and table2.type_id = 2 ? How about if I need other where clauses as well? select * from table1 where table1.name...

In my where clause, I need to compare a field in table_1 to a field in table_2. My problem is that the field in table_1 is a text field, and the field in table_2 is a numeric id...so... table_1.type = "blue" and the equivalent in table_2 would be table_2.type_id = 4 So I essentially need...

I found my answer. Thanks for the replies! What I was trying to do is "fake" dynamic reports as best as I can. What I was failing to do was build the report off of an XML schema of a dataset. I needed it to be generic enough that I could use a dataset generated from one of two databases. As...

Runtime is when I get the error. In looking back, my question should have been: If I set the datasource to a DataSet or DataTable, can I still access the ReportDocument.Database object? Or is that only populated when you actually connect to a DB?

I can set the datasource of a Crystal Report to a DataSet, and it works just fine. If I try to set it to a particular DataTable, I get the error "Invalid Table Number" Any ideas why this would happen?

My account has local admin rights, so I don't think it's the security credentials of my account. What doesn't make sense to me is that it would work under VB6, but not VB.NET. Which function under Microsoft.Win32.Registry() would access the key?

I have an application that was recently run through the migration wizard to bring it from VB6 to VB.NET 2k3. I am having some issues with one particular thing... The application accesses the registry using functions in ADVAPI32.dll. In VB6, everything works fine, and the API function...

I'm having an issue filling a dataset from an excel file. Creates an OleDB connection to the spreadsheet (no problem), then generates a Select statement to read the worksheet in to the dataset. It works great IF all the relevant fields in the spreadsheet contain data. The select is a simple...

Umm...nevermind. Figured it out. New baby...brain is mush.

I'm assuming by "Native" you mean using the MS driver for Oracle? I've been using the Crystal Oracle driver because using the MS supplied causes Crystal to only show stored procs, and not db's.

Crystal Reports XI Oracle 10g I'm writing a report that is supposed to show how much time it took to go from one status to another. Not a big deal. My issue is that Crystal is only displaying the date, not datetime. If I query the db using WinSQL, it shows datetime. If I query the db using...

Ok, that's what I said I wanted to do, but I'm not sure HOW to do it. How do I get the button ID/Name?

I know I can use that object, but I'm not sure how to get the name of the object. I know that GetType will return System.Web.UI.WebControls.Button, but I'm not sure how to get the name/ID of the button. Thanks

C# I have a form with 2 textboxes. I want to add a button by each text box to count the characters. I can do this the really easy way by creating 2 buttons, and coding an OnClick for each button. I'd rather check to see which button is clicked, and count the characters in the appropriate...