Trying to write a new report for reporting services and an associated VB app. The data connections will not work because a cached credential in my computer does not have a high enough privilage. I need to delete it to put in a new one but I can not find out how....more >>

Hi The sql command below does not seem to work in SQL Server, can someone show where I am going wrong Select * from users where ref like '*JOH*' order by ref Thanks in advance -- Kevin Martin Motor Trade Technologies ...more >>

HI Can someone tell me how to create a new SQL server user with password and default database using VB.Net code Thanks in advance -- Kevin Martin Motor Trade Technologies ...more >>

Hello. I am currently calling an acess file like this: (where strpath is the string containing the path to the access file. Process.Start(strPath) I'd like to know how to launch that acess file in readonly mode. Is there a parameter i can add to the string? Thank you. ...more >>

I need help with an error I cant track down. The following code is what I use with the updating of the data taken out. The update of the first table works fine but the second table always comes back with the same error of "Line 1: Incorrect syntax near '12'". This is caught by the exception. An...more >>

Hello! I need to create Oracle stored procedure at runtime with visual basic .net. I want that everytime my application starts, it will run a "create or replace procedure" statement on ORACLE server. I tried to read the SQL statement from a script file (text file) into an OracleCommand obje...more >>

-- If you like eBay and enjoy buying and selling there. Please take the time to join the site below! eBay Sellers Community http://www.ebay-sellers-community.com ...more >>

Hello! I have the following SP (Oracle): ************************************************************************************************ CREATE OR REPLACE PROCEDURE openorder (ordernum out number ,orderdate in date ,clinetnum IN NUMBER) IS begin INSERT INTO ORDERS (ORDER_NUM, CLIENT...more >>

Whats the best method to read rss web files? ...more >>

How do you do a http request in VB .Net? ...more >>

I have a VB6 applikation that is connecting to av msSql database. I am using a ODBC connecion. The database is on a remote server. Now I try to build a connectionstring to the same database in dotNet. I prefer not to use ODBC. Can anyone help me with av example of a correct connectionstring...more >>

I'm looking for code/ideas that will help me parse a webpage, say for something.exe or anything.exe. for instance <td>Bad.exe</td> - im looking for code that can pick up the word inside <td></td>. I need it to be stored as a string which can later be referred to by another program. Possib...more >>

In a VB.Net web application with SQL 2K backend I am trying to create class files for accessing the various tables in the database like I used to do in VB6. To learn to do this, I created a simple class: Imports System.Data.SqlClient Public Class createseminar Inherits System.Web.UI.Page...more >>

Hello, I have develop an application that use the SQL Server 2000. The problem is that I have also install an instance (MyApp) for the SQL Server. When I try to connect over the local network to the instance (Server1\MyApp) I get a message "Server not Found". If I try to connect to directly t...more >>

Hi, I want to develope an ASP.NET application where users can store files (word, excel, pdf, images...) on a server. I would like to know which is the best system of storage. I could use SQL but maybe it will get too slow (I'm thinking of 10.000 users with a maximum storage of 100 MB eac...more >>

I need to do a SQL INSERT statement into an Access table, and I’d like to use the exact technique described in the Help file example for OleDbCommand.Prepare Method. When I follow the example exactly I get the unhandled exception error message: “OleDbCommand.Prepare Method requires all...more >>

I'm using VB.NET to maintain data in an Access database. I wrote a function that inserts a row into a table that has an autonumber column, using an OleDbCommand object. Is there a way to execute the insert and retrieve the autonumber value at the same time? I've thought of taking a two st...more >>

I have a datagrid on an aspx page which draws its data from a SQL database table. Everything displays fine. However, I would like to reformat the text in a particular column for those cells that are non-empty.But I ran into the problem that cells that display nothing, in fact, actually are ...more >>

Hi All! How to use Data Repeater in VB.NET? Data Fields are Employee Number Name Photo Date of Joining Salary I want to use all the fields in Data Repeater? TIA Viswanathan S ...more >>

Hi all i'm new in vb.net i'm coming from access and now my first problem is : using ado.net in sql statement can i use my vb functions example: select ID, PRICE, CALCULATESELLPRICE(PRICE) AS SELLPRICE FROM PRODUCTS WHERE CALULATESELLPRICE IS MY VB FUNCTION this is very simple in MS Acces...more >>

I have some VB.NET code that is connecting to a MySQL database using the MyODBC Connector. My form has a combo box that I'm trying to populate. I've confirmed pretty much that I'm getting the data table properly, but when I try to bind the DataSource I get "An unhandled exception of type 'Syst...more >>

> how do i refer to a specific field in my dataset?? > > i created a dataset and drag-dropped in onto a form, then removed a few > fields that didnt need to be on the form. > i execute the program, and click add-new, fill in the fields, then click > save. > when i click save, this is the co...more >>