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 Last Modified  

50 Answers

+1

Follow 13
Answer

Please enter your answer

Krishna Murari

IT Professional with 8+ years of teaching experience

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
Comments
Dislike Bookmark

Computer Teaching 1.5yr, Mathematics Teaching 1yr Excel Teaching 6Month

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
Comments
Dislike Bookmark

IT professional with 5 years experience

<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
Comments
Dislike Bookmark

RPA Developer with 4 years of experience

<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>
Comments
Dislike Bookmark

IT Professional Trainer with 10 years of experience in IT Industry

<connectionStrings> <add name="ConnStringDb1" connectionString="Data Source=localhost;Initial Catalog=YourDataBaseName;Integrated Security=True;" providerName="System.Data.SqlClient" /> </connectionStrings>
Comments
Dislike Bookmark

IT Proffesional with 4 years of expo in development and support

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
Comments
Dislike Bookmark

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
Comments
Dislike Bookmark

Dot net Profficient with 4 year experince

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
Comments
Dislike Bookmark

"Where Mathematics Meets The Elegance"

<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
Comments
Dislike Bookmark

IT professionals instructor with experience of AI

<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
Comments
Dislike Bookmark

View 48 more Answers

Related Questions

Who is the inventor of C programming?
Dennis Ritchie in the year of 1970 created C Programming language. He is a computer czar also helped to develop the Unix operating system.He died in the year of 2011 on Wednesday at his home in Berkeley Heights, New Jersey
Shreya
0 0
7

I have completed a B.com, an MBA in Finance and Marketing, and 5 years of experience working with SAP software in the oil and gas industry.

Please advise on the best professional course to pursue in order to land a job in a multinational corporation / IT ?
Doing a certification in SAP would help you to get into IT. Certain companies in Oil industry are having their IT wings which can be your target job market.
Priya
What is the actual size of INT in the C language, 2 or 4 bytes?
The actual size to int is determined by the compiler as the program runs. But theoretically the size is 2 bytes. You can increase the size by adding keyword long infront of it to make the size 4 bytes. Eg int a; // 2 bytes Long int b; // 4 bytes
Kunal
what is syntex error
A syntax error is an error which found in the source code of a program or sometimes it can be small grammatical mistakes in spelling or limited to a single character. Programming languages follow their...
Tanha
I am 3 yr experienced in a product but as it is an older version I need to update to new technologies to switch. What is good SSIS tool or Sharepoint for switch?
SSIS is good choice and this will be relevant for your skill set.
Rashmi

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

How to Learn salesforce easily?
Steps: 1.Know the course content. 2. Collect all materials. 3. Separate all materials into A.Admin B.Development C.Project. 4. Get the best trainer and follow him/her. 5. Update your skills with the help of all available resources.

Venkatramana K.

1 0
0
How Does Blockchain Help Fight Fraud?
Definition of Fraud: Noun "1. Wrongful deception with the intent to gain personally or financially. 2. Intentional deception in order to persuade another person to part with something of value. 3....

Utkarsh Kumar

0 0
0
A note on working of Transmission Control Protocol in Computer Networks.
TCP Connection establishment and termination TCP is one of theTCP is connection oriented protocol and reliable protocol. It originated in the initial network implementation in which it complemented the...

Yashika Goel

1 0
0
10 Best Job Interview Tips for Jobseekers
10 Best Job Interview Tips for Jobseekers:- 1. Conduct Research on the Employer, Hiring Manager, and Job Opportunity2. Review Common Interview Questions and Prepare Your Responses3. Dress for Success4....

Itech Analytic Solutions

0 0
0
Example of DependsOnMethod in TestNG
public class dependsonM { @Test public void login() { System.out.println("login"); } @Test (dependsOnMethods = {"login"}) public void email() { //Intentionally I am failing this testcase Assert.assertTrue(false);...
S

Sarthak C.

0 0
0

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 >

Find IT Courses near you
IT Courses in Bangalore
IT Courses in Hyderabad
IT Courses in Delhi
IT Courses in Chennai
IT Courses in Pune
IT Courses in Mumbai
IT Courses in Kolkata
IT Courses in Noida
IT Courses in Gurgaon
IT Courses in Ghaziabad
Online IT Coaching

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