Comments by savedlema (Top 25 by date)

Hi all!
Now I got the code to work perfectly in a windows command prompt, it does all the job. But the problem comes when I bring it to VB.NET, It says the system can not find the file specified.
This is my code in VB:

Process.Start ( "C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqldump.exe" --user=root --password=mypassword --host=localhost --port=3306 --database sakila > "C:\backup\sakilalbackup.sql""")

I will appreciate any help.

Thanks OriginalGriff!

But, with VB 2010, I see that "Properties" is not accepted/supported. I see its My.Settings.ConnectingString...
But thank you, I could learn some syntax.

Thanks ryanb
. I did what you said and I was able to see this error msg:

"mysqldump:Got error:2005: Unknown MYSQL Server host '127.0.0.1'--databases MySQL databasename -r ""C:\GreatestHR Backup\BackUpDataBase.sql"""

But, the mysql server is really there and working, I can fetch and send data to it with my application. This problem happens only with this backup thing.

I tried to use "localhost" instead of 127.0.0.1 but same problem. I also tried to remove 'password' and add a port number, same problem.

Any advice?

Thanks Rob,

I have a question please;
I want to INSERT the result of this query (Total) into a field called "TotalMarks" found in the same table. How to I do that?
I tried INSERT INTO TotalMarks SELECT...(the select query) but did not work.
I also tried INSET INTO tblForm1.TotalMarks SELECT .... but never worked.

Any idea please?

Thanks a lot so far.

Thanks Jacques, Your insert is new to me, so I will have to study it, I know its gonna help me a great deal.
Thanks.

Thanks Ved, I have a question please;
I want to INSERT the result of this query (Total) into a field called "TotalMarks" found in the same table. How to I do that?
I tried INSERT INTO TotalMarks SELECT...(previous solution query) but did not work.
I also tried INSET INTO tblForm1.TotalMarks but never worked.

Any idea please?

Thanks a lot so far.

I managed to do it psychic6000. Thank you very much for your continued support here.
Blessings to you.

Thank you so much. And, Sorry for not being specific at first. Now,please, Why do I get an error creating a temporary table with :"INSERT INTO #temp SELECT StudentID, Average FROM tblForm1 ORDER BY Average DESC " OR even as simple as this:"CREATE TABLE #Results"? But this "CREATE TABLE Results" works. I thought we put # when we need to create temporary tables (Access), its like I've once done that. Help on that please?

Sory,for now I use Access (.mdb)..anything?

Well, thanks. But, how do I get the row number, for instance, from a GridView? If I can get a row number that could be helpful.
Thanks!

Thank you...But, how do I get the grid view row index? Its not shown by default...

psychic6000, Thank you very much for responding. I tried this:

sqlQuery = "SELECT ROW_NUMBER () " _
+ "OVER (ORDER BY Average desc) AS Rank," _
+ "StudentId as rollNO,Physics,Chemistry" _
+ "FROM tblClass1"

and got this error message "Syntax error (missing operator) in query expression 'ROW_NUMBER () OVER (ORDER BY Average desc)'.". Can you tell which operator is missing? If the code works, I think my problem will be solved.

Thanks so much so far.

Thank you for responding. But, this is what I want:After performing a SELECT with ORDER BY query, the results will be filled to a dataset ("StudentRank").So, let's say I search for a particular student, (say John), from that, I want to get John's position in the class.

In other words, John may probably be stored in dataset.Tables ("StudentRank").Rows (4).Item (2), that will means John is in position 5 (4+1) in the class. Now, I don't want the dataset.Tables ("StudentRank").Rows(4).Item(2), I just want to display Johns marks on the form and also display his rank (5) in the class. Something like this:

StudentID: G23
Physics:80
Biology:70
Chemistry:90
Total:240
Average: 70
Rank in the class:5 (I can solve the above, this is the problem now)
All in all, my point is to be able to determine and display student rank in a class. I have tables for each subject (tblPhysics,tblChemistry...) and a table for a specific class (tblClass1) which will contain (StudentID,Physics,Chemistry.... and display the average score for each student)
I hope I made myself clearer, and thank you for your response.

Thank you for responding. But, this is what I want:After performing a SELECT with ORDER BY query, the results will be filled to a dataset ("StudentRank").So, let's say I search for a particular student, (say John), from that, I want to get John's position in the class.

In other words, John may probably be stored in dataset.Tables ("StudentRank").Rows (4).Item (2), that will means John is in position 5 (4+1) in the class. Now, I don't want the dataset.Tables ("StudentRank").Rows(4).Item(2), I just want to display Johns marks on the form and also display his rank (5) in the class. Something like this:

StudentID: G23
Physics:80
Biology:70
Chemistry:90
Total:240
Average: 70
Rank in the class:5 (I can solve the above, this is the problem now)
All in all, my point is to be able to determine and display student rank in a class. I have tables for each subject (tblPhysics,tblChemistry...) and a table for a specific class (tblClass1) which will contain (StudentID,Physics,Chemistry.... and display the average score for each student)
I hope I made myself clearer, and thank you for your response.

Thank you for responding. But, this is what I want:After performing a SELECT with ORDER BY query, the results will be filled to a dataset ("StudentRank").So, let's say I search for a particular student, (say John), from that, I want to get John's position in the class.

In other words, John may probably be stored in dataset.Tables ("StudentRank").Rows (4).Item (2), that will means John is in position 5 (4+1) in the class. Now, I don't want the dataset.Tables ("StudentRank").Rows(4).Item(2), I just want to display Johns marks on the form and also display his rank (5) in the class. Something like this:

StudentID: G23
Physics:80
Biology:70
Chemistry:90
Total:240
Average: 70
Rank in the class:5 (I can solve the above, this is the problem now)
All in all, my point is to be able to determine and display student rank in a class. I have tables for each subject (tblPhysics,tblChemistry...) and a table for a specific class (tblClass1) which will contain (StudentID,Physics,Chemistry.... and display the average score for each student)
I hope I made myself clearer, and thank you for your response.

Thank you for responding. But, this is what I want:After performing a SELECT with ORDER BY query, the results will be filled to a dataset ("StudentRank").So, let's say I search for a particular student, (say John), from that, I want to get John's position in the class.

In other words, John may probably be stored in dataset.Tables ("StudentRank").Rows (4).Item (2), that will means John is in position 5 (4+1) in the class. Now, I don't want the dataset.Tables ("StudentRank").Rows(4).Item(2), I just want to display Johns marks on the form and also display his rank (5) in the class. Something like this:

StudentID: G23
Physics:80
Biology:70
Chemistry:90
Total:240
Average: 70
Rank in the class:5 (I can solve the above, this is the problem now)
I hope I made myself clearer, and thank you for your response.

friends,Some more help please.

Thank you. I'm following your links just now..

thank you shashikanth 2011, but, please, where do I put these codes in my page?

Thanks jim lahey, but, I see you have provided the solution to take when a user doesn't fill anything in the primary key field, but I handled that in a much simpler way. My problem is when a user tries to enter a primary key that has already been entered into the database i.e entering the same MAC address again. That's where I want help. But, thank you for taking your time. Please give some clues.
Frank.