Insert value of 2 dynamic dropdown list and 1 texxtbox value in sql server 2008 database

Question

0.00/5 (No votes)

See more:

Hello Everybody..
I will ask this question two time because i dont get proper answer.
please help me for this.
I have two button 1 is for Add Row(2 dropdown List,1 Textbox) and second for save button for saving this value in sql server database.
when I click on Add button then 2 dynamic and 1 textbox added in aspx page.that is i done.but when i click on save button that time this value cant store in table.
please give me right code for it.

Posted 18-Nov-15 22:42pm

Member 12097108

Add a Solution

Comments

Manoj Sawant 19-Nov-15 5:06am

Can you upload your code

Member 12097108 19-Nov-15 5:13am

yes sure sir

Member 12097108 19-Nov-15 5:17am

protected void lbtnaddrow_Click(object sender, EventArgs e)
{
Table tbldynamic = new Table();
TableCell tc = new TableCell();
TableCell tc1 = new TableCell();
TableRow tr = new TableRow();

for (int j = 0; j <= i; j++)
{
DropDownList drpstart = new DropDownList();
drpstart.ID = j.ToString();
drpstart.Items.Add(new ListItem("8:00 AM"));
drpstart.Items.Add(new ListItem("8:30 AM"));
drpstart.Items.Add(new ListItem("9:00 AM"));
drpstart.Items.Add(new ListItem("9:30 AM"));
drpstart.Items.Add(new ListItem("10:00 AM"));
drpstart.Items.Add(new ListItem("10:30 AM"));
drpstart.Items.Add(new ListItem("11:00 AM"));
drpstart.Items.Add(new ListItem("11:30 AM"));
drpstart.Items.Add(new ListItem("12:00 PM"));
drpstart.Items.Add(new ListItem("12:30 PM"));
drpstart.Items.Add(new ListItem("1:00 PM"));
drpstart.Items.Add(new ListItem("1:30 PM"));
drpstart.Items.Add(new ListItem("2:00 PM"));
drpstart.Items.Add(new ListItem("2:30 PM"));
drpstart.Items.Add(new ListItem("3:00 PM"));
drpstart.Items.Add(new ListItem("3:30 PM"));
drpstart.Items.Add(new ListItem("4:00 PM"));
drpstart.Items.Add(new ListItem("4:30 PM"));
drpstart.Items.Add(new ListItem("5:00 PM"));
drpstart.Items.Add(new ListItem("5:30 PM"));
drpstart.Items.Add(new ListItem("6:00 PM"));
drpstart.Items.Add(new ListItem("6:30 PM"));
drpstart.Items.Add(new ListItem("7:00 PM"));
drpstart.Items.Add(new ListItem("7:30 PM"));
drpstart.Items.Add(new ListItem("8:00 PM"));
drpstart.Items.Add(new ListItem("8:30 PM"));
drpstart.Items.Add(new ListItem("9:00 PM"));
drpstart.Items.Add(new ListItem("9:30 PM"));
drpstart.Items.Add(new ListItem("10:00 PM"));
drpstart.Width = 150;
tc1.Controls.Add(drpstart);
tr.Cells.Add(tc);
tr.Cells.Add(tc1);
tbldynamic.Rows.Add(tr);
// PlaceHolder1.Controls.Add(drpstart);

DropDownList drpend = new DropDownList();
drpend.ID = j.ToString();
drpend.Items.Add(new ListItem("8:00 AM"));
drpend.Items.Add(new ListItem("8:30 AM"));
drpend.Items.Add(new ListItem("9:00 AM"));
drpend.Items.Add(new ListItem("9:30 AM"));
drpend.Items.Add(new ListItem("10:00 AM"));
drpend.Items.Add(new ListItem("10:30 AM"));
drpend.Items.Add(new ListItem("11:00 AM"));
drpend.Items.Add(new ListItem("11:30 AM"));
drpend.Items.Add(new ListItem("12:00 PM"));
drpend.Items.Add(new ListItem("12:30 PM"));
drpend.Items.Add(new ListItem("1:00 PM"));
drpend.Items.Add(new ListItem("1:30 PM"));
drpend.Items.Add(new ListItem("2:00 PM"));
drpend.Items.Add(new ListItem("2:30 PM"));
drpend.Items.Add(new ListItem("3:00 PM"));
drpend.Items.Add(new ListItem("3:30 PM"));
drpend.Items.Add(new ListItem("4:00 PM"));
drpend.Items.Add(new ListItem("4:30 PM"));
drpend.Items.Add(new ListItem("5:00 PM"));
drpend.Items.Add(new ListItem("5:30 PM"));
drpend.Items.Add(new ListItem("6:00 PM"));
drpend.Items.Add(new ListItem("6:30 PM"));
drpend.Items.Add(new ListItem("7:00 PM"));
drpend.Items.Add(new ListItem("7:30 PM"));
drpend.Items.Add(new ListItem("8

Member 12097108 19-Nov-15 5:17am

protected void LinkButton2_Click(object sender, EventArgs e)
{
String str = string.Empty;
DropDownList drpstarttime = (DropDownList)PlaceHolder1.FindControl("drpstart");
DropDownList drpendtime = (DropDownList)PlaceHolder1.FindControl("drpend");
TextBox txtdesc = (TextBox)PlaceHolder1.FindControl("txtdesc");

string constr = ConfigurationManager.AppSettings["Main.ConnectionString"];
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("INSERT INTO t2(StartTime,EndTime,TaskDescription) VALUES(@StartTime,@EndTime,@TaskDescription)"))
{
cmd.Connection = con;
cmd.Parameters.AddWithValue("@StartTime", drpstarttime.SelectedItem.Value);
cmd.Parameters.AddWithValue("@EndTime", drpendtime.SelectedItem.Value);
cmd.Parameters.AddWithValue("@TaskDescription", txtdesc.Text);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
}

Manoj Sawant 19-Nov-15 5:30am

Are you getting any error there??

Member 12097108 19-Nov-15 6:06am

Object reference not set to an instance of an object. this error.
suppoes sir,
Add_click Event
{
TextBox t1=new TextBox();
t1.Id="t1";
PalceHolder.Controls.Add(t1);
}
this code in add button click event
now i want to that value of t1 textbox i want to store in database
for that i wil wrigth code like this
Save_click Event
{
TextBox txtdesc = (TextBox)PlaceHolder1.FindControl("t1");
}

but here txtdesc get null value insted of i want t1 value.so how can i fecth t1 value plz give me right code for that.

Naveen.Sanagasetti 19-Nov-15 7:37am

As per error, you are trying to access null value, so that only you are getting this error. My suggestion is debug the code and check in which line you got this error and check whether it contains value or not?

Manoj Sawant 19-Nov-15 6:48am

Here you are just giving the id to textbox.
t1.id="t1";
t1.Text=txtdesc.Text;

Try this

Member 12097108 19-Nov-15 7:02am

even i dont get it

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)