DataSource Controls :: Retrieve Text Field Using Datareader

Feb 25, 2010

I have text field on a sql server table and I retrieve it on string variable using datareader : string result = reader["MyTextfied"] but I have this errors ( text or binary field cannot be troncated ) My text fied contains a large of text

View 5 Replies


Similar Messages:

DataSource Controls :: Manage A Datareader With Data Field?

Mar 25, 2010

i have a datareader who read from data field from sql server, this field is datetime format now, when this field is null it returns 01/01/1900!! how can i manage it without if or some check, is there a property in datareader or sqlserver properties who i can return null value from datetime field?

View 4 Replies

DataSource Controls :: Almost 2 Seconds To Read A Datareader Field

Apr 16, 2010

I use a SqlDataReader to get fron sqlServer a row af a table. This table have a text field where I store a Xml configuration. In one case this Xml grow up to 650Kb. When I get the field from the datareader it cost amost 2 seconds:

INFO 2010-04-16 09:46:40,559 [12] Cms.dataContenido - readed
INFO 2010-04-16 09:46:42,356 [12] Cms.dataContenido - XMLContent

This is my code:

[Code]....

View 1 Replies

ADO.NET :: Getting DataReader Field Text To System.Collections.IEnumerator

Feb 22, 2011

cmd_again =
new
SqlCommand
();
cmd_again.CommandText =
"select * from QMS_Processes1 where QMSParentProcessId=" +
id + ";"
;
cmd_again.CommandType =
CommandType
.Text;
cmd_again.Connection = con_again;
rdr_again = cmd_again.ExecuteReader();
System.Collections.
IEnumerator
ienum = rdr_again.GetEnumerator();
while
(ienum.MoveNext())
{}

now i want 3 fields in datareader how do i get that?? i tried to create instance of System.data.common.dataRecordInternal..but it didnt happen.

View 4 Replies

DataSource Controls :: Retrieve Part Of A Data Field?

May 16, 2010

how one would retrive a value stored among several values in a single database field?

For example, the MS Customize CreateUserWizard walkthrough [URL] adds the ability to save the users preference for subscribing to a newsletter and allowing their info to be shared as 1 value in the comment column of the membership database. The result ofaspnet_Membership.Comment is Subscribe=TRUE&ShareInfo=FALSE.

My question is if Subscribe=TRUE&ShareInfo=FALSE is in one field of the database, how would you retrieve just the Subscribe=TRUE value from the field and use it to send a newsletter to the proper users while ignoring the ShareInfo=FALSE value?

View 3 Replies

DataSource Controls :: Retrieve A Certain Mssql Field And Use It As Value Source In An Object?

Mar 19, 2010

I'm an experienced PHP programmer that is new to ASP.net (C#). I'm trying to figure out how to do a manual echo of a specific field from an SQL database and was wondering how you do an if condition in case the field would meet certain criteria ?

