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...
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...
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'm trying to backup my SQL server database named "test1" 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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.