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 Convert the column you want to plcae the dropdown in to template column and place the dropdown in the item template and edit item template and give the dropdown the selected value u want to the dropdown note that this way works for VS 2005. if any problems mail me back Mohammad Al Hoss

Google 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[^]

Thanks :)

Thank You

Select * from Table Where Field like 'a%' Select * from Table Where Field like 'ad%' Is that what you are asking for? If it is, you might want to google next time before you ask, it's pretty basic.

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

Just set the click event for both buttons then do a select case on the sender object of the event like below: private sub form_Click(ByVal send as System.Object, ByVal e as System.EventArgs)Handles form1Btn.Click, form2Btn.Click Select Case sender.name Case "form1" 'do something here Case "form2" 'do something else End Select End Sub That should do it. I did this for an airplane seating chart. Worked great. Each seat was really a button and once it was taken I put a big red X on it to show that is was not avaliable. Tom Tom Wright tawright915@gmail.com

Are you sure that the database is in the project folder ? Maybe you have him linked remote to your project and when you want to publish it needs to be in the project folder?

If the grid is bound to a datasource, you don't add the new row to the datagridview. You add it to the datasource, probably a DataTable. How you do that depends entirely on your datasource. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

Drag and drop isn't exactly the easiest thing to understand. Newbie's to it get really confused about which side is supposed to be handling what, what Effects are, how to get the data out of the event args, what Data Formats are, how data is even represented in the operation. In your case, your doing it all inside your own app. Learn the basics of drag and drop first before you start applying it to your DGV's and posting up DataGridRows into the operation. Start with creating a ListView that is a drop target and can take files dragged to it. Drop a ListView on a form and enable it's AllowDrop property. Private Sub ListView1\_DragDrop(ByVal sender As Object, ByVal e As System.Windows.Forms.DragEventArgs) Handles ListView1.DragDrop If e.AllowedEffect And DragDropEffects.Copy = DragDropEffects.Copy Or \_ e.AllowedEffect And DragDropEffects.Move = DragDropEffects.Move Then Dim items As String() = DirectCast(e.Data.GetData(DataFormats.FileDrop, True), String()) For Each item As String In items Dim lvItem As New ListViewItem(item) ListView1.Items.Add(item) Next End If End Sub This is just the Drop side of a Drag and Drop. Once you completely understand every line of this code, you can start experimenting with starting your own Drag. Why all this step-by-step crap?? Because it's what confuses everyone who starts out. They can't keep the two sides of a Drag and Drop straight in their head, and therefore can't keep it straight in their code either. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

Thanks for the help again.....:) Mr Oizo

Thanks for the reply Mr Kreskowiak. I changed it to just 2 datagridviews and after each hour scheduled I save to the database and dispose of any data in the dataset and rebind the dataset tables to the datagridviews again for the next hour, I repeat until each hour is scheduled and now everything works perfectly. :-D Have a good day Mr Oizo

If possible, you'd probably have to enclose any such table and field names in square brackets: SELECT * FROM dayScheduleTemplate,dayTemplateScheduleName, scheduleDate WHERE dayScheduleTemplate.dayTemplateScheduleName = dayTemplateScheduleName**.[24TemplateScheduleName]** and dayTemplateScheduleName**.[24TemplateScheduleName]** = scheduleDate.[24TemplateScheduleName] and scheduleDate.scheduleDate A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007

Dave Kreskowiak wrote: Come on, think!! Pbbbbbbbbt. Why would they do that, that's why they're asking questions in the CP forums... Sigh.. The early bird who catches the worm works for someone who comes in late and owns the worm farm. -- Travis McGee

Assuming this works at all, it looks to me like it reads id3 tags, which don't include length. Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Thanks dude. I'll look around. If you know of any links i can click then please post them here. thanks again:) Mr Oizo

Mr Oizo wrote: Hi... I'm not too sure if I understand but I think you mean that my datbase location is not hard coded. No, it's because it's relative, so you rely on the working directory. The working directory is changed when you select a file. As I said, get the application directory, and use that as a starting point to reach the database file. --- single minded; short sighted; long gone;

Sorry about the earlier message, here you go