Evo mene opet.:D Radim registraciju i pri unosu podataka imam problem nemogu da ga resim ubi se.
Imam bazu Clanovi i tablu Podaci i u njo promenjive IDClana,KorisnickoIme,Sifra,Sajt.
Kompajler ne prikazuje greske ali pri unosu podataka u text boxove i klikom na dugme koj vrsi unos u bazu javlja se problem..
Code:
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class Registracija : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void RegistracijaButton_Click(object sender, EventArgs e)
{
string korisnickoIme = KorisnickoImeTextBox.Text;
string sifra = LozinkaTextBox.Text;
string Email = EmailTextBox.Text;
string sajt = SajtTextbox.Text;
SqlConnection conn=new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=\"D:\\Moje stvari\\ASP.Net & C#\\Vezbanja\\Registracija i logovanje\\App_Data\\Clanovi.mdf\";Integrated Security=True;User Instance=True");
try
{
conn.Open();
//pravimo promenjivu za unos u bazu
SqlCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "INSERT INTO Podaci(KorisnickoIme,Sifra,EmailAdresa,Sajt) VALUES (@korisnickoIme,@sifra,@Email,@sajt)";
cmd.Parameters.AddWithValue("@KorisnickoIme", korisnickoIme);
cmd.Parameters.AddWithValue("@Sifra", sifra);
cmd.Parameters.AddWithValue("@EmailAdresa", Email);
cmd.Parameters.AddWithValue("@Sajt", sajt);
//zaustavljamo ubacivanje
cmd.ExecuteNonQuery();
}
finally
{
if ((conn != null) && (conn.State != ConnectionState.Closed))
conn.Close();
}
}
}
Eror je : Must declare the scalar variable "@Email".
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Must declare the scalar variable "@Email".
i ukazuje na kod
Code:
Line 39: cmd.Parameters.AddWithValue("@Sajt", sajt);
Line 40: //zaustavljamo ubacivanje
Line 41: cmd.ExecuteNonQuery();
Line 42: }
Source File: d:\Moje stvari\ASP.Net & C#\Vezbanja\Registracija i logovanje\Registracija.aspx.cs Line: 41
Crazy shadow
C# i SQL kako upisati brisati manipulisati podacima
