Search results for query: *

I've got a stored procedure that runs a number of different queries. Most of these involve doing joins, updates, and inserts with tables on two different servers. There are about 8 different queries that get run in this stored procedure. If I run them individually, there is one that takes 17...

Yesterday, I made some changes to a web app, then copied only the dll to the server. I didn't change any other files on the site. When I first tested it, it worked fine. But a little bit later, I got reports it wasn't working. I'm assuming it has something to do with the fact that I only...

I need to be able to print DataMatrix 2D barcodes on a crystal report. The report will be viewed and printed with a report viewer object in MS Access. I know that there are a bunch of companies that sell components to generate 2D barcodes like this in Crystal. There is also free code available...

Say I have these 2 tables ProductRules: ProductNum, RuleCode this table says that a particular rule applies to a particular product. RuleCountryLink: Rule Code, Country this table says that a particular rule is applicable to a particular country. So right now, I have a query that is something...

I'm new to web services, but I've got a basic web service with one web method working. With a regular aspx page, you have access to the Request object and can read whatever you need from it. Is there an equivalent to this for web services? I'd like to be able to access the soap request from...

I have some sql that selects from multiple tables and does an insert into a single "report" table that I use for generating a crystal report and an electronic file for a client. So it's something like: INSERT INTO ReportTable(fields....) SELECT fields.... FROM Table1 join Table2... etc. WHERE...

I have a string variable that will usually be several hundred characters long. It is basically a paragraph that will be displayed on a report and included in an electronic file. The electronic file requires that it be split into multiple lines, each of which are no longer than 80 characters...

I'm generating PDF reports with Crystal for VS.Net. I've got a vertical line drawn from the report header through the page header, details, report footer, and page footer. The line shows up fine for all the sections except the page header. Is there any way to make this line visible in the page...

I have a db search page that gives the option of doing a "sounds-like" search. There are 2 types of sounds-like they can pick from, but I also want them to be able to pick neither. So ideally, I'd like 2 checkboxes and I'd like the user to be able to select one or the other or neither. Is this...

I've got 1 primary table and 4 other tables. Each of these other tables has a many-to-one relationship to my main table. For example: Person(SSN) Alias(SSN, FirstName, LastName) Address(SSN, Street, City, State) Phone(SSN, PhoneNum) Each person can have many aliases, many addresses, and many...

The simplest way to explain would be to give an example. Say I have a set of database tables like this: Person(SSN, DOB) Alias(SSN, FirstName, LastName) Address(SSN, Street, City, State) Phone(SSN, PhoneNum) Skill(SSN, SkillDescription) There's one person with a particular SSN and that person...

OK, here's the issue. Say I have 3 tables (tblEntity, tblEntityName, tblEntityAddress) An entity represents a person. That person can have multiple names(aliases) and multiple addresses. So there is a one-to-many relationship between Entity and EntityName and a one-to-many relationship between...

I've got a VB.Net app that is generating reports and exporting them to pdf, xls, etc. I want to be able to capture the total page count of the generated report. I know there is a special field(or function) called TotalPageCount and I'm using that on the report itself. But is it possible to...

Hi, I need to build a page to add entries to several tables. There is one main table and 4 other tables that have foreign key relationships with the main table. The primary key in the main table is auto generated. I know I can insert into the first table, then grab the newly generated primary...

Hi, We've got a SQL 2000 db with several stored procedures that use the sp_OA automation stored procedures to call a VB6 dll that then calls a .Net dll. This all works fine in 2000, but we can't get it to work in 2005. The sp_OA works fine when creating the instance of the VB6 com object, but...

My C# app needs to reference a .Net assembly that was built by one of our previous developers. Everything works fine when I add a reference to the dll and leave "Copy Local" set to true. But this dll is used by several different applications and on several different machines and already has...

I've been scouring the web and I found a few examples that have to do with overriding the paint method. But I can't seem to figure out how to make this something that I can trigger, rather than being dependent on a condition. Does anyone have any examples or ideas? Thanks

I have a datagrid that is bound to a dataset. I have a "Save" button that checks the RowState of each row in the dataset to know whether to update the db or not. I have a "Cancel" button that does a RejectChanges on the dataset. This all works fine. I want to be able to change the color of the...

Hi, I've been doing VB/SQL development for 4 years now since getting my BSCS degree. Most of my time has been spent developing software to support a manufacturing environment. I'd really like to branch out and do something different, but without Java/C++/C work experience, the only jobs I seem...

Hi, Every time I open my VB project and try to compile it, I get a "cant find project or library". When I click OK, I get the Project->References window and I can see the missing reference. The problem is that it is pointing to a path where an old version of an app that I've uninstalled was...