C# - Use Dataset Or Datatable?

Dec 17, 2010

If I need to fetch one whole column from Table1 in the DB, should I fetch it using datatable or dataset? I can do both ways. I mean ok I should use Datatable. Why is that? What would happen if I use Dataset? ok that's what I wanted to know. So there's memory issue. I mean whatever I use be it Datatable or Dataset, both will be fetching only ONE column frommy table in DB. How is Dateset's gonna use more memory then?

View 3 Replies


Similar Messages:

How To Copy Data From Datatable To Dataset.datatable

Oct 31, 2010

how to copy data from datatable to table in dataset i ry this but its readonly property

ds.datatable1=newdt.copy

View 1 Replies

Dataset Vs. Returning A Datatable

Aug 15, 2010

I have created alot of stored procedures in my application that return the result of a query in a datatable object. I never use a dataset. Why would I ever use a dataset over simply returning the result of a query as a datatable object?

View 3 Replies

ADO.NET :: Number Of Datatable In One Dataset Can Contain?

Aug 6, 2010

i have one question for my project. i am fetching all users data in one dataset, but each user will be in unique datatable to avoid no. of database connection i will fetch data in one single transaction no. of user are more than 10000 ..is it practical to store more than 10000 tables in one single dataset what will be then performance issue for the same, it will be the diffrent application for my project to generate this much of data. how many no. of table one dataset can contain in visual studio 2008 with 3.5 framework?

View 2 Replies

ADO.NET :: Delete A Row In Datatable Using Linq To Dataset

Aug 31, 2010

how can i delete a row in datatable using linq to dataset?

I have a dataset in my project, need to delete some rows filtered by ID

how can i do?

View 5 Replies

Sort The Datatable After Binding The Dataset?

Apr 16, 2010

How to Sort The datatable in asp.net. after binding the dataset values i have stored into one table how can i sort the values of the dataset in asp.net with C#

View 4 Replies

How To Populate Google Charts Using Dataset / Datatable

Feb 24, 2011

How to populate google charts using ASP.NET Dataset/Datatable

View 1 Replies

C# - How To Use SqlDataSource For Filling Combobox As Well As Datatable Or Dataset

Apr 30, 2010

I am trying to fetch a column value from a datasource when some value is selected from a dropdownlist on its change event.

[Code]....

Here I want to fetch any other column's value that is not binded to a ddlCityName from sqldatasource.

I have four columns in datasource i.e. name, id, address, phno.

I want to fetch an address of a person who selects some value from ddl.

View 1 Replies

ADO.NET :: How To Create A Datatable With 2 Datatables In Dataset Programmatically

Apr 1, 2011

I have 2 views in sql server and I create a dataset with those 2 views as datatables. Now I need to create a datatable and programmatically fill it with the other 2 datatables. Take the 2 datatable and create a third one in the dataset not create a third view in sql server.

View 2 Replies

Security :: Assigning Result To Dataset Or Datatable?

Jan 1, 2010

I am using membership functions like

Roles.GetAllRoles()

or

Membership.FindUsersByName();

I want to assign the result of these fucntions to a dataset or datatable and not directly to a GridView.

View 3 Replies

Data Controls :: Get Top N Rows From Datatable Or DataSet In C#?

Jan 19, 2012

I have a datatable with 50+ rows I want to get the Top 10 rows and display.

View 1 Replies

Returning Multiple Tables To Dataset / How To Join/add Two Datatable

Jan 21, 2011

I need to return datatable to dataset in asp.net application. I have a method which has a return value as datatable.


However I need to send 2-3 datatable instead of one. I dont know how to join/add two datatable and what could be the return type?

View 2 Replies

VS 2010 - Return Data Reader Or Dataset / Datatable

Dec 18, 2010

Had a datareader question.

[Code].......

Return myDataReader I have a function which is retuning a datareader to various sections of my website which is then being bound to dropdown lists, gridviews, etc. Normally the last line in a function when is the data reader and connection getting closed? Is it best practive to return a data reader or a dataset/datatable (or something even better than these two)?

View 8 Replies

Web Forms :: Adding Datarows To Existing Datatable In Dataset?

Feb 5, 2010

I need to add rows to an existing (maybe) datatable in a dataset that combines the IIS6 index search with my own sql table. I keep getting object reference errors.

[Code]....

View 4 Replies

DataSource Controls :: Is Datatable Data Store In Dataset

Apr 24, 2010

is datable data store in asp.net dataset.. ?

View 1 Replies

DataSource Controls :: Use DataTable Instead Of DataSet / Returning One Table?

