Search results

  1. J

    Problem w/Function.. PLEASE HELP

    Thanks for your responses.... It does need to be intFac * i NOT intFac * 1 :o) Lol, yesterday was a long day guys.. thanks for the quick help!
  2. J

    Problem w/Function.. PLEASE HELP

    I am writing a simple code using a function to return a value. When I run the code, the function always returns one, therefore giving me a logical error. Any and all help is appreciated... Thank you!! Here is the code: Private Function Factorial(ByVal intNumber As Integer) As Integer...
  3. J

    Manipulating Dates.. Please help!!

    I am trying to develop a scheduling system that allows users to have a recurrence pattern. For example, a user may pick Jan 1 as start date, and Feb 5 as end date, and specify they only want to rent the facility on wednesdays. Therefore, I am trying to start this program by determining the...
  4. J

    Date manipulation w/Date TimePickers

    I am trying to develop a scheduling system that allows users to have a recurrence pattern. For example, a user may pick Jan 1 as start date, and Feb 5 as end date, and specify they only want to rent the facility on wednesdays. Therefore, I am trying to start this program by determining the...
  5. J

    Writing to Access w/VB.NET

    Thanks a million! I never would of figured that out... lol. Maybe I can return the favor one day!
  6. J

    Populate Listbox on clicking a value in combobox

    cmdInsert.Parameters.Add(New SqlParameter("@TNames", SqlDbType.Char, 20, "TName")) 'cmdInsert.Parameters("@TNames").Value = txtTeamName.Text
  7. J

    Writing to Access w/VB.NET

    Can someone please tell me how to establish a connection to an Access DB from a vb.net form. I have tried to do this from server explorer, but I don't have the option to select MS ACCESS. I get sql server, oracle, and several other options, but Access isnt one of them. Thank you in advance!
  8. J

    Populate Listbox on clicking a value in combobox

    create a stored procedure. create variable in stored procedure Create Procedure procgetbooks @publication as varchar as "Select * from mytable where publication = @publication" in vb code do this dim cmd as sqlcommand = sqlconnection1.createcommand cmd.type = storedprocedure cmd.text =...
  9. J

    Populate Listbox on clicking a value in combobox

    There are different ways to populate the list box, and I am not sure if yours is correct. try this sqldatadapter.fill(dataset1, "Books") 'Bind listbox with lbName .datasource = dataset1 .displaymember = "books.id" .valuemember = "Books.id" end with 'you also have to filter the sql statement...
  10. J

    Disable Right click in DataGrid

    An odd, and most likely not the best solution is to use the x/y coordinate system to disable the context menu. then set the mouse down event to mean the right mouse button and do nothing. handles mybase.mousedown if e.x = area of grid and e.y area of grid then disable context menu Sorry...
  11. J

    SQL Server/Date &Time conversion for vb.net

    nevermind... i figured it out.. thanks btw, i used the convert function
  12. J

    SQL Server/Date &Time conversion for vb.net

    Hello all! I am trying to pull the time- hour/minutes out of a sql server query. When I attempt this.. I keep getting errors Select datepart(hh:mm, time1) From Table1 I have put the hh and mm in "hh:mm", 'hh:mm', and all types of variatons, but it keeps giving me errors. Any help with...
  13. J

    Scheduling System: VB.NET/SQL Server

    That did it! Hey, thanks a lot man... your help was greatly appreciated!
  14. J

    search functions

    Just a quick thought, you need a comma/" between your select and from statement in the sql command.
  15. J

    Scheduling System: VB.NET/SQL Server

    Actually, that is where my problem lies... I am new to VB and don't know how to search a dataset and check for any conflicts. If you could help with that, it would be greatly appreciated. Thank you!
  16. J

    Scheduling System: VB.NET/SQL Server

    I am working on a program that will be used to check out company vehicles. Users will go online and pick out their vehicle, dates, times, etc. The problem I am having is this: When the user clicks submit, how can I search the dataset to ensure that a vehicle is not going to be reserved by two...
Top Bottom