The answer given by Dave Kreskowiak is absolutely correct. An alternative is to use Expression property of precip DataColumn object to calculate the value based on the value of the tippingB DataColumn as explained here DataColumn.Expression Property[^] After binding the DataTable to the DataGridView the calculated value in the precip column will be displayed in the DataGridView.

"AcceptChanges[^]" only updates the object in memory, not the database itself. I'd suggest you fire an UPDATE statement whenever you want to change something, or an INSERT if you want to add a tuple. Bastard Programmer from Hell :suss:

use this will work Dim cmd1 As String = "Select * from " & inpTable & " Where convert(datetime,mdateTime,101) = convert(datetime,'09/29/2011',101)"

Looks like what I need. Thanks!!! :-D Hypermommy

Google for and read up on the SerialPort class. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008 But no longer in 2009...

Do you have any primary keys defined for the underlying table? If you don't OleDbCommandBuilder will not work.

Is their anyway to Send Email in Exchange 2007 without using SMTP because client doesnot want to enable it Best Regards, SOFTDEV If you have knowledge, let others light their candles at it

I would suggest to use SMTP Client instead of outlook component to send an email using an application SmptClient is an inbuilt .net class , following is an example of using smptClient to send a email. Dim smtpClient As New Net.Mail.SmtpClient() Dim mail As New Net.Mail.MailMessage() 'create the message to be sent mail.To.Add("test@test.com") ' Enter the Email of the person you want to send the mail to mail.From = New Net.Mail.MailAddress("username@gmail.com", "Your Display Name") ' Enter Your email address mail.Subject = "Test Message" mail.Body = "This is a test message" ' Prepare the client to send the above message 'Attach the file as attachment mail.Attachments.Add(new System.Net.Mail.Attachment("yourFileName.xls")) smtpClient.Host = "smtp.gmail.com" smtpClient.EnableSsl = True smtpClient.Port = 587 smtpClient.Credentials = New Net.NetworkCredential("username@gmail.com", "password") 'Enter username and password of the account , you want to use to send mail smtpClient.DeliveryMethod = Net.Mail.SmtpDeliveryMethod.Network smtpClient.Send(mail) There was a similar question posted http://www.codeproject.com/script/Forums/View.aspx?fid=1646&msg=2899587[^] Hope the information is helpful -Regards Bharat Jain bharat.jain.nagpur@gmail.com

Yep, Jan 2 by TheComputerMan. Amazing, noone ever actually reads the forums... A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008

Nope. I've never used the library. That's a question for the people who made it. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008

Thanks Steve. I tried the option you suggested; however, it didn't work. Thanks, Amanjot

You have multiple problems with this. The first is that your SQL statement is wrong. The WHERE clause is comparing your first date with the second, and alway socmming up with True, so that's why you're getting every record in the table instead of a range of them. You should be comparing the field in the table you want to those two dates, not the two dates to each other. Second, dates in Access must be wrapped in # characters. You don't have any of those in your SQL string, so the dates are not even valid, no matter what they look like. Lastly, you're using string concantenation to build the SQL query. This has numerous problems with it as dates in strings can be in many different formats and that might not match the date format Access is using. Use parameterized queries instead. Read this[^] for an explanation of why concantenating strings together to build your SQL statements is a bad thing, and how to use parameterized queries to eliminate some of the problems you're having passing dates into the SQL. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

What's the structure of the seasonSummary table? What's the error message you get?

yah! I know how many inputs are there in the file. Infact, its a formatted file i.e place for each variable is defined. for example, sequence of vaiable will be a,b,c,d in first line and e,f,g in second and h, i, j in third and so on. Thanks. amanjot

Since you only imported the System.Io namespace on the first form, you can only use it's classes on the first form. If you want to use the StreamReader class on you 2nd and 3rd forms, each of them will also have to import the System.Io namespace. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome