ASP.NET

FirstPrevNext

Re: Visual Basic.net Vipin_Arora19-Apr-12 2:23 Vipin_Arora 19-Apr-12 2:23  yes..its true...+5 for it Happy Coding... Export to Excel with number of columns unknown in advance biop.codeproject18-Apr-12 19:52 biop.codeproject 18-Apr-12 19:52  I have a web application to display sales data. My input, transaction_header table, is like this: ... van_id sale_date ... ... Van A 2012-03-01 17:28:38.000 ... ... Van A 2012-03-01 17:33:54.000 ... ... Van B 2012-03-01 12:33:48.000 ... ... Van B 2012-03-01 12:38:14.000 ... I need to export the transaction data to excel and the excel would show as: Gross Sales DATE Van A Van B Van C ... 1-Mar $3,359 ... $49,934 $20,657 $41,481 ... 2-Mar $3,633 $4,263 ... $73,394 $38,134 $41,083 ... 3-Mar $2,118 ... $40,831 $39,838 $32,344 ... 4-Mar SUNDAY 5-Mar $4,387 $3,842 ... $84,814 $39,242 $41,116 ... ... My problem is the number of van may change over time. For the transaction_header table, this does not post a problem as there is just one more row. Yet for the output, it is a problem. Thw columns of my table may increase over time. Now how do I approach this problem? Appreciate any feedback. Thanks. modified 19-Apr-12 22:57pm. Re: Export to Excel with number of columns unknown in advance Hermaine18-Apr-12 21:09 Hermaine 18-Apr-12 21:09  hmmm..... you can do it.... good luck! Re: Export to Excel with number of columns unknown in advance ZurdoDev19-Apr-12 6:37 ZurdoDev 19-Apr-12 6:37  There are a ton of examples online of how to export data to Excel. Start here.[^] There are only 10 types of people in the world, those who understand binary and those who don't. Re: Export to Excel with number of columns unknown in advance biop.codeproject19-Apr-12 16:49 biop.codeproject 19-Apr-12 16:49  Yes, there are tons of example out there. My question, I think, is more specific. The number of columns may increase (or even decrease, although I doubt it will) over time. Now how can I handle this? Re: Export to Excel with number of columns unknown in advance ZurdoDev20-Apr-12 1:53 ZurdoDev 20-Apr-12 1:53  Quote: The number of columns may increase (or even decrease, although I doubt it will) That is just fine. Most examples I have seen use a DataGrid and set AutoGenerateColumns = true. This means that it does not matter how many columns you have. The code is have used before is here.[^] All you have to do is set the datasource of the datagrid. There are only 10 types of people in the world, those who understand binary and those who don't. Re: Export to Excel with number of columns unknown in advance vvashishta24-Apr-12 18:55 vvashishta 24-Apr-12 18:55  Try This...it will work as per your requirement: protected void cmdExport_Click(object sender, EventArgs e) { clsDataAcess oDataAccess = new clsDataAccess(); oDT = new DataTable(); oConst = new clsConstMaster(); string filename = string.Empty; try { oDT = oDataAccess.GetCustomerWholeInformation(Parameter To function Here); if (oDT.Rows.Count > 0) { filename = "CustomerInformationFromMaster.xls"; System.IO.StringWriter tw = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw); DataGrid dg = new DataGrid(); dg.DataSource = oDT; dg.DataBind(); dg.HeaderStyle.BackColor = System.Drawing.Color.LightGray; dg.HeaderStyle.Font.Bold = true; foreach (DataGridItem i in dg.Items) { foreach (TableCell tc in i.Cells) { tc.Attributes.Add("class", "text"); //tc.BackColor = System.Drawing.Color.Blue; } } dg.RenderControl(hw); string style = @" .text { mso-number-format:\@; } "; Response.Write(style); Response.ContentType = "application/vnd.ms-excel"; Response.AppendHeader("Content-Disposition", "attachment; filename=" + filename + ""); this.EnableViewState = false; Response.Write(tw.ToString()); Response.End(); } } catch (Exception ex) { MessageBox(ex.Message.ToString()); } } public override void VerifyRenderingInServerForm(Control control) { } - Happy Coding - Vishal Vashishta border for the repeater control indian14318-Apr-12 18:58 indian143 18-Apr-12 18:58  Hi, I have a repeater control, for which I have header template and item template. Both are in different divs. Both divs are creating rows and border properly. The problem now is the header is having gap and then its body. Is there any way that we can have border for the whole repeater control? Any sort of link or code snippet would be greatly helpfull. thanks in advance, Thanks & Regards, Abdul Aleem Mohammad St Louis MO - USA Re: border for the repeater control Reza Ahmadi19-Apr-12 2:07 Reza Ahmadi 19-Apr-12 2:07  Hi, Try this post: http://forums.asp.net/t/1679854.aspx/1[^] I hope it helps, Cheers Re: border for the repeater control jkirkerx19-Apr-12 8:49 jkirkerx 19-Apr-12 8:49  Is it a vertical gap or horizontal gap? VB.net Hermaine18-Apr-12 18:48 Hermaine 18-Apr-12 18:48  Can we create a message box inside the Label?... and the msgbox contains a link that will use to pop up another form.?.. this program is using a VB.Net... Hermaine Re: VB.net biop.codeproject18-Apr-12 19:54 biop.codeproject 18-Apr-12 19:54  What are you trying to do? Click on a Label and pop up a message box? Click on the link inside the message pop up another form? Wow. Re: VB.net Hermaine18-Apr-12 20:52 Hermaine 18-Apr-12 20:52  haha.. yeah.. i'm just trying to create an event handler calendar using a VB.net.. i don't have any idea on how to put an event to each date of the month. Hermaine Re: VB.net Abhinav S18-Apr-12 20:50 Abhinav S 18-Apr-12 20:50  Hermaine wrote: Can we create a message box inside the Label? That message does not make much sense. A message box / alert is shown on top of the form / web page. A non-modal message box could go behind the application confusing the user. Re: VB.net Hermaine18-Apr-12 20:58 Hermaine 18-Apr-12 20:58  OK.. thanks Sir.. but how about making an event calendar then if the user will point it's cursor on the date within a month there will be a message that shows all of the events of that date. is this possible using a VB.NET application Sir? Re: VB.net ZurdoDev19-Apr-12 6:39 ZurdoDev 19-Apr-12 6:39  Anything is possible since you control the code. I think you should start by learning the language better and viewing samples that other people have. There are only 10 types of people in the world, those who understand binary and those who don't. Re: VB.net Vipin_Arora19-Apr-12 22:30 Vipin_Arora 19-Apr-12 22:30  Hi, See the following article: Event Calendar [ ASP.NET 2.0 / C# ][^] Happy Coding... When opening a SSRS report in visual stusio, gives error unable get IVSDDESIGNER SERVICE nainakarri18-Apr-12 18:14 nainakarri 18-Apr-12 18:14  Hi I have few reports developed on SSRS 2005 and binded in VSS. When i try to open the reports in my login in visual studio, then i get error "UNABLE GET IVSMDDESIGNER SERVICE". When i open the reports locally in visual studio, i can am able to view the reports. Please suggest me how i can solve this. Thanks in advance Naina Naina Get and set the value of a literal in the list item in unordered list - jquery indian14318-Apr-12 13:03 indian143 18-Apr-12 13:03  Hi, I have web page in which I am Literal Control within list item in the unordered list. Is there any way to get or set its value using jquery. Thanks in advance please. Thanks & Regards, Abdul Aleem Mohammad St Louis MO - USA Re: Get and set the value of a literal in the list item in unordered list - jquery jkirkerx18-Apr-12 18:28 jkirkerx 18-Apr-12 18:28  Not that I am aware of, you need to use a div tag or panel with an id assigned Re: Get and set the value of a literal in the list item in unordered list - jquery indian14318-Apr-12 18:46 indian143 18-Apr-12 18:46  Hi, I got it solved by append and remove css, and remove all the elements with that css class in the jquery. Thanks, abdul Thanks & Regards, Abdul Aleem Mohammad St Louis MO - USA Re: Get and set the value of a literal in the list item in unordered list - jquery jkirkerx18-Apr-12 19:00 jkirkerx 18-Apr-12 19:00  Well if that backfires on you later on down the road, you can use jquery to dump or delete everything inside the div tags, and then write new html back inside the tags, while retaining your div tag css, so the div tags retain the proper spacing and alignment. it works great for movie or flash objects, and will destroy the movie and audio as well. Or you can destroy an entire list of products, and write new ones, etc Good to hear you solved it. Re: Get and set the value of a literal in the list item in unordered list - jquery indian14319-Apr-12 5:55 indian143 19-Apr-12 5:55  Thanks & Regards, Abdul Aleem Mohammad St Louis MO - USA pdf rendering options indian14318-Apr-12 11:48 indian143 18-Apr-12 11:48  Hi All, I have a web page which is having print and email buttons. When I say print its printing on paper and on pdf also correctly. Now they want, the same pdf format should be sent as to users when user clicks email. Is there any way to generate the pdf files for this and send emails with those pdfs as attachments when user clicks email button. Please any body if have any idea please help me, its very urgent. Any link or any code snippet helps me a lot. In this mean time I will request to uncle google . Thanks & Regards, Abdul Aleem Mohammad St Louis MO - USA Re: pdf rendering options Sebastian T Xavier18-Apr-12 18:39 Sebastian T Xavier 18-Apr-12 18:39  I have used abcpdf for the same purpose. Its very easy to integrate. Meanwhile, which tool have you used to get your pdf output from webpage?

Last Visit: 31-Dec-99 18:00     Last Update: 26-May-24 0:14 Refresh ᐊ Prev1...529530531532533534535536537538 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.