Get number data from ms access

[dbdb]

hi guys,

i tried to get some data from my access db. i used repeater to get the data, but i got a problem when i tried to get the data with number type in ms access.
it shown an error.

is there another way to get the data ?

thank you.

[PRR]

Can you post some sample code? You need to cast before you can "copy" from repeater... also need to check for null values ...

[Frinavale]

Sample code would really help us understand what you're talking about.

(You can't use a Repeater to retrieve data from a database...but you can use it to display data Retrieved from the database...)

-Frinny

PS

When posting code snippets please remember to use code tags

[dbdb]

here is the code.

Sub Page_Load (Source As Object, E as EventArgs)
        Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("surat.mdb") & ";"
        Dim MySQL As String = "SELECT no, nosurat, tglsurat, kategori, tujuan, perihal, deskripsi FROM surat"
	Dim MyConn as New OleDBConnection (strConn)
	Dim Cmd as New OleDBCommand (MySQL, MyConn)
	MyConn.Open ()
        rptSurat.DataSource = Cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection)
        rptSurat.DataBind()
End Sub

and for the repeater,

<asp:Repeater ID="rptSurat" Runat="Server">
	<HeaderTemplate>
		<table border=1 cellpadding=5 cellspacing=0 width=50%>
	</HeaderTemplate>

	<ItemTemplate>

		<tr>		
			<td width=30%><b><font face=Tahoma size=2>No </font></b></td> 
				<td><font face=Tahoma size=2><%#Container.DataItem("no")%></td></tr>						
		<tr>
			<td width=30%><b><font face=Tahoma size=2>Tanggal Surat </td> 
				<td><font face=Tahoma size=2><%#Container.DataItem("tglSurat")%></td></tr>	
		<tr>
			<td width=30%><b><font face=Tahoma size=2>Kategori </td> 
				<td><font face=Tahoma size=2><%#Container.DataItem("kategori")%></td></tr>
		<tr>
			<td width=30%><b><font face=Tahoma size=2>Tujuan </td> 
				<td><font face=Tahoma size=2><%#Container.DataItem("tujuan")%></td></tr>
		<tr>
			<td width=30%><b><font face=Tahoma size=2>Perihal </td> 
				<td><font face=Tahoma size=2><%#Container.DataItem("perihal")%></td></tr>
        <tr>
			<td width=30%><b><font face=Tahoma size=2>Deskripsi Isi </td> 
				<td><font face=Tahoma size=2><%#Container.DataItem("deskripsi")%></td></tr>				
				
			</ItemTemplate>
		
	<SeparatorTemplate>
		<tr height=25><td></td></tr>
	</SeparatorTemplate>
	
	<FooterTemplate>
		</table>
	</FooterTemplate>

</asp:Repeater>

no : number type in access.
i couldn't get the data, it shown an error.

[Frinavale]

Ok, next thing we need to know is what the error message says :)

[dbdb]

the error msg is like this :

Exception Details: System.IndexOutOfRangeException: no

Source Error: 


Line 49: 		<tr>		
Line 50: 			<td width=30%><b><font face=Tahoma size=2>Letter No </font></b></td> 
Line 51: 				<td><font face=Tahoma size=2><%#Container.DataItem("no")%></td></tr>						
Line 52: 		<tr>
Line 53: 			<td width=30%><b><font face=Tahoma size=2>Date </td> 
 

Source File: D:\ASPwebsite\srtView.aspx    Line: 51 

Stack Trace: 


[IndexOutOfRangeException: no]
   Microsoft.VisualBasic.CompilerServices.Container.InvokeMethod(Method TargetProcedure, Object[] Arguments, Boolean[] CopyBack, BindingFlags Flags) +202
   Microsoft.VisualBasic.CompilerServices.NewLateBinding.CallMethod(Container BaseReference, String MethodName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, BindingFlags InvocationFlags, Boolean ReportErrors, ResolutionFailure& Failure) +150
   Microsoft.VisualBasic.CompilerServices.NewLateBinding.InternalLateIndexGet(Object Instance, Object[] Arguments, String[] ArgumentNames, Boolean ReportErrors, ResolutionFailure& Failure) +166
   Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateIndexGet(Object Instance, Object[] Arguments, String[] ArgumentNames) +22
   ASP.srtview_aspx.__DataBind__control4(Object sender, EventArgs e) in D:\ASPwebsite\srtView.aspx:51
   System.Web.UI.Control.OnDataBinding(EventArgs e) +99
   System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +92
   System.Web.UI.Control.DataBind() +15
   System.Web.UI.Control.DataBindChildren() +211
   System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +102
   System.Web.UI.Control.DataBind() +15
   System.Web.UI.WebControls.Repeater.CreateItem(Int32 itemIndex, ListItemType itemType, Boolean dataBind, Object dataItem) +124
   System.Web.UI.WebControls.Repeater.CreateControlHierarchy(Boolean useDataSource) +443
   System.Web.UI.WebControls.Repeater.OnDataBinding(EventArgs e) +51
   System.Web.UI.WebControls.Repeater.DataBind() +75
   ASP.srtview_aspx.Page_Load(Object Source, EventArgs E) in D:\ASPwebsite\srtView.aspx:14
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +50
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

error in line 51

[Frinavale]

I see your problem.

On line 7 of your VB code:

Sub Page_Load (Source As Object, E as EventArgs)
        Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("surat.mdb") & ";"
        Dim MySQL As String = "SELECT no, nosurat, tglsurat, kategori, tujuan, perihal, deskripsi FROM surat"
	Dim MyConn as New OleDBConnection (strConn)
	Dim Cmd as New OleDBCommand (MySQL, MyConn)
	MyConn.Open ()
        rptSurat.DataSource = Cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection)
        rptSurat.DataBind()
End Sub

You are assigning the DataSource of the repeater to the return value of the ExecuteReader() method.

The ExecuteReader method does not return a Table or any other item that can properly be used as a data source. It returns an OleDbDataReader Object. You would have to use this object (read from the data stored within it) to create a data source that could properly be used with the Repeater.

You could do that, but I'm going to recommend using the OleDataAdpater class to fill a DataSet. Once the OleDataAdapter' s Fill method is used to fill a DataSet, the DataSet will contain DataTables which you can use as a data source for your repeater. In your case it's likely that only 1 table will be in the DataSet....so this should be rather straightforward .

Look into how use DataAdapters and DataSets....and if you're really curious, look up how to use a DataReader properly.

[shiznit770]

The error indicates that the repeater is attempting to read an index that is not present on the datasource.

Make your select statement in a query so that you can see the data it returns. Double check the spelling of your column names and the corresponding indexes used by the data repeater.