resio sam deo problema ali ne znam kako da dodam parametar iz textbox-a za pretragu po bazi
kod:
rotected void Button1_Click(object sender, EventArgs e)
{
SqlDataSource SqlDataSource1 = new SqlDataSource();
SqlDataSource1.ID = "SqlDataSource1";
this.Page.Controls.Add(SqlDataSource1);
SqlDataSource1.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlDataSource1.SelectCommand = "SELECT * from filmovi where nazivFilma values @nazivFilma'";
//TREBA MI NESTO KAO com.parametars.addwithvalue("@naziFilma",textBox1.text);
GridView1.DataSource = SqlDataSource1;
GridView1.DataBind();
}
protected void Button2_Click(object sender, EventArgs e)
{
SqlDataSource SqlDataSource2 = new SqlDataSource();
SqlDataSource2.ID = "SqlDataSource2";
this.Page.Controls.Add(SqlDataSource2);
SqlDataSource2.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlDataSource2.SelectCommand = "SELECT * from zanr where ime values @ime";
//TREBA MI NESTO KAO com.parametars.addwithvalue("@naziFilma",textBox1.text);
GridView1.DataSource = SqlDataSource2;
GridView1.DataBind();
}
Znaci treba mi nesto kao com.parametars kad radim sa sqlcommnad-om
bez blama