"WebBuilder451" <We***********@discussions.microsoft.comwrote in message
news:73**********************************@microsof t.com...
thanks for replying,
I did see this (your answer specific) in another of your postings and it
is
what prompted me to repost with the "(not set)". My admitted lack of
knowledge here is how to get my dataSOURCE in to the dataSET. (...<fetch
DataSet>;)
You need to know how to create a DataSet?
Firstly, it makes a (slight) difference what RDBMS you're using but, for the
sake of argument, let's say you're using SQL Server...
You'll need to reference the System.Data namespace, and use an appropriate
connection string, something like this:
Data Source=myServerAddress;Initial Catalog=myDataBase;User
Id=myUsername;Password=myPassword;
For more specific examples, see here:
http://www.connectionstrings.com/?carrier=sqlserver2005
string strConnectionString = "<...connection string - see above...>";
using (SqlConnection objSqlConnection = new
SqlConnection(strConnectionString))
{
objSqlConnection.Open();
using (SqlCommand objSqlCommand = new SqlCommand(pstrSQL,
objSqlConnection))
{
using (SqlDataAdapter objDA = new SqlDataAdapter(objSqlCommand))
{
using (DataSet objDataSet = new DataSet())
{
objDA.Fill(objDataSet);
objSqlConnection.Close();
return (objDataSet);
}
}
}
}
--
Mark Rae
ASP.NET MVP
http://www.markrae.net 
