Here is a code snippet that I found online a while ago that helps: Try this code in DataGrid CellEndEdit Events (note: this will sum the items not multiply. So you will just modify it to check whether the cells have values and then multiply the values. i am to lazy to retype it)

Dim iTotal As Integer = 0
With DataGrid1
For i As Integer = 0 To .ColumnCount - 2
If Not IsDBNull(.Rows(e.RowIndex).Cells(i).Value) Then
iTotal += .Rows(e.RowIndex).Cells(i).Value
End If
Next
.Rows(e.RowIndex).Cells(.ColumnCount - 1).Value = iTotal
End With

modified on Wednesday, January 27, 2010 2:59 AM

Thanks, I'll take a look and see if I can find anything. Unfortuanately the mail server is administered by a different company but I mainly wanted to establish that it was not something on my side, rather something with their server. Thanks for the help.

:( Hi, Sorry, perhaps I am saying the wrong thing, I am not too familiar with e-mail sever lingo. Basically we used a different mail server to send it off (which i specify as a new smtp client I.p address) and then it did not compress the file. It sends through code to pc's using outlook. But when using the first smtp client I.p (server1) address it zipped the file. On the second I.p (server 2) it didn't. Thats why I can only assume something on the first mail sever is compressing the files when sending :sigh:

Na, It's something on the server. We used another mail smtp client and it worked fine. So now where to look on the server is the question?

Hi All, I am having an issue at work where the .dat (fixed length) file generated for import into a client application (generated and e-mailed to customers in vb.net code using smtpclient) is being compressed into a .zip file. This is causing an issue at customer stores as they are unable to open the files and import. Any ideas why it is doing this? Is it outlook? Is it my vb application (unlikely because if you access the shared folder containing the file before sending it is not compressed) or is it the server? I really need to ghet this fixed as the phone is ringing off the hook and I cant find any helpful articles anywhere. thanks guys,

Dim X as integer for x = Cint(date.Now.year) to (Cint(Date.Now.Year)-20) step - 1 YearFromCoomboBox.items.add(x) next

In the mouse click event for the tetbox you could try: if not (Me.txtNvs.SelectionStart = txtInput.text.length -1) then Me.txtNvs.SelectionStart = txtInput.text.length -1 Me.txtNvs.SelectionLength = 0 end if 'it may be something similar to determine the current selected index in the if statement good luck :)

Try this in your vb code:

CONVERT(DATETIME, '" & Format(datetimepicker1.value, "MM/dd/yyyy") & " 00:00:00', 102)

If this doesn't work change the code 102 to 101 or 103. It might be one of those codes that you need to use. should do the trick

Depending on your requirements you merely use a font. You can download a code 39 (3 of 9) font for free online which can hadle uppercase letters and numbers. Certain barcodes are limited to the characters they can handle and the more you use the longer the barcode becomes (which is true for code 39). I have found the most useful barcode to use is a code 128 type. These barcodes are a fixed length (regarless of the amount of characters) and also use all of the 128 ASCII characters . Code 128 barcode fonts require a checksum (validity check) in order to read characters so they are more challenging to use but if space is limited on the items you wish to apply barcodes to, I would recommend purchasing a code 128 barcode font and checking articles online that can help explain how to create this checksum. Good luck

I don't have the solution to your problem but I do have code that will work for you try:

Dim myMail As New MailMessage()
Dim eFrom As New MailAddress("*****@****.***")
myMail.From = eFrom

    myMail.To.Add("\*\*\*\*\*@\*\*\*\*\*.\*\*\*")
    
    myMail.Subject = "Your subject"
    myMail.Priority = MailPriority.High
    myMail.Body = "Your message"
    Dim myAttachment As New Attachment("your attachment")

myMail.Attachments.Add(myAttachment)

    Dim smtpClient As New SmtpClient("\*\*.\*\*.\*\*.\*\*")    'Whatever your mail server address is
    smtpClient.Send(myMail)

Replacing any * with the proper character and leaving out anything you don't need. Also remember to import Imports System.Net.Mail

I want to supply the user a combobox in a cell ("called Warehouse"- I add programatically to a datagridview) so they can select from the options. I want this datagridviewcombobox column to display the default value and if the use doesn't select a different value and then clicks save it saves to the database this default value. If they change selections and save it must save the selected value. Please Help ;)

Hi I was wondering if anyone could give me any useful links to information on devoping applications for blackberry devices. Please help Thanks

Thanks :)

Hi I am working on a system where I need to read the existing contents of various spreadsheets into tables in a sql database. Eg: a spreadsheet named "Branches" needs the contents of its columns stored into a table named "branches" in the sql database. Can anyone give me a hand with this? Thanks :)

Thank You

Hi. I am trying to figure out how to write a select statement that will retrieve all entries that have a certian letter combination in. EG: If the user enters "a" it will retrieve all words starting with an "a". if he enters "ad" it will return all words stsrting with "ad" etc. Please advise

Hi. I am trying to figure out how to write a select statement that will retrieve all entries that have a certian letter combination in. EG: If the user enters "a" it will retrieve all words starting with an "a". if he enters "ad" it will return all words stsrting with "ad" etc. Please advise :)

Hi. thanks.... I had to use me.text but thanks for the help. ;)

Hi. How do I change the title bar heading in a form dynamically in code?

:) I'll try that thanks.