I'm using related tables. The table being displayed in gridview uses the ID from a different table. How to I have the ID show up as a different column (ex. Name) at run-time?
View 3 RepliesAt the moment I have a detailsview which displays read only data and I have a button also. What I want to achieve is a situation where a user can click a button which will convert that specific piece of data inside a detailsview into a pdf document.
View 7 Repliesin converting gridview data to chart control,i am using asp.net 3.5 and vb.net.
View 1 RepliesI need to open a GridView as either an Excel or a PDF file. The excell prodecure is working fine, but I'm getting a: File does not begin with '%PDF-' error when trying to use the PDF file. The code is as follows:
Protected Sub EMButton_Click(ByVal sender
As Object,
ByVal e As System.Web.UI.ImageClickEventArgs)
Handles EMButton.Click
'Save the table to an excel File
Dim StringWriter
As New System.IO.StringWriter()
Dim html As
New System.Web.UI.HtmlTextWriter(StringWriter)
Dim form As HtmlForm =
New HtmlForm()
Page.Response.ContentType = "application/vnd.ms-excel"
Page.Response.Charset = ""
Page.Response.Cache.SetCacheability(HttpCacheability.NoCache)
Page.Response.AddHeader("content-disposition",
"attachment;filename=FullDateReport.xls")
Page.EnableViewState = False
form.Attributes("runat") =
"server"
Controls.Add(form)
form.Controls.Add(GridView1)
form.RenderControl(html)
Response.Write(StringWriter.ToString())
Response.End()
End Sub
[this doesn't work]
Protected Sub PDButton_Click(ByVal sender
As Object,
ByVal e As System.Web.UI.ImageClickEventArgs)
Handles PDButton.Click
'Save the table to PDF Format
Dim StringWriter
As New System.IO.StringWriter()
Dim html As
New System.Web.UI.HtmlTextWriter(StringWriter)
Dim form As HtmlForm =
New HtmlForm()
Page.Response.ContentType = "application/PDF"
Page.Response.Charset = ""
Page.Response.Cache.SetCacheability(HttpCacheability.NoCache)
Page.Response.AddHeader("content-disposition",
"attachment;filename=FullDateReport.pdf")
Page.EnableViewState = False
form.Attributes("runat") =
"server"
Controls.Add(form)
form.Controls.Add(GridView1)
form.RenderControl(html)
Response.Write(StringWriter.ToString())
Response.End()
End Sub
I've tried using:
Page.Response.Clear()
Page.Response.ContentEncoding = Encoding.Unicode
Page.Response.BinaryWrite(Encoding.Unicode.GetPreamble())
Page.Response.AddHeader("Content-Length", html.ToString().Length.ToString())
With the PDF procedure, but still couldn't get it to work. I've also tried using inline instead of attachment in the header.
I have a field in sql select statement that I want to read to a datareader and convert that value from the field to a word to display in a datagrid. i know that sounds confusing but let me give you an example.I have a field called duration_interval in a sql table and it has data values of 'ww' for Weeks, 'dd' for Days and 'mm' for Months. When I load the Datagrid I want the field for this value to say Weeks instead of ww, how do I convert the 'ww' value to show the word Weeks in the datagrid? Below is the select statement and the code for the datareader I have on my page now that isn't working correct:
[Code]....
i'm having problems with the export to excel from gridview codeit seems like the excel is automatically convert my strings with only numbers to numericthis gives me problem with leading zero string likes for example "007" and the excel will display 7anyone faced with problem before?
[Code]....
I have a field in sql select statement that I want to read to a datareader and convert that value from the field to a word to display in a datagrid. i know that sounds confusing but let me give you an example.
I have a field called duration_interval in a sql table and it has data values of 'ww' for Weeks, 'dd' for Days and 'mm' for Months. When I load the Datagrid I want the field for this value to say Weeks instead of ww, how do I convert the 'ww' value to show the word Weeks in the datagrid? Below is the select statement and the code for the datareader I have on my page now that isn't working correct:
[Code]....
I am getting an error when attempting to call a stored proc from my asp.net page.
e.Message = "Conversion failed when converting character string to smalldatetime data type."
The stored proc is being called by:
The asp.net code that is calling the stored proc is:
[Code]....
I want to export my GridView, but also, replace any CheckBox controls that are rendered automatically with T/F fields in the process, with LiteralControls, so that everything is text in Excel.
See my below code. I'm not getting any errors, but the code is just not working. The resulting spreadsheet contains the CheckBox fields anyway.
[Code]....
currently I have data displayed via repeater and I need to do the following:
Convert each row into a hyperlink Pass through each row (hyperlink) as the query - ?stID The receiving page has the code:
[code]....
Here's a nice one for a Pro to bite into I have a web form that generates a set of reports including asp chart controls. Clicking on the black title loads the report section into the ajax enabled panel below it. Beautiful! Two Problems though: Sometimes, when the ajax is loading the next report section, all the other charts on the page flicker and sometimes even show a red x (the image disappears). They can then reappear again when another chart loads! 2nd Problem: If I use the html-to-pdf converter, I tell all the panels to bind to the data source (they are repeaters) on page load and show content. I Then convert the resulting datastream to PDF. All the other images on the page load, but the ones for the charts don't. I have
looked at the generated code, and they are all linked fine to the correct address of the site and the chart generator url. A sample image of the working page is below:
Example Page
Example PDF
Page PDF is generated from
I have a dataset.table which has some null values. am trying to trasform this using xslt to display like excel. If the value is null, then that node is ommitted by the xml. i tried deafulting the null values from the database itself and thats not generic. Handling null values is troublesome. I tried couple of methods to default null values by looping and thats not optimal solution. I used LINQ to handle null values but couldnt comeup with a neat solution. what am looking for is a generic optimal solution to handle these values.
View 2 RepliesI have a GridView. I am trying to make an Array or ArrayList of type structure. The vales that I want to make the ArrayList or Array (I don't know which one is more appropriate) from are points with latitude and longitude and are of type float. I have:
Point[] Array = new
Point[counter];
foreach (GridViewRow row
in GridView1.Rows)
{......
I have the following code reading in my xml file and sorting it by ID:
Dim ds As New DataSet
ds.ReadXml(Server.MapPath("/posts.xml"))
Dim dv As New DataView(ds.Tables(0))
dv.Sort = "id desc"
The only problem is that it isn't sorting it numerically (it's sorting it alphabetically 1, 10, 11, 2, 24, 3, 4...). It appears as though I have to convert that column into integers, but I haven't been able to figure out an efficient way to do that.
im ds As New DataSet
ds.ReadXml(Server.MapPath("/App_Data/posts.xml"))
'ds.Tables(0).Columns(0).DataType = TypeOf(Decimal)
Dim dv As New DataView(ds.Tables(0))
'dv.Sort = "date"
I've got a checkbox where the column is a Yes/No string and I need to convert this to a True/False in both directions. The database exists already and I can't change it or I would just change it to a bit column.
I tried this and it didn't work even in one direction.
[Code]....
how to Convert Uppercase to Lower case during Binding in datalist in Asp.Net.
we have data in uppercase in sql server database . Now we want to display data in datalist at aspx pages in lowercase.
we are using datalist where control is as
<asp:Label ID="lblAdd" runat="server"
Text='<%# Eval("c_Address", "{0:ToLower}") %>' ></asp:Label>
how to convert data into lower case while dispalying in datalist .
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:
[URL]
And here's the aspx code:
[Code]....
And here's the RowCommand method:
[Code]....
Her'es the SQLDataSource adapter control:
[Code]....
How to assign MaxLength Property to BoundField column in DetailsView COntrol without Converting into TemplateField.
View 3 RepliesI have a table for R&D which has following cols:
EmpID|EmpName|EmpLname|
and i want to insert values using parameters from Stored procedure as:
declare @EMPID int;
declare @EmpName varchar(50);
Declare @EmpLname varchar(50);
Declare @aa varchar(max);
[code]...
once executing, I am getting following error: Conversion failed when converting the varchar value 'insert into Employee(EMPID,EMPNAME,EMPLname) select ' to data type int.
i am getting this error this my c# code
Collapse | Copy Code
string Patient_name = NameTxtBx.Text, Export_TO = ToTxtBx0.Text;
int PatNoVal;
PatNoVal = Convert.ToInt32(PatNo.Text);
PatNoVal = int.Parse(PatNo.Text);
decimal PatID = decimal.Parse(PatID_NO.Text);
[Code] .....
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.
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] .....
protected void Update(object sender, EventArgs e)
{
foreach (GridViewRow row in gvStudeff.Rows)
{
[Code].....
i am binding the datalist using this code and store procedure. the code works fine if i pass only 1 id, but i have an array which have multiple id's separated by comma like 1,3,5, and i want to use this in the @Id parameter , but i get below conversion error: An exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll but was not handled in user code Additional information: Conversion failed when converting the varchar value '1, 3, 4, 5, 6, 7' to data type int. Code behind code is:
private void PageBind(Int32 pno) {
Int32 nor, repcol;
nor = Convert.ToInt32(DropDownList1.SelectedValue);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Display_Search_Records";
[Code] ....
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");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
StringWriter sw = new StringWriter();
[Code] .....