inserting data into database after selected indexchanged in dropdownlist

sarbjeet singh

15y5.6k.NET

hi Guys ,Plz help me out
i m havin the following code

Have Pan Card:

-----select-----

yes

Enter Ist Choice

and the code behind is here

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.OleDb;

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

{

string pan, panno;

OleDbConnection con = new OleDbConnection(ConfigurationManager.ConnectionStrings["adbudhconnection"].ConnectionString);

protected void Page_Load(object sender, EventArgs e)

{

div1.Visible = false;

}

protected void Button1_Click(object sender, EventArgs e)

{

con.Open();

OleDbCommand cmd = new OleDbCommand("insert into demo(pan,panno)values(@pan,@panno)", con);

cmd.Parameters.AddWithValue("@pan", pan);

cmd.Parameters.AddWithValue("@panno", panno);

cmd.ExecuteNonQuery();

con.Close();

}

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)

{

if (DropDownList1.SelectedItem.Text == "yes")

{

div1.Visible = true;

pan = DropDownList1.SelectedItem.Text;

panno = TextBox1.Text;

}

else if (DropDownList1.SelectedItem.Text == "no")

{

pan = DropDownList1.SelectedItem.Text;

panno = "n/a";

}

this gives the error that
Parameter @pan has no default value

plz help its urgent

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suthish Nair15y ago
If the query got resolved, then mark the post that helped you as Answer so will be helpful for others. Otherwise if you got the solution please share with us.
0
Suthish Nair15y ago
change these lines too..

cmd.Parameters.AddWithValue("@pan", DropDownList1.SelectedItem.Text);
cmd.Parameters.AddWithValue("@panno", (DropDownList1.SelectedItem.Text == "no" ? "n/a" :
TextBox1.Text));

DropDownList1_SelectedIndexChanged

if (DropDownList1.SelectedItem.Text == "yes")
{
      div1.Visible = true;
  }
  else if (DropDownList1.SelectedItem.Text == "no")
  {
       div1.Visible = false;
   }

if(!IsPostBack) { } check
0
Krishna Garad15y ago
Don't use that string as static or access the value of the string like
Classname.panno
or replace following line
cmd.Parameters.AddWithValue("@panno",TexBbox1.Text);
0
sarbjeet singh15y ago
pan column is working but when i enter the value in textbox1 and submit it shows only pan data and panno is empty

and i have declared

static string pan,panno;
0
Krishna Garad15y ago
Have you given any default value to Pan column in Database. and try this also
pan = DropDownList1.SelectedItem.Text.ToString();
0
sarbjeet singh15y ago
sir it doesn't work getting the same error
0
Krishna Garad15y ago
modify your Page load as suthish told like
Page_load
{
if(!IsPostBack)
{
div1.visible=false;
}
}
the value is empty because when you fire any other event then first page_load event fires again which set the values default to control.
0
sarbjeet singh15y ago
hello sir , i did it but not getting the exact solution

could u plz help me out
0
Suthish Nair15y ago
Page Load: you need a if(!IsPostBack) { } check. Put a break point and chaeck each line value.
0