GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Tech FAQs  >  SQL Server
Go To First  |  Previous Question  |  Next Question 
 SQL Server  |  Question 39 of 60    Print  
Connection of SQL file to web page
How we can pulish the connectivity of SQL query to the HTML file or web page? Please Explain.


  
Total Answers and Comments: 1 Last Update: January 30, 2008     Asked by: sonukarnatak 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
January 30, 2008 01:51:50   #1  
Mena1710 Member Since: January 2008   Contribution: 16    

RE: Connection of SQL file to web page
Normally connection of SQL file to a web page can be done in two ways

1. Through the code
2. In web config file

If we give through the code, we need to alter the relevant pages, where as if we give through web config , this will be a common file and will be accessed by all files.  More if any changes in tatabases connection then it is easy

Connection is established by giving connection strings.  connection strings is nothing but details of the server, username and password to establish connection

Hope this has made things clear

Thanks
Anna

 
Is this answer useful? Yes | No

 Related Questions


Assume that I have created a employees table which has 10 records. How to create a stored procedure to export all the records into the log file.
Read Answers (3) | Asked by : vani

I have three task in my SSIS package,1. Script Task2. Execute Process Task3. FTP Task I want to enable disable Execute Process Task and FTP Task on runtime using script task, How to do that?Do we have any property of dts using which we can access property of other task iin script task like Dts.Connection("Connectionname") for Connection Controls?

How we can pulish the connectivity of SQL query to the HTML file or web page? Please Explain. 
Latest Answer : Normally connection of SQL file to a web page can be done in two ways1. Through the code2. In web config fileIf we give through the code, we need to alter the relevant pages, where as if we give through web config , this will be a common file and will ...

How to transfer data from a text file to SQL table, Which is the best method to do that? 
Latest Answer : By using OPENROWSET commandExample:                   INSERT INTO dbo.ImportTestSELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:ImportData.xls', ...
Read Answers (1) | Asked by : Veeramma


 Sponsored Links

 
Related Articles

SQL Server 2005 Integration Services Review

SQL Server 2005 Integration Services using Visual Studio 2005 A Beginner s Guide SQL Server 2005 A offering of Microsoft Corporation for database management the SQL server 2005 is one of the powerful database management systems in the world Available for integration in almost any system that uses Mi
 

SQL Server Integration Services

SQL Server Integration Services Here is a sample chapter from Beginners Guide to SQL Server Integration Services Using Visual Studio 2005 by Jayaram Krishnaswamy Environment set up for Visual Studio 2005 with respect to SSIS and multiple tasking Connecting to Microsoft Access Text Files Excel S
 

Web Server

Web Server A web server can be a program or the computer itself which receives the requests from various other browsers and responds to those requests These requests are all requests that are being sent for some documents There are two kinds of web servers available The web server program and the
 

Client-Server Models and N-Tier Applications

Client Server Models and N Tier Applications One of principal objective of Client Server methods is to provide data to an end user However Client Server architectural methodologies are much more complex Client Server describes the process wherein a client program generates contact with a separate se
 

Java and Client Server Models

Java and Client Server Models The Role of Client Servers on the Web Client server models provide the essential mechanisms for working with the Internet In fact most of the World Wide Web is built according to this paradigm In client server models the web browsers run by millions of users are the cli
 

Web Services and Client Server Technology

Web Services and Client Server Technology Introduction to Distributed Computing The Internet and expanded network connectivity established client sever models as the preferred form of distributed computing When talking about Client Server models of networked communication using web services the broa
 

Object-Oriented Client-Server Internet

Object Oriented Client Server Internet OCSI Environments as IT Infrastructure Client Server Basics Object Oriented Client Server Internet OCSI environments provide the IT infrastructure for supporting OCSI applications For our purposes infrastructure refers to operating systems networks middleware
 

N-Tier Client-Server Architecture

N Tier Client Server Architecture Description of 1 Tier and 2 Tier Web Applications This article will discuss the various architectures of Client Server environments Perhaps the most influential Client Server environment is the Internet and its global users With the increasing use of web application
 

What is Data File

In a logical data model, the conceptual data model which is based on the business semantic is being defined. Thus, entities and relationships and corresponding table and column design, object oriented classes, and XML tags, among other things are being laid regardless of the database will be physica
 

Language Enhancements in SQL Server 2005

The T-SQL has been enhanced to include error handling, recursive query and to support the new database engine capabilities. Two new relational operators have been introduced—PIVOT and UNPIVOT for use in the FORM clause query. They perform manipulation on an input table valued expression an
 





About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape