|
Thanks for you answer.
But until before call the c++ dll function, the gridview shows data of mysql db.
But if i click button, it calls c++ dll function and mysql connection error(Unable to connect to any of the specified mysql hosts) occurs. So datagrid not show data of database.
|
|
|
|
|
As I said, there is nothing at all we can do about that -0 we have no idea what code you are using, what your DLL method does - and we certainly can't run it under the same conditions as you because we have no access to your data (or any idea how to run your app).
Seriously, break out the debugger and start looking at exactly what is going on.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Doesn't mean that it is the cause; the error message hints that something else may be happening. Show us the code that you use that fails.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
I think you miss-posted. 
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
You're right 
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
Doesn't mean that it is the cause; the error message hints that something else may be happening. Show us the code that you use that fails.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
IN c#
static class MyDll
{
[DllImport("mine.dll", CallingConvention = CallingConvention.Cdecl)]
public static extern void Test();
}
...
IN mine.dll:
...
extern "C"
__declspec(dllexport)
void Test() {
int a = 5;
}
...
But after i called MyDll.Test(), mysql.data.dll connect exception failed and datagrid not show anything.
|
|
|
|
|
The C# code using the MySQL provider, and your connection string. The code you show is not doing anything database, and will not be the source of the error.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
Unless the C function is doing more than was shown here, and is somehow corrupting the .NET process memory.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
..in exactly the MySQL data provider?
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
in form constructor
dbConn = new DBConnector();
public DBConnector()
{
server = CommonUtil.server;
port = CommonUtil.port;
database = CommonUtil.database;
uid = CommonUtil.uname;
password = CommonUtil.password;
Initialize();
}
private void Initialize()
{
string connectionString;
connectionString = "SERVER=" + server + ";" + "Port=" + port + ";" + "DATABASE=" +
database + ";" + "UID=" + uid + ";" + "PASSWORD=" + password + ";";
connection = new MySqlConnection(connectionString);
}
and i call the Test method in form button event function.
|
|
|
|
|
You should not reuse a connection for a form; create and open it when you need one. It is not clear from this code where you open and close the connection, nor where you use it.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
Hi,
if calling unmanaged code is the suspect, you should make sure the bridge works correctly by having it pass data in both directions. As an example, use:
IN mine.dll:
...
extern "C"
__declspec(dllexport)
int Square(int a) {
return a*a;
}
Then call it from your C# code and check the return value.
One way to make things fail is by having parts of your process compiled for different architectures, e.g. a 32-bit C DLL and a 64-bit C# main program.
|
|
|
|
|
Thanks for your reply.
I tried to build mine.dll with x86 and x64 and run c# app.
But the result is same.
I think mysql.data.dll is problem.
what about your thought?
|
|
|
|
|
Hi,
if you want effective help, please start providing accurate information, and answers to all questions asked. Answers should be literal, not approximate! I will number my questions to make it easy for you to answer them. I am not promising a solution here, I am inviting you to provide enough information for someone to come up with substantiated suggestions rather than wild guesses as to what is going on.
1. If not present yet, put try/catch around the failing code, and make it show the following information:
1a. the entire exception, using its ToString() method;
1b. the error code (MySqlException has a number of properties!);
1c. the inner exception, again with ToString().
Put all of these in your next message!
2. Show your exact connection string or strings (replace password by asterisks). MySQL is known to be picky!
3. Where did you get your mysql DLL's (exact URL) ? what is their version number?
4. Sketch the history of database connects and disconnects up to the moment the failure occurs.
5. Have you modified any of the MySQL configuration parameters, things such as MaxUserPort and many others?
6. Have you specified timeout values that might be critically low?
7. Did you try calling Square(2)? What was its result when compiled with x86 and with x64.
8. What is your operating system? is it Windows10? is it 64-bit?
9. what is your development system? is it Visual Studio? which version?
10. What is the purpose of your app?
11. What is the purpose of your C++ function, the one that seems to sabotage further database accesses?
12. Is there anywhere in your code a try/catch block where the catch block is empty? i.e. are you swallowing exceptions, hence ignoring problematic situations, which is bound to make it extremely hard to understand what goes wrong??
13. are there any TCP actions involved, other than the MySQL accesses?
14. is there anything strange or peculiar happening before the MySqlException occurs, something you considered irrelevant and forgot to mention so far...?
That is it for now...
|
|
|
|
|
Member 14490964 wrote: I think mysql.data.dll is problem.
Not very likely. Post some code to reproduce the issue, and we'll look at it.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
I am trying to build a main system ( web application ) that contain different systems
that provide service for sales , packing and HR dept etc , so i have many users (about one thousand users ) with different page access permissions ( dynamic responsibility that may change at any time )
what is the best design for the responsibility system that can give them the permission to access for some page that developed for them
thx in advance
|
|
|
|
|
Start by looking at how you ar identifying users to your system - most login systems include a "role" facility which allows you to separate things users can do / see from things they can't.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
to explain my case i will provide an example :
i have 3 systems with one login and dashboard page
each one of this systems have a multi pages
so i want to give user A access to system s1 and s2
and from s1 he can view page p1 and p2 just
and so on,
the IT supervisore is who responsable to give this users this roles dynamicly
|
|
|
|
|
I'd just use Identity, it has a role based system and you can apply attributes to actions that restrict access to certain roles (if it's MVC).
|
|
|
|
|
to explain my case i will provide an example :
i have 3 systems with one login and dashboard page
each one of this systems have a multi pages
so i want to give user A access to system s1 and s2
and from s1 he can view page p1 and p2 just
and so on,
the IT supervisore is who responsable to give this users this roles dynamicly
and yes it is MVC5 web application
|
|
|
|
|
|
I have a design issue in my code which I want to clear off.
I have an SMS data contains lakhs of records group by an Unique Code in my C# appplication. So under each Unique code, there will tens/thousands/lakhs of records to sent. So currently, applications picks up one Unique code, select all the unsend records and send. Then move forward and picks the next one like this going one. This is creating more delay in sending and clearing off the sms in a single day where we have lakhs of sms to send. So I think of converting the same to Multi-threaded application, so multiple threads starts at same time, picks up each unique id set and select records to sent, there by running two / three process running at same time, and it will be faster, i believe.
Please advise if this is the correct method to implement or is there any other better ways.
|
|
|
|
|
Threading is not a magic bullet: it won't automatically speed things up, indeed it can slow things down!
Threads require a free core to run, if one is not available then the thread is suspended until the next one that is free (this is an oversimplification, windows preempts tasks to give other threads a chance). And thread handling adds an processing overhead in terms of both speed and memory - so if the number of threads you create exceeds the number of cores, you get into the realms of diminishing returns.
So just "creating threads" to do the job "at the same time" won't necessarily help you - you need to look at how you are sending the SMS: if there is hardware involved such as a mobile phone you are interfacing to, threading will not speed things up as the mobile can only process one SMS at a time.
Start by looking at your whole system, and identify where the bottleneck is: you should concentrate of improving that, rather than looking for "magic bullet" solutions.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Look at the whole process, perhaps plot it out on paper as a chart.
You can add code to measure the time of each process, start time and stop time, then stop - start = time.
Maybe it's your DB write, when you update the record as sent. Writes can take forever.
Consider grabbing 100 numbers at a time, send, update an in memory array, and then grab another 100, and while it's sending, update the database as many in the background.Sort of a flip flop method.
If it ain't broke don't fix it
Discover my world at jkirkerx.com
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
