konvertere dataset til at returnere en int
Hvordan får jeg mit dataset til at returnere en int i stedet for et dataset?System.Data.DataSet getModeid(int klientID)
{
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=D:\\Fam\\db1.mdb";
System.Data.IDbConnection dbConnection = new System.Data.OleDb.OleDbConnection(connectionString);
string queryString = "SELECT [Moede].[MoedeID] FROM [Moede] WHERE ([Moede].[klientID] = @klientID)";
System.Data.IDbCommand dbCommand = new System.Data.OleDb.OleDbCommand();
dbCommand.CommandText = queryString;
dbCommand.Connection = dbConnection;
System.Data.IDataParameter dbParam_klientID = new System.Data.OleDb.OleDbParameter();
dbParam_klientID.ParameterName = "@klientID";
dbParam_klientID.Value = klientID;
dbParam_klientID.DbType = System.Data.DbType.Int32;
dbCommand.Parameters.Add(dbParam_klientID);
System.Data.IDbDataAdapter dataAdapter = new System.Data.OleDb.OleDbDataAdapter();
dataAdapter.SelectCommand = dbCommand;
System.Data.DataSet dataSet = new System.Data.DataSet();
dataAdapter.Fill(dataSet);
return dataSet;
}
