I am trying to write a C code with embedded MySQL with server and client options. I am trying to important a csv data file for MySQL server and client.
I saw on internet like: LOAD DATA LOCAL INFILE 'data.csv' INTO TABLE test FIELDS TERMINATED BY',' LINES TERMINTED BY' ';
But I think that line is for SQL workspace. How to write in C format?
I want to make a launcher for my program but the installation folder is different from one computer to another so I need a function or something that shows the path of the executable file.how to import a file from another folder.
#include<stdio.h> int main(void) { FILE *fp; *fp=fopen("C:Documents and Settings...something.txt","r"); }
private void open(object sender, EventArgs e) { // only works for opening the table dataGridView1.Rows.Clear();
[Code]....
So here in my open method I get a dialog on the file to open and it will display all the saved data into a DataGridView. Every cell is separated by a comma. It will work fine and there are no errors.
However, I'm looking to upgrade this into importing data into another DataGridView instead.
Now all this opening is based off of the writing code not manually written. The writing part is complete with dataGridView1 and dataGridView2 written. However, how do I determine if the data is going to be written in the first or second DGV?
I have a code able to import a file containing words and numbers to a linked list, but I also need to sort this linked list alphabetically. I've done research on this involving bubble sorting, but no explanationcan achieve this objective.
Below is the code that can only put the file into linked list:
Code: #include<iostream> #include<conio.h> #include"U:C++WordClass2WordClass2WordClass.cpp" #include<fstream> #include<vector> #include<string> using namespace std;
The problem is that I do not want to have an external MapData.txt, rather I access it through a embedded text resource, which in this case I have no knowledge on doing so.
I have the following snippet which demonstrates to my knowledge on how to access a text resource; however, I do not know hot to modify the code above to implant this, but to still have the same functionality as the original code above.
I have a requirement where I have to import a lot of text files into excel. Up till now I can import the text files using visual studio C# but after importing the format is not exactly the way I want (mostly the delimiters). So I have to manually use the text import wizard and make the changes. I was just wondering if there is any way to program all of it. Delimiting the spaces, specifying the column widths, eliminating a few rows and columns.
I have 10 or so .sql scripts (the number is likely to rise) which are required to be kept with a C# application.
For the most part the embedded resources seem to work fine , however I require a way in which to guarantee the ordering in which the files are run.
What I do currently:
Retrieve the details of the embedded resources using : Assembly.GetManifestResourceNames()
(and a bit of linq to filter based upon my requirements) which I pass to a list, I then later on use the list to grab the physical resource when its needed.
The files are named such as:
1_ScriptDescription.sql 2_ScriptDescription.sql 3_ScriptDescription.sql 10_ScriptDescription.sql <--- Here's my problem! This will come after 1_ScriptDescription.sql
Ideally I need a way in which to order the list or some kind of ordering when I pull from
Assembly.GetManifestResourceNames()
But I'm not really sure of a practical way to do this, I did consider manipulating the string .....
What I want to do is abstract and model a device (more specifically in this case, an IMU) in an embedded system.
Now, there are a couple of gotchas:
- It is basically a framework, which means that it should work with any device, any platform and any bus.
- It is an embedded system, so power consumption and memory consumption must be reduced. It is not a PC.
- It cannot be too complex, because I fear that will just make people scrap it and rewrite it from scratch :P
- It should aim for as little code as possible to write the whole model, of course. Adding 100 lines of code for each register would be a bummer.
That said, I must also model the current system, which means that the current platform, the current bus (which is I2C) and the specific IMU model (I have a datasheet). So the model I am thinking of currently is this:
First, I have a platform. It will know what bus a device is connected on and contains the buses (or specifically, the instances of the buses). It consists of a specific class for each platform and a base. Here are the two I have now:
Code: namespace Sensors { template<typename Platform_t> class GPS; } namespace Platforms { class RaspberryPi: public PlatformBase
[Code]....
Currently I am making the assumption that all platforms will have an I2c bus and UART bus, but I'm not sure about that. We have only one platform ATM, though, so for now this holds. I'm guessing I might have to move it to the specific platforms later and get rid of PlatformBase.GetI2CBus is a problematic one related to registers, but I'll get back to that.
UART is simple to model since it's just a block read and write, so:
I'm probably going to handle all errors through exceptions. So if I can't open the UART bus, I'll throw an exception.
The I2C bus is a problem. I have a model which deals with it on a register-based level, but ideally I'd like to be able to model and use the devices on the I2C bus on a flag-based level (ie, I have names for each individual flag in the registers which I can read or write to directly instead of writing a hexadecimal value directly to each register).
Here is code:
Code: namespace Buses { template<unsigned int Id> class I2CDevice { public: I2CDevice(I2C& Bus): m_Bus(Bus) {} template<typename T>
[Code]....
So I2CDevice does some checks to see that the data to write to a register is either 8 or 16 bits. It does not check that the size to write matches the register's size, but another class does not.
The idea is also that it checks which device is currently active on the bus, and if it's not the current I2CDevice, then it simply selects that before attempting to read or write (the Open call).
This is not meant for multi-threaded environments. Yet, anyway.
The Impl2::Read/Write just dispatches the call so it calls the correct function for writing and reading the correct size, depending on the size of the data.
This is all well and good, but I2C works with registers, so of course I want a class to model a register which I can read and write to directly. It must tie into the bus class since the bus class is the one that abstracts reads and writes on the bus.
The register class looks like:
Code: template<unsigned int Bits, unsigned int RegisterId, typename Bus_t> class Register { public: typedef typename Impl::RegisterBase<Bits>::Storage_t Storage_t; static_assert(!std::is_same<Bus_t, Buses::UART>::value, "Cannot read and write registers on the UART bus."); static_assert(Bits == 8 || Bits == 16 || Bits == 32 || Bits == 64, "Number of bits must be 8, 16, 32 or 64."); auto Write(Storage_t Data) -> void
[Code]....
I think this explains itself, except for the Regs struct, which is an experiment by me to enable myself to access registers via Regs.Config, etc.
What is missing is the ability to access and read/write the individual bits inside the registers. I am thinking a two-way access, where you can write to individual bits, but must call .Write() to commit the write to the register for efficiency.
I haven't actually written this. I don't know a good way ATM. I don't want to add a lot of variables and a write function because that would use 1 byte for every bit which is unacceptable.
I don't want to add a lot of code to make it work, either. A good get/set class would be nice, but I can't see that working. The register must store all state and any subsequent classes must not store any state or overhead will increase.
Finally, yes, I know a lot is incomplete and untested. It probably won't even compile. But that is for later. First is finishing the model.
It would be nice if things such as the platform and buses could be made static because there will only be one instance at any time, and that would save overhead if I don't have to store objects or references to them, but I haven't figured out how to achieve this.
I'ma firmware writing, and usually use only C language (not my decision, unfortunately!).In many application we've only a text display (2 rows 16 columns ascii char, or 4x20 or something else). But the question can be used also for semi graphics panel and so on.
I'm looking for an example / library / sourcecode to handling all the pages in the project. When the program start you've a 1st page (wth info abt release, hallo screen and so on), then with a arrows buttons you can navigate throught many pages. Some of these can be called by SW (or HW) events. (Button, alarm, end of job ...) In abt 20 year of experience3 I?ve seen many type of different code.
Data handling for a UAV project I am trying. My background is in Microcontrollers but I have never had exposure to "sound" programming practice...
I have got 2 microcontrollers to drive a UAV craft I've made. One "firmware" micro collects all the sensor data and then passes it to the other "application" micro for control processing. Once decisions have been made this is sent back to the "firmware" micro so that actions are taken.
So in essence I am sharing a raw data chunk periodically between the 2 processors that has outputs and feedback data. For the moment this is captured as one big buffer array on either micro after receiving. For easier structure I thought of bouncing this buffer that contains all sensor information and control variables between the 2 processors (visualize a ping pong game with all the possible variables from both micros - bandwidth between the micros is not a limitation) There are quite a few modules that want to access information from this buffer and write control actions back to it.
I was thinking of constructing a struct on both micros to access this "raw data" from the buffer and set it up with variable names so that it is easier for functions to read info and write controls back.
But this would mean that the data is accessible to every function, and there is the fear that some functions will write to the input data or write to control variables that they should not have access to. I also need to reduce memory copies and the like due to limited memory on each micro.
i am doing an embedded project on avr microcontroller ATmega8515.actually my project is smart card based electricity billing using UART interfacing..so in this module HEX to ASCII conversion is not possible for me...
The following code is an example of how task are created with micro cos III in c. I am trying to figure how to create similliar code in C++. My problem is how do I instantiate objects and how to use member functions to represent task. Within the create task routine the address of function is passed as argument. How do I do this in C++? Will I need more than one class? New to embedded C++.
This project is for an embedded micro controller. In the project i wrote a class that generically services uarts. then i declare 6 objects of that class and hand them configurations for each specific uart.
internally all the objects have a send buffer of data that is still to be sent that gets populated by the object member function.
how can i make an array of function pointers that can point to the same member but of six different objects.
for example (not a working one)
class uart { private: struct myData { unsigned char data[20] int head int tail int count;
I have an SDI app created with VC2012. Main view is a CFormView and it's the parent to four embedded dialogs. All four dialogs have title bars. On three of them, the title bars looks as I'd expect. Normal size, text left justified. On the fourth, the title bar is noticeably thicker and the text is centered. All styles are the same as far as I can tell. The main difference is the one that's acting up has a browser control on it, the others just standard controls. It looks normal on Windows 7.
Is there any standard USB protocol which i can follow to send data to my embedded board(and vice versa). I have no clue on USB programming using c,is there any example code i could follow,
I have so far tried MySQL++, ODBC, SimpleDB, and the MySQL C++ Connector. All of them give me a FLOOD of errors in the output. Is there an easy way to connect?
I created a .h file for mysql connections. In my example file, I created an array of my class and made connection with the database for each subscript of the class object one by one. Then I checked if the connection in the previous subscripts are active or not, I found all the previous connection are disconnected.
I want to establish multiple connection with database at a time.
The resultset is always null and the connection is alive. The VS2013 debugger says that mysqlcppconn.dll has no debugging symbols. Tested the query on a mysql console and it worked fine, it returned 1.
1>c:program files (x86)mysqlmysql connector c++ 1.1.3includecppconnsqlstring.h(38): warning C4251: 'sql::SQLString::realStr' : class 'std::basic_string<char,std::char_traits<char>,std::allocator<char>>' needs to have dll-interface to be used by clients of class 'sql::SQLString'
I was created the mysql database in my Pc. This database connecting with vc++ code Using MySQL C++ Connection Example in Visual Studio. I done this work in single PC. It's working good. i viewed the table values using vc++ application.
But now want to connecting the database through lan connection. I refered the below link but i'm not clear.Step # 5 Grant access to remote IP address
For your reference, (I installed)
PC1 - visual studio 2003, mysql 5.6 for win32 & mysql connector (Ver : mysql-connector-c++-1.0.5-win32), OS : XP SP2, IP : 192.168.100.123
PC2 - mysql 5.6, OS: XP SP3, IP: 192,168,100.9
Table created in PC2, database name "test". server = 'localhost', user = 'root', passwd = "".
I like to connect PC1 & PC2 through Lan & access the table using vc++ code.
How can i view PC2's database table values in PC1?
So even though I have so many issues with linking libraries, I apparently became the go-to person for a fellow college friend of mine for a sql library. He's using the mysql connector/c++ and his team has had quite a few issues getting it set up. I've solved two out of three issues:
1st issue I solved was that they didn't know how to build boost, I just linked it and they were good to go.
2nd issue I solved was that they were missing libmysql.lib, I just installed the mysql server onto their computer and linked that up. 3rd issue is where I am now stumped at, as they get a compile error: LNK2001 unresolved external symbol: _get_driver_instance().
I don't understand when I'm only requesting a specific column on a unique row in MySQL that I'm being returned with data from all columns of that row.
My Select Statement - "select article from post where idpost=" + strIDpost + ";"
I should get: |--- article -----| "some article text"
Instead I get: |-idpost-|-title-|---- article------| 1 title some article text
If I run the command directly to the database I get the results I'm looking for, but somehow while running the application, the program is managing to pull the entire row.
I'm using C# on a webform in Visual Studio '13. Here's my Code:
What I would like to happen, when I run my code is that I'll get the following
Item_ID, Name, parent_Name 1 , jeff , jackson
DataSet DS = new DataSet(); if (this.OpenConnection() == true) { mySqlDataAdapter = new MySqlDataAdapter("select Item_ID, NAME, Parent_ID from table1, table2", connection); mySqlDataAdapter.Fill(DS); dataGridView1.DataSource = DS.Tables[0]; //close connection this.CloseConnection(); }
So this spit out parent ID = 5.
I've not worked with Dataset before and I was just wondering what is the best approach? Can this be done via a SQL command or will I have to replace the value(5) with the string(jackson) using a large IF loop to search and replace.