ASP.NET

15-Mar-09 18:19

Hi all,

I have datagrid dg1, paging is true and at a time it is displaying 10 records.I want to export this to excel.Whatever the data is displaying the datagrid at a time that will only export to excel.I dont want to display all the data from database.Is there any solutions .
I am using C#.
Thanks is advance

Re: Datagrid to Excel

Christian Graus15-Mar-09 18:27

15-Mar-09 18:27

Just write a CSV, Excel will open that fine.

Christian Graus

Driven to the arms of OSX by Vista.

Re: Datagrid to Excel

rakeshs31215-Mar-09 18:48

having problem with the datagrid on passing value to next page?

15-Mar-09 18:48

Thanks!!!!

Re: Datagrid to Excel

subhashini.s17-Mar-09 22:48

subhashini.s

17-Mar-09 22:48

Here is the coding for to display the gridview items to the excel when the button is clicked.

Using System.IO;
Using System.Text;
Button1_Click()
{
String attachment="attachment;filename=Gridview.xls";
Response.ClearContent();
Response.AddHeader("content-disposition",attachment);
Response.ContentType="application/ms-excel";
StringWriter sWriter=new StringWriter();
HtmlTextWriter htwWriter=new HtmlTextWriter(sWriter);
Gridview1.RenderControl(htWriter);
Response.Write(sWriter.ToString());
Response.End();
}

public override void VerifyRenderingInServerForm(Control control)
{
}

Alok Sharma ji15-Mar-09 18:12

Re: having problem with the datagrid on passing value to next page?

15-Mar-09 18:12

hi.
on my project i need to carry the value of datagrid to next page.
the datagrid i have is edited by me and i want the value of link to next page
(the datagrid contains a linklabel and a imagebutton)
i tried it with sessions but dont know about fecthing value of selected row

Christian Graus15-Mar-09 18:28

Re: having problem with the datagrid on passing value to next page?

15-Mar-09 18:28

If you want to carry a value to the page you're linking to, just put it on the query string. Don't abuse the session object.

And try posting code when you want help, so we can see what you're trying to do, and where it's broken.

Christian Graus

Driven to the arms of OSX by Vista.

Alok Sharma ji15-Mar-09 18:34

Re: having problem with the datagrid on passing value to next page?

15-Mar-09 18:34

maybe i dont put the clear message
well i have a datagrid view extracting values name(linklabel) and imagename(imagebutton) from database
the paging is enabled i just want the value of linklabel to get fecthed for use in next page. Confused | :confused:

Christian Graus15-Mar-09 18:53

Urgent :Beginner of ajax controls

15-Mar-09 18:53

OK, I think you need to drop your tools, buy a BASIC ASP.NET book and READ it. You need to do EXACTLY what I said. Your link to the next page should put whatever you want to pass, on the URL. If you want to pass lots of things, you're better off passing an Id and reading the whole record from the database, in the page.

Christian Graus

Driven to the arms of OSX by Vista.

Alok Sharma ji15-Mar-09 17:50

15-Mar-09 17:50

hi frnds i am a beginner of ajax controls in asp.net c# .so as it is i am having so much problems in using advance controls like mouserover, accordian etc.....
can youy help me with articles or refer books .
i tried some asp.net books but they are not so much helping for all ajax controls Smile | :)

Abhijit Jana15-Mar-09 18:09

Abhijit Jana

15-Mar-09 18:09

Alok sharma ji wrote:
can youy help me with articles or refer books

Look Here[^]

cheers,
Abhijit
CodeProject MVP

Alok Sharma ji15-Mar-09 18:15

15-Mar-09 18:15

thanks this should help me lot, but can you refer something for more to advance skills in ajax so i dont need to put question again. Big Grin | :-D

thanks again

Abhijit Jana15-Mar-09 18:46

Abhijit Jana

15-Mar-09 18:46

Alok sharma ji wrote:
but can you refer something for more to advance skills in ajax

First Start from W3School[^]

cheers,
Abhijit
CodeProject MVP

rakeshs31215-Mar-09 18:26

15-Mar-09 18:26

If u r a beginner or not ur question has no urgency for us.It wont get any special attention if u use "urgent" or "i am dying".So b4 posting the question read and learn how to post the question decently.

Christian Graus15-Mar-09 18:30

Develop Antivirus (Urgent !)

15-Mar-09 18:30

Just so you know, you're not learning AJAX at all, AJAX is hidden from you, you're playing with some controls that use AJAX, I doubt you have the remotest idea how that works.

So, look for books like 'Mastering ASP.NET AJAX. If you buy AJAX books, they will just confuse you and will not pertain to the controls you're talking about.

Christian Graus

Driven to the arms of OSX by Vista.

Milind Panchal15-Mar-09 17:41

Milind Panchal

15-Mar-09 17:41

I want to develop simple antivirus which scan files from pc with virus names and if it found virus then that can be deleted.
So can any one help me for logic behind that and how can I compare files.
Where I have to store virus database.

Thanks in advance. Thumbs Up | :thumbsup:

Alok Sharma ji15-Mar-09 18:00

15-Mar-09 18:00

is this the topic of asp.net maybe not you should post it to a different forum or
you are wasting your time Laugh | :laugh:

Milind Panchal15-Mar-09 23:15

Milind Panchal

15-Mar-09 23:15

If u r not able to answer so plz don,t reply. No need to laugh. Don't waste ure time.

Abhijit Jana15-Mar-09 18:11

Abhijit Jana

15-Mar-09 18:11

swami samarth wrote:
I want to develop simple antivirus which scan files from pc with virus names and if it found virus then that can be deleted

cheers,
Abhijit
CodeProject MVP

rakeshs31215-Mar-09 18:23

15-Mar-09 18:23

All are asking doubts here and sharing their knowledge here ,your question is not important than others ,all will have the same priority.So dont use "urgent".

Milind Panchal15-Mar-09 23:17

Milind Panchal

15-Mar-09 23:17

This is not an answer of my question.

Christian Graus15-Mar-09 18:31

15-Mar-09 18:31

If someone is paying you for this, they are more lost even than you are. If you're programming for fun, then choose a more sensible project.

Christian Graus

Driven to the arms of OSX by Vista.