Search results for query: *

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...

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...

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...

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...

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

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...

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...

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

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...

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...

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...

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

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

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

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...

Hello how do I compact my adp file in vba code asaf

hello, i have a function which is suppose to query based on a text box in a form like this: SELECT * from table where salespersonid = @forms_form1_text0 but it doesn't work!!! the form *is* open and I enter a number and it pops up 'parameter value', then says &quot;forms_form1_text0&quot...

Hello I upsized to sql server from my mdb file to create adp file. Some queries have failed, one of them is this, can anyone help with the syntax please? Thanks!!! FindContacts <- the name of the query in the mdb file Failed to upsize. Attempted to use SQL: CREATE FUNCTION FindContacts...

Hello, I have a mdb file i just converted to adp, loaded with problems. First, there is a combobox in date format that you enter a date then hit a button and it retrieves all the records with that date. However now in adp mode it doesn't work, it pops up with a parameter instead of reading it...

Hello after upsizing my mdb file to sql server i cannot add a new record in access. what happend? also, is it better to create an ADP file instead of creating links to sql? thanks guys! asaf