registration db

kostasvit — Sat, 29 Jun 2013 19:46:55 GMT

παιδιά καλημέρα

έχω το εξής πρόβλημα, έχω φτιάξη μια βάση sql για registration.μόλις τρέχω τον κώδικα μου χτυπάει error στο SqlCommand cmd = new SqlCommand(sql,conn);

αντιγράφω και τον κώδικα μήπως μπορεί να βοηθήσει κάποιος

using System;

using System.Collections.Generic;

using System.Data;

using System.Data.SqlClient;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Configuration;

namespace TEST

{

public partial class registration : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

}

public string GetConnectionString()

{

return System.Configuration.ConfigurationManager.ConnectionStrings["MyconsString"].ConnectionString;

}

protected void Button1_Click(object sender, EventArgs e)

{

if (TxtPassword.Text == TxtRePassword.Text)

{

//call the method to execute insert to the database

ExecuteInsert(TxtName.Text,

TxtUsername.Text,

TxtPassword.Text,

DropDownList1.SelectedItem.Text,

TxtAge.Text, TxtAddress.Text);

Response.Write("Record was successfully added!");

}

else

{

Response.Write("Password did not match");

TxtPassword.Focus();

}

private void ExecuteInsert(string name, string username, string password, string gender, string age, string address)

{

SqlConnection conn = new SqlConnection(GetConnectionString());

string sql = "INSERT INTO tblRegistration (Name, UserName, Password, Gender, Age, Address) VALUES "

+ " (@Name,@UserName,@Password,@Gender,@Age,@Address)";

try

{

conn.Open();

SqlCommand cmd = new SqlCommand(sql,conn);

SqlParameter[] param = new SqlParameter;

//param[0] = new SqlParameter("@id", SqlDbType.Int, 20);

param[0] = new SqlParameter("@Name", SqlDbType.VarChar, 50);

param[1] = new SqlParameter("@UserName", SqlDbType.VarChar, 50);

param[2] = new SqlParameter("@Password", SqlDbType.VarChar, 50);

param[3] = new SqlParameter("@Gender", SqlDbType.Char, 10);

param[4] = new SqlParameter("@Age", SqlDbType.Int, 100);

param[5] = new SqlParameter("@Address", SqlDbType.VarChar, 50);

param[0].Value = name;

param[1].Value = username;

param[2].Value = password;

param[3].Value = gender;

param[4].Value = age;

param[5].Value = address;

for (int i = 0; i < param.Length; i++)

{

cmd.Parameters.Add(param);

}

cmd.CommandType = CommandType.Text;

cmd.ExecuteNonQuery();

}

catch (System.Data.SqlClient.SqlException ex)

{

string msg = "Insert Error:";

msg += ex.Message;

throw new Exception(msg);

}

finally

{

conn.Close();

}

Πρώτα Βήματα - Web Development

registration db