Apr 9, 2010

I'm returning one table. My understanding is that a DataSet can be made of more than one DataTable. I also understand that I can use either of these to return my one table.

Is it better to use the DataTable when I have one table to return instead of a DataSet? Is there any advantage of not using the DataSet in a situation like this? Is there a disadvantage to using the DataSet when only one table is being returned? Does this even matter?

View 6 Replies

AJAX :: Returning DataSet / Datatable From Webmethod To Javascript

Sep 16, 2010

I have a simple web method written in the code-behind (not a separate asmx) of a test aspx page.

All it does is return a DataTable(or DataSet) both are failing, gives a blank 500 error saying "There was an error processing the request"

If I switch the return variable type to String, it works fine

I think my issue has to do with the version of the System.Web.Extensions, is that the assembly that actually contains the JSON communication implementation?

I've read all kinds of tutorials about how it should be possible to return the DataTable to javascript and then read the properties with javascript syntax.

For some reason it isn't working for me.

My web extensions is imported through my web.config with the following version

<add
assembly="System.Web.Extensions,
Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>

View 5 Replies

DataSource Controls :: Datatable/Dataset Total Memory?

Mar 16, 2011

make a query which will give me 200,000 results and bind it to the datatable but the error will pop out saying out of memory or request timed out.Can datatable/dataset handle these records or is my current server's hardware needs a little upgrade?Actually we are gettings millions of data and i dont have any idea how to solve this one? Have you worked on this kind of data? Do you have any idea on how to send my command from server A to server B while server A also processing request and will not wait for server B's result and server B will just update the records in my database, i think this can solve my problem if doing it in parallel.

View 1 Replies

How To Extract Datatable Or DataSet From Linq Query Or List

Jun 13, 2010

how to extract DataTable or DataSet from Linq Query or List. e.g I have linq query like this

MyDBpDataContext dcSp = new MyDBpDataContext();
dcSp.myProgrammSP().ToList();

I wrote an Sp which sends a Table as result and I have code which is already using DataTable So I want to convert this result in DataTable.

View 1 Replies

Forms Data Controls :: Dataset / Datatable According To Pagesize Given?

Mar 26, 2010

I need your help / guidence for doing custom paging in c#, through sqlserver. so that i can have data in dataset/datatable according to the pagesize given, not all the data in dataset. some code /url .......with full discrption if possible.

View 12 Replies

Silverlight Grid Binding - Dataset/Datatable To List?

Aug 10, 2010

We are in the process of migrating our current asp.net gridviews to silverlight grids. The challenge that I am facing here is that in the gridview, the grid is bind to a dataset/datatable. But in silverlight, I do not have dataset/datatable available in the silverlight class. So only option is to create a Webservice and convert the dataset that I am currently getting from business layer to a class that imlements IList<> (unless there are any other ways). Now to convert this dataset to Ilist, I have to loop through the dataset to load the List. In my current dataset I have almost 10,000 records or even more in some cases. So the response time will be really slow.Are there anyways to

1) Load the List from dataset directly without looping through ?

2) Fetch the data from database directly to a List without having loading the dataset ?

View 7 Replies

Data Controls :: How To Check Whether DataTable (DataSet) Has Rows In C#

May 7, 2015

DataSet ds = new DataSet();
string qry = "select Name,Section,present from presentdays where id='" + TextBox1.Text;
qry += "'";
ds=mvl.GETDS(qry);
foreach (DataRow dr in ds.Tables[0].Rows)
{
TextBox2.Text = dr["present"].ToString();
TextBox12.Text=dr["Name"].ToString();
TextBox13.Text=dr["Section"].ToString();
}

there is no data in id='1'i need to throw the error as there is nothing is found in id='1'

View 1 Replies

Data Controls :: Check If Particular Value Exists In DataTable (DataSet) Using C#

May 7, 2015

check if variable exists in dataset ?

View 1 Replies

DataSource Controls :: How To Filter Dataset/datatable Depending On The Values

Apr 7, 2010

i have a dataset which contains some data.

let dataset have some columns one among them is " Type "

let the values in column type be type1,type2.type3 and so on

now if i want to filter dataset which contains only type3

View 4 Replies

Web Forms :: How To Bind Dataset Or Datatable From Web Method To Datalist Using JQuery

Jun 25, 2012

[URL]

     like above link i want to bind 

     name.....................

     city...... country.........  

for suppose 10 employee. for that i try to bind datalist using webservice & jquery. but i get lots of problem to bind datalist. with name as hyperlink so that when i click at name it go to next page and show details. 

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved