ASP.NET

FirstPrevNext

Re: how to compute two dateTime on postback bernie_0111-May-07 22:25 bernie_011 1-May-07 22:25  How can i insert all the items in listbox into the database? multiple insert. I can get all the items but its just inserting 1 row in that category. drpcategory : Agent,Trainees drpNames : Bernie, Ray,Kirby,John,Beejay list1 : contains all the selected items on drpNames table1 : my table in my database my query now is INSERT INTO table1(Category,Name)VALUES(@category,@name) If list1box1 contains all the items from drpnames and i select "Agent" category on my drpcategory and i click the button insert, all the 4 items will be inserted in my database table(table1) on a single click. Can you help me with that? I am using detailsView and SQLdatasource Bernie Leynes Re: how to compute two dateTime on postback Chetan Ranpariya1-May-07 22:28 Chetan Ranpariya 1-May-07 22:28  Hi, If you are creating seperate row for each of the item in the listbox then you have to loop through all the items and create intsert query in the loop and execute it. Thanks and Regards, Chetan Ranpariya Re: how to compute two dateTime on postback bernie_0111-May-07 22:38 bernie_011 1-May-07 22:38  it works fine if i use dropdownlist, but in dropdownlist you will insert the data in the database individually right?. I want to use listbox for me to insert all the data in a single click of the button. God Bless you! Bernie Leynes Re: how to compute two dateTime on postback Chetan Ranpariya1-May-07 22:40 Chetan Ranpariya 1-May-07 22:40  HI, I am not getting you exact requirement. Can you pelase elaborate by giving an example? Thanks and Regards, Chetan Ranpariya Re: how to compute two dateTime on postback bernie_0111-May-07 22:58 bernie_011 1-May-07 22:58  ok. heres my example I have 2 dropdown and a listbox and a table in my database drpcategory drpNames listbox1 table1- the columns are Category,Name I have items in drpcategory. the items are: Agent, Trainees In my drpNames the items are : Bernie, Ray, Kirby listbox1.items= drpNames.selecteditem.text If my listbox1 contains all the names from drpNames and i select "Agent" from drpCategory then i click insert button all the 3 names on my listbox will be inserted but different row. The result will be Category Name Agent Bernie Agent Ray Agent Kirby My problem is even if i have multiple items in my listbox then after i click insert int only insert 1 row in my table which is the first row only Bernie Leynes Re: how to compute two dateTime on postback Chetan Ranpariya1-May-07 23:09 Chetan Ranpariya 1-May-07 23:09  hi, See in this case the solution is what I have told you before. U have to loop through all the items in the listbox and create INSERT query for each of the item and execute it. Can u send the code you have written? Thanks and Regards, Chetan Ranpariya Re: how to compute two dateTime on postback bernie_0111-May-07 23:29 bernie_011 1-May-07 23:29  listbox1.items = drpNames.selecteditem.text this is how i get the items from dropdown and display in listbox. How can i Loop all the items from listbox? If i do looping it will insert all the items from listbox in my table in the database? Bernie Leynes Re: how to compute two dateTime on postback Chetan Ranpariya1-May-07 23:36 Chetan Ranpariya 1-May-07 23:36  Hi, The onel line of code u have given will not execute coz it will give compile time error. yes i u loop through all items in the listbox it will all the items from the listbox in the table in database. how do u try to insert data in the table in you database? Please paste your code here. Thanks and Regards, Chetan Ranpariya Re: how to compute two dateTime on postback bernie_0111-May-07 23:40 bernie_011 1-May-07 23:40  Heres my code.. INSERT INTO table1(category,Name)VALUES(@category,@name) category bind to drpcategory name bind to listbox1 You are blessed men. Thanks Bernie Leynes Re: how to compute two dateTime on postback bernie_0113-May-07 23:49 bernie_011 3-May-07 23:49  I know you know how to do that man. Please help me.. Thanks and God Bless Bernie Re: how to compute two dateTime on postback Chetan Ranpariya6-May-07 23:57 Chetan Ranpariya 6-May-07 23:57  HI, I have asked you to paste your whole code here. but I dont think you want to do that. You are just pasting one or two lines and want me to do everything for you. Things doesnt happen like that. If you want to insert values from the listbox the commong logic is that you take items from the listbox one by one and create insert query for each of the item and execute the query. foreach(ListItem LI in lstbox.Items) { string strquery = "Insert Into table Values ('" + ddl.SelectedValue + "', '" + LI.Value + "')"; cmd.executenonquery(strquery); } THis is the commong logic. You implement this as per your requirement. If any further assistance is needed then do reply with the whole code u have written to insert the data in the table. Thanks and Regards, Chetan Ranpariya Re: how to compute two dateTime on postback bernie_0117-May-07 0:16 bernie_011 7-May-07 0:16  im sori but i am using SQLDataSource thats why i have only one line of Code. I just bind the listbox on my textfield. I did not use the manual connection in code behind. Any idea about that?. I already check the multiple selection but still insert 1 data per transaction thank you Bernie Exam Application bernie_0119-May-07 20:35 bernie_011 9-May-07 20:35  hi again, do you have any idea on how to create exam application in asp.net 2.0 web app? Bernie How to find the number of parameters in a Store procedure kashasd22-Apr-07 21:05 kashasd 22-Apr-07 21:05  I have a problem in finding how many number of input parameters available in a Store procedure Please help me Thank you Kishore Kumar Manikonda kishore kumar Manikonda Cut Space Socheat.Net22-Apr-07 20:58 Socheat.Net 22-Apr-07 20:58  I have one string "Hello World" I want cut space to like that "Hello World", please help me Thanks ................ Re: Cut Space Chetan Ranpariya22-Apr-07 21:03 Chetan Ranpariya 22-Apr-07 21:03  Not able to get your problemm Thanks and Regards, Chetan Ranpariya Re: Cut Space Socheat.Net22-Apr-07 21:07 Socheat.Net 22-Apr-07 21:07  You it contain many space with it u can view it, it like that "Hello World" ................ ASPNET_PROFILE bernie_01131-May-07 0:22 bernie_011 31-May-07 0:22  hi, i am using CreateUser Wizard to add user information in aspnet_profile table like firstName,lastName etc. but all data are stored in one propertyvaluesString. How can i add column like lastName and insert the lastName value to lastName column Thanks Bernie Re: Cut Space kashasd23-Apr-07 2:25 kashasd 23-Apr-07 2:25  I think my question is not clear to u Assume that we have 10 Store procedures in a database and we only knows names of Store procedures only, Each SP is having its own number of input parameters depends on it requirements i wnat to write a code.... To find the number of input parameters in each SP Thank you kishore kumar Manikonda Software Developer Re: Cut Space Guffa23-Apr-07 9:31 Guffa 23-Apr-07 9:31  I think that you are truly confused. You are replying to people who didn't reply to your question. --- single minded; short sighted; long gone; Re: Cut Space Sathesh Sakthivel22-Apr-07 21:06 Sathesh Sakthivel 22-Apr-07 21:06  Clearly explain what is your problem. There is no difference in your mentioned word of "Hello World". Regards, Satips. Re: Cut Space Socheat.Net22-Apr-07 21:12 Socheat.Net 22-Apr-07 21:12  The string like that "Hello           World", please help me, I want it become like this "Hello World" Thanks Socheat ................ Re: Cut Space Guffa22-Apr-07 21:18 Guffa 22-Apr-07 21:18  Use the Regex.Replace method to replace multiple spaces (pattern = " {2,}") with a single space. --- single minded; short sighted; long gone; Re: Cut Space Socheat.Net22-Apr-07 21:20 Socheat.Net 22-Apr-07 21:20  But i currently using ASP, show how can i? Regard Socheat ................ Re: Cut Space Guffa22-Apr-07 22:38 Guffa 22-Apr-07 22:38  As you asked in the ASP.NET forum, I assumed that you were using ASP.NET. In ASP you can use the RegExp object. As you haven't said what language you are using, I assume that you are using VBScript. Example: With New RegExp .Pattern = " {2,}" .Global = True text = .Replace(text, " ") End With --- single minded; short sighted; long gone;

Last Visit: 31-Dec-99 18:00     Last Update: 4-May-24 22:15 Refresh ᐊ Prev1...5047504850495050505150525053505450555056 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.