.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Kaviya Balasubramanian
Imran Ghani
Post New Web Links

Help me with this error Format of the initialization string does not conform to specification starti

Posted By:      Posted Date: September 27, 2010    Points: 0   Category :ASP.Net
 

I am getting this error-- Format of the initialization string does not conform to specification starting at index 0. whenever i want to insert some record into DB using store procedures.

 String cstr = ConfigurationManager.ConnectionStrings["cstr"].ConnectionString;
       SqlConnection con = new SqlConnection("cstr"); 
        cmd = new SqlCommand("insert1", con);
         
        cmd.CommandType = CommandType.StoredProcedure;  
           
         cmd.Parameters.Add(new SqlParameter("@empid", SqlDbType.VarChar)).Value = TextBox1.Text;  
         cmd.Parameters.Add(new SqlParameter("@name", SqlDbType.VarChar)).Value = TextBox2.Text;  
                   
         con.Open();  
         cmd.ExecuteNonQuery();  
         con.Close();   

and my connection string in web.config

<configuration>
	<configSections>
		<sectionGroup name="system.web.extensions" type="System.Web.Configuration.SystemWebExtensionsSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
			<sectionGroup name="scripting" type="System.Web.Configuration.ScriptingSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35


View Complete Post


More Related Resource Links

Format of the initialization string does not conform to specification starting at index 0.

  

Hi,

I am getting the error above when i click on a button...



Thanks!

ro


Usual solutions not the problem for Format of the initialization string does not conform to specific

  
I know that there are normally two causes/solutions for the "Format of the initialization string does not conform to specification starting at index 0" error message.  The two normal suggestions are a problem with the connection string or it is surrounded by quotes in Dimming the connection. I get the message while running in debug (though it is pulling the selected row ID value correctly).However neither of those are the case in my file.  I know the connection string is configured correctly because it works in the rest of the page.  Further I don't have quotes in the Dim connection part.  Relevant bits of code below.Imports System.Web.UI.WebControls Imports System.Web.UI.WebControls.ImageButton Imports System.Web.UI.WebControls.DataControlField Imports System.Data Imports System.Data.SqlClient Imports System.Configuration Imports System.Object Imports System.DirectoryServices Partial Class Default2 Inherits System.Web.UI.Page 'Private auth As authenticate 'Private dt As DataTable 'Private programs As DataRow() Private dbConnection As String = "KMConnectionString" . . . Sub btnPlay(ByVal sender As Object, ByVal e As EventArgs) 'grab video ID Dim videoID = GridView1.SelectedValue.ToString() Response.Write(videoID) Dim con As New SqlConnection(dbConnection)

Error when instantiating MySqlDataAdapter "Format of the initialization string..."

  

<%@ Page Language="javascript"%>

I'm writing a website that's a little heavy on the database connection calls, so I've decided to try to encapsulate it in a Javascript pseudo-class.  When I try to instantiate the MySqlDataAdapter, I get the error "Format of the initialization string does not conform to specification starting at index 0."  While I can appreciate this, I've used the same connection string (more or less) across many pages now, without issue when I'm not trying to use this class.

I'm a little confused - does anyone have any idea why line would be throwing this error?

On a side note, is there any way to post code in a <textarea> or something like it?  This nifty little javascript wrapped textbox keeps erasing all my tags.  :)


The Error Message

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.ArgumentException: Format of the initialization string does not conform to specification starting at index 0.

Source Error: 

