Data Controls :: Error While Converting DataList To PDF

Mar 31, 2014

While I am converting datalist to pdf it diplays below error:

Control 'DataList1_ctl00_RadioButton1' of type 'RadioButton' must be placed inside a form tag with runat=server.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Web.HttpException: Control 'DataList1_ctl00_RadioButton1' of type 'RadioButton' must be placed inside a form tag with runat=server.

Source Error: 
Line 52: StringWriter sw = new StringWriter();
Line 53: HtmlTextWriter hw = new HtmlTextWriter(sw);
Line 54: DataList1.RenderControl(hw);
Line 55:
Line 56: StringReader sr = new StringReader(sw.ToString());

Code :

protected void Button1_Click1(object sender, EventArgs e) {
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=Respiratory.pdf");
StringWriter sw = new StringWriter();

[Code] .....

View 1 Replies

Similar Messages:

Data Controls :: C# Error - Arithmetic Overflow Error Converting Expression To Data Type Datetime

May 7, 2015

I am trying to insert a value in database from a dropdownlistddlvaue = 10.00 - 11.00in db asstarttime=10:00:00endtime=11:00:00using split function

string dropdownvalue = ddlduration.SelectedItem.Text.ToString();
string et = dropdownvalue.Split('-')[1].ToString();
endtime = et.Split(' ')[1].ToString();
starttime = dropdownvalue.Split(' ')[0].ToString();
I am joining date value + time value in the query uisng('" + datevalue + "' + ' ' + '" + starttime + "')

'2014-05-15' + '16.00' --> to get 2014-05-15 16:00:00

it is getting inserted successfullybut while selecting and viewing it from the database I am getting error as,

"Arithmetic overflow error converting expression to data type datetime"

If i mannually enter the date in db it is workingmanuall value=2014-09-30 14:00query value =2014-09-30 14:00

both are same but error is only occuring for query inserted value

View 1 Replies

DataSource Controls :: Error Converting Data Type Nvarchar To Int?

Jan 6, 2010

when i am trying to uedit my recods in gridview this error is coming. I am using SQLDatasource with gridview and for edit purpose i am using stored procedure. I have manually executed the SP and its woring fine. my SP is here


and my SQLDataSource is here


and gridview is here


View 2 Replies

Data Controls :: SQL Error / Conversion Failed When Converting Nvarchar Value To Data Type Int

May 7, 2015

how can in sql server show two columns as one column.. one of them is nvarchar  and the other is int from two tables i have did this but it give error

select depart.depart_name+input_comp.no_of_depart as department,dbo.depart.depart_id from dbo.depart inner join dbo.input_comp on dbo.depart.depart_id=dbo.input_comp.depart_id group by depart.depart_name,dbo.depart.depart_id,input_comp.no_of_depart
the depart_name is nvarchar datatypeand the no_of_depart is int datatype

the error is

Conversion failed when converting the nvarchar value to data type int. 

View 1 Replies

Data Controls :: Error Converting Data Type Nvarchar To Bigint C#

Jan 24, 2016

I'm getting the following error base on dropdownlist selectindexchanged: error converting data type nvarchar to bigint

Below is my dropdownlist code:

Protected Sub ddlTaxName_SelectedIndexChanged(sender As Object, e As EventArgs) Handles ddlTaxName.SelectedIndexChanged
Dim strConnString As String = ConfigurationManager.ConnectionStrings("BytConnectionString").ConnectionString()
Dim strQuery As String = "select TaxName, [Rate(%)] from Sale_Tax where" & " TaxID = @TaxID"
Dim con As New SqlConnection(strConnString)

[Code] .....

View 1 Replies

Data Controls :: Error Converting Data Type Nvarchar To Numeric

Nov 6, 2013

protected void Update(object sender, EventArgs e)
foreach (GridViewRow row in gvStudeff.Rows)


View 1 Replies

Data Controls :: Saving DropDownList Value To Database - Error Converting Data Type Nvarchar To Int

May 7, 2015

I am using  a  viewstate to store the company Ids and splitting at hyphen.

protected void onCompanychange(object sender, EventArgs e) {
ViewState["companyID"] += companydropdown.SelectedValue + "-";
String companyids = ViewState["companyID"].ToString();
string pattern = "-";
company_array = Regex.Split(companyids, pattern);
company_length = company_array.Length;

Company array is a string array  where i have stored the company ids

the problem is company_array[0] has the initial value of the dropdownlist(company) --select company which is why m getting the error(cannot convert data type nvarchar to int) .  I have used the same logic in many places in my project it did not give any error.

int count = 0;
company_length = company_length - 1;
while (count < GridView3.Rows.Count && compid_counter < company_length ) {
cmd = new SqlCommand("insertWorkDetais", conn);
cmd.CommandType = CommandType.StoredProcedure;

[Code] .....

View 1 Replies

DataSource Controls :: System.Data.SqlClient.SqlException - Error Converting Data Type Varchar To Bigint?

Jan 16, 2010

I have a website having an aunthentication system. When I am setting my website on IIS 6 the code is absolutly working fine. But when i configure the website on IIS 7 (Windows 2008 server) it is showing me the above error. I am using a stored procedure for it

View 3 Replies

Forms Data Controls :: Getting Error / Conversion Failed When Converting From A Character String To Uniqueidentifier

Feb 18, 2011

This is the Firefox error console window when I clicked on any page.

Error: Sys.WebForms.PageRequestManagerServerErrorException: Conversion failed when converting from a character string to uniqueidentifier.

Source File:


And here's the aspx code:


And here's the RowCommand method:


Her'es the SQLDataSource adapter control:


View 2 Replies

DataSource Controls :: Datatype Numeric Error - "Arithmetic Overflow Error Converting Numeric To Data Type Numeric."?

Apr 18, 2010

i have set the type of a column in a table numeric(6,2) but when i insert a value above 9999,99 i get the error

"Arithmetic overflow error converting numeric to data type numeric."

Do you know whats wrong??

ofc thats all through visual studio for an asp site thats why im posting here

View 4 Replies

Data Controls :: Show Error When DataList Is Empty

Sep 21, 2013

I have datalist in product.aspx page that bind from database and there is Repeater that bind from database... when I click on item from repeater it  bind datalist... and I define Label =LBLerrorS  that when there isn't any data in database it show this message="There isn't any Product"

below are code

<asp:Label ID="LBLerrorS" runat="server" CssClass="lblerrorS" Text="there isn't any product ." Visible="false"></asp:Label>
<asp:Repeater ID="RptWood" runat="server" >
<ItemTemplate> <li>
<a href='<%#"House.aspx?subset="+Eval("subset")+"&ID="+Eval("ID")+"&ListType="+(DataList1.Visible == true ? "Product" : "Store")%>'>

[Code] ....

In above code I put LBLerrorS.visible=true  in else condition... problem is that whenever I select item from repeater it show lblerrors but I want it just show lblerrorS just when there isn't any data in database, actually I want when datalist is empty it show error .... How I can do it?

View 1 Replies

Forms Data Controls :: Load A DataList Showing Error

Sep 3, 2010

i use the next datalist:


but show me this error:

Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control.

View 3 Replies

DataSource Controls :: Arithmetic Overflow Error Converting Numeric To Data Type Numeric

Feb 15, 2010

First of all im new to and am in the process of learning it.

Heres my problem, i am receiving this error when submitting the form: "Arithmetic overflow error converting numeric to data type numeric"

And it halts at command.ExecuteNonQuery();

Input form:


Code Behind:


Stored Procedure:


View 11 Replies

Error Converting Data Type Nvarchar To Float / How To Fix It

Nov 30, 2010

Here is the code:


After I try to test the page, I am getting the following error:


[b]Error converting data type nvarchar to float. [/b]


View 1 Replies

DataSource Controls :: Error Converting Numeric To Decimal?

Mar 20, 2010

I have a feedback page with rating controls and I use a stored procedure to insert the record using C#

I get an error when I try to insert about conversion.


I have 20 ratings and a textbox I think the error is with the last parameter @Overall

it displays on the page as 4.9 in a label control, it is previously calculated in the Calculate_Ratings(), and it is declared as a decimal, I have also tried it declared as double. My column is declared decimal(1,1) in sqlDatabase

The Error says

System.Data.SqlClient.SqlException: Error converting data type numeric to decimal. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException

Reliability Rating What is this?

Were we there on the date and times scheduled?

Rating 5 = Perfect
Rating 1 = Very Unreliable

View 3 Replies

Syntax Error Converting The Nvarchar Value To A Column Of Data Type Int?

May 5, 2010

I have 1,2,3,4,5,6,7,8,9 stored as nvarchar inside Level in my db.

I then have a dropdownlist with values 1,2,3,4,5,6,7,8,9. When a user makes a selection (i.e 1) (Level.SelectedValue.ToString). This builds an sql query via a param like this:

"Select things From MBA_EOI Where level = 1"

When I run the select I get the following error:

Syntax error converting the nvarchar value '1,2,3,4,5,6,7,8,9' to a column of data type int.

I was under the impression that I was dealing with an Nvarchar field and the selected value as string, where does the int conversion come in?

p.s I have also tried Level.SelectedItem.ToString

View 1 Replies

Forms Data Controls :: Eval Function Of Datalist - Error. Comma, ')', Or A Valid Expression Continuation Expected?

Feb 1, 2010

<asp:Button ID="btnDetail" OnClick=<%#"javascript:return Detail(DataBinder.Eval(Container.DataItem,"Description"));"%> runat="server" Text="View Detail" />

it is giving me error.

Comma, ')', or a valid expression continuation expected.

View 7 Replies

C# - Error Converting Data Type Varchar To Bigint Inline Sql Statements?

Aug 31, 2010

This is the code i have used to get LocationID from database with MerchantID. I am getting an exception from Fill dataset part. The error is Error converting data type varchar to bigint.

public DataSet getLocationID(long MerchantID)
//long LOCID = null;
SqlParameter[] parameters = new SqlParameter[]
new SqlParameter("@merchantID",MerchantID)
string strCommandText = "Select LocationID from Merchant_Location where MerchantID ='@merchantID' order by LocationID ASC";
DataSet pds = new DataSet();
SqlHelper.FillDataset(DbConnString, System.Data.CommandType.Text, strCommandText, pds, new string[] { "LocID" }, parameters);
return pds;
catch (Exception ex)
//LogError("Error Occurred When Retrieving LocationID: " + MerchantID.ToString(), ex);
return null;

View 2 Replies

SQL Server :: Error: Conversion Failed When Converting The Nvarchar Value ' ' To Data Type Int

Mar 28, 2011

I have a query in SQL Server 2008:


Everything looks fine but I keep getting the error: 'Conversion failed when converting the nvarchar value 'xxxx' to data type int... where xxxx is the the value of @Query.

View 3 Replies

SQL Server :: Error Converting The Nvarchar Value '1,2,3,4,5,6' To A Column Of Data Type Int - IN Where Clause

Feb 28, 2011

I am using an adapter to get a list with IN where clause as:


I passed the parameter, CatIDList, with string value 1, 2, 3, 4, 5

However, it returns error of Error converting nvarchar value.

View 3 Replies

Forms Data Controls :: DataList No Results / Access Datasource On The Page With A Datalist To Show The Data?

Nov 15, 2010

The problem is that i have a search page. Access Database holding the information. I have a Access Datasource on the page with a Datalist to show the data. I need to find a way on setting it up to says "Sorry no results found" when the is no results. i am unsure on how to do this though.

Below is my datasource and datalist


View 6 Replies

DataSource Controls :: Replication Error Converting Date / Time From Character String

May 11, 2010

we are using transactional replication on an sql 2008 server. we try now to add a table to the replication that only consists of 1 culomn of type date and we insert the dates to the table. when we then create the replication we are getting an error on the creation of the snapshot. here is the create table with the insert dates:

USE [Product]
/****** Object: Table [TimeSlices].[BaseDate] Script Date: 05/03/2010 15:52:24 ******/
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[TimeSlices].[BaseDate]') AND type in (N'U'))
DROP TABLE [TimeSlices].[BaseDate]
USE [Product]
/****** Object: Table [TimeSlices].[BaseDate] Script Date: 05/03/2010 15:52:24 ******/
CREATE TABLE [TimeSlices].[BaseDate](
[TargetDate] [date] NOT NULL,
[TargetDate] ASC
INSERT INTO [TimeSlices].[BaseDate] SELECT TargetDate FROM [TimeSlices].UDF_GetTravelDateRange(GETDATE()-2 , GETDATE()+1000)
attached is the UDF:
this is the add article:
use [Product]
exec sp_addarticle @publication = N'Product$(QuoteNumber)', @article = N'BaseDate', @source_owner = N'TimeSlices', @source_object = N'BaseDate', @type = N'logbased', @description = null, @creation_script = null, @pre_creation_cmd = N'drop', @schema_option =
0x000000000803509F, @identityrangemanagementoption = N'manual', @destination_table = N'BaseDate', @destination_owner = N'TimeSlices', @vertical_partition = N'false', @ins_cmd = N'CALL sp_MSins_TimeSlicesBaseDate', @del_cmd = N'CALL sp_MSdel_TimeSlicesBaseDate',
@upd_cmd = N'SCALL sp_MSupd_TimeSlicesBaseDate'

this is the error we get:

Message: Query for data failed

Stack: at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.ThrowNativeBcpOutException(CConnection* pNativeConnectionWrapper)
at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.BcpOut(String strBcpObjectName, String strBcpObjectOwner, String strBaseBcpObjectName, Boolean fUnicodeConversion, String strDataFile, String strLoadOrderingHint, String strWhereClause,
Boolean useTableLockHint, Int32 bcpFileFormatVersion)
at Microsoft.SqlServer.Replication.Snapshot.SqlServer.BcpOutThreadProvider.DoWork(WorkItem workItem)
at Microsoft.SqlServer.Replication.WorkerThread.NonExceptionBasedAgentThreadProc()
at Microsoft.SqlServer.Replication.AgentCore.BaseAgentThread.AgentThreadProcWrapper() (Source: MSSQLServer, Error number: 0)
Message: Conversion failed when converting date and/or time from character string.
Stack: (Source: MSSQLServer, Error number: 241)

why we are getting the conversion error on the snapshot creation?

View 2 Replies

DataSource Controls :: Cannot Evaluate Expression Error After Converting VS 2003 Web Application To VS 2008?

Jul 8, 2010

I recently converted a web application of ours to VS 2008 so that we could upgrade to .net 3.51 framework.

I have been making some changes to the layout, to take advantage of ajax and minimize the amout of data needing to be loaded and the number of postbacks processed.

The problem I am having is when I try to save the data.

The page postback calls a local Sub which reads the form data into local variables and then passes these variables to our assembly.

The primary assembly has 70 parameters which are used to populate one of the tables in our database.

So I have 70 local variables just for this call plus a variable reference to the output of the assembly which contains a property for each of the columns in the associated database record.

There are some additional assemblies called to update other tables so, in all there are 121 locally defined variables in this sub.

Bear in mind that this sub is called from the page load event which has 93 of it's own locally declared variables.

Here is what is happening, when I run the code I am using cdate() to convert the value of a text box to datetime and pass it to my assembly. When doing so it throws a conversion error.

So I created a local datetime variable and converted the value of the control to the datetime and passed the variable to the assembly.

No more error, but the proc did not save the data as it was supposed to.

What I noticed in debugging, on the locals tab, is that every local datetime variable displayed the following message:

Cannot evaluate expression because we are stopped in a place where garbage collection is impossible, possibly because the code of the current method may be optimized

I also noticed that on the watch window the same message would display if I attempted to reference any of the datetime controls on the form.

There are only 3 variables and 3 datetime controls that appear to be affected. the controls are all html input boxes. Every other variable and control on the form behaves normally and I can see their values while debugging, it is just these six that are exhibiting the problem, whats more is that they are not new controls to the form.

View 1 Replies

SQL Server :: Error Converting Data Type Varchar Column To Float - The Statement Has Been Terminated

Feb 1, 2011

I want to change one of my table columns data type. Now the column data type is varchar and i want to change it to float. Updated all the column data to numeric and tried to convert the datatype with the following syntax

alter table vibration_values alter column dis_v float

but getting the error as

Error converting data type varchar to float.

The statement has been terminated.

Suprisingly every thing worked well in sqlserver 2005 and not working in sqlserver 2000.

View 6 Replies

Data Controls :: Datalist Inside Datalist Access Child LinkButton On Click

Apr 23, 2012

In Datalist Item Template Another Datalist And Child Datalist How can we access link button inside chile datalist when click in child link button

View 1 Replies

Copyrights 2005-15, All rights reserved