how can i create the app.config file in windows applications? [Resolved]

Hi

Are you using the below code

 string provider = ConfigurationManager.AppSettings["Provider"].ToString();

            string conStr = ConfigurationManager.AppSettings["CnStr"].ToString();

            DbProviderFactory factory = DbProviderFactories.GetFactory(provider);

            DbConnection connection = factory.CreateConnection();

            connection.ConnectionString = conStr;

            return connection;

this is properly working

Blessy Baby
Digitalmesh Softech pvt Ltd
https://blessybaby.wordpress.com/

Sudheep.grandhe, if this helps please login to Mark As Answer. | Alert Moderator

What is the Problem ?

Thank you for posting at Dotnetfunda
[Administrator]

Sudheep.grandhe, if this helps please login to Mark As Answer. | Alert Moderator

Hi,

DbConnection con = DBConnection.GetConnection(); in this line it wont display the getconnection();

this is my problem

Best,
Sudheep.

Sudheep.grandhe, if this helps please login to Mark As Answer. | Alert Moderator

let me see the definition of this function

GetConnection()

Thank you for posting at Dotnetfunda
[Administrator]

Sudheep.grandhe, if this helps please login to Mark As Answer. | Alert Moderator

Hi,

Here is the coding of the getconnection().please find it.

public static class DBConnections
{
static string provider = ConfigurationManager.AppSettings["Provider"].ToString();
static string conStr = ConfigurationManager.AppSettings["CnStr"].ToString();
public static DbConnection connection = null;
public static DbCommand command = null;
static DbProviderFactory factory;

public static DbConnection GetConnection()
{
string provider = ConfigurationManager.AppSettings["Provider"].ToString();
string conStr = ConfigurationManager.AppSettings["CnStr"].ToString();
DbProviderFactory factory = DbProviderFactories.GetFactory(provider);
DbConnection connection = factory.CreateConnection();
connection.ConnectionString = conStr;
return connection;
}

public static void CloseConnection()
{
if (connection != null)
connection.Close();
}

public static DbCommand GetCommand()
{
string provider = ConfigurationManager.AppSettings["provider"].ToString();
factory = DbProviderFactories.GetFactory(provider);
DbCommand command = factory.CreateCommand();
command.Connection = connection;
return command;
}

Best,
Sudheep.

Sudheep.grandhe, if this helps please login to Mark As Answer. | Alert Moderator

This

 ConfigurationManager.AppSettings["Provider"].ToString(); 

needs to be

ConfigurationManager.AppSettings.Get("Provider");

 

Change the others also

Thank you for posting at Dotnetfunda
[Administrator]

Sudheep.grandhe, if this helps please login to Mark As Answer. | Alert Moderator

Hi,

Thanks for replying to me.If changed over there it wont work.

Best,
Sudheep.

Sudheep.grandhe, if this helps please login to Mark As Answer. | Alert Moderator

Hi,

Could you please provide the error that you are getting. I didn't get any error while trying the same code.

Blessy Baby
Digitalmesh Softech pvt Ltd
https://blessybaby.wordpress.com/

Sudheep.grandhe, if this helps please login to Mark As Answer. | Alert Moderator

Hi,

Thanks for replying to me.DbConnection con = DBConnection.GetConnection(); in this line it wont display the getconnection(); after dbconnection it wont display the getconnection.i wrote the connection in dbconneciton.cs in above i posted the dbconneciton.cs coding.here is my app.config file code


<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<appSettings >
<add key ="petstore09" value ="C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data.mdb"/>
<add key ="petstore09" value ="Initial Catalog=petstore09;Data Source=mars-104;User Name=sa;Password=password"/>
</appSettings>
</configuration>

Best,
Sudheep.

Sudheep.grandhe, if this helps please login to Mark As Answer. | Alert Moderator

Hi,

it shows the error are

Error 1 Non-invocable member 'System.Configuration.ConfigurationManager.AppSettings' cannot be used like a method.

Best,
Sudheep.

Sudheep.grandhe, if this helps please login to Mark As Answer. | Alert Moderator

HI,

For me it's not working.I am using the same code.

Best,
Sudheep.

Sudheep.grandhe, if this helps please login to Mark As Answer. | Alert Moderator

Hi,

What was the issue.

Blessy Baby
Digitalmesh Softech pvt Ltd
https://blessybaby.wordpress.com/

Sudheep.grandhe, if this helps please login to Mark As Answer. | Alert Moderator

Hi,

In this line string conStr = ConfigurationManager.AppSettings["CnStr"].ToString();.i have to giving the databasename as "petstore09".i am giving the other one.that's all my issue was resolved.

Best,
Sudheep.

Sudheep.grandhe, if this helps please login to Mark As Answer. | Alert Moderator