I have 2 blocks of code, I would get the functionality I am looking for. The first block of code downloads a gridview to excel using the download dialog I am looking for:
[Code].....
How can i make a downlandable file links in asp.net mvc for downloading the files.Also how can i show the file as thumbnail in my page in asp.net mvc.
View 4 RepliesIn the above mentioned article at "[URL]" instead of selecting the existed table in dbserver is it possible to create a dynamic database table based upon the structure of the excel file to be loaded??
View 1 RepliesDoes anyone know how to pass values from adynamically created gridview checkboxes to a crystal report?Is it possible? I am using asp.net, vb.net and mssql. Here's my grid minus a few boundfields:
<asp:gridview id="grid" runat="server" autogeneratecolumns="False" cellpadding="4"
forecolor="#333333" gridlines="None" emptydatatext="No Products registered for this company...">
<RowStyle BackColor="#EFF3FB" />
<Columns>
<asp:TemplateField HeaderText="Select">
<ItemTemplate>
<asp:CheckBox ID="chkSelect" runat="server" onclick="javascript:HighlightRow(this);" AutoPostBack="True"/>
</ItemTemplate>
<HeaderTemplate>
<input id="chkAll" onclick="javascript:SelectAllCheckboxes(this);" runat="server" type="checkbox" />
</HeaderTemplate>
</asp:TemplateField>
<asp:BoundField DataField="aid#" HeaderText="AID#" />
<asp:BoundField DataField="brandname" HeaderText="Brand Name" />
<asp:BoundField DataField="exp_date" DataFormatString="{0:MM/dd/yyyy}" HeaderText="Exp. Date" />
</Columns>
</asp:gridview>
I want to create reuseable control for genrating same kind of report like :-1. should take two date i mean start date and end date2. result should dispaly a count in label for total change in records
View 4 RepliesI've got an .rdlc report which I print from my .net app (C# Visual Studio 2005), where I use a RemoteReportPrinter object. I give it as parameters the server name, report name, report parameters, etc. Works fine. My question is, I would live to do an analagous export of that report to Excel. Set it up exactly the same, but have it export to Excel rather than print, probably using some other type of object than RemoteReportPrinter.
View 1 RepliesI need to know if there is a way to export a rdl report to excel by clicking a button on my web form?
Is it possible to make the column headings appear vertically in my matrix report?
View 2 RepliesI'm creating an quiz application which queries the database and extracts the questions and choices. I use dynamically created controls such as a checkbox list and fill the values dynamically. How do I do this? Right now I have these functions:
array_random_init(); this creates a 10 element integer array from 1-20 - extract_question(i): this extracts a question indexed at i in DB, I created the controls and set the appropriate text in this function. - validate_question(i); this is called by button_click and validates the question i according to DB.
I understand I have to recreate the controls in Page_init on postback, but what should it look like? Do I need to add "if IsPostBack" in page_init, or do I create the controls in page_init() and reset their properties in page_load when I use extract_question(i)? Also, I cannot seem to clear the selected boxes on postback, I added page directive "enableviewstate=false" but it doesn't work.
I have a website that sales associates access to view account information with clients. S.A's can only view information for accounts that they are tied to. Some clients have more than one account, S.A's can be tied to more than one account, but not all accounts of one client need to be tied to one S.A.
On the account info pages, I have account numbers (dynamically displayed labels) displayed of other accounts that the account client is associated with, which the S.A's can see. I'm modding this so that if the S.A has viewing permissions of any of the other accounts on that list of accounts, that instead of a label being displayed, a button directing them to that account page will display instead. In order for this to work, I have to attach a security function to the button, otherwise the page will blow out on the S.A's.
So I'm running a piece that is displaying a button instead of a label, which is working fine. My problem is when I try to attach the security event to the dynamically displayed buttons. It seems that the page just posts back and doesn't execute my code at all.
On my Page_Load, I'm running this after the buttons and labels are displayed:
For x = 0 to tblAccountList.Rows.Count - 1
'use a try to target the button, use catch to handle if it's instead a label, only one cell per row.
Try
Dim accountLink as Button = tblAccountList.Rows(x).Controls(0)
Addhandler accountLink.Click, AddressOf Me.PermissionViewCheck
Catch ex as InvalidCastException
Continue For
End Try
Next
I don't have any code checking for postbacks or anything like that, but the "PermissionViewCheck" event never fires and just reposts the page.
I am developing a website admin control page....I have to import data from an excel sheet to a table...the table same columns as excel sheet....how do i import data from excel sheet....also i have to make every record unique by giving a unique ID.
View 1 RepliesMy goal is to take some form inputs and prompt the user to download a summary of everything once a certain button is clicked. I have no need for the file once it is downloaded and so I'd like to have a solution where the data is streamed directly to the user. My current solution doesn't even prompt the user for a download. Can anyone point out what I'm doing wrong?
I've got it wrapped as a webmethod and so I needed to add a definition of the _Default page class so I could access certain things.
[Code]....
this wasn't mentioned earlier but the webmethod is being called by an AJAX request!
using vs.net 2005.I have a console application that is displaying a Crystal Report.I want to use a query that I created in sql server mgmt for the data in Crystal reports.some questions:
1. how do I do this?
2. Is is more efficient to do this with stored proc or just enter the query?
3. There are some fields where I need a case statement because so that I can display meaningful text (not the code values that are returned), is it normally more efficient to put the case statement in the SQL or to add logic in the report for this?
I am reading a CSV file created by Excel. the string I am reading needs to be encoded (it shows small boxes instead of hebrew characters) so I wrote a lil routine to convert the string -
Function encodeName(ByVal name As String) As String
Dim src As Encoding = Encoding.UTF8
Dim dest As Encoding = Encoding.Default
Dim srcBytes() As Byte
srcBytes = src.GetBytes(name)
Dim asciiBytes() As Byte = Encoding.Convert(src, dest, srcBytes)
Dim mychars(dest.GetCharCount(asciiBytes) - 1) As Char
dest.GetChars(asciiBytes, 0, asciiBytes.Length, mychars, 0)
Dim asciiString As New String(mychars)
End Function
From what I read FileStream.ReadLine reads the text with encoding UTF8 so I try to convert from UTF8 to Encoding.Default buy instead of little boxes I get question marks.
In my Asp.net, I have to generate a Report in Excel. In Excel sheet I have 30 Coulmns, where I also need to do some calculation.
View 7 RepliesI have been experiementing with the annonymous types in C#, and am wondering if it would be possible to have a 'dynamic key' in the annonymous object.Here is what I have so far:
[Code]....
[ { "monday": true } ] what I am getting: [ { "temp": true } ]Is there a way to have the object's 'key' be dynamicly created? What I want it to be able to send the KeyValuePair's key as the object's key. Is this possible?
I'm trying to get the value of a dynamically created radiobuttonlist via javascript to call a pagemethod.
This is how I'm creating the rbl:
rbl.Attributes["onclick"] = "javascript:preview('" + rbl.ID + "','" + rbl.ClientID + "');";
And this is the javascript:
function preview(controlid, clientid)
{
var radio = document.getElementsByName(clientid);
var answer = "k";
for (var ii = 0; ii < radio.length; ii++)
{
if (radio[ii].checked)
answer = radio[ii].value;
}
PageMethods.SaveAnswer(controlid, answer);
}
The problem however is that I want to get the groupname of the radiobuttionlist so I can use getElementsByName, but i have no luck so far.
ive got a table and any updated to this is captures in a new table2. all I need to do is to generate any update's ( which are captured in table 2 ) to be reported in an excel sheet. how do i do this. i only need to show the updates in the excel.
View 2 RepliesI use excel through vb.net/asp.net to generate reports from a web page and then send the file down to the user. We've had some issues with Excel being super slow/inefficient/not closing (even when we keep track of the process id and try to kill it in code...). So I'm looking for some flexible alternatives. We need a replacement that can:
Allow for inidivdual cell formatting including borders (different settings on each side), background colors, font styles/coloring, etc...
Allow for cell merging
Allow for formatting (bolding in this case) of a portion of the text inside of a cell while leaving the rest of the text unchanged
Image insertion/repositioning inside a cell (not crucial)
Multiple Worksheets per Workbook
These are all the features I can think of off hand, any help or suggestiong at alternative libraries to look at would be appreciated. We are running Excel 2007 on the server but we are rolling out Office 2010 to clients so I think that might open the doors for some more supported file formats,
I'm creating 14 textboxes for every day in a month and user can select the month so i have o create them dynamically. But i can't reach the values in the textboxes.
When i don't create them dynamically like
<asp:TextBox ID= "TextBox1" name="TextBox1"> </asp:TextBox>
I can get the value from the C# side by using the
((TextBox)Page.Form.FindControl("TextBox1")).Text
However this moethod doesn't work for the textboxes that i created dynamically. I'm creating them in a loop it's something like;
[Code]....
Then i add the text box to the necessary places at my table.However i can't reach the textboxes when i use the same method
((TextBox)Page.Form.FindControl("!A uniqe ID!"));
It gave a null value...
I have a tree view with checkboxes for leaf nodes. If i click on checkboxes, I am creating some html controls dynamically. And in other static button click event I need to get an ID's of those dynamically created controls.
My Code is:
.aspx
<asp:Panel ID="pnlOuter" runat="server" Visible="false" Width="650px">
<table>
<tr>
<td>
<asp:Label ID="lblQtnrName" runat="server" Text="Questionaire Name"></asp:Label>
<asp:TextBox ID="txtQtnrName" runat="server"></asp:TextBox>...
I will have to retrive data from database assume this is the data I got
|No | Name|
46 ANN
24 LISA
20 JOAN
41 JACK
and so on. I will have to create checkbox dynamical by these data like this
checkbox ANN checkbox LISA checkJOAN
checkbox JACK
I will create a container and then create checkbok , then add control to container.. my problem is how to give it a break each 3 controls? and how to format them like this
<TR>
<TD width =33%>
checkbox ANN
</TD>
<TD width =33%>
checkbox LISA
</TD>
<TD width =33%>
checkbox JOAN
</TD>
</TR>
<TR>
<TD width =33%>
checkbox JACK
</TD>
</TD>
In my code behind (c#) I dynamically created some RadioButtonLists with more RadioButtons in each of them. I put all controls to a specific Panel.What I need to know is how to access those controls later as they are not created in .aspx file (with drag and drop from toolbox)?
I tried this:
foreach (Control child in panel.Controls)
{
Response.Write("test1");
[code]....
"test1" and "test2" dont show up in my page. That means something is wrong with this logic.
I know this question has been asked thousands of times, and I've struggled with it before, but for some reason, I can't accomplish what I want to accomplish... I have a dynamically added LinkButton that when clicked will dynamically add a control (in this example, a textbox) to the same panel. The intent is to continuously add on as many controls as times the LinkButton was clicked (i.e. I click it once, one box, then another click will give me 2 boxes, another click adds a 3rd). In the code below, I use the current date and time serialized to create a unique ID for each textbox control.
When I execute the code, clicking "Add Filter" will generate a new textbox, but once clicked again will create a new one, and dispose of the one before it. Instead, I want to persist the previous textbox as well as any data submitted within it.In the aspx:
<asp:Panel ID="pnlFilter" runat="server">
</asp:Panel>
In the aspx.cs:
protected void Page_Init(object sender, EventArgs e)
{
LinkButton lb = new LinkButton(); [code]....
I want to preserve the dynamically created control when postback occurs .
protected void Page_Load(object sender, EventArgs e)
{
} It can be achieved by calling CreateTable() in Page_Load. Is there any alternative way to preserve the control
[code]....