The parameterized query '(@value nvarchar(4000))insert into abs2(vab2)values(@value)' expects the parameter '@value', which was not supplied.
<html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>Untitled Page</title> </head> <body> <form id="form1" runat="server"> <div> <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" onselectedindexchanged="DropDownList1_SelectedIndexChanged" Width="112px"> <asp:ListItem>value1</asp:ListItem> <asp:ListItem>value2</asp:ListItem> <asp:ListItem>value3</asp:ListItem> <asp:ListItem>value4</asp:ListItem> </asp:DropDownList> <asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Button" /> </div> </form> </body> </html>
public partial class _Default : System.Web.UI.Page { string var; SqlConnection conn; SqlCommand cmd; string str = ConfigurationManager.ConnectionStrings["cnstr"].ConnectionString; protected void Page_Load(object sender, EventArgs e) { } protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { var = DropDownList1.SelectedValue; } protected void Button1_Click(object sender, EventArgs e) { conn = new SqlConnection(str); cmd = new SqlCommand("insert into abs2(vab2)values(@value)",conn); cmd.Parameters.AddWithValue("@value", var); try { conn.Open(); int a = cmd.ExecuteNonQuery(); if (a > 0) { Response.Write("inserted"); } else { Response.Write("failed"); } } catch (Exception ex) { Response.Write(ex.Message); } finally { conn.Close(); } } }
cmd = new SqlCommand("insert into abs2(vab2)values(@vab2)",conn); cmd.Parameters.AddWithValue("@value", var);
var v= DropDownList1.SelectedValue; cmd=new SqlCommand("insert into abs2(vab2)values(@vab2)",conn); cmd.Parameters.AddWithValue("@value", v);
cmd = new SqlCommand("insert into abs2(vab2)values(@value)",conn); cmd.Parameters.AddWithValue("@value", DropDownList1.SelectedValue);
string var;
var
conn = new SqlConnection(str); cmd = new SqlCommand("insert into abs2(vab2)values(@value1)",conn); cmd.Parameters.AddWithValue("@value1", var);
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)