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
Hi, I am PHP developer, and I want to learn new language. So, which language to learn React js or Python? 
Python is the best language to start with, I suggest you to start with Python.
72
What is the difference between web design & UI design?
So a UX designer chooses how the UI functions while the UI designer chooses how the UI looks, and the web designer puts it all together into a cutting-edge website. This is a community-oriented procedure,...
I completed my B.Tech in may 2019 in Electronics and Communication with 71% from an NIT. Since no company came for placements in Core company I ended up in a software development job. I joined this job in Bengaluru last month and got Web development Role. But I want to switch to some Electronics Core job. Embedded System or VLSI. I will really appreciate your suggestions
In Hyderabad there are so many famous institutes....like vector and tech veda..... always embedded systems and VLSI are having very nice career opportunities.....
Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com
Ask a QuestionRelated Lessons
Nest GCS -Top 10 SAP ABAP Institutes in Hyderabad Enhanced his Professional Value
As a computer science graduate with an MBA in Systems, Fahim was working as an in-charge of the ERP software implementation and maintenance project of a logistics firm with country-wide presence. The entire...
Search engine optimization
Now there are a lot of e-books online sharing a lot about Search engine optimization, like how to do it. What are the benefits of SEO or tips and tricks, so I was thinking is there any thing new that can...
M
Cracking Mainframes Interview
Prepare the basic questions that talks about you, your Project, Current work etc Practice and Take as many Mock Interviews as Possible with your friends or experts in Mainframes Technologies.
N
Inversion of Control
Problem You have classes that have dependencies on services or components whose concrete type is specified at design time. In this example, ClassA has dependencies on ServiceA and ServiceB. Figure 1 illustrates...
Why Should We Learn Java Language?
Most of starters has confusion today that which of the programming language should be chosen to work on. It totally depends upon your need. As per my opinion, if you want to grow your career in IT industry...
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
