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!

  • Congratulations strongm 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

    Hello, I have a datareader which binds my datalist. Now, I want to fetch Row #21 lets say and store the data that is in a specific column called "Sound" to a variable. Anyway to do this? <%@ Page Language="vb" %> <%@ import Namespace="System.Data" %> <%@ import...
  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

    Dear tek tips gurus, I have a page here which displays a random record each time. However, I only want it to display the record if it meets this criteria: Specialtag = 1 (Specialtag is a columm in my database). I only want to show a special product, not a normal product, this is why. So look at...
  6. asafb

    Binding a text box control to data

    Hello, I was able to successfully bind combo boxes to data. Now I need your help again (jennifer? ;) ) Here's my code that works: <%@ Page Language="VB" %> <%@ import Namespace="System.Data" %> <%@ import Namespace="System.Data.SqlClient" %> <script runat="server"> Sub Page_Load(sender As...
  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

    Hello, I've been reading how to insert/update using a single page, but I've got a lot of records. Here's what I want: You hit a link called "Add new record." Then it takes you to a new page with a simple form. Let's have just two fields: Name, Telephone. You hit add record and it inserts it in...
  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

    Hello, I have an ASP page that says if the ID = 13, display more HTML. Now I want to port it to ASPX. Here's my code: <%@ Page Language="vb" %> <%@ import Namespace="System.Data" %> <%@ import Namespace="System.Data.SqlClient" %> <script runat="server"> Sub Page_Load(sender As Object, e...
  15. asafb

    Query String

    Hello, how do you create an aspx page with a query string i.e. test.aspx?id=5, where basically the datalist would retrieve the data just for that record. i did it in asp, but i need help to do it in .net. thanks guys! <%@ Page Language="vb" %> <%@ import Namespace="System.Data" %> <%@ import...
  16. asafb

    Moving to Next Record

    Hello, I'm using the Repeater control to display pictures from a SQL database. Now I'd like to format it in a neat grid table. Right now, it's displaying this: pictures are the x's: x x x x x x x i want it to look like this: x x x x x x x x x x x x Problem is, it doesn't go to the next...
  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!

    Hello, I have an ADP file in Microsoft Acces 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...

Part and Inventory Search

Back
Top