all groups > vb.net data > may 2006
install Access 2003 mdb to network
Posted by Beth at 5/31/2006 12:02:01 PM
Hello.
I'm writing an application that, for now, uses an Access 2003 database.
If I install my application and the .mdb to c:\program files\vendor\app, it
works fine.
However, the data in the .mdb needs to be shared by multiple users, so I
want the .exe and .mdb on a network drive.
When ... more >>
check if row exists in table
Posted by Beth at 5/25/2006 3:39:01 PM
Hello.
I need to import files from our network to an image server, but only if they
haven't been imported already. I have a table storing records for each file
that's imported, and I want to check that table to see if there's a row that
matches the file's name and size. If it's there, I don... more >>
SSPI Issues
Posted by Aussie Rules at 5/25/2006 2:09:18 PM
Hi,
About 8 times a day, all of a sudden I get the message 'cannot generate SSPI
context' when trying to connect to SQL Server in my vb.net app. (also SQL
Management fails at the same time, with same error)
I have read up on this, and understand its a security issue, but why does it
happ... more >>
Inline SQL vs stored procs on SQL Server 7 and 2000
Posted by kentk at 5/24/2006 9:37:01 AM
Is there a difference in how SQL Server 7 and SQL 2000 processes SQL passed
from a program by an ADO command object. Reason I ask is I rewrote a couple
applications a couple years ago were the SQL statements were inline. I
basically took the SQL statements and put them into stored procs, wer... more >>
getting data from DBF into SQL Express
Posted by Burtamus at 5/19/2006 3:34:08 PM
I'm using VB.NET 2005 and SQL Express. I have WinApp set up and shows my
clients with no problem. I receive a DBF file from a supplier and would like
to suck that into SQL Express. Since SQL Express can't import the data
directly, I'm working a coding it.
I can connect to the DBF file using... more >>
how to add a reference in asp.net/vb.net?
Posted by Ben at 5/17/2006 8:27:39 PM
Hi,
I need to add a reference in my project to a file (e.g. mysqldata.dll) in
order to access Mysql.
Using Visual Web Developer, i know how to do (menu website/add reference),
but suppose i have no VWD or any tools, and that i create only one test.aspx
file and another test.aspx.vb file with ... more >>
Create DB Example - It works, but is it right?
Posted by Miro at 5/17/2006 10:14:19 AM
Sorry forgot to post this on is forum, so this is also posted on
microsoft.public.dotnet.langauges.vb
I am teaching myself vb.net 2003, and I was wondering if someone can check
my code.
-It works, but i was wondering if i was on the right track or if I should
have done it differently.
... more >>
DataGridView and ComboBox
Posted by Art at 5/12/2006 7:06:01 AM
Hi -- I hope someone can point me in the right direction
I have a DataTable that I want to fill using a DataGridView. I've set the
DataSource of the DataGridView to my DataTable. My problem is that I want
some of the columns to be drop downs. For example, the user will need to
enter a "p... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Export DataTable to CSV file
Posted by Tom Rahav at 5/9/2006 5:36:36 PM
Hi,
I have a DataTable that I need to convert to a CSV file, in the fastest and
less resources demanding way.
I did it by creating a MS Excel object, Worksheet object, etc. and running
over each row and column in the DataTable and writing it to the Excel sheet.
It's working, but v-e-r-y slo... more >>
Basic Database Questions
Posted by Miro at 5/9/2006 12:01:13 AM
Ok im a newbie to VB, and am having some trouble reading msdn help / or how
it all links together. My books are either
missing a step / or assume everything is set up correctly.
I know about tables and keys but i just cant seem to find a "starting point"
in VB.net.
1. Where do I go crea... more >>
SQL Aggregation Query
Posted by Liddle Feesh at 5/7/2006 6:06:25 PM
Dear Group,
I appreciate that you are all busy; however I have a SQL programming task
that I can't seem to get my head around at the moment. Any assistance will
be very warmly appreciated.
I have the following SQL view, which returns a Data Table, STOCK_TRADE, with
the following data..
... more >>
Aggregating groups of rows using SQL
Posted by Liddle Feesh at 5/7/2006 5:58:36 PM
Dear Group,
I have a SQL coding problem, which I hope that you can help me with!
I have the following SQL view, which returns a Data Table, STOCK_TRADE, with
the following data..
CUSTOMER STOCK_CODE QUANTITY PRICE DATE
J. BLOGGS MSFT 1000 535.50 10/05/2006
J. BLOGGS MSFT 2000 536.... more >>
List SQL Servers in ComboBox
Posted by MATT at 5/5/2006 11:04:01 PM
I would like to be able to list all the SQL Servers on a local network in a
comboBox. Much like the ODBC Wizard does it. Could someone point me in the
right direction. I've Tried the SQLDMO, but that dosen't seem to exist in
the VB.NET.
Thanks
MATT... more >>
Cannot create a new record?
Posted by TofuTheGreat NO[at]SPAM gmail.com at 5/4/2006 9:34:33 AM
Ugh. I'm starting to dislike ADO.Net. ADO seemed so much simpler.
I'm creating a small database application for logging phone calls. The
program is supposed to load a data entry screen where the user can
enter the details of a phone call and then save the record. The
functionality desired ... more >>
Design question
Posted by Lefteris Kororos at 5/4/2006 9:02:36 AM
I am developing an application in VB.NET to produce some reports. The
back-end DB is an MS Access db. I have a table with the details of
employees, a table with several projects, and a table with details for
a specific month for each project.
Due to the nature of the paying scheme of the emplo... more >>
Create SQL Statement with Form with many textboxes
Posted by MATT at 5/3/2006 3:25:02 PM
I have a form with about 50 textboxes that the user inputs information. When
you click "Submit", it inserts the record into a SQL Database. Could someone
recomend a better way of generating the sql statment. Right now i have:
"Insert into Table (field1, field2, field3.... field50) values ... more >>
NULL Value - Specified cast is not valid
Posted by fniles at 5/3/2006 1:56:06 PM
I am accessing MS Access db with tblA whose column UNABLE can have NULL
value. When I access UNABLE whose value is null, I got an error "
Run-time exception thrown : System.InvalidCastException - Specified cast is
not valid." either when I do
IsDBNull(dr.GetString(0))
or
dr.GetString(0)
How... more >>
Cannot create data connection via drag-drop from server explorer in vb .net 2005 project
Posted by Chris Johnsen at 5/2/2006 3:59:24 PM
Hi,
Posted this in the ADO non-.net newsgroup. Oops.
Anyway, have a connection to a SQL Server 2005 database in my server
explorer/data connections. I want to drop this onto my form to create a
data connection. It won't let me do it. Get the circle-slash "can't do
that here" cursor wh... more >>
Appending two data tables
Posted by Mark at 5/1/2006 1:06:01 PM
Hi -
I'm looking for a code sample that will let me append a data table to a
second master data table. You can assume that the tables' structures are
identical.
Seems like there should be a method to do this, but I can't find one.
Thanks,
Mark
... more >>
|