Export to Excel in a Zip format - ASP.NET Discussion Boards

how to avoid loading time while using repeater

prakash.ss8326-Jul-10 2:23

26-Jul-10 2:23

hi guys,

I am using .net 3.5 framework and i am using repeater control in my application.I am using link button to display the records.Displaying 9 records in a page.Show all button is there.When i click on show all button(Result of 250 records) then the page is loading and hanging for some time anf then it is displaying the all records.I know the time taken between the server and the browser.But i need to avoid the hanging of the page and the loading time should be reduced.How to solve this issue.If the page contains 9 products then it is loaded quickly.But if it contains lot of images then it's hanged.

some of my friends told to use the jquery but i have noo idea regarding jquery so can anyone give an solution for this.Till it's breaking my head.

regards,

krish

Re: how to avoid loading time while using repeater

Not Active26-Jul-10 2:42

Not Active

26-Jul-10 2:42

What fields are being displayed in the repeater? If you are trying to display too much, or there is nesting involved then of course the rendering will be slower.

JQuery, or any Ajax technique, will not reduce the load time, it can help mask it by making an out of band call rather than a postback. However, you would responsible to load the data into the page controls.

I know the language. I've read a book. - _Madmatt

Re: how to avoid loading time while using repeater

Herman<T>.Instance26-Jul-10 3:48

Herman<T>.Instance

26-Jul-10 3:48

if you use a SqlDataReader you can load the data Asynchronous bij using the BeginExecuteReader() in your sqlCommand and when you have the IAsuncResult you call the EndExecuteReader(IAsyncResult) method of your sqlCOmmand.
Nice documentaton to try out: http://aspnetlive.blogspot.com/2010/03/asynchronous-data-access-using-adonet.html

In Word you can only store 2 bytes. That is why I use Writer.

Re: how to avoid loading time while using repeater

Not Active26-Jul-10 4:32

Not Active

26-Jul-10 4:32

This will not help. Special handling is necessary to implement async pages and the page will not be rendered until all threads have completed. The problem is not the database execution but rather the rendering of the data to the page.

I know the language. I've read a book. - _Madmatt

Re: how to avoid loading time while using repeater

T M Gray26-Jul-10 4:22

T M Gray

26-Jul-10 4:22

Where is the performance issue? Is it the data coming from the server or is it the rendering in the browser? If you are using HTML tables then you are probably introducing large rendering delays. If you use DIV tags and CSS for your layout you will have better rendering times.

IIS configuration error

Ahamed Azeem26-Jul-10 1:49

Ahamed Azeem

26-Jul-10 1:49

Only by giving IP address i can view the page.. but by giving the virtual directory i cannot browse the page in IIS 7.0

Could you please suggest me the remedy

Ahamed Azeem
software Programmer

Re: IIS configuration error

Herman<T>.Instance26-Jul-10 3:50

Herman<T>.Instance

26-Jul-10 3:50

does your iis entry has an application name?

In Word you can only store 2 bytes. That is why I use Writer.

Export to Excel in a Zip format

Member 322226425-Jul-10 20:52

Member 3222264

25-Jul-10 20:52

Hi,
I have a gridview with some rows.
The below code works fine to export the data in Excel format

protected void btn_Export_Click(object sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
//Response.Charset = "UTF-8";
Response.AppendHeader("Content-Disposition", "attachment;filename=schoolsinfo.xls");
Response.Write(filename);
Response.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-8");
Response.ContentType = "application/ms-excel";
this.EnableViewState = false;
System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("EN-US", true);
System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
grd.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());

}

how to get the filename schoolsinfo.xls to string.
I am getting filename as null.

Please help

Also i need to export the excel file in Zip format.

Guhananth.S

Re: Export to Excel in a Zip format

Not Active26-Jul-10 2:36

Not Active

26-Jul-10 2:36

First, read How to get an answer to your question[^], particularly #7.

What browser and version are you using? If you want a zip then you must compress the file before transporting, the Response object is not going to do it for you.

I know the language. I've read a book. - _Madmatt

Re: Export to Excel in a Zip format

Member 322226426-Jul-10 19:07

Member 3222264

26-Jul-10 19:07

IF I GIVE Response.ContentType = "application/zip"; THE ZIP FILE IS FORMED,BUT THERE IS NO EXCEL INSIDE IT.

SQLStatement

arsha_midy25-Jul-10 11:39

arsha_midy

25-Jul-10 11:39

It may be somewhat odd to discuss about older technologies, but it has always been interesting to me to know that about.

Ok, I have the following as my "filename.htx" file:

<TABLE BORDER="1" CELLPADDING="2" WIDTH="100%">
<TBODY>
<%begindetail%>
<TR VALIGN=TOP>
<TD><%LastName%></TD>
<TD><%FirstName%></TD>
<TD><%EMail%></TD>
</TR>
<%enddetail%>
</TBODY>
</TABLE>

And here is my "addto.idc" file:

Datasource:Address_IDC
Template:filename.htx
SQLStatement:INSERT INTO Addresses(LastName, FirstName, EMail) VALUES('%FName%', '%LName%', '%Email%')

