how can make a connection string in a class file

Posted by Umeshdwivedi under Regular Expressions on 7/31/2011 | Points: 10 | Views : 5568 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

dear to all
i want to mak a connection string in class file and call the function in .cs code
how can i do .give me an example

Latest Technology Trainer
And Part time software consultant

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: SheoNarayan on: 8/1/2011 [Administrator] HonoraryPlatinum | Points: 25

0	What is the problem you are facing when you are trying to do so? What approach you have used that is causing problem in doing this? Ideally you store the database connectionstring into the web.config file and access it in the class file using ConfigurationSettings that exists in the System.Configuration namespace. Something like below protected static string ConnStr = ConfigurationSettings.AppSettings["ConnStr"].ToString(); Above code only works if your database connection string exists into your web.config file like this <add key="ConnStr" value="Data Source=MY-PC\SQLEXPRESS;Initial Catalog=xxx;Persist Security Info=True;User ID=xxx;Password=xxx;" /> Thanks Regards, Sheo Narayan http://www.dotnetfunda.com Umeshdwivedi, if this helps please login to Mark As Answer. \| Alert Moderator

What is the problem you are facing when you are trying to do so? What approach you have used that is causing problem in doing this?

Ideally you store the database connectionstring into the web.config file and access it in the class file using ConfigurationSettings that exists in the System.Configuration namespace. Something like below

protected static string ConnStr = ConfigurationSettings.AppSettings["ConnStr"].ToString();

Above code only works if your database connection string exists into your web.config file like this

<add key="ConnStr" value="Data Source=MY-PC\SQLEXPRESS;Initial Catalog=xxx;Persist Security Info=True;User ID=xxx;Password=xxx;" />

Thanks

Regards,
Sheo Narayan
http://www.dotnetfunda.com

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

Latest Posts