How to Get Server name, Database name, User name, Password from web.config file in C#

System.Data.Common.DbConnectionStringBuilder builder = new System.Data.Common.DbConnectionStringBuilder();

builder.ConnectionString = ConfigurationManager.ConnectionStrings["inventoryDBConnection"].ConnectionString; ;

string server = builder["Data Source"] as string;

string database = builder["Initial Catalog"] as string;

string UserID = builder["User ID"] as string;

string password = builder["Password"] as string;

Thanks For read this Article

Comments

How To Check if table exists in c#

Use this query to check table is exist or not "select case when exists((select * from information_schema.tables where table_name = 'Table_Name')) then 1 else 0 end " You Get result 1 for if Exist and 0 for Not Exist

MIME Types list

Multipurpose Internet Mail Extensions (MIME) is an Internet standard that extends the format of email to support: Text in character sets other than ASCII Non-text attachments: audio, video, images, application programs etc. Message bodies with multiple parts Header information in non-ASCII character sets MIME Types list Suffixes Mime .3dm x-world/x-3dmf .3dmf x-world/x-3dmf .a application/octet-stream .aab application/x-authorware-bin .aam application/x-authorware-map .aas application/x-authorware-seg .abc text/vnd.abc .acgi text/html .afl video/animaflex .ai application/postscript .aif audio/aiff .aif audio/x-aiff .aifc audio/aiff .aifc audio/x-aiff .aiff audio/aiff .aiff audio/x-aiff .aim application/x-aim .aip text/x-audiosoft-intra .ani application/x-navi-animation .aos application/x-nokia-9000-communicator-add-on-software .aps application/mime .arc ap...

How to get First,Last,Next,Previews Data in .Net C#

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.Odbc; using System.IO; namespace WindowsApplication1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } OdbcDataAdapter da; DataSet ds; int i = 0; int j; OdbcConnection conn; int last; private ...

Asp .Net Solution

Search This Blog