Search results for query: *

Whats wrong with my code? When a new book is added it doesnt give error BUT the sequence is not incremented if a same booktitle is entered. I have three columns(author, booktitle, sequence). Sequence should increment if book with same title is added. But with my codes it doesnt. Protected Sub...

I solved this problem by trial and error(since im still new to asp.net). I just enclosed all my codes in the Page_Loads into a : If Not Page.IsPostBack Then ........my codes on page load.......... End If Thanks.

thanks for answering. I still have the same problem (data is not updated eventhough there are no errors in running the code)

Why is it that when i run this codes i get no errors (Label states that account is updated) BUT in reality at the database side no changes occurs at the data. ID is displayed in a label everytime the page loads. Thanks in advance. Dim DBConn As New Data.SqlClient.SqlConnection("DATA...

Can you please show me where am i gonna insert the increment code. DBCmd = New Data.SqlClient.SqlCommand("SELECT COUNT(*) FROM Books WHERE Name = @Name)", DBConn) DBCmd = New Data.SqlClient.SqlCommand("INSERT INTO BOOK (TITLE, AUTHOR, PUBLISHER) VALUES (@TITLE, @AUTHOR, @PUBLISHER)"...

I want that number_of_books column will automatically increment by one if same book title is entered. otherwise, if no book with same title exist in the database the number_of_books column data will be one (also automatically). thanks

I have a book entry page design in asp.net 2.0, I can already add a new row to the database table by having to enter details of the book into textboxes and then clicking a button. My problem is, i want the design to automatically increase the number of books (NUMBER_OF_BOOKS column) whenever a...

How do you make loading from database into a listbox (located in the web form) much faster. Lets say 30,000 rows with only one column being displayed on the listbox. The details are loaded into the listbox during the loading of the page. From my computer, it has been very slow. About 1 min. to...

Can anyone help me please on on how to start with this project. when clicking on the listbox (displayed with a column data from a database table) the data details will be displayed on textboxes just beside the listbox. Protected Sub ListBox1_SelectedIndexChanged(ByVal sender As Object, ByVal...

i've tried your code and it gave no more errors. Thanks. but the data in the database is not updated. Is there something that i miss.

Can anyone help me please on on how to start with this project. when clicking on the listbox (displayed with a column data from a database table) the data details will be displayed on textboxes just beside the listbox. Protected Sub ListBox1_SelectedIndexChanged(ByVal sender As Object...

Can any body please tell me what does this error mean. System.FormatException: Failed to convert parameter value from a String to a Int32. ---> System.FormatException: Input string was not in a correct format. at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer&...

Please can you show me the code on how to do it. Im sorry, its just that im still on the learning stage with regards to this technology.

thank you There are no more errors when i click the delete button but the data is not deleted in the listbox and in the database. the data is still displayed in the listbox. Can you also help me with populating the data from listbox to textbox when i click the listbox since i can only display...

I have an error in my code which states: System.Data.SqlClient.SqlException: Conversion failed when converting the varchar value '(ListBox1.SelectedValue.ToString)' to data type int. at System.Data.SqlClient.SqlConnection Can anyone help me why this is happening. im using web developer express...

ive tried using your code but the data is not deleted on the database when i click the delete button. there were no errors though. also the data is still displayed in the listbox. By the way thanks.

I have an error in my code which states: System.Data.SqlClient.SqlException: Conversion failed when converting the varchar value '(ListBox1.SelectedValue.ToString)' to data type int. at System.Data.SqlClient.SqlConnection Can anyone help me why this is happening. im using web developer...

I have already this listbox that displays data from database whenever a page is loaded. My problem is that i want to display the remaining details of that data whenever i click a data in the listbox(ListBox1_SelectedIndexChanged). Please can anyone help me on this. Below is my starting code...

I have an error in my code which states: System.Data.SqlClient.SqlException: Conversion failed when converting the varchar value '(ListBox1.SelectedValue.ToString)' to data type int. at System.Data.SqlClient.SqlConnection Can anyone help me why this is happening. im using web developer express...

I am having problem in databinding my listbox to a textbox. My application is about data entry. I can already list the details in the listbox when the page loads. My problem is when i choose a data in the listbox i cannot display the details on the textboxes. Can i also update, delete or add...