Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: asafb
  • Order by date
  1. asafb

    DataReader Specific Value

    hello boudlerbum, thank you, but can you give me that code in vb.net not c? thanks asaf
  2. asafb

    DataReader Specific Value

    ...string1 = Help!!! strConn = "server=x;" _ & "database=x;user id=x;pwd=x" Dim MySQL as string = "SELECT * FROM products" Dim MyConn as New SQLConnection(strConn) Dim objDR as SQLDataReader Dim Cmd as New SQLCommand(MySQL, MyConn) MyConn.Open()...
  3. asafb

    Finding a value that is not NULL

    Hello Marty. Let me explain. I revised it now slightly. I want the datareader to retrieve this command SELECT * from products where specialtag = 1 and idproduct = " & randomnumber. Now, i want this: If the randomnumber retrieves no record, then randomize again until the randomnumber that is...
  4. asafb

    Finding a value that is not NULL

    Hi marty i get syntax error says "position" not declared ort something
  5. asafb

    Finding a value that is not NULL

    ...RANDOMIZE LowestNumber = 4 HighestNumber = 39 RandomNumber = Int((HighestNumber-LowestNumber+1)*Rnd+LowestNumber) Dim CommandText As String = "SELECT * FROM products WHERE idproduct = " & randomnumber Dim myConnection As New...
  6. asafb

    Binding a text box control to data

    ...<select id="agentnamebox" style="FONT-SIZE: 8.6pt; FONT-FAMILY: Verdana" runat="server"> </select> </form> </body> </html> ******* Now I want to add a textbox control which will take the source from a sql statement like: select price from prices where id = 5.... thanks!
  7. asafb

    Combo Box Data Bind

    Hello, I'm having problems databinding a combobox. Code: <%@ Page Language="VB" %> <%@ import Namespace="System.Data" %> <%@ import Namespace="System.Data.SqlClient" %> <script runat="server"> Function GetPriceBracket() As System.Data.DataSet Dim connectionString As String...
  8. asafb

    get current date

    Thanks Jennifer it worked! you're the best! :)
  9. asafb

    get current date

    hello how do i retrieve the current date and pass it tried date() doesn't work tried cdate(thedate) but get syntax error 12:00:00 a.m. i want short date format 08/08/2004
  10. asafb

    Retrieve Last Record

    Hello, I have a datagrid which is bounded using the databind feature. The SQL is SELECT * FROM customers for example, and it shows a beautiful grid! Now, I want it to display just teh LAST row from that table. How the heck do you do that in ADO.NET / ASP.NET land? With ASP classic, you do...
  11. asafb

    Update/Insert New Record asp.net

    ...a grid using the datagrid control or datalist, to the right you see a hyper link called "EDIT" when you hit "Edit", i want it to LITERALLY go to a *new* page where you see the form again, but this time the form shows the values of the record you're editing. I don't like the approaches I've...
  12. asafb

    Search Form

    Hi, I want to create a simple form for search. You have a text box control and a button. It should then go to the aspx page with my filtered results. in other words, set the source.. any quick ways? ab
  13. asafb

    If Then

    'set the label or literal text Okay, how do you do that? AB
  14. asafb

    If Then

    ...= New SqlConnection("server=xxxx;" _ & "database=xxxx;user id=xx;pwd=x") myCommand = New SqlDataAdapter("SELECT * FROM products WHERE IDproduct = " & id, myConnection) ' Create and fill a DataSet. Dim ds As Dataset = new...
  15. asafb

    Query String

    ...= New SqlConnection("server=XXXX;" _ & "database=XXXX;user id=sa;pwd=XXXX") myCommand = New SqlDataAdapter("SELECT * FROM data WHERE id = " @id ,myConnection) ^^^ this doesn't work!!!! is it @id, or & id? ' Create and fill a DataSet...
  16. asafb

    Moving to Next Record

    ...what is the command for next record? I'm trying to accomplish this: http://asafblasberg.com/test1/store.asp Any help thank you very very much!!!! ************* ASP.NET Code ************ <%@ Page Language="vb" %> <%@ import Namespace="System.Data" %> <%@ import...
  17. asafb

    prevent users from deleting data

    hello i have an access adp projected connected to my sql server. how can i setup a logon that lets them do everything except DELETE DATA thanks asaf
  18. asafb

    how can i protect my vba code

    Hello I have an ADP file; lots of VBA code, i want to protect it with a password how? asaf
  19. asafb

    Backup to network folder gives access denied

    Hello, I'm trying to backup my SQL server database named &quot;test1&quot; as an example. When I select \\servername\serverfolder\serverfile (as an example), i get op system 5: access denied. What gives folks/ I'm logging in as administrator, what should i check for? thanks asaf
  20. asafb

    emergency, what to do!

    ...2000 format. When I open it in Access 2002 I see the following objects: tables, queries, forms, etc. etc. when i open in access 2000 i see tables, ***VIEWS!!*, forms, *STORED PROCEDURES*.... and this is bad because the adp file doesn't work in access 2000 because it is looking for all of my...

Part and Inventory Search

Back
Top