如何将应用程序名称添加到 <appSettings/>? [英] How to add Application name to <appSettings/>?
问题描述
这是我的 app.config 文件:
This is my app.config file looks like:
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<appSettings>
<add key="Application Name" value="/MyApplication" />
</appSettings>
<connectionStrings>
<add name="frmStartup.My.MySettings.HDIMembershipProviderConnectionString"
connectionString="Data Source=.\sqlexpress;Initial Catalog=HDIMembershipProvider;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
<system.web>
<membership defaultProvider="HDIMembershipProvider">
<providers>
<clear/>
<add name="HDIMembershipProvider" type="MyApplication.HDIMembershipProvider, MyApplication"/>
</providers>
</membership>
</system.web>
<system.diagnostics>
<sources>
<!-- This section defines the logging configuration for My.Application.Log -->
<source name="DefaultSource" switchName="DefaultSwitch">
<listeners>
<add name="FileLog"/>
<!-- Uncomment the below section to write to the Application Event Log -->
<!--<add name="EventLog"/>-->
</listeners>
</source>
</sources>
<switches>
<add name="DefaultSwitch" value="Information" />
</switches>
<sharedListeners>
<add name="FileLog"
type="Microsoft.VisualBasic.Logging.FileLogTraceListener, Microsoft.VisualBasic, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=MSIL"
initializeData="FileLogWriter"/>
<!-- Uncomment the below section and replace APPLICATION_NAME with the name of your application to write to the Application Event Log -->
<!--<add name="EventLog" type="System.Diagnostics.EventLogTraceListener" initializeData="APPLICATION_NAME"/> -->
</sharedListeners>
</system.diagnostics>
</configuration>
我正在尝试使用 HDI 会员提供程序,这是我的用户表结构:
I am trying to use HDI membership provider and this is my Users table structure:
在我最近的问题中问这里 Oded
帮我解决了插入语句的问题,我重新修改了它,我的数据库结构中有一个 ApplicationName 列,我需要指定它.(因为它不应该是空值)
And in my recent question asked here Oded
helped me out trying to figure the problem with my Insert statement and I re-modified it and I have an ApplicationName column in my database structure I need to specify it.(As it should not be null value)
现在我需要默认添加我的应用程序名称以进入数据库,就像我们为 web.config 所做的一样.
Now I need to add my application name by default to enter to database as we do it for web.config.
这就是我的意思.
我需要将该 MyApplication 添加到我的 app.config 文件中.
I need to add that MyApplication to my app.config file.
那我该怎么做?
这是我尝试将用户详细信息输入数据库的方式,但它没有输入单个值
This is how I'm trying to enter user details to database but it is not enetering a single value
Try
Dim connectionString As String = "Data Source=.\sqlexpress;Initial Catalog=HDIMembershipProvider;Integrated Security=True"
Using cn As New SqlConnection(connectionString)
cn.Open()
Dim cmd As New SqlCommand()
cmd.CommandText = "INSERT INTO Users ( Username, Password, Email, PasswordQuestion, PasswordAnswer) VALUES(@Username,@Password,@Email,@PasswordQuestion,@PasswordAnswer)"
Dim param1 As New SqlParameter()
param1.ParameterName = "@Username"
param1.Value = txtUsername.Text.Trim()
cmd.Parameters.Add(param1)
Dim param2 As New SqlParameter()
param2.ParameterName = "@Password"
param2.Value = txtPassword.Text.Trim()
cmd.Parameters.Add(param2)
Dim param3 As New SqlParameter()
param3.ParameterName = "@Email"
param3.Value = txtEmail.Text.Trim()
cmd.Parameters.Add(param3)
Dim param4 As New SqlParameter()
param4.ParameterName = "@PasswordQuestion"
param4.Value = txtSecurityQuestion.Text.Trim()
cmd.Parameters.Add(param4)
Dim param5 As New SqlParameter()
param5.ParameterName = "@PasswordAnswer"
param5.Value = txtSecurityAnswer.Text.Trim()
cmd.Parameters.Add(param5)
cmd.Connection = cn
cmd.ExecuteNonQuery()
cn.Close()
End Using
Successlbl.show
Successlbl.show.Text = "Regisration Success."
Catch
Errolbl.Show()
Errolbl.Text = "Your account was not created.Please try again."
End Try
谁能指出我哪里出错了.
Can anyone point me out where I'm making mistake.
这是我进入数据库时得到的最终结果:
And this is the final result I'm getting while entering to database:
为了更简洁明了,我需要使用 HDI 成员资格提供商将上面显示的用户详细信息输入到我的数据库中.
To be more short and clear I need to enter the above shown User details to my database using the HDI membership provider.
推荐答案
我自己摸索了很多头发,找到了解决方案,我把代码改成这样:
I have figured out the problem Myself after a lot of hair pulling and found the solution that I have changed my code in this way:
cmd.CommandText = "INSERT INTO Users ( Username,ApplicationName,Password,
Email, PasswordQuestion, PasswordAnswer) VALUES(@Username,@ApplicationName,@Password,
@Email,@PasswordQuestion,@PasswordAnswer)"
并以这种方式添加另一个参数:
And add another Param this way:
Dim param6 As New SqlParameter()
param6.ParameterName = "@ApplicationName"
param6.Value = txtApplicationName.Text.Trim()
cmd.Parameters.Add(param6)
我知道这不是最好的方法如果有人找到任何其他最佳解决方案,请告诉我.
I know this not the best way If anyone found any other best solution let me know.
这篇关于如何将应用程序名称添加到 <appSettings/>?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!