Search results for query: *

showdialog() works great, well... for now at least :o)

ok. thanks.

I have a problem... when I do this after successfuly authenticating. Dim MainFrm = New Main MainFrm.Show() it just blinks for a milisecond and that's it. I just want to open the main application form and work with it. Why does it not stay ?

ok. thanks. I'll try. I need it because once the user(sales rep) enters their username and password I can retrieve info from database based on that particular rep's Id number. Like the customers, sales orders and everything else related to that particular person. I am new to VB.NET and I...

I have a little authentication window come up as soon as you start the program but then when a user enters their username and password (correctly; it is checked against database) I need it to set a few variables (variables must be public and kept until application closes) and pass them to the...

OK, I just figured out a way. I am using datareader. It works just like I need it.

I need to assign a data value from a dataset/dataadapter to a variable, or can I check if dataset returned any values?

can you please explain what exactly scope.identity() does? I can't find info on it.

I have 2 tables in the SQL 2000 database, Customers and CustomerAddress. The reason is because one customer can have multiple physical locations. I am building an ASP app that automates sales order process. Anyway... I have a single form that has to create a new customer record but Company...

thanks will try

Oh I am sorry, forgot to mention... I am using SQL 2000

I need to generate a unique number besides the autoincrement ID field that will be a unique alphanumeric order number, maybe even in sequence to look better say... ABCD0001 format

need some help to figure out how to display existing data for a particular record in Form fields and if changed in the field I need to click update button which will update the changed fields in the database, or maybe all because the ones that weren't changed gonna stay the sane anyway. what's...

I setup a 2003 server and have a workstation right beside it. Web server and workstation both on 192.168.2.0 network that's connected to a router and then to internet. The server is only letting through port 80. For security reasons. I don't wanna access it from my workstation through this IP...

I am kinda close to resolution though, but I still don't think that my current solution is completely appropriate.

Updating values, how to make it work? by Belcom125

maybe you guys can help me solve the problem at the root then? I posted recently another topic "the problem itself". I guess you know how to find the post. So please have a look at the description an the code I am using and the problem I am having. I'd appreciate another opinion on this.

Nope, I tried and got a bunch of weird numbers instead of proper format CustomerNumbers and still get 30 records that occur twice.

Yes I know that it is not the most proper way. But I am getting frustrated here. I've been working on this task for a like a week now. Which seems like a VERY long time. And right now I just wanna hand it in as long as it works. I am kinda an intermediate SQL programmer however sometimes I...

I am doing an update procedure where I am running the first update and then the second update statement only needs to update the records modified by the previous one. So I wanna specify in the where clause that it needs to update only the records where the LastUpdate Time and Date is within the...