How to store dyanamic dropdownlist and textbox data in sqlserver table in c#

Question

0.00/5 (No votes)

See more:

Hello Sir,
I have take two dynamic dropdownlist and one text box.now i want to store this data into sqlserver database.
I have written code but it is not work properly.
I will send my code please help me for this.

this is Add button(to add new row(dropdownlist and textbox)
static int i = 0;
protected void Button1_Click(object sender, EventArgs e)
{

for (int j = 0; j <= i; j++)
{
DropDownList drpstart = new DropDownList();
drpstart.ID = "d1"+j;
drpstart.Items.Add(new ListItem("8AM"));
drpstart.Items.Add(new ListItem("9AM"));
drpstart.Items.Add(new ListItem("10AM"));
drpstart.Items.Add(new ListItem("11AM"));
drpstart.Items.Add(new ListItem("12PM"));
drpstart.Items.Add(new ListItem("1PM"));
drpstart.Items.Add(new ListItem("2PM"));
drpstart.Items.Add(new ListItem("3PM"));
drpstart.Items.Add(new ListItem("4PM"));
drpstart.Items.Add(new ListItem("5PM"));
drpstart.Items.Add(new ListItem("6PM"));
drpstart.Items.Add(new ListItem("7PM"));
drpstart.Items.Add(new ListItem("8PM"));
drpstart.Items.Add(new ListItem("9PM"));
drpstart.Items.Add(new ListItem("10PM"));
drpstart.Width = 150;
pnlInfo.Controls.Add(drpstart);

DropDownList drpend = new DropDownList();
drpend.ID = "d2"+j;
drpend.Items.Add(new ListItem("8AM"));
drpend.Items.Add(new ListItem("9AM"));
drpend.Items.Add(new ListItem("10AM"));
drpend.Width = 150;
pnlInfo.Controls.Add(drpend);

TextBox txtdesc = new TextBox();
txtdesc.ID = "t3"+j;
txtdesc.Width = 700;
pnlInfo.Controls.Add(txtdesc);

}
i++;
}

this is save button

protected void Button2_Click(object sender, EventArgs e)
{
String str = string.Empty;
DropDownList drpstrattime = (DropDownList)pnlInfo.FindControl("d1");
DropDownList drpend = (DropDownList)pnlInfo.FindControl("d2");
TextBox txtdesc = (TextBox)pnlInfo.FindControl("t3");

string constr = ConfigurationManager.ConnectionStrings["my"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("INSERT INTO t2(fromtime,totime,description) VALUES(@fromtime,@totime,@description)"))
{
cmd.Connection = con;
cmd.Parameters.AddWithValue("@fromtime",drpstrattime.SelectedItem.Value );
cmd.Parameters.AddWithValue("@totime",drpend.SelectedItem.Value);
cmd.Parameters.AddWithValue("@description",txtdesc.Text);
cmd.ExecuteNonQuery();
con.Open();
cmd.ExecuteNonQuery();
Label1.Text = "succes..";
con.Close();
}
}

}

please help me for how to store two dropdown list and one text box value in database

Posted 17-Nov-15 0:59am

Member 12097108

Add a Solution

Comments

Gautham Prabhu K 17-Nov-15 7:10am

What is the going wrong? any error message you can share?

Member 12097108 17-Nov-15 8:04am

sir this is not my problem.I solve it again i did but it is not work

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Gautham Prabhu K · Answer 1 · 2015-11-17T01:12:00

Solution 1

From first inspection it looks like you executing query twice.
First time even before connection is opened to DB.

I think connection must be opened first the assigned to SqlCommand.

C#

cmd.ExecuteNonQuery();
con.Open();
cmd.ExecuteNonQuery();

Posted 17-Nov-15 1:12am

Gautham Prabhu K

HobbyProggy · Answer 2 · 2015-11-17T01:20:00

Please try putting a try{} catch(Exception ex) {} BLock around your SQL query.

like

C#

try{
    cmd.Connection = con;
    cmd.Parameters.AddWithValue("@fromtime",drpstrattime.SelectedItem.Value );
    cmd.Parameters.AddWithValue("@totime",drpend.SelectedItem.Value);
    cmd.Parameters.AddWithValue("@description",txtdesc.Text);
    cmd.ExecuteNonQuery();
    con.Open();
    cmd.ExecuteNonQuery();
    Label1.Text = "succes..";
    con.Close();
}
catch(Exception ex)
{
//Let the exeption be shown (use a message box or whatever :) )
}

then you can find the error way easier.
2nd thing is that i guess your program fails while the first executeQuery().

You have to open the connection before executing!
Also you will get a long back if it worked, i guess a not 0 is it worked.
then you can set the label to sucess if it worked and to false if it failed.(do this in the catch Block)

Debug your code and see if it jumps into the catch block, then please hand us the exeptionmessage.

What are you supposed to do with this?

C#

string constr = ConfigurationManager.ConnectionStrings["my"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("INSERT INTO t2(fromtime,totime,description) VALUES(@fromtime,@totime,@description)"))
{

would you mind commenting that out and just do it without the "using"
like this :

C#

string constr = ConfigurationManager.ConnectionStrings["my"].ConnectionString;
SqlConnection con = new SqlConnection(constr);

SqlCommand cmd = new SqlCommand("INSERT INTO t2(fromtime,totime,description) VALUES(@fromtime,@totime,@description)");

Just for a try.