Visual Basic

DataGridViewCellStyle Format

3-Jul-08 10:21

To start off their is no comparison Smile | :)

Regards,
Thomas Stockwell

Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.

Visit my homepage Oracle Studios

Discounted or Free Software for Students:
DreamSpark - downloads.channel8.msdn.com
MSDN Academic Alliance - www.msdnaa.com

Smithers-Jones2-Jul-08 2:49

Smithers-Jones

2-Jul-08 2:49

In my DataGridView I have a column displaying date and two columns displaying time (begin/end).
For the date column I set CellStyle format=d, so users can only enter proper dates and it works fine, but I don't seem to get it working for the time-columns. Time should be formatted HH:mm, but when setting format=t users still are able to enter into the time-columns whatever they want.
Solution anybody?

"I love deadlines. I like the whooshing sound they make as they fly by." (DNA)

Re: DataGridViewCellStyle Format

Tom Deketelaere2-Jul-08 5:03

Tom Deketelaere

2-Jul-08 5:03

how about format = HH:mm:ss

don't know for shure but I seem to remeber having a simular problem and that fixed it (I think)

Re: DataGridViewCellStyle Format [modified]

Smithers-Jones2-Jul-08 19:46

Smithers-Jones

2-Jul-08 19:46

~~I tried "HH:mm" before, but no success.~~

-edit-
Thanks, found the error. The column in my datatable, which was bound to datagridview, had the datatype string instead of datetime.

"I love deadlines. I like the whooshing sound they make as they fly by." (DNA)

modified on Thursday, July 3, 2008 6:10 AM

Add Control

~V~2-Jul-08 2:30

~V~

2-Jul-08 2:30

Hi

I added a control named Shockwave flash object from com object to my toolbox but when i drag it to my form it gives error that:

Failed to import ActiveX control, Please ensure that it is properly registred.

Can any one give me the right way to do it

Thanks

Unless u don't give ur hundred percent whatever u r doning till there is no result of ur work...

Re: Add Control

Thomas Stockwell2-Jul-08 2:34

2-Jul-08 2:34

Find another activeX control that is better than what you are currently using. Their may be a compatability issue with using it in Visual Studio. Or if you can use WPF, convert the flash object to XAML.

Re: Add Control

~V~2-Jul-08 2:40

~V~

2-Jul-08 2:40

Thanks 4 reply

But sorry! i din't get it

Their may be a compatability issue with using it in Visual Studio. Or if you can use WPF, convert the flash object to XAML.

Unless u don't give ur hundred percent whatever u r doning till there is no result of ur work...

Re: Add Control

Thomas Stockwell2-Jul-08 2:45

Any one help me-smtp server

2-Jul-08 2:45

If the designer for visual studio crashes or does not allow the activeX control to be added to a form, then their is a problem. The problem is most likely because of an incompatability between the activeX control and either visual studio or the .NET framework. To fix the problem, ditch the control and find a replacement. You can either find an activeX control that works or you can use the Windows Presentation Foundation (of .NET 3.0). To use WPF you would have to convert the flash file to XAML.

kannanmani2-Jul-08 1:26

kannanmani

2-Jul-08 1:26

Hii Friends

I have a form in my software in which if user is connected to internet can send an querry to my id, myid@gmail.com. Two textboxes one for sender email id will be written and another for subject, And the main querry in the multiple lines text box. i have a smptp and pop3 account with gmail.com as smtp.gail.com and pop.gmail.com . How can i do this which namespace i have to import for tat and the code is required.
I use this code but didn't send mail .if any one help me...

Dim Email As New System.Net.Mail.MailMessage("kanmani84@gmail.com", "kanmani84@gmail.com") '(From, To)

Email.Subject = "Dot Net 2.0 Mail Class Test"
Email.Body = "This is the Dot Net 2.0 Mail Class Test Email. "

Dim mailClient As New System.Net.Mail.SmtpClient()
Dim basicAuthenticationInfo As New System.Net.NetworkCredential("kanmani84", "mani12")
mailClient.Host = "mail.gmail.com"
mailClient.EnableSsl = True
mailClient.Port = 25
mailClient.UseDefaultCredentials = False

