Search results for query: *

Using a dataset (VB.Net) to fill a listview with records from a SQL Server table. How can I get the column names from the table to the column names on the listview?

Brand new to .NET here. Need connection string help for connection to SQL server.

I need to import/export tables between databases. There is no problem in this working using the Wizard except for the fact that all the 'default value' properties are lost. These tables have up to 300 columns, so this is obviously a big deal. Is there some way to keep these 'default values'...

Hello, The anaylzer debugger isn't working properly. I right click in the object browser and choose debug, but the analyzer looks like it just runs through the stored procedure and gives a return value. The pane where the variables are displayed is shaded out with nothing displayed in it. I get...

Hello, I have some extensive stored procedures that copy complete records from like tables across several databases. I'm using #temp1 withing EXEC statements and this works great. Is there any way to do this if the table that is being copied to is not exactly the same as the table that the...

I would like to run an active report in my VB App and have it show on a form and be of a certain size on that form. Can this be done? Any way will be helpful. Thanks.

Simply: I'm am building an SQL Statement string to populate a recordset in my VB. String looks something like this: recordset.Open "SELECT * FROM Account WHERE LastName Like '%" & strName & "%' ORDER BY LastName" I need to know how to handle this if the user enters some character, like a...

Well, that's about it. I need to know how to implement and use bound connections. Thanks.

I have some large stored procedures that run some complicated calculations. They are called from my VB app by using a batch run method and on an individual basis. There are situations where we could have several users calling the SP at the same time - batch and individual. Cursors are used...

I need to keep a total of each field within a tabel. Is there a way with an SQL statement in my SP to loop through the fields in each record without being forced to name each field specifically. This is a large table, and I'm trying to get away from something like "Field1Tot = Field1Tot +...

Hi, I use a lot of Stored Procedures with my Apps. I also use several databases at the same time. The databases represent fiscal years of data, so the only difference between them is updates made to the information from year to year. When a new year comes around, I simply copy the tables...

Hi, Is there any way to gain access to the name of the database that a stored procedure is in? In other words, can I put the database name in a variable within a stored procedure? I would like to store the database name in a table. Thanks for any help. Mitch C.

Hi, I am working on converting tables from my old database for use in SQL and VB. The text files were built with a query utility on the old database. They are comma delimited with quotes signifying the non-numeric fields. I'm using Enterprise Manager and the Import Data function. Some of the...

Hi, Is there any way to take an existing CR9 report, make a copy of that report and rename it, and then change the name of the table the report fields use. In other words, I need two reports that are formatted identical and use separate tables that are also identical. I have a ReportA using...

Hi, I recently changed from Cr8 to Cr9. The switch was made primarily because I need to be able to change databases dynamically while running my VB application. I have all my reports that were developed in Cr8 now working with Cr9 within my VB application. I have a question, however, about...

Hi, I am building SQL Strings in my stored procedure in order to execute with dynamic information. After much agony dealing with the single-quotes, double-quotes, when and when not to use quotes, etc..., I have them working. The problem is when I need to insert an integer variable into the...

Hi, I am running some stored procedures from my VB application. Is there any way to get an informational message from the SP to show in the VB application, like the MsgBox in VB? The RaiseError sends back a message but there is too much overhead info and system error info. Thanks for any help.

Hi, How can I take a RAISERROR message that is sent to my VB application and limit the display to only the text that I sent. In other words, can I get rid of all the system text and error numbers that also show up in the box and have it display only the string that was built with the Stored...

Hi, I would like to use a trigger with some of my tables to build some kind of audit file. I would like to keep up with certain information any time one of these tables is updated. That would be information such as user and password info, machine name from where the table is being accessed...

Hi, I need to run a stored procedure, (with parameters), from within another stored procedure. Some of the SP's I need to run are in another database, and should execute for the database that they are located in. How do I call a SP from within a SP, and is the naming convention for running...