|
Hello Friend
I am connectin Mysql in vb.net2008 on vista then its give error(Unable to connect to any of the specified MySQL hosts.) but whene i conectthis on xp os then its excute .... {}
My Code-
MySqlConnection _MySqlConnection;
MySqlCommand _MySqlCommand;
MySqlDataAdapter _MySqlDataAdapter;
string _Conentionstring = "server=localhost;database=schoolinventory;user id=root;password=;";
public int GetId()
{
try
{
_MySqlConnection = new MySqlConnection(_Conentionstring);
_MySqlConnection.Open();
string _Adpstring = "select Count(*) from goods";
_MySqlDataAdapter = new MySqlDataAdapter(_Adpstring, _Conentionstring);
DataSet _ds=new DataSet();
_MySqlDataAdapter.Fill(_ds);
int i = Convert.ToInt32( _ds.Tables[0].Rows[0].ItemArray[0].ToString());
return 0;
}
catch (Exception ex)
{
return 0;
}
}
Piyush Vardhan Singh
p_vardhan14@rediffmail.com
Eventure Technology
http://holyschoolofvaranasi.blogspot.com
http://holytravelsofvaranasi.blogspot.com
|
|
|
|
|
I suggest you stop swallowing exceptions like that. Add Console.WriteLine(ex.ToString()); or something similar and see what it tells you.
|
|
|
|
|
5 - agreed 
|
|
|
|
|
Do you have a MySQL server running on your Vista machine, with the same configuration and databases? At least your connection string says server=localhost. If it is on the XP machine only, you have to replace the name here, and you will likely have to some configuration on the server to allow connections from other computers. The Exception thrown will give you more details.
|
|
|
|
|
It could also be a firewall problem if the Windows Firewall blocks incoming requests on port 3306 (default port for MySQL services).
|
|
|
|
|
I see 1 posibility that spring to my mind.
- MySql Connector is not installed on your Vista.
|
|
|
|
|
I am make a report to display info about students but i have a record with each student with declare registration date of each student ,
My Question ? I am Display all info for students in report but i want to display the first value of date of first record and the last date of registered student to know the range (ex. From : 1/1/2010 to 1/2/2011) in the same report to be displayed in the header of the report ?
I want to know the steps ?
|
|
|
|
|
Which part of this are you having problems with?
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
I wouldn't let CG touch my Abacus!
|
|
|
|
|
i WANT TO KNOW HOW I CAN DISPLAY ONLY THE FIRST VALUE OF DATE AND THE LAST VALUE OF DATE WHERE MY SQL COMMAND SELECT ALL ROWS.
report parts
- table to display all student info ( I do this)
- above the table I want to know how i can display date from : ...... to ......) ( I not know how i can do it ?
|
|
|
|
|
You do not state whether your database is Access, SQL Server, MySql, Oracle or whatever.
Still, on the chance that it might help, take a look at this[^] thread, where the OP has a similar problem.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
I wouldn't let CG touch my Abacus!
|
|
|
|
|
|
|
Don't expect to be spoon-fed.
You now have enough information to formulate a suitable search phrase for an internet search.
You know that your database is SQLServer, because it's your database
You know that you are dealing with date data, because it's your data
You know that one way to solve your problem is by use of the Min and Max SQL Functions, because I gave you that information in the link I provided earlier.
All you have to do now is to use your brain and rearrange the emboldened words into a phrase useable with an internet search engine.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
I wouldn't let CG touch my Abacus!
|
|
|
|
|
Did you look at minimum/maximum in the summary totals field?
You should be able to define two summary total fields there (Min and Max) and place them in the header or footer section of the report.
V.
|
|
|
|
|
if any one have information about following point please help me:
architecture of messenger
messenger communication server
messenger email DB server
messenger data flow diagram
create messnger as final project from begin to end project
source code of messenger chatting msn by c#
how the messenger work by programming language
|
|
|
|
|
It is very unlikely that anyone will have this ready to hand you a ready made solution. Try doing some research for yourself (Google is a great tool) and come back when you have a more specific problem to resolve.
I must get a clever new signature for 2011.
|
|
|
|
|
It's you again. From what I can gather, you are attempting to write this for your course work - therefore, the requirement is for you to do the work. You've posted on this several times, and you don't seem to have progressed any in the last two months. What have you been doing with your time?
|
|
|
|
|
He's been trying to find some schmuck to do the work for him. If he put half the effort into actually doing it himself he'd probably be pretty much done by now.
I wasn't, now I am, then I won't be anymore.
|
|
|
|
|
om_metab wrote: create messnger as final project from begin to end project
Yeah, that's not going to happen.
This is where you stand or fall, on your own, demonstrating that you've actually learned something throughout your classes.
|
|
|
|
|
Hi Everybody,
I have developed A Desktop Application in VS 2008. In This One Facility Is Provided To Scan The Document. Firstly It Was Working Fine , But Now A Days I Am Getting The Error a generic error occurred in gdi+ While Saving The File. I Have Set All The Permission To The File Where The Scanned Image Is Saved.
I AM Unable To Resolve The Problem. Please Help Me To Solve My Problem.
Thanks & Regards
Sanket Patil 
.
|
|
|
|
|
Without seeing the code where the error occurs, we're just guessing at this.
But, from your vague description, it sounds like you loaded a file using the FromFile method of a Bitmap object and now are trying to save that same file to it's original filename. This doesn't work because the file is locked open for the entire lifetime of the Bitmap object.
To get around this, you open the file using a FileStream object, then pass that stream to the contructor of your bitmap object, then close the file. This prevents the file from being locked and will allow you to dave the new image back to the original filename.
|
|
|
|
|
This[^] might be able to help you.
The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it.
My latest tip/trick
|
|
|
|
|
This link[^] refer some such type of problem with solution.
hope it will works for you.
|
|
|
|
|
Hello,
I'm working with windows media player inside a C# winform application.
I couldn't find a good and simple example for working with playlist.
I'll be glad to get some help or an example.
I want to create a playlist from a list of songs name and then give it to the player so it will play them in repet.
(I tried to do it alone with a list of songs and an index but it ddin't work like I thought. The player have to much statuses that he jump between).
Thanks
|
|
|
|
|
Did you find Create a Windows Media Player List[^] here on The Code Project during your searches.
It might help to get you started at least.
There are also other articles covering the subject just search the articles for wmp playlist.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
I wouldn't let CG touch my Abacus!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
