Visual Basic

19-Dec-05 4:07

This is probably a simple question, but for some reason (maybe Monday morning fog, or too many Christmas goodies in the conference room to distract me from thinking) but I can't seem to figure out what I'm doing wrong.

I have a textbox on a Windows form, and the client is supposed to enter a date in this textbox. The information is then posted via a stored procedure into a SQL table in a column that is formatted datetime.

You would think this is simple, but even when I put a valid date like 11/11/99 in the text box, when it executes the following code I get the message 'Cast from string "System.Windows.Forms.TextBox, Te" to type 'Date' is not valid.'.

cmdPost.Parameters("@BirthDate").Value = frmEx.tbxDOB.ToString

Even if I change the code to the example below, I get the same error.

cmdPost.Parameters("@BirthDate").Value = CDate(frmEx.tbxDOB.ToString).ToShortDateString

I know the answer is something simple, and after a few more glasses of egg nog, maybe I'll figure it out, but if anyone has any suggestions, I'd appreciate your input.

Thanks Roll eyes | :rolleyes:

Lost in the vast sea of .NET

<a href="http://www.komputing.com/Pricelist.html">Visit my website at www.komputing.com</a>

albCode19-Dec-05 4:32

albCode

19-Dec-05 4:32

try this format date
example:
frmEx.tbxDOB.text = "1999.11.11" or
frmEx.tbxDOB.Text = "2005.12.19"

cmdPost.Parameters("@BirthDate").Value = frmEx.tbxDOB.Text.ToString

KreativeKai19-Dec-05 4:45

19-Dec-05 4:45

If I use this format I get the following error

The string was not recognized as a valid DateTime. There is a unknown word starting at index 0.

Confused | :confused:

Lost in the vast sea of .NET

<a href="http://www.komputing.com/Pricelist.html">Visit my website at www.komputing.com</a>

albCode19-Dec-05 4:51

albCode

19-Dec-05 4:51

Dim data As New Date
data = Me.TextBox1.Text
MessageBox.Show(data)

'format date i added in textbox is 19.12.2005

in windows form works fine

KreativeKai19-Dec-05 5:30

19-Dec-05 5:30

Thanks for your help. I know what happened. I was using ...tostring, and should have used ...text.

I knew it was simple. Thanks for your time. Smile | :)

Lost in the vast sea of .NET

<a href="http://www.komputing.com/Pricelist.html">Visit my website at www.komputing.com</a>

dptalt21-Dec-05 2:59

dptalt

21-Dec-05 2:59

What is the value of frmEx.tbxDOB.ToString when it is converted to a date?

KreativeKai21-Dec-05 3:31

regarding excel sheet generation in vb.net

21-Dec-05 3:31

The value of frmEx.tbxDOB.ToString is
'System.Windows.Forms.Texbox, Text: 11/11/05.

The value of frmEx.tbxDOB.Text is '11/11/05'.

Lost in the vast sea of .NET

<a href="http://www.komputing.com/Pricelist.html">Visit my website at www.komputing.com</a>

datagrid validation

usernamess19-Dec-05 3:49

usernamess

19-Dec-05 3:49

Hi Guys. I'm using datagrid in vb.net. Question is how do i validate datarid.

I've fixed number of column but row can be vary. I have some mandatory field which i have to make sure is filled in or if it say phone number or email, i have to make sure my code can validate that function. Pls help

thx

usernamess

nagalakshmibasireddy19-Dec-05 2:37

nagalakshmibasireddy

19-Dec-05 2:37

hello,
The datagrid that is generated in webform should generate in excel form in vb.net.The entire form should be generated into excelsheet and form also contains picture images also.plz explain with namespaces
plz help me as i am beginner to vb.net.
thanks & regards
Nagalakshmi

-- modified at 22:52 Monday 19th December, 2005

Re: regarding excel sheet generation in vb.net

usernamess19-Dec-05 3:46

usernamess

19-Dec-05 3:46

hello, so let me get this straight, you are using datagrid and you want to create excel file from that. Or you want to create from webform.

Here are links from internet.

http://support.microsoft.com/default.aspx?scid=kb;en-us;317719

http://geekswithblogs.net/azamsharp/archive/2005/08/05/49291.asp

let me know if you need more help

thx

Printing problem in VB.net

HemaRawat19-Dec-05 0:17

HemaRawat

19-Dec-05 0:17

Hey All

I am Stuck in a problem

I have an application that generates the Barcode

When I am printing that with the laser printer , Then That printed barcode is readble through the Scanner

But when I am printing it with the Label Printer(USed to print small badge cards, Address labels etc.) then that printed barcode (printed by label printer) is not readable by the barcode scanner

Can you give me the direction Why is it so.

Thanks for this help

Hema Chaudhry

Re: Printing problem in VB.net

Duncan Edwards Jones19-Dec-05 0:25

Duncan Edwards Jones

19-Dec-05 0:25

Does it look different to the human eye? (stretched, etc.)

If not then your ink may not be compatible - i.e. the scanner has a single light wavelength and maybe the difference between bars and spaces in your ink in that wavelength is not sufficient.

'--8<------------------------
Ex Datis:
Duncan Jones
Merrion Computing Ltd

HemaRawat19-Dec-05 0:31

HemaRawat

19-Dec-05 0:31

Thanks for this prompt reply(really your answer is urgent for me)
I can't understand what is problem

That Printer also has a software that also generates sample Barcodes
& those printed barcodes (By label printer) are readable by that scanner

But the barcodes generated by my application & printed by label printer is not readable by that scanner.

But the barcodes generated by my application & printed by Laser printer is readable by that scanner.
That's why I am not getting the actual problem
what it is????

thanks & regards

Hema Chaudhry

Dave Kreskowiak19-Dec-05 7:27

Dave Kreskowiak

19-Dec-05 7:27

If your barcode is getting streched left and right (I'm assuming a Code 39 or 128 barcode or something similar here) at all, then it won't read properly. Print a sample barcode on the printer that prints the working barcode and on the card printer (exact same barcode!) and measure the two. The length of the barcode should match exactly. If not, there's your problem.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

HemaRawat19-Dec-05 17:26

HemaRawat

19-Dec-05 17:26

Yes I am using the Code 128 B BarCode symbology .

And also ,The Barcode printed by Label printer are somewhat different from the barcode printed by the laser printer.

That's why my scanner reads the barcode printed by the laser printer
but can't read the barcode printed by the label printer.

Now , I can't understand with what the exact problem is :
1. with barcode
2. With Label printer.
3. or Sacnner

Although all three are working properly individually.

Plz repy me as soon as possible for You

Thanks a bunch in advance.

Hema Chaudhry