Lägg i databas

alasadi
Gradering

#18254

Hejsan!

Håller på att göra ett fomulär som skickar in fatan i en Access databas men det blir fel..

Här är källkoden : http://www.aspkoll.se/code/Index.asp?id=574

Får upp ett felmeddelande:

Server Error in '/emilwebbdesign' Application.

Input string was not in a correct format.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.FormatException: Input string was not in a correct format.

Source Error:

Line 45:             strText = Ctype(AddPanel.Controls(i), TextBox).Text
Line 46:                 If strText <> "" Then
Line 47:                     dr(j) = strText
Line 48:                     
Line 49:                     CType(AddPanel.Controls(i), TextBox).Text = ""

Source File: C:\Documents and Settings\Administratör\Skrivbord\emilwebbdesign\test.aspx Line: 47

Stack Trace:

[FormatException: Input string was not in a correct format.]
   System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) +7469351
   System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) +119
   System.String.System.IConvertible.ToInt32(IFormatProvider provider) +46
   System.Data.Common.Int32Storage.Set(Int32 record, Object value) +59
   System.Data.DataColumn.set_Item(Int32 record, Object value) +51

[ArgumentException: Input string was not in a correct format.Couldn't store <asd> in ID Column.  Expected type is Int32.]
   System.Data.DataColumn.set_Item(Int32 record, Object value) +90
   System.Data.DataRow.set_Item(DataColumn column, Object value) +296
   System.Data.DataRow.set_Item(Int32 columnIndex, Object value) +27
   ASP.test_aspx.Submit(Object Sender, EventArgs e) in C:\Documents and Settings\Administratör\Skrivbord\emilwebbdesign\test.aspx:47
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565

Version Information: Microsoft .NET Framework Version:2.0.50727.3603; ASP.NET Version:2.0.50727.3082

Redigerad av alasadi
Anledning:

| Skriv ut

ID: #18254 | Skapades: 2009-10-24 02:38:56 | Tråden har 0 svar och har lästs 348 gånger.

Ingen har svarat på denna tråd än.