السلام عليكم
انا عامل كود يضيف مستخدم جديد او بالاصح اعمل ا كاونت جديد بس انا عندي المشكله بالبرامترز حق الفنكشن
OleDbConnection conn = new OleDbConnection("data sourse ='.'; initial catalog=Project1");
ياريت لو حد بيفهم الادو يدلني وش الحل
اما كود الصبمت submit هو
protected void Button1_Click(object sender, EventArgs e)
{
string v_reselt = "";
int cont_error = 0;
OleDbConnection conn = new OleDbConnection("data sourse ='.'; initial catalog=Project1");
OleDbCommand cmd=new OleDbCommand("select * frome Hotels where Hotel_Id="+UserName.Text.Trim()+"'",conn);
if (UserName.Text.Trim() != "")// chike if did not enter data
{
conn.Open();
OleDbDataReader dr = cmd.ExecuteReader(); //to execute cmd select .
if (dr.Read())
{
cont_error += 1;
v_reselt += "You enter used id by another user.Plese enter another ID <br>";
}
dr.Close();
conn.Close();
}
else
{
cont_error += 1;
v_reselt += "Please netre yor Passworrd<br>";
}
if (City.Text.Trim() == "")
{
cont_error += 1;
v_reselt += "Please enter your city name <br>";
}
if (Stars.Text.Trim() == "")
{
cont_error += 1;
v_reselt += "please enter your hotel stars<br>";
}
if (Address.Text.Trim() == "")
{
cont_error += 1;
v_reselt += "please enter yor addres <br>";
}
if (EMail.Text.Trim() == "")
{
cont_error+=1;
v_reselt += "Please enter your E-Mail address<br>";
}
if (Stars.Text.Length > 1)
{
cont_error += 1;
v_reselt += "the rate of stas is(1-7)<br>";
}
if (cont_error > 0)
ResultLabel.Text = v_reselt;
else //if the enterd data have no error
{
conn.Open();
string ins_statment = "insert into Hotels_Profile values(@Hotel_ID,@Name,@City,@Street_Address,@Area,@Website_Name,@Telephone,@E_Mail)";
cmd.CommandText = ins_statment;
cmd.Parameters.Add("@Hotel_ID", OleDbType.Char,25);
cmd.Parameters["@Hotel_ID"].Value = UserName.Text;
cmd.Parameters.Add("@City", OleDbType.Char, 12);
cmd.Parameters["@City"].Value = City.Text;
cmd.Parameters.Add("@Street_Address", OleDbType.Char, 30);
cmd.Parameters["@Street_Addrees"].Value = Address.Text;
cmd.Parameters.Add("@Area", OleDbType.Char, 12);
cmd.Parameters["@Area"].Value = Area.Text;
cmd.Parameters.Add("@Website_name", OleDbType.Char, 25);
cmd.Parameters["@Website"].Value = WebSite.Text;
cmd.Parameters.Add("@Telephone", OleDbType.Char, 12);
cmd.Parameters["@Telephone"].Value = Telphon.Text;
cmd.Parameters.Add("@E_Mail", OleDbType.Char, 25);
cmd.Parameters["@E_Mail"].Value = EMail.Text;
cmd.ExecuteNonQuery();
Response.Redirect("New_H_Order.aspx");
}
}