Using Statement When Setting Control's Datasource To Sqldatareader

Aug 25, 2010

I know it is recommended to use a using statement with a sqldatareader, but I was wondering if it is necessary when you are setting the datasource of a control to a datasource directly. in some places in my code I do this.

using (SqlDataReader reader = getReader())
{
while (reader.Read())
{
// do stuff with data
}
}

when binding to a control I do this.

ddlCustomer.DataSource = getReader(); // get Reader returns a sqldataReader
ddlCustomer.DataBind();

In the second case, do I need to use a using statement. Do i have to first declare an SqlDataReader in a using statement, then set the DataSource to that object. Seems like more clutter in the code, so i was hoping binding to the SqlDataReader disploses of the SqlDataReader.

View 3 Replies


Similar Messages:

DataSource Controls :: Using A Form View Control Instead Of The SQL Statement?

Feb 10, 2010

I hope I have the right forum =)

Here is the issue.

I have a table:

[URL]

What I would like to do is retrieve the Grade score based on a number that is between the Max and Min for that Job Title.

I presume the sql would be like:

"SELECT [Grade] FROM [NUGGET_Tech_Score] WHERE ([Job_Title] = @Job_Title AND @total BETWEEN [MinScore] and [MaxScore])"

However since I am new at this, I am not sure how to get the grade and show it as a label on my form.

Should I be using a Form View control instead of the SQL statement?

View 4 Replies

DataSource Controls :: SqlDataReader Does Not Get Results

Aug 19, 2010

I am trying to run a stored proc from this function. When I run it thorugh the debugger I can see that myReader.HasRows = true and myReader.FieldCount =14.

But the control does not go in the loop while (myReader.Read()) where I am trying to read Version field returned by the stored proc.

[Code]....

View 3 Replies

DataSource Controls :: Get ArrayList Value In SqlDataReader

Sep 24, 2010

I'm trying to convert some code from VB to C# on a site i'm working on and can't seem to get the arraylist to function properly.

Here is what we currently have in the codebehind:

[Code]....

Which we then call from the page using:

[Code]....

I want to convert this to C# as the rest of the code on the new site is in C# and I'm having problems with the ArrayList. I've got the other parts of the code all converted fine it's just the GetContent Function that isn't working right. Here's what I have:

[Code]....

I got an error on the "objSDR.Item" part of the code saying "SqlDataReader doesn't have definition for Item" and so if I changed this to the code above. Only problem now is I can't call this from the page using the code below as there is no "Item" in the GetContent Function any more

[Code]....

[Code]....

View 8 Replies

DataSource Controls :: Read A Bit Value From DB With SqlDataReader?

May 2, 2010

In SQL Server 2008 bit is like boolean (true/false), but I tried to read the bit value (0 or 1) and got error. How can I read it?

[Code]....

View 1 Replies

DataSource Controls :: How To Read Data From The SqlDataReader .

Apr 18, 2010

how to read data from the sqlDataReader .