What I want the script to do is check in the database if a certain condition is activated, then the html page should echo a windows media player object with the source of the video coming from the database itself ( $line[Video], and if the condition isn't active then either don't echo the player or just echo an old video (in the script I'm just printing a message).

in PHP:

[Code]....

View 9 Replies

DataSource Controls :: Retrieve Text Values From Sql Table Using An XML List?

May 6, 2010

Some ids are pulled out from the XML field of a certain User Profile . Those ids have their text values stored in a SQL table.

What is the best way to map that xml list to the SQL table in order to populate a dropdown list which contains ids from the XML list and text values from the SQL table?

View 1 Replies

DataSource Controls :: Saving A Text As Binary Into Db And Retrieve It To Read?

Jul 2, 2010

I am generating some text on my application just like as below;

KgQa5MgxIXH6czaTSue/zcjQ6p5d4BCK2uNgscHq3+h/gbbrfEPvWGySnZGy88ntm28DPFp3KhDFQhXHNkZecQI0HyBq7BDJTop6n0VgTWc2AQEnZWPvEgHc4vMTDIfnoY+/04414vOUdatD8G+CZexcJQr0Tz4jLkDEsI58xcc=

I wanna save this text in my sql db as binary.I wanna retrive it any time I want and read text and view it. How can I do that in c#. Aslo what should my table row type? binary(1000) is ok?

View 6 Replies

DataSource Controls :: Transforming 1 Text Field With A Stored Procedure?

May 12, 2010

I have imported a table from a text file and 1 of the fields was a text field and it imported with " around the text.

so instead of being Field Text it is "Field Text"

how with a simple stored procedure could I eliminate those quotation marks?

View 2 Replies

DataSource Controls :: Retrieve Data From Data Base And Display A Field Based On The Dropdown?

Jul 6, 2010

I am in need to retrieve data from data base and display a field based on the drop down is selected

View 2 Replies

DataSource Controls :: Importing Text Field From Excel To SQL Server 2005

Jun 10, 2010

from an Access database, I created an Excel spreadsheet. On the spreadsheet I made the adjustments I needed to and then proceeded to use the SQL Server 2005 Import/Export Wizard to import the spreadsheet into a SQL table. I then get the following error message:[Code]....

When I remove the problem columns from the import, then it works just fine. But I really need those text columns! The SQL Server columns that they are supposed to go into are varchar(MAX).

View 1 Replies

DataSource Controls :: Comparing Data In A Text Box To A Date Field In A Record?

Feb 12, 2010

I have a form that contains a text box called "MyDate" in which the user enters a date. I have a table that contains records of which one of the fields in the record is a date field named "DateAvailable" (type is "datetime"). I want to compare the data in the text box to the "DateAvailable" field in record. How do I define my text box as a "datetime" field.

View 2 Replies

DataSource Controls :: Stored Procedure To Insert Value From A Text Field Into 2 Fields In Two Different Tables?

Mar 31, 2010

I want to insert username and password into two tables (say table1 as well as table 2) using stored procedure.

View 4 Replies

DataSource Controls :: Need To Store In MS SQL Server 2005 A Vary Large Text In To One Field Of Type Nvarchar?

Feb 13, 2010

I have the following problem: I need to store in MS SQL Server 2005 a vary large text in to one field of type nvarchar(MAX), In spite of the configuration is apparently correct I keep receiving the following message in the exception: "string or binary data would be truncated".

View 1 Replies

DataSource Controls :: Use A DataReader With SQL?

Mar 29, 2011

I have put a SQLDataSource on my page and everything is adjusted and it works properly. I read an article
here which was indicating that you can use a DataReader in order to get data from sqldatasource, but it doesn't say how, the only thing that is said is to use DataSourceMode property in order to adjust it for a DataReader.

View 1 Replies

Forms Data Controls :: Changing Webpage Label Text Based On Datasource Field In A Repeater Control?

Jan 27, 2011

I have a web page that has a repeater bound to a data source. I beed to change a label inside the repeater based on the data that is in each repeater item. For instance, for the first item it might be one thing, and for the next item the label may be something else. I am currently doing some processing in the prerender event, but I don't know if I can or how to access the data source fields there. Where and how do I get access to the data in each item so I can change the label text?

View 3 Replies

DataSource Controls :: How To Load A DataReader

Apr 21, 2010

How do I load a datareader in a defult.aspx page using while using a database connection that is defined in the web.config file?

View 3 Replies

DataSource Controls :: Create ConnectionString Using SQL DataReader

Sep 11, 2010

why this first connection works but the second doesn't?

[Code]....

I'm trying to use <asp:FileUpload> to upload images and as far as I know you have to use <asp:SqlDataSource> to do it but I need to create the connections string using entries stored in a database.

View 2 Replies

DataSource Controls :: DataReader Telling Me It Needs To Be Closed

Jun 28, 2010

Dim sqlc1 As New SqlCommand("sp_navmenu 275,1,21", ERIKSDbCon)

View 4 Replies

DataSource Controls :: How To Evaluate Nothing Value Returned By Sql Datareader In Vb.net

Aug 24, 2010

When a sql query returns NULL , I can use the following code to evaluate:

[Code]....

When a sql query returns nothing, neither IsDBNull nor is Nothing works. I don't know why some sql queries return null while some return nothing when there are no data returned. But anyway, can somebody tell me how to evaluate nothing value returned in sql datareader in vb.net? When I put the cursor over signInfo variable in debug mode, I can see Nothing show as its value. But the line does not work

[Code]....

View 3 Replies

DataSource Controls :: How To Convert Datareader To Dataset

May 11, 2010

Any one can suggest a method to convert Datareader to dataset or any alternate method

View 7 Replies

DataSource Controls :: DataTable With DataReader Not Working?

May 17, 2010

dataTable with dataReader not working

[Code]....

View 3 Replies

DataSource Controls :: Datareader - Loop Through Results In VB?

Feb 1, 2010

I would like to loop through my result set and generate a menu structure like this:

pagetitle
pagetitle
subtitle
subtitle
pagetitle
pagetitle

So far I have the following code but it doesn't generate the menu?

While reader.Read()
' set title
sitetitle = reader.Item("siteName")
mydata &= reader.Item("pagetitle")
' check subtitle exists, if so, build menu, loop though subtitles somehow?
if not IsDBNull(reader.Item("subtitle"))
mydata = "<ul>"
mydata &= "<li>" & reader.Item("subtitle") & "</li>"
mydata &= "</ul>"
end if
End while

Qeury and result set below:

sql:

SELECT subpages.subpageid, pages.pageid, sites.sitename, sites.siteid, pages.siteid,pages.pagetitle, subPages.subtitle FROM pages LEFT JOIN sites ON pages.siteid = sites.siteid LEFT JOIN subpages ON subpages.subpageid= pages.pageid WHERE sites.siteID = 1 ORDER BY sites.siteid, pages.pageid, subpages.subpageid ASC

results:

subpageid | pageid | siteid | siteid | pagetitle | subtitle
NULL 1 SCHS 1 1 Sandwell Community Healthcare Services NULL
NULL 2 SCHS 1 1 About Us NULL
NULL 3 SCHS 1 1 Your Services NULL
4 4 SCHS 1 1 Equality and Diversity Team at SCHS 1111
4 4 SCHS 1 1 Equality and Diversity Team at SCHS 2222
4 4 SCHS 1 1 Equality and Diversity Team at SCHS 333
4 4 SCHS 1 1 Equality and Diversity Team at SCHS 44444
NULL 5 SCHS 1 1 Single Equality Scheme NULL
NULL 6 SCHS 1 1 Diversity Strands NULL
NULL 7 SCHS 1 1 Equality Impact Assessments NULL
NULL 8 SCHS 1 1 Quality and Safety Committee NULL
NULL 9 SCHS 1 1 Contact Us NULL

View 5 Replies

DataSource Controls :: DataReader.Read() Not Working?

Mar 16, 2010

I have used SqlDataReaders a million times. Someone, what is wrong with this code:

SqlConnection connection = new SqlConnection(connectionString);
try
{
connection.Open();
SqlCommand command = connection.CreateCommand();

[Code]....

I have checked this against similar classes and it is exactly the same, but this one doesn't work.

View 4 Replies

DataSource Controls :: There Is Already An Open DataReader Associated With This Command Which Must Be Closed First.

May 27, 2010

protected void Page_Load(object sender, EventArgs e)

View 7 Replies







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