DropDown List Issue

Question

Hello Good Morning All

 

I am facing a problem while am fetching the data from database in drop down list then i want to store that selected data in another database.

 

am making a online test

there are different dropdown lists

all lists are getting the data dynamically from databse

when dropdown list sleect the value from databse that selected value i want to store in another table

but am facing the the problem while i am storing the data in another table the value of datavaluefield not saving only name of the column is saving in database my code is showing below

 

plz help me as soon as possible 

 

 

 

 

{

string conn = ConfigurationManager.ConnectionStrings["abc"].ConnectionString;

SqlConnection con = new SqlConnection(conn);

con.Open();

SqlCommand cmd = new SqlCommand("select id,testcategoryname from TestCategoryName", con);

cmd.CommandType = CommandType.Text;

cmd.Connection = con;

DropDownList1.DataSource = cmd.ExecuteReader();

 DropDownList1.DataTextField = "testcategoryname";

DropDownList1.DataValueField = "id";

DropDownList1.DataBind();

DropDownList1.Items.Insert(0, new ListItem("--Select Category--", "0"));

 }

{

string conn1 = ConfigurationManager.ConnectionStrings["abc"].ConnectionString;

SqlConnection con1 = new SqlConnection(conn1);

SqlCommand cmd1 = new SqlCommand("select id,testsubcategoryname from TestSubCategoryName");

cmd1.CommandType = CommandType.Text;

cmd1.Connection = con1;

con1.Open();

DropDownList2.DataSource = cmd1.ExecuteReader();

DropDownList2.DataTextField = "testsubcategoryname";

DropDownList2.DataValueField = "id";

DropDownList2.DataBind();

DropDownList2.Items.Insert(0, new ListItem("--Select Sub Category--", "NA"));

}

{

string conn2 = ConfigurationManager.ConnectionStrings["abc"].ConnectionString;

SqlConnection con2 = new SqlConnection(conn2);

SqlCommand cmd2 = new SqlCommand("select id,testquestiontype from TestQuestionType ");

cmd2.CommandType = CommandType.Text;

cmd2.Connection = con2;

con2.Open();

DropDownList3.DataSource = cmd2.ExecuteReader();

DropDownList3.DataTextField = "testquestiontype";

DropDownList3.DataValueField = "id";

DropDownList3.DataBind();

DropDownList3.Items.Insert(0, new ListItem("--Select Question Tye--", "NA"));

}

 }

 

protected void Button2_Click1(object sender, EventArgs e)

{

 DropDownList1.DataValueField);

 string conn4 = ConfigurationManager.ConnectionStrings["abc"].ConnectionString;

SqlConnection con4 = new SqlConnection(conn4);

con4.Open();

SqlCommand cmd4 = new SqlCommand("insert into AddQuestions(testcategory,subcategory,questiontype) values(@testcategory,@subcategory,@questiontype)", con4);

 DropDownList1.DataValueField = Request.QueryString["testcategory"];

 

cmd4.Parameters.AddWithValue("@subcategory", DropDownList2.DataValueField);

cmd4.Parameters.AddWithValue("@questiontype", DropDownList3.DataValueField);

 

  

cmd4.ExecuteNonQuery();

con4.Close();

Response.Redirect("AddQuestions.aspx");

}

 

Answer 1

If you write something after finally block,Then it wont execute if

1. Catch part throw some exception which is not handled by another try catch,
2. Finally part throw some exception which is not handled by another try catch,
3. Code  written before Try throw some exception which is not handled by another try catch,
4. return statement is executed prior to the statement written after Finally...
   (Means return statement written inside Try/Catch/Code Block before Try, and it executes)
   (Writing return inside finally causes syntax error so obviously it doesn't matter).

Hope it helped.

Mark as answer if it is. :)