how to add selected items in listbox to database every selected item to new record

Question

0.00/5 (No votes)

See more:

Hello

as title said

how to add selected multiple items in listbox to database every selected item to new record

i have listbox that bounded from database and i want to add every selected item to new record in sql server DB iam using C#

more explain i want every item that i select to insert to new row

this is my code but this insert the whole items in listbox

for (int indexCounter = 0; indexCounter < test_names.Items.Count; indexCounter++)
        {
            
           

            string patient_id = Request.QueryString["id"];
            SqlConnection cnm = new SqlConnection(ConfigurationManager.ConnectionStrings["lap_connection"].ConnectionString);
            SqlCommand cmd = new SqlCommand("INSERT INTO [tetstttt] (test_id,date,pname) VALUES ('" + test_names.Items[indexCounter] + "',N'" + DateTime.Now.ToString("yyyy-MM-dd") + "','" + patient_id + "');", cnm);
            cmd.Connection = cnm;
            cmd.CommandType = CommandType.Text;
            cnm.Open();
            cmd.ExecuteScalar();
            cnm.Close();
            ScriptManager.RegisterStartupScript(this, this.GetType(), "show_error", "showSuccess('Test Has Been Added Successfully',2000);", true);
        }

sorry for bad English

thanks in advanced

Posted 2-Feb-14 18:10pm

Abdullaziz Said

Updated 2-Feb-14 18:54pm

v3

Add a Solution

Comments

Rockstar_ 3-Feb-14 0:27am

What have you tried?

Rockstar_ 3-Feb-14 0:28am

Google.......
seems you need to insert data to database.

JoCodes 3-Feb-14 1:21am

IS test_id primary key for the table?Then any reason you are inserting test_id from the code? And specify whats the issue you are facing with the above code

4 solutions

Solution 4

hello

another thing iam trying to add more thank one filed but i get error

C#

foreach (ListItem lst in test_names.Items)
        {
            if (lst.Selected)
            {
                string selectedValue = lst.Value;
                string patient_id = Request.QueryString["id"];
                SqlConnection cnm = new SqlConnection(ConfigurationManager.ConnectionStrings["lap_connection"].ConnectionString);
                SqlCommand cmd = new SqlCommand("INSERT INTO [patient_test_data] (test_id,test_date,pat_id,data_id) VALUES ('" + selectedValue + "','" + DateTime.Now.ToString("yyyy-MM-dd") + "','" + patient_id + "');", cnm);
                cmd.Connection = cnm;
                cmd.CommandType = CommandType.Text;
                cnm.Open();
                cmd.ExecuteScalar();
                cnm.Close();
                ScriptManager.RegisterStartupScript(this, this.GetType(), "show_error", "showSuccess('Test Has Been Added Successfully',2000);", true);

            }
        }

this is the error that i got

There are more columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.

i don't know how to insert with this function

Posted 4-Feb-14 10:34am

Abdullaziz Said

Comments

CHill60 4-Feb-14 16:40pm

You have posted a comment as a solution. If you had done this before anyone had answered your question then it would have dropped out of the list of posts awaiting solutions and fewer people would have viewed it. As it is, this is really another question so you could have posted a new question, or used the Improve Question Link

Solution 5

In answer to the subsequent question regarding error

Quote:
There are more columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.

generated by the line

SQL

SqlCommand cmd = new SqlCommand("INSERT INTO [patient_test_data] (test_id,test_date,pat_id,data_id) VALUES ('" + selectedValue + "','" + DateTime.Now.ToString("yyyy-MM-dd") + "','" + patient_id + "');", cnm);

[Details given here as subsequent question posted as a solution and may disappear]

Your sql command INSERT INTO [patient_test_data] (test_id,test_date,pat_id,data_id) is expecting 4 values to be supplied. You have only supplied 3 of them...

test_id <= selectedValue
test_date <= Now
pat_id <= patient_id

data_id <= ????????????????

As an aside, when you are creating SQL commands be wary of the risk of SQL Injection Attacks - see this reference http://bobby-tables.com/[^]

Posted 4-Feb-14 10:46am

CHill60

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)

Praveen_P · Accepted Answer · 2014-02-02T19:28:00

Hope this will meet your requirement

C#

foreach (ListItem lst in test_names.Items)
       {
           if (lst.Selected)
           {
               string selectedValue = lst.Value;
               string patient_id = Request.QueryString["id"];
            SqlConnection cnm = new SqlConnection(ConfigurationManager.ConnectionStrings["lap_connection"].ConnectionString);
            SqlCommand cmd = new SqlCommand("INSERT INTO [tetstttt] (test_id,date,pname) VALUES ('" + selectedValue + "','" + DateTime.Now.ToString("yyyy-MM-dd") + "','" + patient_id + "');", cnm);
            cmd.Connection = cnm;
            cmd.CommandType = CommandType.Text;
            cnm.Open();
            cmd.ExecuteScalar();
            cnm.Close();
            ScriptManager.RegisterStartupScript(this, this.GetType(), "show_error", "showSuccess('Test Has Been Added Successfully',2000);", true);
              
} }</pre>

