Search results for query: *

No sure. The query now works fine, even with the 'month' alias... I couldn't really figure out what the error was. Thanks anyway! (I don't know how to change thread name to 'solved'...)

Ah, sorry for that! I displayed the actual error message and it states: Incorrect syntax near ')', though I tested the query in the SQL management studio first. But some mistake must have been occured though I couldn't see the syntax error. I rebuild the select query and now it works...

Hi all, I'm trying to fill a dataadapter from my sql2005 server. After filling i'm planning on generating a chart (VS2008) from the datarows. But upon filling the data adapter I'm getting: "A first chance exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll" in...

Thanks very much, jmcilhinney! That was easy, but I couldn't find it. Must have been blind ;-) Thanks!

Hi all, Hope you can help me with this silly question: In my application I have bound a datagridview to a SQL2005 bindingsource. I really had to change a database field (more length allowed) and now de DGV displays red exclamation marks and states: 'Colomn 'password' exceeds the MaxLength...

Aaahhrrrgggg!!! How stupid of me.... Ofcourse the " " need to go... Sorry for bothering you with this dumb question :-)

Hi all, My application (vb.net 2008) connects to sql server 2005 express. When I hardcode the following it works with no problem: Dim objconnection As SqlConnection = New SqlConnection("server=.\SQLEXPRESS;database=tstDB;Trusted_Connection=True;") objconnection.Open() But ofcourse I don't...

This issue still exists. Anyone got any suggestions for me? Or need some more info? Thanks!

Yes, sorry for not including any code. I fully understand the 'my car won't start'-example and I know you're not mind readers. But I thought it had somerhing to do with MDI parent/child that I was not aware of. Something very general. So that's why I kept it very general. Sorry! I'm not...

No one? Is my question is not clear enough, please ask. At this moment I'm not sure how to say it differently.

Hi all, I have this weird issue: I developed an application with a sequence like this: login form -> mainform (=mdi parent) --> some functionform (mdi-child)--> report form The reportform contains a reportviewer and will display different dataset queries depending on the state of some radio...

Thank you again. I've read this and we discussed this on page 1 of this thread. So I changed the 'Copy always' property, but no changes. Then I build and published my appl but no data is being saved. I have two projects: a testproject in which I try and try and try....to avoid pollution in the...

Correct, 'Update' returns '1'

Well, I think I'm getting close now... I tried this: li_tblIndex = EPaysDataGridView.CurrentRow.Index EPaysDataSet.EPays(li_tblIndex).Ontv_bedrag = li_ontBed EPaysDataSet.EPays(li_tblIndex).Datum_bet = ld_Bet_dat If EPaysDataSet.HasChanges() Then...

BTW: I noticed a couple of links in your sig, which seem very usefull. I am at work now and tonight (which differs because I'm located in Europe) I'll try to read all this. I looks like it is what I'm looking for....

I created a boolean and put the update result in it. Sorry, my bad. So when I make it an integer it returns an '0'. I created a very simple form, dragged the table (datagridview) from the datasource explorer and also a textfield/datefield for every database item (also drag-n-drop). Further a...

Thanks again, jmcilhinney. As expected, the update return a false... So no changes are really made. Right now I'm trying to figure out the second part of your post. Searching the web and many books for the right syntax to: -bind dataTable to BindingSource -bind BindingSource to grid -access...

Thank you for your reply, But I don't really get it. What do you mean not to work with the grid in code? You mean these lines?: li_ontBed = Ontv_bedragTextBox.Text li_tblIndex = DataGridView1.CurrentRow.Index DataGridView1.Item(7, li_tblIndex).Value = li_ontBed DataGridView1.Item(6...

I tried some other things, but no success. One thing I tried is this: li_ontBed = Ontv_bedragTextBox.Text li_tblIndex = DataGridView1.CurrentRow.Index DataGridView1.Item(7, li_tblIndex).Value = li_ontBed DataGridView1.Item(6, li_tblIndex).Value = ld_Bet_dat...

I thougth about this and I guess I was thinking in the wrong direction. I figured I just put the values in the datagrid positions and then safe (update) the grid to the database (just like earlier by inserting a new row) Am I thinking right? So I wanna add twoo values to a existing row in the...