I'm working in VS2005, C#.  I have a form with a details view of records.  
The Fill statement takes 1 parameter a BOXNUMBER so I fetch only one record
from the database table.  Fill(MBDataSet.MBDetailsDataTable dataTable, string
BoxNumber)

i am applying aggregate function on datatable.compute.  I have one
fiter criteria and based on that i want to apply sum function on two
columns like sum(sal), sum(pf).  if i write query in sql it is
allowing me to use more than one aggregate function but how to do it

Is there a rule about when should I have to use a typed or untyped DataSet?
What are your tips and advices?
Thanks,
Willian

I´m starting with C# and .NET. So, I have some difficulties with some codes.
I´m already a programmer and I´m migrating from Delphi to C#. My questions
are:
1) Into a form I´ve made my connection string and my SqlConnection variable.

I made a database (http://users.skynet.be/fc042048/Pizza.jpg) in Access
which I want to use via typed datasets on my website. Problem is, if I i.e.
want to edit the datatable "Pizza" in a gridview, I get the error "Can't
delete or update the record because there are related ...

I'm having the oddest issue.  I can execute a select query on a database but
I get an error when I try to execute a stored procedure.  It is probably
something dumb but I have tried everything I can think of.  I'm not having
much luck searching the web either.

What´s the diference between TableAdapter and DataTable? When I should use a
TableAdapter and DataTable?
Hugs,
Willian

Environment Information:
I am running Visual Studio 2005 Version 8.0.50727.762 (SP.050727-7600) and
connecting to a SQL Server 2005 database, although this problem never reaches
the database.  I am also using Windows XP Professional SP 2.

The database I use is SQL Server 2005.
The user to login database is 'PG_TestUser', it has 'dbo' schema, and it has
datareader and datawriter permission.
I have .NET Code like this.

I'm trying to create a Server Cursor (MSSQL2005) via Ado.net like this:
           cmd.CommandText = "DECLARE " + crsName + " CURSOR LOCAL
SCROLL STATIC READ_ONLY FOR " + cmd.CommandText;
           cmd.ExecuteScalar();

I trying to connect remote sql server from my machine. but
it giving me some errors
Here are few errors listed,
An error has occurred while establishing a connection to the server.

I'm developing a Web App in C#. The following method executes without
exceptions but the database does not get changed. The data is changed in the
record[0] at the point prior to executing the   " adapter.Update(record);"
instruction.

I have an Excel file, saved as XML-file, which is put as an embedded
ressource in my project. How can I read this Excel file using an
OleDbDataAdapter?
I know how to read an XML file as embedded ressource, and how to read a

I have 2 tables...
Table1:  FullName, City, State, Data1
Table 2:  FullName, City, State, Data1, Data2, Data3
This is what I want to do...

I´m a newbie with C# and .NET. I´m professional programmer with Delphi and I
migrating from Delphi to C# with .NET
.
My questions are: