g to export data from SP to a .xlsx sheet. Total no of rows is more than 15000 with total of 13 columns.The data is generated with the help of SQL Server SP. Till this point it is working fine. However while exporting to excel I do not get any data , the excel has blank content.If I have records less than 12000 it generated the excel report with relevant data. However as row increases the report is blank.
View 2 Replies
In internet exporer 8, every time the dialog box is opened the textbox controls increase in size! None of the other items do: label and button. If it makes any difference - dialog is created when a certain item is selected within a select list.
Th dialog is themed from the theme roller site and the controls styled using an external css file.
$('#<%= uxSearchUnitDialog.ClientID %>').dialog({
autoOpen: false,
width: 600,
title: "Search",
hide: "puff",
modal: true,
[Code]....
I have the following gridview, which fits ontop a screen without having to scroll. I added
AutoGenerateDeleteButton="True" AutoGenerateEditButton="True"
Now when I select "Edit" it increases the with of the gridview and makes scrollbars because the width increase. This is because it creates texboxes for each column for me to edit...but the width increases soo much..
<asp:GridView ID="GridRevenueCalculation" runat ="server"
AutoGenerateColumns="False" DataKeyNames="calc_flag"
OnRowCreated="GridView1_RowCreated" OnDataBound="GridView1_DataBound"
OnRowDataBound="GridRevenueCalculation_RowDataBound"
[Code]....
I have a form which a user can fill in x times with the data they want too. The form is posted to the following Action.
[HttpPost]
public ActionResult Manage(ProductOptionModel DataToAdd)
{
if (!ModelState.IsValid)
{
return View(DataToAdd);
}
var ProdServ = new ProductService();
if (DataToAdd.ID != 0)
{
//Edit Mode.
DataToAdd = ProdServ.EditProductOption(DataToAdd);
ViewData["Message"] = "Option Changes Made";
}else
{
//Add
DataToAdd = ProdServ.AddProductOption(DataToAdd);
ViewData["Message"] = "New Option Added";
}
var RetModel = new ProductOptionModel() {ProductID = DataToAdd.ProductID};
return View(RetModel);
}
So at the bottom I blank the model (Leaving just the required field) and then return to the view. However the view holds the data from the previously submitted form. I have debugged the code and checked that the RetModel variable is empty.
I have very basic knowledge of ASP.net. I am using following script to resize and image, but the problem is it increases the disk volume of resized image to almost 4 times or original image.
Example:
Original Image: 1024 x 769px and Disk space: 135 KB
Resized Image: 600 x 380px and Disk space: 825KB
Notice resized image becomes 825KB.
Quote:
[code]....
I am trying to understand the best way of implementing a DropDownList in ASP.NET MVC 2 using the DropDownListFor helper. This is a multi-part question.First, what is the best way to pass the list data to the view?Pass the list in your model with a SelectList property that contains the dataass the list in via ViewDatHow do I get a blank value in the DropDownList? Should I build it into the SelectList when I am creating it or is there some other means to tell the helper to auto create an empty value?
View 5 RepliesI've dynamically added a DropDownList to the Gridview. To this DropDownList I'm trying to add a blank row. I'm not getting any error but why is the blank row not added to the Gridview?
Dim ddlActualPickupTime
As
New DropDownList
objBLLRsrv.FillTimeSlot(ddlActualPickupTime)
ddlActualPickupTime.ID ="dynDDLActualPickupTime"
e.Row.Cells(3).Controls.Add(ddlActualPickupTime)
ddlActualPickupTime.Items.Insert(0,New ListItem("select", -1))
ddlActualPickupTime.SelectedValue = ActualPickupTime.ToString
I have a project which is developed by using VS 2003 with Framework 1.0.My project works very well while I am testing it on localhost.But 'sometimes' my application will appear blank page after click a save button in the production side(using IE 7).I set 'Try catch' into server codes to detect any error caused after users click save button. And they never see any error description page but 'sometimes' blank page.So I assume my server codes are safe.
View 7 RepliesI would like to create a completely blank aspx page, but I can't figure out how. When I open up Visual Web Developer 2010 Express, and I go to File -> New Web Site, I have a few options. When I choose the ASP.NET Empty Web Site, it does not give me any tools in the Toolbox on the left, so this is no good. But when I choose ASP.NET Web Site, it gives me this template and all of this other stuff. I dont need this 'Welcome to ASP.NET!' template. I'm thinking that I need to choose the Empty Web Site and then Add New Item, but what item? I'm lost!
View 8 Repliesi am working in MVC & using mvccontrib grid to show the result in grid format.
the Grid is showing up all my database records & now i want that a blank row should be added at the end of the grid which i can us eto add a new record .
let me know how i can add a blank row at end of mvc contrib grid
I am trying to have a listview which will work like a table with paging. My problem is I need to be able to add more than 1 row at a time. ie I want to click "add new row" multiple times on the same page without the page changing and without the rows I'm adding going away.
Basically I need the user to still see the already inserted rows as well as the rows they are planning to insert on the same page. This would mean the page size is temporarily larger than it should be. The new rows would be added to the end of my data source when the user goes to another page or clicks a separate save button.
I've finally figured out an issue I'm have with a zip code field being entered in a text box of a details view in edit mode. I'm trying to understand why i have the issue though. I don't understand why it keeps occurring.his what happens with the zip code field. I've been able to make it reoccur numerous times. If the details view is put in edit mode and the record is updated with the original 5 digit zip code, unaltered in any way, my regular expression validator catches it and doesn't let the update happen. If I change the replace the 5 digit zip code with a new one the update goes through fine. This new value can be a different or the same 5 digits and the update will work. If I don't change the value at all though the update will not go through.
View 8 RepliesI have a method like
public DataRow
GetItem(ENTITY_TYPE
EntityType, long EntityID)
This fetches a row and returns it. Pretty simple.
However I can't test in the method to see if the row was fetched, as the method has to end with:
return ds.Tables[0].Rows[0];
If the row wasn't fetched, this errors as there is no row at position 0.
I can't do this:
DataRow dr;
if (ds.Tables[0].Rows.Count
== 1)
{
dr =
ds.Tables[0].Rows[0];
}
return dr;
.. because then I get an error that I can't return an uninitialised variable (dr).
I can't stipulate what the columns are and return a "blank" DataRow as far as I can see, because it's dynamic so I don't know what the columns will be. There doesn't seem to be a way to instantiate the DataRow return var except by assigning, er, a DataRow. Which I may not have.
I don't really want to switch to using the ItemArray and pass arrays about, I'd rather just pass the DataRow object as this is in a loop which might process a lot of rows.
i am creating a WebCustomControl Following is the code
[Code]....
in RaisePostBackEvent the valu of the textbox is always blank.
[Code]....
This is having problems if the phone number is NULL or BLANK. Is there a way to fix it?
I have a dropdown list populated from the database. There is also a button next to the dropdownlist that once clicked on. It takes the item in the dropdownlist and use that to populate the gridview.however though, I would like to add a blank to the dropdownlist and message that would say, you have selected a blank whenever the user selects the blank from the dropdownlist and clicks on the button.
View 7 RepliesI have a problem registering a stored procedure in the EDMX file in my web application. When I try to add the function, I have the message:
"No Database connection is defined for this model"
All the buttons are also disabled. If I click on the white spaces to get the properties of edmx file, the connection string is blank. I am not sure how this came about. Everything compiles and runs I can add tables and views but not Stored procedures. I created a test project from the scratch and added a new edmx file and I was able to add the stored procedure. i nthe new project the connection string is defined. Connection strings are defined in the web.cnofig. I suspect that somehow the edmx file or project got corrupted.
I have one telerik rad grid.Using a method i am filling the grid.I have enabled paging property.I have used itemtemplate-->ImageButton for delete and edit options.I have set page size as 10.Page load time it is working properly and populating the grid.After inserting 11 th row the pagination starts and it will show in next page with one record.But when i am deleting the 11th row the grid become blank.I have used dataset to bind the records.
[code].....
I have created master page in my application using site map and have some web forms. When I click a link from site map I would like to open in blank page like popup window. How can I do that ?
View 3 RepliesI have two pages: the first it's a gridview that bind to DataSet, the second one have DetailsView that bind to DataSet that is used for editing and inserting.
Upon insertion on DetailsView Page, I want to redirect to GridView Page.
[Code].....
I added some textboxes to gridview using following code
<asp:TemplateField HeaderText="STD<br/>ID">
<ItemStyle BackColor="LightBlue" />
<ItemTemplate>
<div style="font-size:xx-small; overflow:hidden;">
<asp:TextBox ID="txtStandard" EnableViewState="true" Height="10" Font-Size="XX-Small" Width="50" Text='<%# bind("STANDARD_ID") %>' runat="server"></asp:TextBox>
<asp:AutoCompleteExtender ID="AutoCompleteExtenderDemo" runat="server"
TargetControlID="txtStandard" ServiceMethod="GetCompletionList"
MinimumPrefixLength="1" CompletionInterval="1000"
EnableCaching="true" CompletionSetCount="20">
</asp:AutoCompleteExtender>
</div>
</ItemTemplate>
</asp:TemplateField>
I want to save updated values to database, But when I try to access values using string strs = ((TextBox)TwoHeadedGridView1.Rows[0].FindControl("txtStandard")).Text;
It always returns me the blank value for all the rows, Same thing happens for dropdown list it returns me originally selected value i.e. value selected at the time of writing dropdown box, there are no duplicate ids present on my asp form , This is my first interaction with customizing gridview, I want to somehow make it run,
I have a field that is a DropDownList. When in the insert mode I want that field to be blank - It currently is displaying the first record in the table it pulls from. I was expecting to see an initial value setting in the DropDownList properties but do not. For example - suppose I have a field named locations that consist of 4 location (below). In "Insert" mode, location currently displays Dallas. I want it to be set to blank initially and the user select one. What am I mssing?
View 4 Repliesusing asp.net membership api when I call Roles.GetRolesForUser(); it returns nothing. When I make a call Roles.GetAllRoles() all the roles are returned. What is the problem? Also what is the correct way to authenticate users using the membership api?
View 2 RepliesI'm finally at the point of deploying my ASP.NET 4.0 MVC 2.0 -based web application to the target system and I am getting blank pages for everything - even for the login page. The web application is starting up cleanly without exceptions according to the logs, but none of my MVC routes are ever followed. Instead I get a 200 OK response with an empty page. Here's my environment:
The web application is the root application of a web site. This web site is associated with its own app pool. The pool is set up for .NET 4.0 with a specific local non-privileged user (not the default Network or System user), and this user has read access to the entire web site's tree.I am including System.Web.Mvc as a "Copy Local" reference, which is then in the bin area of the site. I have confirmed that the installed .NET 4.0 already has version 4.0 of the Abstractions and Routing stuff.The web site directory is in the Program Files tree, but any data the application reads and writes is in a different tree, a subdirectory of ProgramData. The app pool's user has read/write access to everything in that subtree. Evidence: the program is logging successfully to a directory in that tree.The site uses HTTPS but I have verified via trace.axd that it is getting through that stuff OK.
Here's what I've seen so far that leads me to suspect a routing problem:
I have a common base class for all my controllers that provides them with common resources. I have a log statement in its constructor, so I should see that in the logs if any of my routes are hit.Nothing is logged if I just give my https://systemname:81/.If I do https://systemname:81/Home/Index, which should be equivalent, I get a blank page from Firefox with a 404 error. (From IE, I get the standard IE 404 page - equivalent meaning.) I do not get the logging in that constructor.If I do https://systemname:81/Home.aspx/Index, I get the ASP.NET default 404 page and no constructor logging.However, if I do https://systemname:81/Home/Index.aspx, I still get the ASP.NET default 404 page, but my controller base class constructor is executed, as evidenced by the log message.
My asp.net webpage has a ton of white space at the bottom of a div within a content page, and I have no idea where its coming from. There are NOT a ton of<br />'s or 's in the source view. How can I find out where the space is coming from and correct?Could this element be taking up space???
<ul style="display: none; visibility: hidden; z-index: 10000; overflow-x: hidden; overflow-y: auto; width: 246px; position: absolute; height: 320px;" class="ajax__combobox_itemlist" id="ctl00_ctl00_PageContent_PageContent_cboTurnOver_OptionList"><li> </li><li>Aaron Ament - 034 </li><li>Aaron Stack - 235 </li><li>Accounting - OA </li><li>Adam Kauth - 289 </li><li>Admin - 481 </li><li>Aimee Tatge - 149 </li><!--Over 100 entries removed for security and brevity--><li>Zeddie Roshelle - 346 </li></ul>