mailClient.Credentials = basicAuthenticationInfo
mailClient.Send(Email)

I have been tryin on this

Please share if u have N E idea.

Thanks
By
K.Mani

By
K.mani

~V~2-Jul-08 2:38

~V~

2-Jul-08 2:38

Try this one

But first
Imports system.web.mail

<br />
 Dim obj As System.Web.Mail.SmtpMail<br />
    Dim mailMsg As New MailMessage()<br />
<br />
        mailMsg.From = "abc@gmail.com"<br />
        mailMsg.[To] = "def@gmail.com"<br />
        mailMsg.Subject = "Just 4 Testing"<br />
        mailMsg.Body = "Hello"<br />
<br />
        mailMsg.Priority = MailPriority.High<br />
    ' Smtp configuration <br />
        SmtpMail.SmtpServer = "smtp.gmail.com"<br />
    ' - smtp.gmail.com use smtp authentication <br />
        mailMsg.Fields.Add("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate", "1")<br />
        mailMsg.Fields.Add("http://schemas.microsoft.com/cdo/configuration/sendusername", "abc@gmail.com")<br />
        mailMsg.Fields.Add("http://schemas.microsoft.com/cdo/configuration/sendpassword", "password")<br />
    ' - smtp.gmail.com use port 465 or 587 <br />
        mailMsg.Fields.Add("http://schemas.microsoft.com/cdo/configuration/smtpserverport", "465")<br />
    ' - smtp.gmail.com use STARTTLS (some call this SSL) <br />
        mailMsg.Fields.Add("http://schemas.microsoft.com/cdo/configuration/smtpusessl", "true")<br />
    ' try to send Mail <br />
<br />
        SmtpMail.Send(mailMsg)<br />
<br />

Hope it will help U

Unless u don't give ur hundred percent whatever u r doning till there is no result of ur work...

Thomas Stockwell2-Jul-08 2:41

2-Jul-08 2:41

First thing I spot is that you are using the wrong port number. I have code similar to yours for my own application (I can't get to it at the moment, otherwise I would post it), but you can start off getting the correct port number.

Jay Royall2-Jul-08 2:51

Jay Royall

2-Jul-08 2:51

You should really remove your Gmail username and password from this post (and then change your password).

DataGridView Column ordering

jzonthemtn2-Jul-08 6:07

jzonthemtn

2-Jul-08 6:07

Follow Google's instructions for configuring other mail clients[^].

Fahim A2-Jul-08 1:16

Fahim A

2-Jul-08 1:16

Hi Guys

I have a .Net WinForm with a bound DataGridView which has been formatted in design view. All columns are bound to the datasource in design view with datapropertyname and Grid datasource is passed at runtime. Some colms are visible, frozen and invisible. Issue I have is I cannot seem to order the columns properly. What it shows at design time is not what is displayed at run time. Everytime I order the columns at design time, it just reorders as it likes. I tried to control this at the Designer class and still was no luck.

Can someone help me please.

Re: DataGridView Column ordering

paas2-Jul-08 3:05

paas

2-Jul-08 3:05

Before you bind the grid to the desired datasource, make sure you set the grids AutoGenerateColumns property to False. I expect that will solve your problem.

Re: DataGridView Column ordering

Fahim A4-Jul-08 13:00

Fahim A

4-Jul-08 13:00

Thank you very much it worked

Tablebuilder

Kahuna2-Jul-08 0:48

Kahuna

2-Jul-08 0:48

How do you used VB to create tablebulder,can someone please point me in the right direction

Thomas Stockwell2-Jul-08 2:46

2-Jul-08 2:46

tablebuilder with regards to what. For printing? monitor display? webpage?

Kahuna2-Jul-08 3:39

Kahuna

2-Jul-08 3:39

in regard to display data of an excel spreadsheet

Thomas Stockwell2-Jul-08 3:42

2-Jul-08 3:42

Well, if you do not want the user to interact directly with Excel, then you could use the Grid control or an equivelant or better third party control to host the user information. Or have a form that just has textboxes whose information will be sent to excel. Then google how to send information to Excel through either Excel API or VSTO.