Recent content by patrickstrijdonck

Hello, For a new app I am trying to get our twitter feed in it, So far I have got a JSON Parser for search, but this just searches twitter for any tweet of any user with the name you supply. I just want to show the tweets I did place on my account in a UITableView. Can someone help me point in...

Hi Jason, Thanks for your reply, I was looking on google for a very long time, After my post on here I found something of usefull, see code below; string connectionstr = Properties.Settings.Default.VerzendDB1ConnectionString; OleDbConnection conn = new...

Hi All, For a urgent work project I need to create an XML file from a c# program. In my access database there is a table called tblparcels. it contains all parcel information. not only the table information needs to be added, 2 fixed fields need to be added. the XML should look like this...

Got it, Properties.Settings.Default.ConnectionString1 Was not correct, It had \10.0.0.1 instead of \\10.0.0.1 Thanks anyway

Hello, Im trying to setup a one way sync between 2 different MS ACCESS files. The first SQL query runs fine, If I add a record, it gets deleted. The problem occurs at the second SQL query. the error is: Invalid Argument. selectSQLL = "INSERT INTO table1 SELECT * FROM [MS Access;DATABASE=" +...

I Managed to get everything in the Treeview as I want, But I cannot see if there is something open for a specific store. I have fixed this temporary by only showing the stores which has something OPEN in the treeview and put a extra node with all the stores in it. I cannot figure out that last...

Found it out, Change that part of code to OutstandingTreeviewCalls.Filter = "Store=" + Convert.ToString(comemailasm3.ExecuteScalar()); What I forgot was to say in the command on which field it should filter, which was field "Store". Thanks for the help.

Both is not working for me,.... Still getting the error at this point; (Filter expression '7622' does not evaluate to a Boolean term) outstandingCallsBindingSource1.Filter = Convert.ToString(comemailasm3.ExecuteScalar());

Hey Jason, I am actually including a value, comemailasm3.Parameters.AddWithValue("@name", SqlDbType.VarChar); comemailasm3.Parameters["@name"].Value = e.Node.Text; e.Node.Text is the text which is for the selected node. and the code you provided gave an error in...

Hello, In my Treeview, the bindingsource for my Datagrid must be updated with a filter. Currently I have this piece of code that must do that // Get Storenumber from Storename string command3; string cmdemailasm3 =...

Hey Guys, I have tried looking it up on Google but I cannot find what i'm really looking for, Im hoping someone might point me in the right direction; I have a MS access database with the following tables; tblStores tblTickets tblOrders What I want is a treeview where I can see if there are...

thanks, the field is not called Count offcourse, I just used that to make it more clear, it's all dutch nonsense :-P I had already tried to remove the "" but then access gives "The expression you entered contains an invalid syntax" but I think you are right on the text comparison, as in Text...

Hello, I have got a strange thing in MS Access, When i use the following rule; IIf([Count]>="2","True","False") If Count is 1 it will show "False" = Correct! If Count is 2 trough 9 it will show "True" = Correct! If Count is 10 trough 19 it will show "False" = NOT CORRECT! If Count is 20...

Its a query that already exists in the msaccess database. and yes its already filtering the results. it just needs to give the count of that query. im not using SQL Server form Microsoft but MS Access. when trying to run that in MS Access and let Access advise the performance of this query, it...

Ok, Ive combined 2 SQL commands into 1, the other command is getting the data from another datasource. string command1; string cmdCount3 = Properties.Settings.Default.IT4ConnectionString1; command1 = @"SELECT Count(*) FROM OutstandingCalls...