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 everyone, I want to start my career in SAP. Can anyone tell me which module is best for me to get a job easily?
My qualification: B.Tech ECE (Having 1+ yrs of experience in webdesigning UI).
Go with SAP ABAP including HANA with Mobility / UI5 and Web dynpro ... Try online Corporate training at www.sapglobalsupport.com, it have the best trainers... They can support you till you get the good Job
8 Benefits of doing advanced computer course? 
It will help you in future.. knowledge is the investment...
I am currently working in Storage technology (EMC, IBM). I want to move to Cloud Computing. I would like to understand. 1) Which Cloud Technology I will need to learn now. 2) Can you please suggest a good tutor/institute where they teach about the background on how it works, not just explaining the front end software. Because, this will really help me to understand in case tomorrow I have to plan existing storage infrastructure into Cloud. 3) I recently learnt Python and have good amount of knowledge on it. So will this help?
If you want to understand cloud technology basics, I would recommend that you take the Rackspace CloudU certification. This does not cost any money and it will lay the foundation of cloud technology...
What are the best sources to learn iOS mobile application development?
Search the best IOS developer and learn from that guys or you could find the best institute or trainer who gave the depth knowledge for develop the IOS Apps
I want to become Android/ IOS Developer. But I have confusion that which OS I should learn, I don't know the difference, current market values, scopes, etc. So it would be grateful if you can clear my doubts?
Hi , You can go for Cross Platform Development. With Cross Platform development you will be able to write code once and run in any Platform like Android, iOS and Windows. Microsoft has developed a...
Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com
Ask a QuestionRelated Lessons
Approach for Mastering Data Science
Few tips to Master Data Science 1)Do not start your learning with some software like R/Python/SAS etc 2)Start with very basics like 10th class Matrices/Coordinate Geometry/ 3) Understand little bit...
Understanding concept of Inheritance in Java
Inheritance: Acquiring a properties and methods from Parent class to Child class. For example, In some cases we can hear from any one of your relative or your friends will say like that "You are bahaving...
What is M.S.Project ?
MICROSOFT PROJECT contains project work and project groups, schedules and finances.Microsoft Project permits its users to line realistic goals for project groups and customers by making schedules, distributing...
What Is Power Query?
Power Query is an Excel add-in that can be used for data discovery, reshaping the data and combining data coming from different sources. Power Query is one of the Excel add-ins provided as part of Microsoft...
My first C++ program
# include using namespace std; int main() { cout<<"Welcome to C++"; return 0; } Use IDE such as CodeBlocks to run this program. To do this, open CodeBlocks, Goto File->New->Empty File. Copy...
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