Karthik_Mahalingam · Accepted Answer · 2014-02-02T19:30:00

Solution 2

Try this

C#

for (int indexCounter = 0; indexCounter < test_names.Items.Count; indexCounter++)
       {
           if (test_names.Items[indexCounter].Selected)
           {

               string patient_id = Request.QueryString["id"];
               SqlConnection cnm = new SqlConnection(ConfigurationManager.ConnectionStrings["lap_connection"].ConnectionString);
               SqlCommand cmd = new SqlCommand("INSERT INTO [tetstttt] (test_id,date,pname) VALUES ('" + test_names.Items[indexCounter] + "',N'" + DateTime.Now.ToString("yyyy-MM-dd") + "','" + patient_id + "');", cnm);
               cmd.Connection = cnm;
               cmd.CommandType = CommandType.Text;
               cnm.Open();
               cmd.ExecuteScalar();
               cnm.Close();
               ScriptManager.RegisterStartupScript(this, this.GetType(), "show_error", "showSuccess('Test Has Been Added Successfully',2000);", true);
           }
       }

Posted 2-Feb-14 19:30pm

Karthik_Mahalingam

Comments

Praveen_P 3-Feb-14 1:36am

gud , 5 !

Karthik_Mahalingam 3-Feb-14 1:40am

:)

Siva Hyderabad 3-Feb-14 4:58am

Hai karthik,busy na?

Karthik_Mahalingam 3-Feb-14 5:26am

tell me

Siva Hyderabad 3-Feb-14 6:01am

I have an exception..It's comes no:of times...

Siva Hyderabad 3-Feb-14 6:05am

Data Table retrives another Datatable information..It's an live application..what's wrong in my code..I don't know..It's exception shows every page..in my application

Karthik_Mahalingam 3-Feb-14 6:57am

post a question and give me that link.
I know Tamil,Kanada

Siva Hyderabad 3-Feb-14 7:05am

It's a crediential site..user should username,pwd

Karthik_Mahalingam 3-Feb-14 7:06am

what is your issue ?
post a question

Siva Hyderabad 3-Feb-14 7:09am

Data Table retrives another Datatable information..It's an live application..what's wrong in my code..I don't know..It's exception shows every page..in my application

Siva Hyderabad 3-Feb-14 7:13am

No error in my project..It's working fine Sometime...some time shows different different exceptions shows..DataTable get another DataTable Information..

Karthik_Mahalingam 3-Feb-14 7:16am

is it dynamic operation ?

Siva Hyderabad 3-Feb-14 7:21am

It's a Polutry based Project..we entered daily details in my application..

Siva Hyderabad 3-Feb-14 7:25am

observe this code..

if (HttpContext.Current.User != null)
{

if (Session["username"] != null)
{
string pageName = Page.Page.AppRelativeVirtualPath.Substring(Page.Page.AppRelativeVirtualPath.LastIndexOf('/') + 1);
DataTable dtFeatures2 = new DataTable();
dtFeatures2.Clear();
////da = new SqlDataAdapter("Exec Sp_GetUserModuleFeatures '" + Session["UserType"].ToString() + "'", con);
////da.Fill(dtFeatures);
objMatermenuPL.usertype = Session["UserType"].ToString();
dtFeatures2 = objMastermenuBAL.GetMastermenu(objMatermenuPL);

DataView dt = new DataView(dtFeatures2);
dt.Sort = "fld_feature ASC";

if (dtFeatures2 != null)
{
foreach (Control control in leftpanel.Controls)
{
Type ty = control.GetType();
if (ty.Name.ToUpper() == "HTMLANCHOR")
{
int i = dt.Find(control.ID.Substring(3));
if (i < 0 && control.ID.Contains("lnk"))
control.Visible = false;
if (control.ID.Contains("lnk") && control.ID.Substring(3) + ".aspx" == pageName)
{
HtmlAnchor a = (HtmlAnchor)control;
a.Attributes.Add("class", "active");
}
}
}
}

}
}
else
{
Response.Redirect("~/Login.aspx");
}

Siva Hyderabad 3-Feb-14 7:34am

http://www.codeproject.com/Questions/720287/DataTable-Gets-another-DataTable-Information

see this Link..I posted my question

Karthik_Mahalingam 3-Feb-14 9:28am

check my solution..

Karthik_Mahalingam 3-Feb-14 8:14am

ok i wil check in 20 mins
moving to home now...

how to add selected items in listbox to database every selected item to new record

4 solutions

Solution 1

Solution 2

Solution 4

Solution 5

Add your solution here

Preview 0

Existing Members

...or Join us