im getting the dreaded:  
Object reference not set to an instance of an object.
on the code below. pretty new to C# but i know im missing something basic here.   
any help is appreciated

I want to convert standard SQL update syntax into calling stored procedure.
Normal Coding
-------------
Dim constr As String = "server='SQLSVR'; user id='USER';

I'm a total ADO.NET newb! I've done some Visual C++.NET and some windows
forms programming but have not done any ADO.NET coding yet. I am writing to
ask what is the best way to get started with a simple Windows Forms ADO.NET
project? Is it possible to build a Windows Form project ...

If I create a child relationship between 2 tables, but the parent table has a
value which is not found in the child table, then this will cause an
exception....right?  So how to I indicate that the parent/child relationship
may or may not exists so that no exception is generated ...

I am having a few problems with one of my forms... I have a data grid bound
to a dataset using a currencymanager and it's all working fine. However when
i edit or change any of the data in the Datagrids columns/rows i need to
call update so the changes are saved back to my database, ...

When it developed in Embedded Visual Basic my database it was in Access
and OK worked, now development in Visual Basic .NET (Smart Device
Application) and do I need to occupy Access and don't I find any
example of as making it, does somebody have an example or does know if

I am trying to add a row to a table in a dataset.  The table contains an ID
field, which is set up as an AutoIncrement field, with AutoIncrementSeed = 1
and AutoIncrementStep = 1.  I like the convenience of the following syntax:
MyDataset.Tables("MyTable").Rows.Add(New ...

Another DateTime Picker question!
But I simply can't find a proper athoritative answer anywhere.
I have the showcheckbox option of the datetimepicker enabled.
However, when a null value is passed to that control, the control is

Application: When a user selects a name in the listbox complete
information(phone-no,E-mail,et­c..) regarding the person should be
displayed.
Problem: I have populated the list-box with names using datareader.The

I am having a problem inserting into a dataset that is loaded from a view
that does joins with other tables and includes required fields from those
tables. For example, I might have a view that is an Orders view which does a
join to a Contact table and contains the contact's last ...

1. In a simple query like
str = "select * from emp where empid = '23'"
why in the where clause we always use '@@' these quotes.

Does anyone know why while working with drv (DataRowView)
a) if I uses this:
--------------------------------------------------------------------
drv.Row.Item("CODE") = 254

The SQL that I'm sending to my server doesn't work unless I run it through
an interactive tool.
I've done this in VS 2003
   cmd.CommandText = "SELECT * FROM \"tblTasks\" ORDER BY " + OrderBy;

Thank you for any help you can provide!
I have a long list of links with decscriptions titles etc in a SQL Server
2000 database. The basic problem is that I am attempting to use a data base
cursor to to the proper starting point in a sorted view, get the next 10-or

I am getting [OleDbException (0x80004005): Operation must use an updateable
query.] error on ExecuteNonQuery() . Full code is given below. The values I
have given are; ('trtrt', 'retret', '1/1/2', '333'). The application is an
asp.net webform. Any idea what is the problem?