sqlDataReader sdr = sql_comm.executeDataReader();
if(sdr.hasRows)
{
while(sdr.read)
i=0
[code]...

View 3 Replies

DataSource Controls :: Why SqlDataReader Class Is Not Instantiated

Feb 18, 2010

Why SqlDataReader Class object is not created by "new" Operator.

Is it not possible to create the object like below

SqlDataReader dr=new SqlDataReader();

dr=cmd.ExecuteReader();

Why the constructor of the SqlDataReader class is internal?

View 2 Replies

DataSource Controls :: How To Use SqlDataReader To Read The Last Row Added To A Table

Jun 17, 2010

[Code]....

My question is how do i use SqlDataReader to read the last row added to a table getting the contents of a column and storing it as a c# varaible

View 2 Replies

DataSource Controls :: SqlDataReader Class Is Not Instantiated By New Opperator?

Feb 19, 2010

When I am using SqlDataReader class on that time without creating instance of the SqlDataReader Class I m using Command.ExecuteReader() Method. Why We not create the object of the SqlDataReader Class by using " new " Operator.We use like below:

SqlDataReader dr=cmd.ExecuteReader();
Why not we use this class like below:

SqlDataReader dr=new SqlDataReader();

dr=cmd.ExecuteReader();

View 2 Replies

DataSource Controls :: Loading Datatable From SQLDataReader Does Not Call Set Method?

Apr 28, 2010

When using the DataTable.Load(SQLDataReader) method, if the datatable is a property of a class, the set method is not called to populate the object. For example...

MySQLDataReader = command.ExecuteReader();
if (MySQLDataReader.HasRows)

myObjDataTable.Load(MySQLDataReader); -- The result of this will be 0 rows returned. The "Set" method of the object is never called.

View 1 Replies

DataSource Controls :: SqlDataReader And The Invalid Attempt To Call FieldCount Error?

Mar 30, 2010

I have several methods where I return a SqlDataReader to populate Gridviews, Listview, etc. I get random "Timeout expired" errors regarding connection pooling, so I decided to add using{} to my methods. The lack of using is a carry over from my more beginner days.Below I included the before and after code. The after code always gives me the "Invalid attempt to call FieldCount when reader is closed" error. I have tried various combination of using{}, but ALL result in the same error.What am I doing wrong? Also, from the code below what is the best way to structure this code to ensure no connection leakage?Before:

[Code]....

After:

[Code]....

View 6 Replies

DataSource Controls :: Meaning Of N In Statement?

Jan 28, 2010

OBJECT_ID(N'AdventureWorks.Person.Address');

what does the "N" mean or do in this statement?

View 4 Replies

DataSource Controls :: Foreach Like Statement In T-SQL?

Mar 10, 2010

how to do do some action recurting each row? My data looks like

[Column1] [Column2]
item 1 10
item 2 5

I would like to do something like..

foreach row in Column1 <-- how would I do this part??
While (row.Column2 > 0)
BEGIN
.. do something
row.Column2 = row.Column2-1
END

View 3 Replies

DataSource Controls :: Select Top Record From Sql Statement

Mar 17, 2010

If I run the following SQL script:

[Code]....

View 3 Replies

DataSource Controls :: SQL UPDATE Statement Not Updating DB?

Feb 24, 2010

I am writing a simple form that will take in data and insert it into a db if it's a new record and update the existing record if it already exists. The insert works fine, but the update isn't working at all, yet the code looks solid to me and everything I've compared it to in my google searches.

[Code]....

View 7 Replies

DataSource Controls :: How To Select Statement For Some Scenario

Apr 24, 2010

I want the select statement for the above scenario.

View 2 Replies

DataSource Controls :: Using A Variable As A Parameter In A SQL Statement

Mar 25, 2010

I've done some SSIS package work in the past, but am by no means an expert.

I want to use an SSIS package to do the following:

1. Get the file name of the newest file in a windows folder (using a filename template like his: filename_ *.txt where the * part is always a date in the format of yyyy-mm-dd.

2. Use that file name in later portions of the SSIS package by reading the file and transferring data from it to a SQL table using a Data Flow task.

and use the result (which should be the name of the newest file) to open that file and pull data out of it and into a 2nd SQL table. I admit, I'm not sure how to use the dynamic result of this SELECT query as the file name in a flat file connection manager.

View 6 Replies

DataSource Controls :: How To Declare Variable From SQL Statement

Oct 21, 2010

I am rather confused as how or where to declare this variable in asp.net.

[Code]....

Whenever i put this in my sqldatasource for it is asking me to Define Parameters:

The wizard has detected one or more parameters in your SELECT statement. For each parameter in the Select Statement, choose a source for the parameter's value.

View 4 Replies

Binding Different LINQ Datasource Using Same Variable With If Statement?

Nov 27, 2010

OK So I know WHY I am having the error I am getting. I don't know HOW to fix it. Basically, if the user doesn't have a certain permission, I need to join another table. But .NET is so picky I can't just make two different queries in an IF statement and then use it outside of the if statement. I can think of some ugly work arounds for this, but I would rather not. I am fairly new to .NET I know just enough to be dangerous.

[code]....

I get the error: Unable to cast object of type

'System.Data.Linq.DataQuery1[VB$AnonymousType_111[System.Guid,System.String,System.String,System.String,System.String,System.Nullable1[System.DateTime],System.Nullable1[System.DateTime],System.Nullable1[System.Guid],System.Nullable1[System.DateTime],System.Nullable1[System.Guid],System.Nullable1[System.DateTime]]]' to type 'System.Collections.Generic.IEnumerable`1[Ten11CRMLib.Company]'.

because of this: Dim l As IEnumerable(Of Company) its not just IEnumerable of a Company, its got the source in it. I have to explicitly select source to use it in my datagrid. Can I make Dim l something that will make it stop complaining?

View 2 Replies

DataSource Controls :: Insert Query Statement?

Aug 16, 2010

I have SQL Details View insert statement, I need to have a Condition checked for the Insert Query. The condition is, I do have a table by name table1 with the No of Questions (for Eg: 10). The insert statement shud insert data to the table2 (Another table) only if the no of rows is less than or equal to 10 else it shud give me a message (It has exceeded the no of questions).

View 3 Replies

DataSource Controls :: Insert Statement And Where Clause?

Apr 7, 2010

I am trying to do an insert statement to a table from classic ASP.I tried the below:

[Code]....

But, I am getting the error as: Incorrect syntax near the keyword 'where'.How to insert data, using a where clause in the above scenario?

View 5 Replies

DataSource Controls :: INSERT SELECT Statement?

Apr 30, 2010

How would you handle an INSERT that gets some values from another table using SELECT, where you wanted some values to come from the source table record and other values to come from a different parameter source like a session value? Is this possible?

View 3 Replies

DataSource Controls :: Insert Statement Violation?

Jun 22, 2010

i'm developing windows application one of its forms supposed to fill a table called rooms with data throughout a collection of text boxes and comboboxes controls, i'm successfuly bound each control to the binding source and make sure that each data adapter contains the required data but when i start to excute the insert statement

insert into rooms([room_id],[floor],[price],[currency_id],[rec_id],[s/d],[s/ns],[room_direction],status)
values( '"+Int64.Parse(textBox1.Text) +
"' ,'" +
Int64.Parse(textBox2.Text) +
"', '" +
Int64.Parse(textBox3.Text) +
"','" + comboBox1.SelectedIndex +
"','" + comboBox2.SelectedIndex +
"','" + comboBox3.SelectedIndex +
"','" + comboBox4.SelectedIndex +
"','" + textBox4.Text +
"','" + comboBox5.SelectedIndex +
"')

it displays an error message when i'm trying to select a value from the combobox for any parameter that is"column currenc_id is constrained to be unique value 2 is already exists"can any body help me it is very important

View 5 Replies

DataSource Controls :: Sql Statement To Get One Record Each From Two Tables?

Feb 2, 2010

I don't know if I'm posting this in the right place - I have a feeling it can't be too difficult but I can't seem to figure it out. I've come across this problem many times and I've never solved it. I would imagine the scenario is commonplace - I have a table of Products with a PK of ProductID, and a table of related images with a FK of ProductID. Each product can have many images, but for my initial display I want to display one product record with one image record. I have a Sequence field in the Images table and I could pick the lowest one. Right and left Joins return too many records - if I have three images for Product 1 then Product 1 is listed three times.

I've gotten around this before using a flag in the Products table, or listing an image in both tables but I'm sure there must be a SQL statement that can get the information that I need.

View 5 Replies

DataSource Controls :: SQL Multiple Count Statement?

Jan 20, 2010

I am currently trying to create a SQL statement that does a multiple count on a table. The table has a number of reports each listing the "User" who created that report and if that report is "Famous" (A famous report is symbolised as 2 in the table).

What I need to create is a SQL statement that returns each User with the total number of reports he/she has created and how many of these reports are famous. My current SQL statement looks like:

[Code]....

View 4 Replies







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