VS 2010 - Return Data Reader Or Dataset / Datatable

Dec 18, 2010

Had a datareader question.


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

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


View 1 Replies

ADO.NET :: When To Use 'reader' Versus A Datatable, Table Adaptor?

Sep 20, 2010

I'm making the leap from using all the 'wizards' that are built into VS, and have been doing more with code-behinds. But, I'm curious as to when/why I should use a reader, versus a databable, table adaptor to "manage" the data returned from a stored procedure. Typically, the data is to be displayed on a webpage, and not written back to the database. What's the difference? When should I use one over another?

View 2 Replies

SQL Server :: Get Return Value From Server In C# Through Data Reader?

Feb 5, 2011

I want to take my return value from sql server to c#.

my code


ALTER procedure [dbo].[userss](@email varchar(100),@password varchar(25),@name varchar(250),@DOB varchar(20),@acc_vari int,@ip_address varchar(50),@vari_code varchar(7) )
declare @uid int
select @uid=uid from users where email='12we'
return 0
insert into users values(@email,@password,@name,@DOB,@acc_vari,@ip_address,@vari_code )

In this i want to take return value "return 0 " from sql server to c#.

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

VS 2010 - Adobe Reader In Web Browser / IFrame

Jul 25, 2011

Our ASP.NET application allows the users to review any number of PDF forms. A simple listbox holds filenames and the forms are displayed inside a standard iFrame. The setup is simple and effective: when the user clicks on a filename, that filename is loaded into the iFrame, and shown to the user.

Users are allowed to digitally sign the forms. For appearance purposes, a bitmap of the user' signature is generated and placed in the appropriate location of the PDF form.

The bitmap file format is GIF, and the background is transparent.

We use iTextSharp for form-filling, and we also use iTextSharp to place the bitmap on the forms. Nothing special.

We can readily verify that the signature bitmap is correctly placed on the form, and that the bitmap itself is definitely transparent.

Problem 1:

After placing the bitmap of the user' signature on the form, the form is reloaded and displayed to the user (for verification) and, in most cases, the forms do not display the bitmap. Opening the PDF reveal that the bitmap has been placed and is definitely visible in Adobe Reader (9 and 10 - these are the versions available for testing).

Experimentation and quite a bit of research seems to suggest that the problem lies in caching. One of the possible solution/suggestion is to append a time-stamp or a GUID to the URL, when loading the form after applying the bitmap. In theory, this should prevent Adobe Reader from using a cached copy of the PDF form.

We have tried appending a time-stamp and/or a GUID, without any success: the forms still display without the bitmap. At the risk of repeating myself: the PDF form is correctly signed, and the bitmap is correctly placed. It is just not visible.

This problem seems common to users running the application on intranet web servers (IIS 7). The one application instance running on public web server (IIS 7) does not seem affected by this problem.

Problem 2:

As mentioned, the GIF file generated by our application has a transparent background. In almost all cases, Adobe Reader (9 and 10) seems to understand and respect the transparency of the bitmap.

In one very peculiar case (when the application is running on a Windows 7 64 bit machine with IIS 7), when the bitmap is placed on the form, it becomes opaque (complete loss of transparency).

Again, the problem seems related to Adobe Reader, because the bitmap being applied positively sports a transparent background.

View 1 Replies

DataSource Controls :: Is Datatable Data Store In Dataset

Apr 24, 2010

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

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

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 += "'";
foreach (DataRow dr in ds.Tables[0].Rows)
TextBox2.Text = dr["present"].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

Forms Data Controls :: Return Dataset As Datasource For Gridview

Dec 5, 2010

I am trying to return a dataset. I must be doing something wrong. The returned dataset in this sample code indicates there is a datatable, Users, but there are no datarows. What am I doing wrong? This example is only using the rows.count, but of course I really need to use the whole datatable as the datasource for a gridview.


Public Function getmyds() As DataSet
Dim dsUser1 As DataSet = New DataSet()
Dim tbUser1 As DataTable = dsUser1.Tables.Add("Users")
tbUser1.Columns.Add("Days Remaining")
Dim rwDefaultUser1 As DataRow = tbUser1.NewRow()
rwDefaultUser1("UserName") = "John Smith"
rwDefaultUser1("Days remaining") = 100
rwDefaultUser1("userAccountControl") = "Enabled"
Return dsUser1
End Function

View 2 Replies

Forms Data Controls :: Return Number Of Rows In A Dataset?

Jan 14, 2010

I'm using a table adapter to perform my queries. I'm sure I'm missing something really easy, but I can't figure out how to return the number of rows returned from a query to a dataset used for a GridView.Basically, I want to display a message "No records exist for your selection" by testing for ReturnedRows = 0.

Excerpt of C# code:

handoutDSTableAdapters.handoutTableAdapter handoutsAdapter =
new handoutDSTableAdapters.handoutTableAdapter();
gv_Handout.DataSource = handoutsAdapter.GetDataByDoctor(Int32.Parse(ddl_MD.SelectedValue));

View 4 Replies

Data Controls :: Export DataSet Or DataTable To PDF In (WinForms) Application

Mar 31, 2014

 I want to get print out for Dataset which creates a pdf file as out put.

View 1 Replies

Data Controls :: Fetch Top N Records From DataTable Or DataSet In Net Framework 2.0

May 7, 2015

Aspx code:

MembershipUser m_user = Membership.GetUser();
DataTable dt = new DataTable();
foreach (ListItem li in lst_Users.Items) {

[Code] ....

I am calling "Application object" from above aspx page into web service page as below:

[WebMethod(EnableSession = true)]
[ScriptMethod(ResponseFormat = ResponseFormat.Json)]
public string WebMessage() {
List<string> list = new List<string>();
DataTable dt = ((DataTable)HttpContext.Current.Application["Message"]);

[Code] ....

I want to know that the approach im using in Web service page to fetch top 5 messages from Datatable is correct or not? How to do that without using LINQ as I am using framework 2.0 ...

View 1 Replies

Forms Data Controls :: Use Dataset And Datatable To Bind Data To A Gridview?

Aug 27, 2010

on which all conditions we use dataset and datatable to bind data to a gridview?

View 2 Replies

Forms Data Controls :: Bind Data From DataSet (DataTable) To A Selectrow DropDownList In GridView?

Nov 19, 2010

I have a Gridview and two link button in that GridView , one link button click is to add edit row ( Edit ), one link button click is to select row ( Select ). I have a dropdownlist inside row which selected when i click link button Select in the gridview edit template, as of my business logic i need to show the dropdownlist only when the user clicks Edit button and when the user clicks Select button . That mean when the user clicks Select button then they clicks Edit button on the gridvview i should allow him to edit the dropdownlist (showing the value to the user through a label).


[Code].... C#

When I click Select link button , then I click Edit link button . They have errors : Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index" I don't know what error?. How to fix it

View 3 Replies

Forms Data Controls :: How To Add A Data In Datagridview Without Using Datatable Or Dataset

Feb 26, 2011

i am using vb.net 2008 i need to know about datagridview ......Is it to possible to add a data through vbcode in datagridview without using any datatable or dataset....

View 1 Replies

Data Controls :: Pass DataTable Or Dataset As Parameter To WebMethod Of WebService

Mar 16, 2014

can datatable pass to web service as input parameter? i have a scenario to pass values as datatable to web service. eg as follows

when Invoice or Bill is entered, I want to send the entered data as datatable to web service to insert into another application.

View 1 Replies

Data Controls :: Generic Method To Bind DropDownList With DataTable Or DataSet

Sep 4, 2012

i have 2 dropdown list and i need to create a Generic method so that I an reuse it...

View 1 Replies

VS 2010 - How To Use The Adobe PDF Reader (AxAcriPDFLib) Control To Display Preview Of PDF Document

Jan 31, 2011

In a VB.Net project I use the Adobe PDF Reader (AxAcriPDFLib) control to display a preview of a selected PDF document whereafter the user can double-click upon the selected listbox item to enjoy a full screen view of the relevant PDF document. see the attached sample in this regard. Is there any way to emulate this in ASP.Net?

View 5 Replies

Forms Data Controls :: Binding Datatable To Grid View Based On A Return From A Tableadapter?

Feb 17, 2010

I have no clue what I'm doing wrong here, but I wanted to create a grid view based on a return from a tableadapter.



Also, maybe I should be going about this another way as I wanted to add a drop down to each record and a link to each record.On pointers on how I should do this would be great too.

View 6 Replies

VS 2010 - Create Class To Return Data As List Object

Dec 4, 2013

I have a Google spreadsheet that I am reading data from and I want to load the data into a list object so I can use but I am having some issues.

Google Spreadsheet
-Worksheet name: Charts
-Tab: Color_Summarized
-Column 1: ColorSummary
-Column 2: ChildID
-Column 3: ParentID

sample rows:

My results are
Yellow Color_Summarized FH 55 28

How do I need to set it up so it keeps all the data loaded instead of just the last instance? Is there a better way then putting in class?

My code:

Imports Microsoft.VisualBasic
Imports System.Data
Imports System.Collections.Generic
Imports Google.GData.Spreadsheets


View 3 Replies

ADO.NET :: Can't Get Reader.hasrows And Reader.read To Work Together In Code Behind

Feb 22, 2011

I have some code in my vb.net code behind that queries a database, and if there is data, outputs it from the codebehind to a datalist on my asp.net page. In addition to sending the data to the datalist on the page, I need to take the value from "mbillaty" that is returned from the sql query, and have that value be the selected value for a drop down box also on the page. I can get either the datalist to fill, or the selected value for the dropdown box to be selected depending upon which bit of code I place before the other (ARGH), but I can't get them to both work together on the page. What am I doing wrong?


View 2 Replies

VS 2010 - Reading Excel Data Into Dataset Loses Data

Apr 22, 2014

I have a client that provides a .xls file on their site that we have no control over that we download the file and then read it to update inventory. The first column is the SKU and in cell A2 it has the value 1028. This outputs fine but when I get to A8 the value is '1051-LV' and in my output it is blank. I am thinking in my dataset it reads A2 value and that becomes the type for the remainder of the rows. But what if that is wrong? How do I fix so it doesn't set the datetype to say int when it could be a string type?

Below is my code and works but the output of certain rows sku values are blank and are not like that in the excel file.

Protected Sub btnGetExcelFile_Click(sender As Object, e As System.EventArgs) Handles btnGetExcelFile.Click
litOutput.Text = ""
Dim ws As New WebPost
ws.URL = "http://www.domain.com/dropship/feed.xls"
'downloads excel file based on url
Dim bExcel() As Byte = ws.RequestBinaryData("", True)

[Code] ....

View 2 Replies

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

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