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

That's EXACTLY what I'm looking for. Thanks. Mitch

I do login using a login form with Login, Password, and DBname. I am trying to avoid sending another parameter to the SP's because it would involve a lot of changes. I need the SP's to write the database name to a table, if there's any way to aquire it withing the SP. The database name needs...

OK, I wasn't very clear. I'm running the stored procedures from a Visual Basic App. I use several databases that are set up identical. They are named YEAR2004, YEAR2005, YEAR2006 ..., in order to keep multiple years of information. The stored procedures in each database are also identical...

At the time the stored procedure is run, I won't know which database I'm working in. How do I choose the database that the stored procedure is in? There are numerous database names in the sysdatabases table.

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

That's a huge relief. Thanks. Mitch

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