Line 16: 		
Line 17: 	this.command = new MySqlCommand( "", this.sql );
Line 18: 	this.adapter = new MySqlDataAdapter( "&

Enterprise Library 4.0 error: Input string was not in a correct format.

  

I am trying to insert candidates information into SQL Server database. I have written the corresponding stored procedure like below in SQL server:

ALTER PROCEDURE [dbo].[USPInsertCandidate]
	@candidate_name varchar(60),
	@dob datetime,
	@gender char,
	@current_location varchar(60),
	@mobile_no_one varchar(20),
	@mobile_no_two varchar(20),
	@home_phone	varchar(20),
	@work_phone varchar(20),
	@email_id varchar(100),
	@passport varchar(20),
	@as_on_date datetime,
	@file_upload_path varchar(255),
	@availability char,
	@applied_position varchar(30),
	@max_round_id int,
	@certification_comment varchar(2000),
	@source_id int,
	@source_comment varchar(2000),
	@skillset_comment varchar(2000),
	@max_status_id int,
	@total_exp_year int,
	@total_exp_month int,
	@source_date datetime,
	@user_id int,
	@visa varchar(20),
	@qualification varchar(100)
AS
BEGIN
	declare @candidate_id int;
	set @candidate_id = dbo.GetCandidateID();
	insert into candidates(candidate_id, candidate_name, dob, gender, current_location, mobile_no_one, mobile_no_two, home_phone, work_phone, email_id, 
							passport, as_on_date, file_upload_path, availability, applied_position, max_round_id, certification_comment,
							source_id, source_comment, skillset_comment, max_status_id, total_exp_year, total_exp_month, source_date,
							user_id, visa, qualification)
	values

C#: SELECT @@IDENTITY AS 'Identity'. Error:Input string was not in a correct format.

  

 

Hi

 

Using VS2005, SQL Server 2005, FormView,C#.

Please Note: I can not use stored proecdeures.

 

I currently Insert a record in my FormView.

 

I need to then retrieve the IssueID of the inserted record and use the latest IssueID to insert a record into another table.

Error: Input string was not in a correct format. using c# .net

  

anyone can help me regarding this error:

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

here's my code behind:

referenceno = Convert.ToInt32(drReaderpay["STAFF_ID"]);

note: staff_id = 123456-8


Input string was not in a correct format.

  

Hi, I just started learning asp.net

i set simple application but i get this error that  "Input string was not in a correct format"

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 10:     protected void Page_Load(object sender, EventArgs e)
Line 11:     {
Line 12:         decimal num1 = Decimal.Parse(txtNumber1.Text);
Line 13:         decimal num2 = Decimal.Parse(txtNumber2.Text);
Line 14:         decimal ans = num1 + num2;

How can I correct this error

 

thanks

 


While dispose the com+, encounter error: failed due to the following error: Old format or invalid ty

  
I have web service to invoke com+ to do business layer checking. recently, the application encountered intermittently the following error while tried to dispose the com+ instance. Appreciate anyone who help for this. thanks!   System.InvalidCastException: Unable to cast COM object of type 'System.__ComObject' to interface type 'System.IDisposable'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{805D7A98-D4AF-3F0F-967F-E5CF45312D2C}' failed due to the following error: Old format or invalid type library. (Exception from HRESULT: 0x80028019 (TYPE_E_UNSUPFORMAT)).   Server stack trace:    at System.IDisposable.Dispose()    at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)    at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs)    at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)   Exception rethrown at [0]:    at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage

"Format exception was unhandled by user" error. . .please help. . urgent!

  
Hi to all developers. I'm developing a survey site and i got this error 'Format exception was unhandled by user'. .  please help me deal with this. . any help is much appreciated. .here is where the error occured(2nd line):If Not Request.QueryString("DeptCode") Is Nothing Then            Dim DeptCode As Double = Double.Parse(Request.QueryString("DeptCode"))            Session.Add("DeptCode", DeptCode)        Else            Response.Redirect("default.aspx")        End Ifthanks in advanced. .

error in MVC2 on empty string form fields which are required: "This property cannot be set to a null

  
In model I have:[DisplayName("ISBN")] [Required(ErrorMessage = "ISBN is required.")] [StringLength(50, ErrorMessage = "ISBN book must have max {1} chars.")] [DisplayFormat(ConvertEmptyStringToNull = false)] public string isbn { get; set; }But when I submit form with empty field ISBN I have an error - ConstraintException: This property cannot be set to a null value.I have find that other people have the same problem and they say that debbugger in VS2010 works wrong - yes ?http://p2p.wrox.com/book-professional-asp-net-mvc-2/79788-constraintexception-unhandled-user-code.html#post259245http://efreedom.com/Question/1-3129080/Server-Side-Validation-REQUIRED-String-Property-MVC2-Entity-Framework-Workhttp://mvcmusicstore.codeplex.com/workitem/6604

NET Framework Initialization Error: C:\WINDOWS\Microsoft.NET\Framework|v2.050727\mscorwks.dll could

  
After making a full restore, i can not open some applications (Microsoft Office 2003, Intuit Quickbook POS). Once i try to open them it shows me the following message: NET Framework Initialization Error: C:\WINDOWS\Microsoft.NET\Framework|v2.050727\mscorwks.dll could not be loaded.   However it does let me open several others such as Microsoft Works, etc, etc.

Cannot FindByThumbprint - Invalid Hexadecimal string format

  
I'm trying to set up a sample WCF service using a self-signed certificate.  For some reason, I repeatedly get the error "FormatException - Invalid hexadecimal string format." I was initially trying it in the config file but decided to try setting it up in code but still get the same error. I then tried it on a different machine and it works just fine.  I would appreciate any suggestions.  Here are the details. Environment:  Windows 7 Home Premium, Visual Studio 2010 C# Express Edition, .NET 4.0 Code:     // Create the host ServiceHost host = new ServiceHost(hostType);     string valueToFind = "‎‎‎‎‎66 31 bf 9e f7 4f 9e b6 c9 d5 a6 0c ba 6a be d1 f7 bd ef 7b"; host.Credentials.ServiceCertificate.SetCertificate(   StoreLocation.CurrentUser, StoreName.Root, X509FindType.FindByThumbprint, valueToFind);     The exact same code runs just fine on another machine.  No complaints of an invalid hexadecimal value.  Here are the details of the other machine: Environment:  Windows XP, Visual Studio 2010 C# Premium, .NET 4.0 Any ideas?

SlideShowExtender - Sys.Net.WebServiceProxy._createFailedError(methodName, String.format(Sys.Res.web

  
Hello,   I put a SliderShowExtender and i created a web service with a function that return AjaxControlToolkit.Slide(), but when a run the project give me the error: Microsoft JScript runtime error: Sys.Net.WebServiceFailedException: The server method 'returnLogo' failed with the following error: <html>    <head>        <title>Unknown web method 'returnLogo'.<br>Parameter name: methodName</title>        <style> ...   Anybody know why?   Tks

Input string was not in a correct format.

  
I am trying to convert a null value to a double value using convert function in C#. Can anybody help me in this regards... I am getting a null value in a variable named "gridCol1" Step 1 - I am doing                Convert.ToDouble ( gridCol1.ToString() );                Error : "Input string was not in a correct format."

My problem with an gridView, Input string was not in a correct format.

  
Hello all ! I'am actually encounter problem with an gridView which is composed of five columns, the both first are string type, third is date and the two last are linkbutton to edit or delete rows. On clicking edit button, i catch good event to edit and traitment  work fine but on living function an error occur with this message : error : System.FormatException: Input string was not in a correct format. stackTrace :   [FormatException: Input string was not in a correct format.] System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) +7471479 System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) +119 System.Web.UI.WebControls.GridView.GetRowIndex(GridViewRow row, String commandArgument) +99 System.Web.UI.WebControls.GridView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) +602 System.Web.UI.WebControls.GridView.RaisePostBackEvent(String eventArgument) +207 System.Web.UI.WebControls.GridView.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) +175 System.Web.UI.Page.ProcessRequestMain(Boolean inclu

WebSecurity covert string to int error?

  
Server Error in '/dev' Application. Cannot convert type 'string' to 'int' 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: Microsoft.CSharp.RuntimeBinder.RuntimeBinderException: Cannot convert type 'string' to 'int' Source Error: Line 12: login_password = Request.Form["login_password"]; Line 13: string login_username = Request.Form["login_username"]; Line 14: if(WebSecurity.Login(login_username, login_password)){ Line 15: Response.Redirect("~/"); Line 16: } Source File: c:\WWW\cisatools.com\apps\csg\dev\login.cshtml Line: 14 Stack Trace: [RuntimeBinderException: Cannot convert type 'string' to 'int'] CallSite.Target(Closure , CallSite , Object ) +216 System.Dynamic.UpdateDelegates.UpdateAndExecute1(CallSite site, T0 arg0) +344 Microsoft.WebPages.SimpleMembershipProvider.GetUserId(Database db, String userTableName, String userNameColumn, String userIdColumn, String userName) +1199 Microsoft.WebPages.SimpleMembershipProvider.VerifyUserNameHasConfirmedAccount(Database db, String username, Boolean throwException) +51 Microsoft.WebPages.SimpleMembershipProvider.Vali

Need to convert query string(date - 09/15/2010) to a text format - yyyymmdd

  
I am fairly new to C # and need some assistance with a form page.  I have created a simple form that requires the user to select a beginning date and ending date.  I then pass the values to my code behind page via query strings.  I have them passing, but I need the format to be change to a different format.  Unfortunately the database does not use the standard date format.  It requires the date to be in a text format as YYYYMMDD.Form: <tr> <td> Beginning Date:</td> <td><asp:TextBox runat="server" ID="begDate"></asp:TextBox> <asp:Image ID="Image2" ImageUrl="~/images/calendar_schedulehs.png" runat="server" /></td> </tr> Code Behind: protected void createReport_Click(object sender, EventArgs e) { StringBuilder url = new StringBuilder("Report/TopCustomer.aspx?"); url.Append("BegDate=" + begDate.Text); url.Append("&EndDate=" + endDate.Text); url.Append("&Brnch=" + ddlLocation.SelectedValue); Response.Redirect(url.ToString()); Current URL: TopCustomer.aspx?BegDate=09/15/2010&EndDate=09/30/2010&Brnch=300I need to have the above URL change to:TopCustomer.aspx?BegDate=20100915&E
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend