Search Results

Search found 137 results on 6 pages for 'datareader'.

Page 2/6 | < Previous Page | 1 2 3 4 5 6  | Next Page >

• Transfer DataReader rows to a CrystalReport DataSet

  - by lennie

  Please help me as I am a newbie using VB.NET. I have been asked to transfer rows from a DataReader into a Crystal Report dataset. Here are the coding: Private Sub BtnTransfer() dim strsql as string = "Select OrderID, OrderDate from ORDERS" dim DS as new dataset1 '<---crysal report dataset1.xsd dim DR as SqlDataReader dim RW as…

  Read the article

• Checking if a record in datareader is NULL

  - by user279521

  I have browsed thru other postings on S/O, but I can't find a solution that works for me. I have a datareader that might return a null value, and if so, I want to value to equal blank txtMiddleName.Text = rdrGetUserInfo.GetString(1) ?? ""; The string above does not work. When I walk thru the code, the code jumps to my error trapping block; …

  Read the article

• Execute sql statement and get datareader - WITH flow control

  - by dotnetdev

  I have a standard method which gets some data from SQL Server. I want to refactor this so that based on the value of an enum (passed as a method parameter), a different sql statement is executed (all return datareader). I can't seem to code this in a way which is elegant and tidy. What would be a good way to do this? Thanks

  Read the article

• ExtJS: Ext.data.DataReader: #realize was called with invalid remote-data

  - by TomH

  I'm receiving a "Ext.data.DataReader: #realize was called with invalid remote-data" error when I create a new record via a POST request. Although similar to the discussion at this SO conversation, my situation is slightly different: My server returns the pk of the new record and additional information that is to be associated with the new…

  Read the article

• How to tell if a datareader is open on a connection and close it

  - by Earlz

  Hi, I'm setting up a little thing for connection pooling and on of the more common bugs that we have occur(its always an easy fix, but we just can't remember reader.Close()!) it is when we have a connection that is used by a lot of classes/methods and one method opens a data reader and forgets to close it. This isn't really bad cause a lot…

  Read the article

• F# working with DataReader

  - by mamu

  let getBytesData x = let len = reader.GetBytes(1, int64 0, null, 0, 0); // Create a buffer to hold the bytes, and then // read the bytes from the DataTableReader. let buffer : byte array = [||] reader.GetBytes(1, int64 0, buffer, 0, int32 len) |> ignore buffer let retVal = List [ while reader.Read() do yield…

  Read the article

• DataReader already open when using LINQ

  - by Jamie Dixon

  I've got a static class containing a static field which makes reference to a wrapper object of a DataContext. The DataContext is basically generated by Visual Studio when we created a dbml file & contains methods for each of the stored procedures we have in the DB. Our class basically has a bunch of static methods that fire off…

  Read the article

• Using application roles with DataReader

  - by Shahar

  I have an application that should use an application role from the database. I'm trying to make this work with queries that are actually run using Subsonic (2). To do this, I created my own DataProvider, which inherits from Subsonic's SqlDataProvider. It overrides the CreateConnection function, and calls sp_appsetrole to set the…

  Read the article

• How to initialize F# list when size is unknown, using while..do loop

  - by James Black

  I have a function that will parse the results of a DataReader, and I don't know how many items are returned, so I want to use a while..do loop to iterate over the reader, and the outcome should be a list of a certain type. (fun(reader) -> [ while reader.Read() do new…

  Read the article

