I'm building vb.net app using n-tier format with business layer using Typed Dataset that's generated from SQL 2005, and UI layer.
Everything works fine until my boss decided he wants to use an empty database, which means i have to redirect the connection string to the new database in our sql...
I'm trying to pass a date parameter using sqlcommand into sql server, however for some reason the date parameter caused the stored procedure to fail. Here's my code:
...sqlcmd initialization
With cmdHdrUpdate
With .Parameters
.Item("@DepositID").Value = dr("DepositID")...
In my solution i have 3 projects which contains a business logic, form bases, and front end UI. Originally i use 3 different namespaces for each of them, however i recently changed each namespace to use the same format like for example:
Original Namespace:
Business Logic -> BL
Form bases ->...
Hi,
I'm having some problem loading data from SQL Express with my winform app. It crashed (waiting indefinitely) when loads the actual data that contains thousands of records. So i tested the app using only hundreds of records and everything works fine. The reason i'm loading all the data at...
Hi All,
I'm trying to create a simple module that will take my initial SQL database (has some initial value) and copy it to user spec. location, so that the user can work on the copy database and never touches the template database. Does anybody know how to do this? I've been googling for...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.