|
Hi,
Why I am getting the following error:
Input string was not in a correct format.
here is my code:
sql_connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["SQLdb"].ConnectionString);
sql_connection.Open();
sql_command = new MySqlCommand("sp_add_new_volow_member", sql_connection);
sql_command.CommandType = CommandType.StoredProcedure;
sql_command.CommandTimeout = 300;
sql_command.Parameters.AddWithValue("param_full_name", txtSignupFullName.Text.Trim()).MySqlDbType = MySqlDbType.VarChar;
sql_command.Parameters.AddWithValue("param_email_address", txtSignupEmailAddress.Text.Trim()).MySqlDbType = MySqlDbType.VarChar;
sql_command.Parameters.AddWithValue("param_login_password", txtSignupPassword.Text.Trim()).MySqlDbType = MySqlDbType.VarChar;
sql_command.Parameters.AddWithValue("param_record_identity", MySqlDbType.Int32).Direction = ParameterDirection.Output;
sql_command.Parameters.AddWithValue("param_record_guid", MySqlDbType.VarChar).Direction = ParameterDirection.Output;
sql_command.Parameters.AddWithValue("param_is_exist", MySqlDbType.Bit).Direction = ParameterDirection.Output;
int result_rows = sql_command.ExecuteNonQuery();
and this is my SQL:
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_add_new_volow_member`(IN param_full_name varchar(255), IN param_email_address varchar(255), IN param_login_password varchar(255), OUT param_record_identity int, OUT param_record_guid varchar(255), OUT param_is_exist bit)
BEGIN
SET param_is_exist = FALSE;
INSERT INTO volow_members (volow_member_full_name, volow_member_email, volow_member_password) VALUES (param_full_name, param_email_address, param_login_password);
SET param_record_identity = LAST_INSERT_ID();
SET param_record_guid = 'abc';
END
|
|
|
|
|
Did you ever bother to check your sql char arrays, and feed them in manually to your database using a management tool, to make sure they work first.
Then test your connection by just selecting records, to make sure your connector works
jrahma wrote: DEFINER=`root`@`localhost`
you have too many quotes
jrahma wrote: sql_connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["SQLdb"].ConnectionString);
sql_connection.Open();
Usually you program your parameters before you open the connection
Your code looks strange to me, and your use of parameters does not look well formatted. The parameters are individual objects, that you add to the SQLCommand, once you build your parameters, you open the database, execute, and close it.
Dim strConnString As String = GetSQLConnString()
Dim objConn As New SqlConnection(strConnString)
Dim strSQL As String = "DELETE FROM ProductInfo WHERE ProductID=@ProductID"
Dim objCmd As New SqlCommand(strSQL, objConn)
Dim paramProductID As SqlParameter
paramProductID = New SqlParameter("@ProductID", SqlDbType.Int)
paramProductID.Value = ProductID
objCmd.Parameters.Add(paramProductID)
Try
'Delete the record in the database
objConn.Open()
objCmd.ExecuteNonQuery()
objConn.Close()
Success = True
Catch ex As Exception
Success = False
End Try
objCmd = Nothing
objConn = Nothing
|
|
|
|
|
I suspect that the problem is with the 3 lines lines starting with:
sql_command.Parameters.AddWithValue("param_record_identity", MySqlDbType.Int32)
AddWithValue expects you to provide the actual values to the parameters instead of the data types (as in the preceeding 2 lines).
|
|
|
|
|
In a C# 2010 form application, I want to change an existing display from being a textbox, to being a popup new window where the user can enter data. Basically there is not enough room for a user to enter a large volume of notes.
Thus can you tell me how a user can click on an existing textbox, and a new window will showup for the user to enter the data. The user will click a save button, the data will be updated in the database potnetially and the user will return to the original window.
I would like to see this using ajax and non ajax code.
|
|
|
|
|
I always wanted to try grow ui, tryed it once, but no luck, but your suppose to be able to grow the textbox larger, and shrink it back
[Grow UI^]
|
|
|
|
|
Please take a look at jQuery UI, especially the dialog component:
http://jqueryui.com/demos/dialog/#modal-form[^]
Using or not ajax is different story as it will only affect whenever whole page will reload or not after user click save.
--
"My software never has bugs. It just develops random features."
|
|
|
|
|
you can use Div COntrol the div control u setup height and width call div using JQuery Method
|
|
|
|
|
how to optimize emails on mobile devices using the Exact Target api..
Plz let me knw if there exists any api in exact target for the above?
|
|
|
|
|
Using Facebook Login how to login my website.
Sankar.R
|
|
|
|
|
I am getting the following error:
A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
I am only trying a simple INSERT procedure running on localhost MySQL on my local laptop?
Any possible reason?
|
|
|
|
|
here is my ConnectionString:
<add name="SQLdb" connectionString="SERVER=127.0.0.1;Port=3306;DATABASE=myDB; UID=root; PASSWORD=abc123;Connect Timeout=300;" providerName="MySql.Data.MySqlClient"/>
|
|
|
|
|
Do you have a firewall installed?
Why is common sense not common?
Never argue with an idiot. They will drag you down to their level where they are an expert.
Sometimes it takes a lot of work to be lazy
Please stand in front of my pistol, smile and wait for the flash - JSOP 2012
|
|
|
|
|
Input string was not in a correct format.
here is my code:
sql_connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["SQLdb"].ConnectionString);
sql_connection.Open();
sql_command = new MySqlCommand("sp_add_new_volow_member", sql_connection);
sql_command.CommandType = CommandType.StoredProcedure;
sql_command.CommandTimeout = 300;
sql_command.Parameters.AddWithValue("param_full_name", txtSignupFullName.Text.Trim()).MySqlDbType = MySqlDbType.VarChar;
sql_command.Parameters.AddWithValue("param_email_address", txtSignupEmailAddress.Text.Trim()).MySqlDbType = MySqlDbType.VarChar;
sql_command.Parameters.AddWithValue("param_login_password", txtSignupPassword.Text.Trim()).MySqlDbType = MySqlDbType.VarChar;
sql_command.Parameters.AddWithValue("param_record_identity", MySqlDbType.Int32).Direction = ParameterDirection.Output;
sql_command.Parameters.AddWithValue("param_record_guid", MySqlDbType.VarChar).Direction = ParameterDirection.Output;
sql_command.Parameters.AddWithValue("param_is_exist", MySqlDbType.Bit).Direction = ParameterDirection.Output;
int result_rows = sql_command.ExecuteNonQuery();
|
|
|
|
|
give answer example(path of file)
|
|
|
|
|
Don't post just 'How to..' without any effort.
Replied you on how to save[^], learn and then try to do reverse of it.
|
|
|
|
|
From a folder on the server, or a folder on the users computer?
|
|
|
|
|
How to save any image or file in folder please give answer very soon in asp.net
|
|
|
|
|
|
How to save any image or file in folder please give answer very soon
|
|
|
|
|
|
|
when i use the gridview the i am unable to update and delete while select option work properly
|
|
|
|
|
And what did you do to update/delete? Until you share the effort made, any specific issue - how can anyone help you?
Select, Update, Delete are standard features whose implementations are widely discussed and shared on web, look at them and learn.
|
|
|
|
|
I need to create a pop up window in the top of the web page with the message"Please disable your pop up blocker" . Can you please help me out
Beni
|
|
|
|
|
Beniston1205 wrote: I need to create a pop up window in the top of the web page with the message"Please disable your pop up blocker" . Can you please help me out
One way around would be to create a div section, hidden by default, and to "pop it up" with JavaScript by toggeling the visibility. That way there will not be an additional window 
Bastard Programmer from Hell 
if you can't read my code, try converting it here[^]
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
