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

Hi, I am using Create User Wizard for membership. How can i add some fields like "FirstName" and "LastName" in CreateUser Wizard and Store it in Aspnet_Profile or in the other table. I want also to store userName and password in "Members" table. Thank you and God Bless! Bernie

hi again, do you have any idea on how to create exam application in asp.net 2.0 web app? Bernie

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

I know you know how to do that man. Please help me.. Thanks and God Bless Bernie

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

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

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

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

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

i got it..Thank yo very much i used DIM something like that. God Bless you boy.. Ahh.. I have another question, How can i insert multiple items from listbox in my table in database? I have a category "Agents" on dropdownlist, I have may names on my listbox, If i click Insert it only insert 1 row not all the items inside my listbox. Bernie

Can you please do the code in visual basic not in C# code? Thanks and God Bless! Bernie

i have 2 time dropdownlist, frmdrp and todrp, i just add collection to dropdown which is 8:30,9:00,9:30,10:00(completed to 24 hours) For example i have selected 8:30 from the frmdrp then i select 12:30 from todrp. After postback, the label will show the difference between the two time selected. The result is: label1="4" hour difference. Can you help me with that? Bernie

Hello programmers, Any idea how to compute two time value in two textbox and display in label? Bernie

hi i have two dates in my table, 03-23-2007 8:00:00 03-24-2007 8:00:00 I have two dropdown in my page use to filter between those two dates. i used to convert the two dates into CHAR CONVERT(CHAR(10),date,110) so the result is just "03/23/2007" and "03/24/2007" but the problem now is, when i filter the date like SELECT * FROM table WHERE date BETWEEN '03/23/2007' and '03/23/2007' returns no value but if my query is like : SELECT * FROM table WHERE date BETWEEN '03/23/2007' and '03/24/2007' it returs value but only the rows with the date '03/23/2007'. Any idea about that? Bernie

my report viewer is working project preview, but when i deploy it in IIS it does not work. but by the way lets forget about that. I am downloading SSRE, it has reporting options. ' I have questions about dateTime, my date Format is 2007-MARCH-23 yyyy-MONTH-dd, I have 3 dates 2007-MARCH-23,2007-MARCH-24 and 2007-APRIL-01, i have query using BETWEEN, SELECT * FROM table1 WHERE date BETWEEN '2007-MARCH-23' AND '2007-APRIL-01' but it returns no rows, but if my query is SELECT * FROM table1 WHERE date BETWEEN '2007-APRIL-01' AND '2007-MARCH-24' it returns the rows. Base on my query SELECT MAX(date),MIN(date) FROM table1, '2007-APRIL-01' is the minimum. any idea about that?. How can i have between queries? Bernie

i found the solution friend. I put the data item in header or footer not in "details" and it works. my problem now is when i deploy it on IIS, the reportViewer does not work. Bernie

i have deployed my program in IIS, my report viewer works on my project but when i deployed it on IIS error was display, An error occurred during local report processing. The definition of the report 'Main Report' is invalid. The report definition is not valid. Details: Data at the root level is invalid. Line 1, position 1. Any idea about this? thank you very much.. Bernie

Hi, I have a report viewer, I have tables on my report. I set the hideDuplicates to my dataSet, It hides the data but still adding row on below, any idea about that?. I dont want to display row without data below in my table Thanks Bernie

I set the page size to 10000 but it doesnt show the pager, I got some error in pre render event. null reference. My gridview is controlled by dropdown Bernie