Comments by bunzitop (Top 22 by date)

i was not giving justification! actually i was harassed by the problem . I have improved my question. Please help me

It works finely in my laptop when connected to internet toooo.. just in client's pc it doesn't work. For few weeks it worked and today it threw error message

SELECT category_name FROM SubCategory a INNER JOIN Category b ON a.ID = b.ID

USE IT
previously there was IINER in place of INNER

simple management software!!! it finely works in my laptop when internet is on
i hav vs 2010 installed in m laptop.
but when i try to open in client's pc with internet connection on throws error messge

yes i have checked with debugger and the count is two and its right beacause i have inserted two items but when retrieving i only get last inserted item

DataTable dt = new DataTable();
foreach (ListViewItem item in listView1.Items)
{
table.Columns.Add(item.ToString());

foreach (var it in item.SubItems)

dt.Rows.Add(it.ToString());
}
I tried this
but didnt meet my requirement.
sorry for not posting my code
the above code inserted row as column of table and column as row of list view

DataTable dt = new DataTable();

foreach (ListViewItem item in listView1.Items)

{

table.Columns.Add(item.ToString()); //For adding column namescol

foreach (var it in item.SubItems) //For adding row values

dt.Rows.Add(it.ToString());

}

i have already stated with my problem,
i have a listview and my requirement is to load the listview items to datatable
hope you have understood my problem

suppose i kept the connection outside loop, then will it be standard form of codding and efficient way of coding ??? will my code perform high??

can u tell me how to append condition in existing sqlcommand

i want to check as


if(combobox1.text!="")
{
here i want to replace and 1=1
}
if(combobox2.text!="")
{
here also i want to replace second 1=1 with "and value= '"+combobox.value+"'
}


simiilarly for others
finally '
my command will be
SE:ECT * FROM TABLENAME WHERE 1=1 +(and followed by ONLY the selected values of select combobox )

i am currently using the code you suggested as
commandtext = "Select * From TableName Where columnvalue = '" + combobox.value + "'";

but my requirement is to filter the database according to the value of combobox.
if i have 4 combobox then it will have 16 possibilites to filter the database

but if i wrote the original code as
commandstring = "SELECT * FROM TABLENAME WHERE 1=1 and 1="

replaced the value "and 1=1 " with "and value = '"+combobox.value+"' "
then i will be more dynamic
sp i dont have to check each combobox if it is blank or not..

yes you are totally right! i agree with you
but i showed above example because if he wants to save string value from checkBox instead of boolean value,
My solution is not final solution, the solution is dependent on his requirement
thanks for comment :)
regards
bunzitop

Please make your question clear, If possible share your code so our geeks can make some correction in your real application

Do you want to save the data on the check event of checkBox or you want to save the value of checkBox into database, plz make it clear/

Thank you for your kind help.
your code gets all the items to variable, its good but my requirement is
i need to get all the values of items of listview through a loop and pass it as parameter of SP. suppose i have 10 rows in my listview, and i need to insert all those rows in DB through Sp which is in class purchase, how to manage a loop for this?? this is my confusion.
waiting for reply asap.
regards
bunzitop

when i passed parameters (values other than from listview) to sp in purchase it worked properly