لما هذا الخطأ أثناء إضافة البيانات إلى SQL Server
هذا هو كود الإضافة:
SqlCommand sql_command = new SqlCommand("INSERT INTO members (member_sex, member_cpr, member_password, member_nationality, member_block, member_gov, member_daaera, member_email, member_mobile, member_created_ip) " + "Values ('" + Session["member_sex"].ToString() + "', " + (int)Session["member_cpr"] + ", '" + Session["member_password"].ToString() + "', '" + Session["member_nationality"].ToString() + "', '" + Session["member_block"].ToString() + "', 'GOV', 6, '" + Session["member_email"].ToString().ToLower() + "', '" + Session["member_mobile"].ToString() + "', '" + Request.UserHostAddress.ToString() + "')", sql_connection);وهذا هو الخطأ:
System.InvalidCastException was unhandled by user code
Message="Specified cast is not valid."
Source="App_Web_rntv0oro"
StackTrace:
at ASP.confirm_signup_aspx.btnRegister_Click(Object sender, EventArgs e) in c:\Documents and Settings\Jassim Rahma\My Documents\Visual Studio 2005\WebSites\Bahrain Public Opinion Polling\confirm_signup.aspx:line 27
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
