what is datasource can u explain

Question

0.00/5 (No votes)

See more:

what is data source and how it is useful and can you tell me with code.i know a little about the data source but tell me working can u help me...

Posted 5-Dec-12 22:36pm

karthikeyan9966

Add a Solution

5 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Deenuji · Answer 1 · 2012-12-05T22:50:00

Data Source Controls:

Quote:
ASP.NET includes data source controls that allow you to work with different types of data sources such as a database, an XML file, or a middle-tier business object. Data source controls connect to and retrieve data from a data source and make it available for other controls to bind to, without requiring code. They can also support modifying data.

This topic provides information about the different types of data source controls in ASP.NET. The data source control model is extensible, so you can also create your own data source controls that interact with different data sources or that provide additional functionality for an existing data source.

In VB.Net

VB

Dim nwindConn As SqlConnection = New SqlConnection("Data Source=localhost;Integrated Security=SSPI;" & _"Initial Catalog=northwind")
nwindConn.Open()

[C#]

C#

SqlConnection nwindConn = new SqlConnection("Data Source=localhost; Integrated Security=SSPI;" + "Initial Catalog=northwind");
nwindConn.Open();

VishwaKL · Answer 2 · 2012-12-05T23:24:00

Solution 3

Data Source Controls Overview[^]

Data Source Controls[^]

Refer these links, you will understand what is the data source and what is the use.

Posted 5-Dec-12 23:24pm

VishwaKL

Updated 27-Feb-13 19:17pm

v2

Shubh Agrahari · Answer 3 · 2013-02-27T23:21:00

Hi friend...

With the help of Data Source Control, we can perform the data binding operation by writing some data access code. This is used to retrive a DataReader or a DataSet object from the server and you can show that retrived data in DataGrid, DropDownLIst or in ListBox.

Example:

SqlConnection con = new SqlConnection();

SqlCommand cmd = new SqlCommand("Select * from Emp", con);

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

da.Fill(ds);

GridView1.DataSource = ds;

GridView1.DataBind();

Happy to help

Singh Vijay Kumar · Answer 4 · 2012-12-05T22:45:00

Data Source Allows you to bind your controls directly with Datasets or Databse tables.

One of the Example is.

C#

Dataset ds = new Dataset();
ds = DBComponent.FillPlants();
DropdownList1.DataSource = ds.tables[0];
DropDwonlist1.DisplayField = "PlantName";
DropDwonlist1.ValueField = "PlantCode";

.......... so on.

samadhan_kshirsagar · Answer 5 · 2013-02-27T21:38:00

Solution 5

visit this link

http://pic.dhe.ibm.com/infocenter/idm/v2r2/index.jsp?topic=%2Fcom.ibm.optimd.install.doc%2FapxF_ODMInstall%2Fopinstall-t-odbc_data_source_definition.html[^]

Posted 27-Feb-13 21:38pm

samadhan_kshirsagar

what is datasource can u explain

5 solutions

Solution 2

Solution 3

Solution 6

Solution 1

Solution 5

Add your solution here

Preview 0