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
How will career as Sap hana modeler be in future? 
SAP HANA is the only course will give you an edge over other guys as HANA is the best Analytical tool by any company in market and for this you can ask even 100% hike from other companies...and this...
5 I want to change my domain from php to android mobile application? Can I get.
Yes very easy for you to move from php to android. Android is programming in java. Both are in web technology. For Android you just need core java knowledge..that's it. Many tutorials spoon feeding now...
what are the major critriea to learn programing?????
There is no major criteria to learn programming. Yes, you should have knowledge of computer and zeal to learn. Rest of the things will be in favour with you.
Hi, can anyone tell me where I can learn more and be professionally guided on 1-1 basis , on Machine Learning and Deep learning using Python? I already have statistics and programming background
I would first recommend taking some good Linear Algebra course, you would need some intuitive understanding about concepts like linear leas squares, singular value decomposition, normal equations,etc....
Which technology is better to learn Linux, java or python to get a good job please help me out in this?
actually both are two different technologies, java is object oriented programming where as unix is operating sysstem so, there is no relation between both so, its your choice to learn either java or unix....
Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com
Ask a QuestionRelated Lessons
Pl SQL Cursors
To process an SQL statement, ORACLE needs to create an area of memory known as the context area; this will have the information needed to process the statement. This information includes the number...
How Design Concept related to company or client requirement
How we design new things & how we incorporate these things to make things practically proved. First we get input from product end user, because our client guide us what type of system they want or...
D
Framework in Automation Testing & its advantages?
Q) Do You Know what is a framework? What are the advantages of Automation Framework?A) Framework is a constructive blend of various guidelines, coding standards, concepts, processes, practices, project...
I
Advanced Filter in Microsoft EXCEL
ADVANCED FILTRATION PART NAME C Lang. JAVA NAME C Lang. JAVA SAME LETTER NAME CRITERIA ASHU 55 63 A* ...
V
Formula to Populate Weekdays of a Given Month
If you want to populate weekdays (Monday to Friday) in a range, follow below steps. Step1: In Cell A1 write any month 1st date. Let’s say 02/01/2017 (Feb 1st 2017) Step2: In Cell C1 write this...
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
