Hi, I have asp.net project with sql connection.I want connect database with asp.net and run the project and web config file there
Asked by Fathima Ruksar Last Modified
Follow 13 
Answer 
Put this in Web configuration file as: <connectionStrings> <add name="yourconnectinstringName" connectionString="Data Source= DatabaseServerName; Integrated Security=true;Initial Catalog= YourDatabaseName; uid=YourUserName; Password=yourpassword; " providerName="System. Data. SqlClient" />...
read more Put thisin Web configuration file as: <connectionStrings> <add name="yourconnectinstringName"connectionString="Data Source= DatabaseServerName; Integrated Security=true;Initial Catalog= YourDatabaseName; uid=YourUserName; Password=yourpassword; " providerName="System. Data. SqlClient" /></connectionStrings> read less
2
Comments
In web.config: <connectionStrings> <add name="ConnectionString" connectionString="Data Source=192.168.1.25;Initial Catalog=Login;Persist Security Info=True;User ID=sa;Password=example.com" providerName="System.Data.SqlClient" /> </connectionStrings>In Class.cs public static string ConnectionString{...
read more In web.config: <connectionStrings> <add name="ConnectionString" connectionString="Data Source=192.168.1.25;Initial Catalog=Login;Persist Security Info=True;User ID=sa;Password=example.com" providerName="System.Data.SqlClient" /> </connectionStrings>In Class.cs public static string ConnectionString{ get{ return ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;} set{} read less
2
Comments
<connectionStrings> <add name="yourconnectinstringName" connectionString="Data Source= DatabaseServerName; Integrated Security=true;Initial Catalog= YourDatabaseName; uid=YourUserName; Password=yourpassword; " providerName="System. Data. SqlClient" /> </connectionStrings>
read more <connectionStrings> <add name="yourconnectinstringName"connectionString="Data Source= DatabaseServerName; Integrated Security=true;Initial Catalog= YourDatabaseName; uid=YourUserName; Password=yourpassword; " providerName="System. Data. SqlClient" /> </connectionStrings> read less
1
Comments
<connectionStrings> <add name="ReviewsConnectionString" connectionString="Data Source=serverName; Initial Catalog=databaseName; Persist Security Info=True; User ID=username; Password=password" providerName="System.Data.SqlClient" /> </connectionStrings>
1
Comments
<connectionStrings> <add name="ConnStringDb1" connectionString="Data Source=localhost;Initial Catalog=YourDataBaseName;Integrated Security=True;" providerName="System.Data.SqlClient" /> </connectionStrings>
1
Comments
namespace DemoApplication { public partial class Demo System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { string connetionString; SqlConnection cnn; connetionString = @"Data Source=WIN-50GP30FGO75;Initial Catalog=Demodb ;User ID=sa;Password=demol23"; cnn...
read more namespace DemoApplication { public partial class Demo System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { string connetionString; SqlConnection cnn; connetionString = @"Data Source=WIN-50GP30FGO75;Initial Catalog=Demodb ;User ID=sa;Password=demol23"; cnn = new SqlConnection(connetionString); cnn.Open(); Response.Write("Connection MAde"); conn.Close(); } } } read less
0
Comments
Pravin Barmashe
Research Professional with 12 Years of Experience in Computer Programming and Research Tools
'Connectionstring' is the variable to use the connection string in any class of the .net. ip_address_of_server : represents the ip of the server databasename : database name username : name of the database user password : password of the database associated with the user Use belo code in web.config file...
read more 'Connectionstring' is the variable to use the connection string in any class of the .net. ip_address_of_server: represents the ip of the server databasename: database name username: name of the database user password: password of the database associated with the user Use belo code in web.config file <appSettings><add key="connectionstring" value="server=ip_address_of_server;database=databasename;uid=username;pwd=password"/> </appSettings> read less
0
Comments
After opening the web.config file in application, add sample db connection in connectionStrings section In appsetting section like this: <connectionStrings> <add name="yourconnectinstringName" connectionString="Data Source= DatabaseServerName; Integrated Security=true;Initial Catalog=...
read more After opening the web.config file in application, add sample db connection in connectionStrings section In appsetting section like this: <connectionStrings> <addname="yourconnectinstringName"connectionString="DataSource=DatabaseServerName;IntegratedSecurity=true;InitialCatalog=YourDatabaseName;uid=YourUserName;Password=yourpassword;"providerName="System.Data.SqlClient"/> </connectionStrings> read less
0
Comments
<connectionStrings> <add name="yourconnectinstringName" connectionString="Data Source= DatabaseServerName; Integrated Security=true;Initial Catalog= YourDatabaseName; uid=YourUserName; Password=yourpassword; " providerName="System.Data.SqlClient" /> </connectionStrings>
read more <connectionStrings> <addname="yourconnectinstringName"connectionString="DataSource=DatabaseServerName;IntegratedSecurity=true;InitialCatalog=YourDatabaseName;uid=YourUserName;Password=yourpassword;"providerName="System.Data.SqlClient"/> </connectionStrings> read less
0
Comments
<connectionStrings> <add name="yourconnectinstringName" connectionString="Data Source= DatabaseServerName; Integrated Security=true;Initial Catalog= YourDatabaseName; uid=YourUserName; Password=yourpassword; " providerName="System.Data.SqlClient" /> </connectionStrings>...
read more <connectionStrings> <addname="yourconnectinstringName"connectionString="DataSource=DatabaseServerName;IntegratedSecurity=true;InitialCatalog=YourDatabaseName;uid=YourUserName;Password=yourpassword;"providerName="System.Data.SqlClient"/> </connectionStrings> read less
0
Comments
View 48 more Answers
Related Questions
If i would like to take Online Tuition, then what are the neccessary equipments I should have ? 
You need to have a Headset with Mic along with Windows OS in Laptop/Desktop which would be enough.
16 How can you check to see whether a symbol is defined?
You can use the #ifdef and #ifndef preprocessor directives to check whether a symbol has been defined (#ifdef) or whether it has not been defined (#ifndef).
Hello, I have completed B.com , MBA fin & M and 5 yr working experience in SAP PLM 1 - Engineering documentation management 2 - Documentation management Please suggest me which IT course suitable to my career growth and scope in market ? Thanks.
If you think you are strong in finance and costing, I would suggest you a SAP FICO course which is definitely always in demand. if you have an experience as a end user on SAP PLM / Documentation etc, even a course on SAP PLM DMS should be good.
Hello all, I have completed B.com, MBA fin & M and 5 yr working experience in SAP PLM 1 - Engineering documentation management 2 - Documentation management Please suggest me which type of training I should take for getting more knowledge, clear all concept in details, also help for getting job and cracking interview questions for SAP consultant. 1) Real time training 2) Online training 3) Local institute training 4) Certification training
Hi Priya, since you have B Com and MBA Finance better to go with SAP FICO. Whether online or classroom it doesn't make much difference. But the subject should be learned thoroughly. It will increase your...
Where can i download Red Hat Linux 6.3 for free?
Check this Link Dines : http://iso.linuxquestions.org/red-hat/
Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com
Ask a QuestionRelated Lessons
What is Microsoft Access?
Microsoft Access has been around for some time, yet people often still ask me what is Microsoft Access and what does it do? Microsoft Access is a part of the Microsoft Office Suite. It does not come with...
Creating Formulas In Excel
Formulas in MS Excel: Formulas are the Bread and butter of worksheet. Without formula, worksheet will be just simple tabular representation of data. A formula consists of special code, which is entered...
Why we need to learn Programming languages?
Language is medium for communication. If two parties like to communicate or exchange the thoughts they must know a language. Language should be understandable by both the Parties. For example A wants to...
What is Big Data and Why Do Organizations Need It?
Big data is a term that describes the large volume of data – both structured and unstructured – that inundates a business on a day-to-day basis. But it’s not the amount of data that’s...
A New Way To Learn Web Development.
Hello, My name is Ajay. I work at a small IT company and yes on weekends provides some training and guidance and consultancy to students. Before past 7-8 months, I was just a random student just like so...
Recommended Articles
Make a Career in Mobile Application Programming
Almost all of us, inside the pocket, bag or on the table have a mobile phone, out of which 90% of us have a smartphone. The technology is advancing rapidly. When it comes to mobile phones, people today want much more than just making phone calls and playing games on the go. People now want instant access to all their business...
Read full article >
Make a Career as a BPO Professional
Business Process outsourcing (BPO) services can be considered as a kind of outsourcing which involves subletting of specific functions associated with any business to a third party service provider. BPO is usually administered as a cost-saving procedure for functions which an organization needs but does not rely upon to...
Read full article >
Top 5 Skills Every Software Developer Must have
Software Development has been one of the most popular career trends since years. The reason behind this is the fact that software are being used almost everywhere today. In all of our lives, from the morning’s alarm clock to the coffee maker, car, mobile phone, computer, ATM and in almost everything we use in our daily...
Read full article >
Why Should you Become an IT Consultant
Information technology consultancy or Information technology consulting is a specialized field in which one can set their focus on providing advisory services to business firms on finding ways to use innovations in information technology to further their business and meet the objectives of the business. Not only does...
Read full article >
Looking for IT Courses ?
Learn from the Best Tutors on UrbanPro
Are you a Tutor or Training Institute?
Join UrbanPro Today to find students near you
