Search results for query: *

Hi Guys, Hope someone can help me out here. I have this query here that works OK if i hardcode the value from the textbox into the query, otherwise i get this error? Here is the code. Any ideas? This works perfect String delete_jobs = db.Query<String>("UPDATE CONFIGD SET CONFIGD.KEYVALUE = "...

Hi Hoping someone can give me a wee hand. I have a XML file, that i am adding some new elements then saving as another XML but debugging shows the application cant find the file. The file is there in the correct path, Any ideas? try { XDocument xmlDocument...

Hi Any ideas why i am getting this error on my update query? Here is my code String updateStockDet = db.Query<String>("UPDATE STOCKDET SET STOCKDET.PICKED = " + DateTime.Now.ToOADate() + " From STOCKDET Inner Join STOCKHDR On STOCKHDR.STOCKID = STOCKDET.STOCKHDRID Inner Join...

Hi I have a service application but i have the timer1.start(); on the ONStart method although it's not running my timer. If i put a streamwriter file logging into the OnStart to check the OnStart method is okay then it's logging file data to the log ok. Any ideas? Timer is enabled Inside...

Hi I am currently using socket programming to send commands to a device and it sends reply commands. How can i get the console to read the reply thats returned? So far i have m_socClient = new Socket(AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp)...

Hi i am trying to move contents of the app.config file to textbox. I have tried the following code but its not working on my form load event The name of the config is indeed DATALOGIC_IP string DatalogicIP = ConfigurationManager.AppSettings["DATALOGIC_IP"]; string DatalogicPort =...

Hi i am having issues trying to look at a TIMESTAMP data type to only see if records within last hour, Example of code below: Any ideas? :) DateTime hourDate = DateTime.Now.AddHours(-1); FbDataAdapter sqlFB = new FbDataAdapter(" Select...

Hi, Anyone know if WPF applications .NET framework runs successfully on Mint? I know Mono helps run .NET framework applications but i was wondering if anyone has tried it and it has worked? Cheers Tom

Hi i need some help please. I have a textbox that the user scans into with a scanner and if the barcode exists i want another form to appear to allow them to continue, and if the barcode doesn't exist in the DB another form which will tell them. I keep getting this flag though. Can anyone help...

Hi I am looking for some help if possible, I have a query that writes off stock in our system which is older than 30 days. I would like the query results though to show in the body of the email it sends also so users know what stock has been written off. It doesn't need to be fancy, just a list...

Hi I have two forms, the main form loads and there is a button on it. The user presses a button and it loads up a second form containing a datagridview. The user selects the row in the datagridview and I would like it to close automatically and populate a textbox in the main form with data they...

Hi, I have CSV files that come from our ERP system although there is a bug with the system ( waiting for it to be fixed) where occasionally it sends down a file that contains CSV files with a duplicate row which is then causing chaos with our other system that it imports into. I should have a...

Hi I have a datetime stored as double table format in a firebird database. I need to update the DB for records older than 5 days old. Can anyone help me with how to convert the table to datetime, and then convert back? Or any best practice? Please see example of my code below. Thanks String...

String deletecommod = db.Query<String>("UPDATE REQUIREMENTSH SET REQUIREMENTSH.DELETED = " + DateTime.Now.ToOADate() + "WHERE REQUIREMENTSH.CREATIONDATE >= DATEADD(day,-5, GETDATE()") .FirstOrDefault(); Hi i have a firebird database which it's datetime format is stored as a DOUBLE. I cannot...

Hi I have the following code; although its not passing the value. Can anyone give me some guidance please? AdjustCodeTxtBox is returning with no data. ISForm myForm = new ISForm(); ProductDGV.CurrentRow.Cells[0].Value =...

Hi there, Does anyone have any code examples of removing quotations from CSV files in a directory? I can only find on Google; how to remove them from specific CSV files and not all CSV files within that folder. Example of CSV with quotations: "B0517","B900300005","2019-01-31","B1-5-B",175.000 I...

Hi everyone, I have just found this forum! looking forward to checking this place out. I have a datagridview (unbound) that exports successfully into XML with elements. I want to however; run the XML for every line in the datagridview that contains data and treat it as a individual XML import...