empty dataSet

[Toyin]

hello,when i try to insert a dataSet record into another database table, what
i see in the table is null values. i have test this dataset and it contains 1
Row of record but when in perform insert command it inserts null values. pls
someone helpl. Also i have difficult in connecting to Microsoft Sql server
2000 database on another machine from my own machine in visual studio.net
2003.
thanks
Toyin

 

[W.G. Ryan]

Toyin:

With respect to your first problem, have you verified that values that the
parameters in your Sql statement are being set to? the problem is likely
either your parameters directly or the mappings. Check the sql statement
and verify the statement is syntactically correct and then check your
parameters and their mappings (if you are using parameters). Without seeing
the code, or knowing more about how you are attempting to perform the
insert, it's impossible to diagnose. As always, you can start a trace w/
Profiler, perform the task with the UI that adds the record and see what's
being sent back to the database - this is one direct approach that will
verify that the params are using values that are null.

next, I'd need to know more about "difficult in connecting". Does this mean
you can't do it at all? Can you connect if you just use a SqlConnection
object configured with a connection string to point to that db and call
Open() ?