DataAdapter Connection Problem

[Tifosi]

Hi,
I am trying to run the following code -:
DataAccess Layer Function-:

public DataSet getContacts(str ing Country, string Product)
{
DataSet dsContact = new DataSet();
dsAdapter = new SqlDataAdapter( );
string conString= ConfigurationSe ttings.AppSetti ngs["ConnectionStri ng"];
mySqlConn = new SqlConnection(c onString);
mySqlConn.Open( );
dsAdapter.Selec tCommand.Connec tion = new SqlConnection(c onString);
dsAdapter.Selec tCommand.Comman dText = "sp_getContactD etails";
dsAdapter.Selec tCommand.Comman dType = CommandType.Sto redProcedure;
dsAdapter.Selec tCommand.Parame ters.Add("@Coun try",Country);
dsAdapter.Selec tCommand.Parame ters.Add("@Prod uct",Product);
dsAdapter.Fill( dsContact);
return dsContact;
}

And the fron end code is-:
getContacts(str ing cntry, string prd)
{
dsContacts = obj.getContacts (cntry, prd);
if (dsContacts.Tab les[0].Rows.Count > 0)
{
pnlHomePage.Vis ible=false;
pnlDispContacts .Enabled = true;
lblDispContacts .Text = dsContacts.Tabl es[0].Rows[0].ToString();
lblDispContacts .Visible=true;
}
else
{
//do something
}
}

The if condition is throwing the error -: System.NullRefe renceException: Object reference not set to an instance of an object
The error is because there there are no tables in the dataset dsContacts;
First problem is the database code is throwing execption at the following line-:
"dsAdapter.Sele ctCommand.Conne ction = new SqlConnection(c onString); "
can anyone show me where the problem is;
the conectivity is working fine for all the other functions except for this one.
Thank You;

[Tifosi]

Hi,
I am trying to run the following code -:
DataAccess Layer Function-:

public DataSet getContacts(str ing Country, string Product)
{
DataSet dsContact = new DataSet();
dsAdapter = new SqlDataAdapter( );
string conString= ConfigurationSe ttings.AppSetti ngs["ConnectionStri ng"];
mySqlConn = new SqlConnection(c onString);
mySqlConn.Open( );
dsAdapter.Selec tCommand.Connec tion = new SqlConnection(c onString);
dsAdapter.Selec tCommand.Comman dText = "sp_getContactD etails";
dsAdapter.Selec tCommand.Comman dType = CommandType.Sto redProcedure;
dsAdapter.Selec tCommand.Parame ters.Add("@Coun try",Country);
dsAdapter.Selec tCommand.Parame ters.Add("@Prod uct",Product);
dsAdapter.Fill( dsContact);
return dsContact;
}

And the fron end code is-:
getContacts(str ing cntry, string prd)
{
dsContacts = obj.getContacts (cntry, prd);
if (dsContacts.Tab les[0].Rows.Count > 0)
{
pnlHomePage.Vis ible=false;
pnlDispContacts .Enabled = true;
lblDispContacts .Text = dsContacts.Tabl es[0].Rows[0].ToString();
lblDispContacts .Visible=true;
}
else
{
//do something
}
}

The if condition is throwing the error -: System.NullRefe renceException: Object reference not set to an instance of an object
The error is because there there are no tables in the dataset dsContacts;
First problem is the database code is throwing execption at the following line-:
"dsAdapter.Sele ctCommand.Conne ction = new SqlConnection(c onString); "
can anyone show me where the problem is;
the conectivity is working fine for all the other functions except for this one.
Thank You;

Hi,
Got a solution for this one. The code above initializes everything except for one object reference that is SelectCommand . To initialize it we have to pass a command object to the reference of SelectCommand. Sadly it isnt possible to do so through DataAdapter. But still it works fine without it by just allocating the reference of SelectCommand to your command object.
Thank You.