Dataset and DataAdapter - Hardcoded

[Christopher]

Hi

I have the following hardcoded the following (only the relevant code is
shown),
to populate a datagrid. The data loads into the grid as expected

private void LoadData()
{
//THIS CODE WORKS FINE - within this eventhandler
and the dataset and dataadapter are availible in the intellisense

// Dataset dsModify = New Dataset();

// SqlDataAdapter daModify = new SqlDataAdapter();

}
private void btnModify_Click(object sender, System.EventArgs e)
{
//Accept user changes

// PROBLEM - the dsModify and daModify are not availible in intellisense
to allow modifications to be pushed through to the database

// Errors generated are :

1) The type or namespace daModify could not be found
are you missing a using directive or an assembly reference"
2) The name dsModify does not exist in the <class>.<form>
}
I have attempted to put the following code into the public class of the form

private System.Data.SqlClient.SqlDataAdapter daModify

and get an error saying that daModify is never used - however it is used in
LoadData()

Any assistance would be appreciated

Thanks

Christopher

[Jon Skeet [C# MVP]]

Christopher <Ch*********@discussions.microsoft.com> wrote:

I have the following hardcoded the following (only the relevant code is
shown),
to populate a datagrid. The data loads into the grid as expected

private void LoadData()
{
//THIS CODE WORKS FINE - within this eventhandler
and the dataset and dataadapter are availible in the intellisense

// Dataset dsModify = New Dataset();

// SqlDataAdapter daModify = new SqlDataAdapter();
}
private void btnModify_Click(object sender, System.EventArgs e)
{
//Accept user changes

// PROBLEM - the dsModify and daModify are not availible in intellisense
to allow modifications to be pushed through to the database

// Errors generated are :

1) The type or namespace daModify could not be found
are you missing a using directive or an assembly reference"
2) The name dsModify does not exist in the <class>.<form>
}

I have attempted to put the following code into the public class of the form

private System.Data.SqlClient.SqlDataAdapter daModify

and get an error saying that daModify is never used - however it is used in
LoadData()

Could you post a short but complete program which demonstrates the
problem?

See http://www.pobox.com/~skeet/csharp/complete.html for details of
what I mean by that.

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too

[Sijin Joseph]

You need to change this line
//SqlDataAdapter daModify = new SqlDataAdapter();
to
this.daModify = new SqlDataAdapter();

and also you need to add this line to the class declaration
private System.Data.Dataset dsModify;

and change this line
//DataSet dsModify = new Dataset ();
to
this.dsModify = new Dataset();

--
Sijin Joseph
http://www.indiangeek.net
http://weblogs.asp.net/sjoseph
"Christopher" <Ch*********@discussions.microsoft.com> wrote in message
news:77**********************************@microsof t.com...

Hi

I have the following hardcoded the following (only the relevant code is
shown),
to populate a datagrid. The data loads into the grid as expected

private void LoadData()
{
//THIS CODE WORKS FINE - within this eventhandler
and the dataset and dataadapter are availible in the intellisense

// Dataset dsModify = New Dataset();

// SqlDataAdapter daModify = new SqlDataAdapter();

}
private void btnModify_Click(object sender, System.EventArgs e)
{
//Accept user changes

// PROBLEM - the dsModify and daModify are not availible in intellisense
to allow modifications to be pushed through to the database

// Errors generated are :

1) The type or namespace daModify could not be found
are you missing a using directive or an assembly reference"
2) The name dsModify does not exist in the <class>.<form>
}
I have attempted to put the following code into the public class of the form
private System.Data.SqlClient.SqlDataAdapter daModify

and get an error saying that daModify is never used - however it is used in LoadData()

Any assistance would be appreciated

Thanks

Christopher