Database

APPLICATION			TEXTDATA					DURATION STARTTIME			READS	WRITES	CPU
---------------------------------------------------------------------------------------------------------------------------------------------
.Net SqlClient Data Provider						1229250	1/3/2006 10:53:53 am	2080346	366	60811
Internet Information Services						618203	1/3/2006 10:54:38 am	61550	1	4016
.Net SqlClient Data Provider	exec lc_getLatestIpById @mem_id = 267980	483	1/3/2006 11:26:44 am	4594	0	484

<br />
    Private Sub TotalDocumentSize()<br />
        Dim Command1 As SqlCommand = New SqlCommand("Select Sum (DocSize) AS myDocSize From Document")<br />
<br />
        Command1.CommandType = CommandType.Text<br />
        Command1.Connection = SQLConnection1<br />
<br />
        Dim myDocSizeVarTmp As Integer = CType(Command1.ExecuteScalar(), Integer)<br />
        BytesToMegabytes(myDocSizeVarTmp)<br />
<br />
    End Sub<br />

<br />
    Public Function BytesToMegabytes(ByVal Bytes As Double) As Double<br />
        'This function gives an estimate to two decimal<br />
        'places.  For a more precise answer, format to<br />
        'more decimal places or just return dblAns<br />
<br />
        Dim dblAns As Double<br />
        dblAns = (Bytes / 1024) / 1024<br />
        BytesToMegabytes = FormatNumber(dblAns, 2, , , TriState.False)<br />
<br />
        Dim MyItem As ListViewItem<br />
        MyItem = New ListViewItem("Total Document Size (MB)")<br />
        MyItem.SubItems.Add(BytesToMegabytes)<br />
        listStat.Items.Add(MyItem)<br />
    End Function<br />

I am using VB.Net and have recently started working with databases. I hae managed to connect to and manipulate databases done in access that hae already been built, but I am currently trying to use a database I have built but get errors when I try to generate a dataset. The error reads "Retreiving the schema for OleDbDataAdapter1 failed. IErrorInfo.GetDescription failed with E_FAIL(0x80004005)" I think it has something to do with how I am building the database, all I hae done is create a new database and put a table in it with the headings that I require. I wold be greatfull if anyone cold tell me what else I need to do to the database to make it work.

<br />
public void ExecuteStoredProcedure(string pStoredProcedureName, <br />
                                       object[] pReturnValue)<br />
    {<br />
      if(dbConnection.IsConnected())<br />
      {<br />
        bool outputValue = false;<br />
        command.Parameters.Clear();<br />
        try<br />
        {  <br />
        foreach(IDbDataParameter parameter in parameterCollection)<br />
        {<br />
          if(parameter.Direction != ParameterDirection.Input)<br />
            outputValue = true;<br />
          command.Parameters.Add(parameter);      <br />
        }<br />
        command.CommandText = dbConnection.FormatStoredProcedureCall<br />
                                                           (pStoredProcedureName, <br />
                                                            command.Parameters);<br />
<br />
        //command.CommandType = System.Data.CommandType.StoredProcedure;           <br />
	if(outputValue)<br />
	{<br />
		IDataReader reader = command.ExecuteReader();<br />
		reader.Close();         <br />
						<br />
		int count = 0;<br />
					  <br />
		foreach(IDbDataParameter parameter in command.Parameters)<br />
		{<br />
			Console.WriteLine("Parameter value:" + parameter.Value.ToString());<br />
<br />
			if(parameter.Direction != ParameterDirection.Input)<br />
			{<br />
				pReturnValue[count] = parameter.Value;<br />
				count++;<br />
			}<br />
		}  <br />
	}<br />
	else<br />
		command.ExecuteNonQuery();<br />
        }<br />
        catch(Exception e)<br />
        {<br />
          throw new DbException(ErrorMessage.INVALID_METHOD);<br />
        }       <br />
        parameterCollection.Clear();<br />
      }<br />
      else<br />
        throw new DbException(ErrorMessage.NOT_CONNECTED);<br />
    }<br />

public static string NewId(ICommand pCommand, int pModuleId)<br />
{<br />
        string sqlStatement = "NewRecordId";<br />
	object[] id = new object[1];	<br />
        try<br />
        {		<br />
	  pCommand.DefineParameter("pReturnValue", <br />
	  			  DbType.String, <br />
				  null, <br />
				  ParameterDirection.ReturnValue, <br />
				  30);<br />
	  pCommand.DefineParameter("pCurrentDate", <br />
				  DbType.DateTime, <br />
				  DateTime.Now);<br />
	  pCommand.DefineParameter("pNewId", <br />
				  DbType.String, <br />
				  Guid.NewGuid().ToString());<br />
  	  pCommand.ExecuteStoredProcedure(sqlStatement, id);            <br />
	<br />
	  if (id[0].ToString().Length != 30)<br />
		throw new DatabaseLayerException("Genearated Id doesn't have 30 digits.");<br />
      }<br />
      catch(Exception e)<br />
      {<br />
	throw new DatabaseLayerException("LCMS5000", e.Message);<br />
      }<br />
			<br />
			return(pModuleId.ToString() + id[0].ToString());<br />
		}