Ok so i've added a ddl to a datagrid in vs.net using the template controls
provide in the ide. How then do I bind that ddl to a field in an access
database. Incidently, by binding the control, that means it should drop-down
all values stored in each record or can I limit the values ...

Dim index As Integer
index = e.Item.ItemIndex
DsSchedule1.Monday_Schedule.Rows(index).Delete()
OleDbDataAdapter2.Update(DsSchedule1, "Monday_Schedule")

I have a huge SQL script(generated through SQL server enterprise manager)
which creates tables, users and procedures. I am using a command object to
run it. It works all fine except for the procedures. The error it gives is :
" Must declare the variable @vchProperty"

Please see this error below. This code runs fine in v1.0, but I just
compiled it and ran it in v1.1. The first time the page loads, everything is
OK, but if you hit refresh or navigate away and come back to the page, the
following error occurs:

I need to write own insert, delete and update command.
I have to getchanges first.
I am wondeering if there are some sample codes I can find
Thanks

I'm creating a report that needs to be split up by a date range, then by
employee, then by weeks within the employee daterange. Better to use
multiple dataviews to accomplish this or is there a better way? Filtering
and refiltering hasn't struck me as being the cleanest method of ...

Hi, I'm reading XML into a dataset and now I want to insert into Sql Server
the data from the XML file.  I haven't been able to figure out any other way
than to do this than to walk through the dataset and insert each record one
at a time.

Is is possible to bind a datagrid to an empty dataset?
Initially, I would like the datagrid to be empty to allow users to insert
new rows.
I have the code to add new rows to the datagrid and to update the DB.

I'm dealing with a buggy-like behaviour when I call ReadXml method of
DataSet.
Here the scene:
I have myCustomDset.xsd and its associated/generated myCustomDset.cs; now my

Environment : Visual Studio 2003 v 7.1.3088 (French)
Development of a Windows application with SQL Server 2000
I get the following compile error message in the .xsd module : C:\Documents
and Settings\TORDEUR.FRYORKF\Mes documents\Visual Studio

I'm posting this message again cause my lat message was totally wrong.
What I'm looking for is how do I authenticate SQL users from a VB.NET
application using VB.NET language? I know there is a sp_addlogin stored
procedure in the master database, but do I call it from my ...

I am losing lots of hair over this issue. We are trying to implement windows
authentication from a web server to a database server.
The web server is on a domain; the db server is not... does this matter?
the IUSR_machinename user from the web server has been added as an account

I have a comma-delimited text file that I am reading via a connection
string:
junk = "Provider=Microsoft.Jet.OLEDB.4.0;"
junk &= "Data Source=\inware\data\df;"

I created a stored proc in SQL Server 2000 that returns the result of a left
outer join. For example:
CREATE PROCEDURE MyProc ... AS
BEGIN

How could I retreive the users and their corresponding passwords from SQL
Server 2000?
I'm using VS 2003 and VB.NET language.
Thanks,