Inserting into MySQL database from C# Webforms, give ArgumentException -

-

I am trying to create a registration page through a web page that will connect to a MySQL databse and insert data , But it puts an argument exception (even if I believe I'm following the tutorial at all) and will not include the data in the table.

My C # code for the registration page is as follows: 

  Public partial class registration: system. Web. UI page {MySql.Data.MySqlClient.MySqlConnection conn; MySql.Data.MySqlClient.MySqlCommand CMD; String query STR; Secure Zero Page_load (Object Sender, EventAgps E) {} Safe Weather Register Aventim (Object Sender, EventArgus E) {Register User (); } Private Zero Register User () {string connString = System.Configuration.ConfigurationManager.ConnectionStrings ["WebAppConnString"]. ToString (); Conn = New MySql.Data.MySqlClient.MySqlConnection (connString); conn.Open (); QueryStr = ""; Include QueryStr = "seniorschema.registration (password 1, email, first name, last name, password 2, code)" + "value ('" + password reader box 1. text + "," "+ email textbox. Text + "','" + First name text box. Text + "','" + Last name textbox. Text + "','" + password textbox. Text + "','" + CodeTextBox.Text + "')"; CMD = New MySql.Data.MySqlClient.MySqlCommand (queryStr, conn); cmd.ExecuteReader (); conn.Close ();}}   
 And my connection to WebConfig file is here: < / p> 
  & lt; connectionStrings & gt; & lt; add name = "w EbAppConnString "connectionString =" server = localhost; Id = webware; pwd = password; Database = Senior Summary; "ProviderName =" MySql.Data.MySqlClient "/> & lt; / ConnectionStrings & gt;   
 Any help would be most appreciated thanks!   
 
 
 I do not know what tutorial you've read but should never teach them to use string combination Create a SQL command text.  
 However, the error you get is from connectionstring. 
 You should write  
  string connString = Configu RationManager.ConnectionStrings ["WebAppConnString"]. Connection String;   
 There is an error in the definition of connection string in web.config (a typo?) This  uid = ....  No  id = .....   
 And how do I enter here, which adds the record.  
  MySql.Data Using .MySqlClient;; queryStr = @ "insert in seniorschema.registration (password1, email, first name, last name, password2, code) values ​​(@pwd, @email, @first, @last, @ pwd2) , Using @code ", (MySqlConnectionCon = New MySqlConnection (connString)) (MySq LCommand cmd = New MySqlCommand (queryStr, Connecticut) {conn.Open (); Cmd.Parameters.AddWithValue ("@ pwd", PasswordTextBox1.Text); cmd.Parameters.AddWithValue ("@email", EmailTextbox.Text); Cmd.Parameters.AddWithValue ("First", firstNameTextBox.Text); cmd.Parameters.AddWithValue ("Last @", LastNameTextBox.Text); Cmd.Parameters.AddWithValue ("@ pwd2", PasswordTextBox2.Text); cmd.Parameters.AddWithValue ("@ code", CodeTextBox.Text); Integer rowAdded = cmd.ExecuteNonQuery ();}   
 This approach combines all the complexities needed to code the quotation marks around the values ​​away from the values;  
 Finally, but it is actually a logic that is very broad and is not immediately related to your question. 
 If a copy or a copy of a registration table can be used to store a password in clear text, from a bad practice, from a security perspective, clear text, then it will be able to read the passwords of all registered users. There are proven methods that make them unreadable to the audience

Comments

Post a Comment

Popular posts from this blog

php - PDO bindParam() fatal error -

-
I am trying to learn PDO, now I have written this small code, but it gives me a serious error: Fatal error: Call a member function at a non-object dot () ... $ con = new mysqli ("127.0.0.1", "root", "", "csvdangercheck"); $ Query = $ con- & gt; ("Id,` var1`, `var2`) values ​​(" id,: var1,: var2) ";); $ query- & gt; bypass pattern (': id', $ id); $ query- & gt; BindParam (': var1', $ VAL1); $ Query- & gt; bindParam (': var2', $ val2); $ Query-> Executed (); I Trying to use print_r ($ con-> errorInfo ()) but Fatal error: Undefined method mysqli :: errorInfo ( ) ... can someone tell me what am I missing? Flaffeh said, you have PDO Missing Mysqy, try it: $ con = new PDO ('mysql: host = 127.0.0.1; dbname = csvdangercheck', 'root', '');
Read more

php - How can I cram 6+31 numeric characters into 22 alphanumeric characters? -

-
I have a 6 digit number and a 31-digit number (such as "234536" and "201103231043330478311223582826") that I The API needs to be crawled in the same 22-character alphanumeric field that uses PHP. I tried to convert each one to 32 (using custom code could not handle the base_convert () large number) and to connect with a single-character delimiter, but It only gives me 26 characters This is a restore API, so the letters should be URI-protected. I would like to do a database table cross with two references without reference to another reference value, if possible, any suggestions? Instead use a radix of 62. This will give you 22 characters for the top, 3.35 for the pre and 17.3 for the next. & gt; & Gt; & Gt; Math.log (10 ** 6) /math.log (62) 3.3474826039165504 & gt; & Gt; & Gt; Math.log (10 ** 31) /math.log (62) 17.295326786902177
Read more

logging - How can I log both the Request.InputStream and Response.OutputStream traffic in my ASP.NET MVC3 Application for specific Actions? -

-
For a specific set of tasks, I need to log in to the incoming request inputstream as well as outgoing response. is. I am using an ActionFilterAttribute for this and overriding the OnActionExecuted and OnResultExecuted methods. So I'm starting with this idea ... Public category ActionLoggerAttribute: ActionFilterArrbit {Public Override Zero On-Offed Execution (ActionActioned Contact Filter Filter) {base.OnActionAxecuted (FilterContext); HttpRequestBase request = filterContext.HttpContext.Request; // TODO: Log the request. InputStream} Public Override Zero OnResultExecuted (ResultExecutedContext FilterContext) {base.OnResultExecuted (filterContext); HTTPRPSPointBase Response = FilterContacts Hpptex response; // TODO: Log on Response.OutputStream}} Ideally I'll hook it up with enterprise library logging because I'm already using it for error logging. Am I reaching the input and output stream at the right time? Can I easily use the Enterprise Library to log i...
Read more