kenomote

Hey guys ineed help on how to install or which is first to install using VS 2008 and MS SQL server & and IDE server management tool for MSSQL 2005

hey guys i need to know some of the techniques on how to shorten a very long query for example Dim SqlStatement As String = "INSERT INTO tblcenterlane(DESCRIPTION, UNIT, BEG, OT_KITCHEN, OT_F&B, OT_F.O., OT_S&M, OT_H.K., ADMIN, DEL, PULLOUT, SPOILAGE, ENDING, UNIT_COST, AMOUNT, VARIANCE, REMARKS, DEPARTMENT, DATE, DATE_DURATION_FROM, DATE_DURATION_TO, SUPPLIER_ID, CATEGORY) …

Hey guys im trying to display diffirent tables on 1 datagridview (ofcourse its one at a time only) so far it works everytime i change the datatable using listview for selecting now the problem is how do i insert data on it but only using a single form....each table have …

Hey guys how do you filter a datagridview with a the contents of a combo box? For example i have a combobox filled with categories. btw im using a MYSQL as database

hey guys i need some help on table values for example i have a table for books and it has two fields one is number of Copies and Number of Borrowed how do i subtract and add values to each fields for every single transaction on the same table?

hey guys i need some help on my code here.......... im trying to do some computation about the biling system or a library if the borrwer returns the book on time it will be no charge.......but if hte book is damage then it will charge him trice the ammount of …

Hey guys i need some help on how to save Values in My.Settings Two texboxes to save two different values and be albe to read those values or laod them when the program is oppned again...and also to be able to be replaced those values...

Any idea on how to Add dates based on the number inside the data tables? for example I set the limit of Days of books for borrwing it then i set the amount of fine that will generate if the the borrowed books is not returned IE: `DateNow * Value …

hey guys i need some help on my Search button It seems that it is not accepting the data on the cboSI.text which contains the Field Names of the Table Heres the Code: Private Sub cmdSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdSearch.Click Try Dim d3 As New …

Hey guys i need some help on how to Subtract the Dates i used a readline for sotring the number of fines per day on a txt file....now i wanted to know how do you subtrack the date the book borrowed and the date it was returned then multiplying the …

Hey guys its me again...im having some problems modifying the data in the DataGridView The error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where UserID='3'' at line 1 and it highlight this …

Hey guys i need some help on how to create a connection of a relationship between two forms...for example I have a DataGridView on another form....with a search button.. if i click the search button another window will pop out with a text box lable "Look For:" and a combobox …

Hey guys im having problem with the registration form that i created the error shows after i tried some error handling if the username already exists this is the error message: `{"Invalid attempt to Read when reader is closed."}` and this is the error highlight `While mydr.Read()` Heres my code …

Hey guys im having this error on my codes but seems to work on the other new projects it always highlight the .ExecuteNonQuery `{"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at …