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.