how to pass tables field name in insert commamd of sql when selected from checkedlistbox in C#

Question

0.00/5 (No votes)

See more:

how to pass tables field names in insert commamd of sql which was selected from checkedlistbox in Window Form application using C#

Explanation---

I want to use insert query to insert some values in particular table.But the field names of that table was selected from CheckedListBox...

insert into Tablename(??????????)values()

Instead of ? ihave to select the field names from Checkedlistbox....
Plz help....

Posted 19-Feb-13 23:17pm

akrati shakya

Add a Solution

Comments

CHill60 20-Feb-13 5:40am

You're really going to insert a row onto your table with only 1 column completed? I think your table schema might need some attention. However, the sql command is just a string so you can build it up dynamically. What have you got so far? (i.e. post your code segment)

1 solution

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)

*Karthik Harve* · Answer 1 · 2013-02-19T23:48:00

Hi,

you can go for dynamic SQL queries.
prepare the string like below.

C#

string strQuery = "INSERT INTO TableName(";
int count =0;
foreach(object itemChecked in checkedListBox1.CheckedItems)
{
    strQuery += itemChecked.ToString();  //column names from the checked list
    count++;
    if(checkedListBox1.CheckedItems.Count > count)
        strQuery += ","; 
}
strQuery += ")VALUES(";
for(int i =0;i<checkedlistbox1.checkeditems.count; i++)
{
    if(i != 0)
        strQuery +=",";
    strQuery += "Value " + i.ToString(); // your values to the table
}

send that string to stored procedure and in the procedure execute the query like below.

SQL

EXEC(@Query)
--Where @Query would be input parameter

refer links below for more on dynamic sql.
Execute Dynamic SQL commands in SQL Server[^]
Dynamic SQL[^]

hope it helps.