Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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