• Close reader before closing connection

  - by Dan

  Should you always close a DataReader before closing the connection, or is it okay to just close the connection? By just closing the connection does that effectively close the reader? (This is for c#.net 3.5) Thanks!

  Read the article

• how can i loop through all of the columns of the OracleDataReader

  - by ooo

  I have the following code and i want to loop through all the fields in the result of this query and populate the dictionary called field. Given a datareader is this possible? OracleCommand command = connection.CreateCommand(); string sql = "Select * from MYTABLE where ID = " + id; …

  Read the article

• Get the number of Rows returned by a OleDbDataReader ASP.NET (VB)

  - by AZIRAR

  Hey, After connecting to a database using DataReader, how can I count the number of rows ? Thanks.

  Read the article

• There is already an open DataReader associated with this Command error in Linq To sql

  - by dinesh

  I am getting the above error when i retreived the data from the Datacontext Model. it is happening now and then also.

  Read the article

• XML/C#: Read content if only if attribute is correct

  - by Zach

  Hi Guys, I have an XML file as follows, and I'm trying to read the content of the Name tag, only if the attribute of the Record tag is what I want. (continued below code) The XML file is: <?xml version="1.0" encoding="utf-8" ?> <Database> <Record Number="1"> <Name>John Doe</Name>…

  Read the article

• How to initialize list with parent child relation

  - by user2917702

  Let's say I have the following classes. public class Parent { public string name; IList<Children> children; } public class Child { public string parentName; public int age; } As it is understandable, each parent can have multiple children, and we can have multiple parents. What is the best way to…

  Read the article

• How to validate DataReader is actually closed using FxCop custom rule?

  - by tanmay

  I have written couple of custom rules in for FxCop 1.36. I have written code to find weather an opened DataReader is closed or not. But it does not check which DataReader object is calling the Close() method so I can't be sure if all opened DataReader objects are closed!! 2nd: If I am a DataReader in an 'if/else'…

  Read the article

• How to fix Index out of range exception on idatareader

  - by Phil

  Good morning stack overflow, I have been forced into using the idatareader as opposed to the sqldatareader which has .hasrows available. In my code I am attempting to handle nulls like this: reader = GetContent(pageid) While reader.Read If reader("content") IsNot DBNull.Value Then …

  Read the article

• Read from multiple tables in vb.net data reader

  - by user225269

  I'm trying to read from two tables in mysql: Dim sqlcom As MySqlCommand = New MySqlCommand("Select * from mother, father where IDNO= '" & TextBox14.Text & "' ", sqlcon) -But I get this error: Column 'IDNO' in where clause is ambiguous Here is the whole code: Dim NoAcc As String Dim…

  Read the article

• C# Object Creation from Datatable

  - by Jonesy

  Hi Folks, Im just getting my head round C#. I've been creating classes and objects so say i created a class called Member: public class Member { public int MemberID; public string FirstName; public string LastName; public string UserName; } and i create a new…

  Read the article

• combobox with for each loop

  - by Mary

  Hi I am a student do anybody know after populating the combobox with the database values. How to display the same value in the text box. When I select a name in the combobox the same name should be displayed in the text box I am using seleted item. Here is the code. I am getting the error the…

  Read the article

• Strange results from OdbcDataReader reading Sqlite DB

  - by stout

  This method returns some strange results, and was wondering if someone could explain why this is happening, and possibly a solution to get my desired results. Results: FileName = what I'd expect FileSize = what I'd expect Buffer = all bytes = 0 BytesRead = 0 BlobString = string of binary…

  Read the article

• Idatareaders not returning values from database

  - by Phil

  In my codebehind I have this vb: Dim reader as idatareader = includes.SelectDepartmentID(PageID) While reader.Read Did = reader("departmentid") GroupingHeading = reader("heading") Folder = reader("folder") If reader("OwnBanner") Is…

  Read the article

• MySQL Casting in C#

  - by user798080

  Okay, so I'm attempting to print out the contents of a table in a comma-separated file. using (OdbcCommand com = new OdbcCommand("SELECT * FROM pie_data WHERE Pie_ID = ?", con)) { com.Parameters.AddWithValue("", Request.Form["pie_id"]); com.ExecuteNonQuery(); using…

  Read the article

• Knowing what input radio is selected on ASP.NET (VB)

  - by AZIRAR

  Hello, I'm creating input radio dynamicly on a ASP.NET page using PlacHolders. While reader.Read Dim ltr As New Literal() Dim ltr1 As New Literal() Dim ltr2 As New Literal() Dim ltr3 As New Literal() Dim ltr4 As New Literal() ltr.Text = reader.GetString(2) & "<br…

  Read the article

• how to get varchar as byte[] using DataReader in Ado.Net?

  - by Krishna

  how to get varchar as byte[] data using DataReader in Ado.Net? We have tried the following code. if (!objDataReader.IsDBNull(i)) { long len = objDataReader.GetBytes(i, 0, null, 0, 0); …

  Read the article

< Previous Page | 1 2 3 4 5 6  | Next Page >