It works fine as it inserts data to database, but I need to display all records stored after the above insertion. What can I do?

N.B. SQL Server uses "output inserted" clause to do so but I haven't tested with that. I use Access 2007 as the database.

Real Eyes Realize Real Lies.

Re: SQLStatement

Not Active25-Jul-10 15:34

Not Active

25-Jul-10 15:34

And how is this related to ASP.NET?

I know the language. I've read a book. - _Madmatt

Re: SQLStatement

arsha_midy25-Jul-10 20:50

arsha_midy

25-Jul-10 20:50

Where should I post that question?

I could also post that in "web development" or "database" section. But the question is also not really related to any of those section above.

Real Eyes Realize Real Lies.

Re: SQLStatement

Nishant Singh26-Jul-10 1:54

Nishant Singh

26-Jul-10 1:54

Post it in Web development forum since this looks to be a question related to ASP,
There you might get correct answer , here most people have either not worked on ASP or have forgotten it long time back Wink | ;)

Grid view with asp.net model pop up

Amit Patel198525-Jul-10 1:00

Amit Patel1985

25-Jul-10 1:00

Hi All,

I have one requirement i have one page which contain patient Id , patient name , patient last name text box

it has one search button if i click one this button on pop up should come and there user can search record those record should come in grid so when user click on any record it should fill those details into the above text boxes.
is it possible if yes can u guys give me direction.

thanks,

Amit

Re: Grid view with asp.net model pop up

Sandeep Mewara25-Jul-10 6:24

Sandeep Mewara

25-Jul-10 6:24

Yes, it is possible.

This article is not exactly what you are looking for but would give you direction to move in:
Partial update of parent page via AJAX (ASP.NET 2.0) on close of a child window - conditionally[^]

Re: Grid view with asp.net model pop up

koolprasad200325-Jul-10 18:06

koolprasad2003

25-Jul-10 18:06

Yes, it is possible
use grid view with tampate control with radio buttons. The user will select one, and click on submit.
The get the selected row record and fill the values in textboxes

Rating always..... WELCOME

Be a good listener...Because Opprtunity knoughts softly...N-Joy

MVC and Entity framework

future383924-Jul-10 20:13

future3839

24-Jul-10 20:13

Hi guys,
I am working MVC and entity framework to build up my knowledge.
I craeted database. then I create Entity framework in Model Folder.next, Create View.
In Model Folder I created Partial class which the purpose of this class is to encapsulate the data which interact with aother layers or DB.
So far, I haven't any problem because I realized everything regarding Entity framework. the problem is I don't know what is next step. What I have to write. I just wanna get same data from database and show them up on the form.
Please someone help me in this matter,
what is next step?

thx heaps

Re: MVC and Entity framework

Gil Fink24-Jul-10 20:32

Gil Fink

24-Jul-10 20:32

Hi,
The first thing to do was to create a controller in order to intercept http requests then you should have built the view. Go to the following tutorial for more details about MVC and EF:
http://www.asp.net/mvc/tutorials/creating-model-classes-with-the-entity-framework-cs[^]

I hope it will help you.

Re: MVC and Entity framework

future383926-Jul-10 13:58

future3839

26-Jul-10 13:58

Hi, Firstly, thank you for your help.

Look, I followed the steps. I created a Controller.(Customer Controller)

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using Practice1.Models;
using Practice1.Models.Repository;


namespace Practice1.Controllers
{
    [HandleError]
    public class CustomerController : Controller
    {
        TestDBEntities _db;

        public CustomerController()
        {
           TestDBEntities _db = new TestDBEntities();
        }

        public ActionResult Index()
        {
            ViewData.Model = _db.Tbl_Customer.ToList();
            return View();
        }

        public ActionResult About()
        {
            return View();
        }
    }
}

AS, I am following your link, I got confused. Could you please tell me where I have to add this code? which part? do I need to create another class

ViewData.Model = _db.MovieSet.ToList();
ViewData.Model = (from m in _db.MovieSet select m).ToList();

Re: MVC and Entity framework

Gil Fink27-Jul-10 20:50

Gil Fink

27-Jul-10 20:50

Hi,
The controller should be placed in the controllers directory in the MVC project.
About the two lines of code you wrote:

ViewData.Model = _db.MovieSet.ToList();
ViewData.Model = (from m in _db.MovieSet select m).ToList();

They are doing the same thing. The first is getting all the movies form the database and returns them as list using the context you use. The second uses Linq to Entities to return all the movies from the database as list.

datagridview

ptvce24-Jul-10 19:59

ptvce

24-Jul-10 19:59

i have a dataGrid view in my windows form and now i want bind it programatically. i write this code::

string ConnString = "";
sqlConnection conn = new SqlConnection (ConnString);
string sql = "";
sqlDataAdapter da = new SqlDataAdapter(sql,conn);
conn.open()l
dataset ds = new dataset();
da.fill(ds);
conn.close();
datagridview1.DataSource = ds;

my code is right and ds hase 1 record and fill right but my grid dont show any record

do u know why?
has anything that i dont

Re: datagridview

thatraja24-Jul-10 20:08

thatraja

24-Jul-10 20:08

your code is incomplete. Add the following line end of your code.