c#:配置系统初始化失败

本文关键字：初始化 失败 系统 配置 | 更新日期: 2023-09-27 18:27:18

我正在制作一个c#程序，该程序将windows窗体应用程序的输入转换为localDB。我浏览了app.config和实际调用的教程，也查看了这里的其他问题，但没有找到任何解决它的方法。特别是，如果我不使用try/catch，它会在"SqlCommand cmd=conne.CreateCommand（）；person newPerson=new person（FirstNameBox.Text，phoneBox.Text，emailBox.Text、LastNameBox.TText）；"它确实说"配置元素未声明"，但我没有看到任何显示它错误的内容？

try
        {
            System.Data.SqlClient.SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["database"].ConnectionString);
        SqlCommand cmd = conn.CreateCommand();person newPerson = new person(FirstNameBox.Text, phoneBox.Text, emailBox.Text, LastNameBox.Text);
        cmd.CommandText = @"Insert into Person (FirstName,LastName,Email,Phone)
                            VALUES(@FirstName, @LastName, @Email, @Phone)
";
        cmd.Parameters.AddWithValue("@FirstName", newPerson.getFirstName());
        cmd.Parameters.AddWithValue("@LastName", newPerson.getLastName());
        cmd.Parameters.AddWithValue("@Email", newPerson.getEmail());
        cmd.Parameters.AddWithValue("@Phone", newPerson.getPhone());
            conn.Open();
            cmd.ExecuteNonQuery();
            conn.Close();
            if (!ValidateForm())
            {
                return;
            }
        }
     catch (Exception ex)
        {
           MessageBox.Show(ex.Message,
          Application.ProductName,
          MessageBoxButtons.OK,
           MessageBoxIcon.Exclamation);
       }

app.config

<?xml version="1.0" encoding="utf-8" ?>
 <configuration>
 <startup> 
     <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5" />
</startup>
<configSections>
<sectionGroup name="applicationSettings"
              type="System.Configuration.ApplicationSettingsGroup, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" >
  <section name="Midterm.Properties.Settings"
           type="System.Configuration.ClientSettingsSection, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
           requirePermission="false" />
    </sectionGroup>
    </configSections>
    <connectionStrings>
    <add name="database" 
         connectionString=" Data Source=(LocalDB)'v11.0;AttachDbFilename=C:'Users'Matthew'Documents'Visual Studio 2012'Projects'Midterm'Midterm'Database1.mdf;Integrated Security=True;pooling=false"
       providerName="System.Data.SqlClient"  ></add>
     </connectionStrings>
<connectionStrings>
        <add name="Midterm.Properties.Settings.Database1ConnectionString"
        connectionString="Data Source=(LocalDB)'v11.0;AttachDbFilename=|DataDirectory|'Database1.mdf;Integrated Security=True"
        providerName="System.Data.SqlClient" />
     </connectionStrings>
 </configuration>

c#:配置系统初始化失败

配置字符串有两个部分。你只需要有一个

<connectionStrings>
    <add name="database" connectionString="......."/>
    <add name="Midterm.Properties.Settings.Database1ConnectionString" connectionString="..... " />
</connectionStrings>

您的配置文件中有两个不同的<connectionStrings>节点

<connectionStrings>
    <add name="database" 
     connectionString=" Data Source=(LocalDB)'v11.0;AttachDbFilename=C:'Users'Matthew'Documents'Visual Studio 2012'Projects'Midterm'Midterm'Database1.mdf;Integrated Security=True;pooling=false"
   providerName="System.Data.SqlClient"  ></add>
 </connectionStrings>
 <connectionStrings>
    <add name="Midterm.Properties.Settings.Database1ConnectionString"
    connectionString="Data Source=(LocalDB)'v11.0;AttachDbFilename=|DataDirectory|'Database1.mdf;Integrated Security=True"
    providerName="System.Data.SqlClient" />
 </connectionStrings>

将它们合并为一个<connectionStrings>条目。

<connectionStrings>
    <add name="database" 
     connectionString=" Data Source=(LocalDB)'v11.0;AttachDbFilename=C:'Users'Matthew'Documents'Visual Studio 2012'Projects'Midterm'Midterm'Database1.mdf;Integrated Security=True;pooling=false"
   providerName="System.Data.SqlClient"  />
    <add name="Midterm.Properties.Settings.Database1ConnectionString"
    connectionString="Data Source=(LocalDB)'v11.0;AttachDbFilename=|DataDirectory|'Database1.mdf;Integrated Security=True"
    providerName="System.Data.SqlClient" />
 </connectionStrings>
相关文章：