Re: columns in mutilple rows using any control to be exported to excel? - ASP.NET Discussion Boards

ZurdoDev21-Jun-12 2:37

21-Jun-12 2:37

Did you copy this code from somewhere else? Common is somebody's namespace, it is not built-in to System. See previous comment on how to get FileName or find the Common namespace in your App.

Quote:
An error occurred during three days

What? Three days?

There are only 10 types of people in the world, those who understand binary and those who don't.

asp.net 2010 button

classy_dog20-Jun-12 10:08

classy_dog

20-Jun-12 10:08

I am adding some additional code to a C# 2010 web form application that I would like suggestions on how to accomplish the following:

1. I just created an additonal web form page to an existing application so the user can enter more information. I basically want the user to hit the 'back' button so they can return to the original web page and correct the values for up to 4 specific fields. There are two additional fields that the user is not allowed to change.

2. To point the user to the previous page, I do the command, "Response.Redirect("~/Att.aspx"); This works,

3. I want to be able to load all the information the user has entered already when the user returns to this web page. When the user returns to this webpage, the data has already been stored in two tables in the database.

4. Thus I am looking for your suggestion on how to accomplish this goal. I am thinking of the following options:

a. returning the user to the orginal web page in the state it was when they hit the 'next' button to go to the previous webpage. However I do not know how to proceed with this method.

b. Obtain the values from the database, or

c. use session variables. Thus can you tell me what you think the best method would be and examples of code of how you would accomplish this goal?

Re: asp.net 2010 button

R. Giskard Reventlov20-Jun-12 10:47

R. Giskard Reventlov

20-Jun-12 10:47

I would probably use session variables.

The details are all here: ASP.NET Session State Overview[^].

In the OnClick button method on the first page I would store the values in session variables and read them on the next form as required. When you navigate back to the first form repopulate appropriate fields with the session values. I'll leave it you to work out the particulars but the article link above should get you going.

"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum

me, me, me

Re: asp.net 2010 button

classy_dog20-Jun-12 15:53

classy_dog

20-Jun-12 15:53

I am already passing data to the second page as session varirables.
When I return to the first page, I would need to pass session variables from page two to page one. I would need to create new session variables for page 1, correct?

Re: asp.net 2010 button

David Mujica20-Jun-12 11:03

David Mujica

20-Jun-12 11:03

Hmm ... I was thinking of getting the data from the database.

My reason for this is that since you are adding functionality to an existing application, then let's assume that "Page 1" is a complete, working entity.

Now you add "Page 2" to the applicaiton and you build it in such a way that it stands on it's own and can store the additional fields. You just now provide a link which would bring them back to "Page 1" which should know nothing about "Page 2" nor the data that it stores.

Nice. Clean.

Now if the data between Page 1 & 2 are more intricately related, it may not be so easy to implement it this way. One thing you should protect against is that the user cannot navigate to Page 2 without completing Page 1.

Just a though. Rose | [Rose]

Remember to vote. Cool | :cool:

Re: asp.net 2010 button

trooper081421-Jun-12 8:44

trooper0814

21-Jun-12 8:44

Under some circumstances, you might want to post one page to another page. For example, you might be creating a multi-page form that collects different information on each page. In that case, you can configure certain controls (those that implement the IButtonControl interface, such as the Button control) on the page to post to a different target page. This is referred to as cross-page posting. Cross-page posting provides some advantages over using the Transfer method to redirect to another page

http://msdn.microsoft.com/en-us/library/ms178139.aspx[^]

columns in mutilple rows using any control to be exported to excel?

akpaga2220-Jun-12 9:40

akpaga22

20-Jun-12 9:40

144 Points

137 Posts
columns in multiple rows issue?

4 minutes ago|LINK

Hi friends,

I want to build a gridview from a view join two tables Customer and CustomerAddress table..

BUt the format in which my end user wants is the problem i am facing

The gridview should look like this

Colum1 Column2 Column3
xx xxx xxx
Column4 Column5 column6
xxx xxx xxxx

Colum1 Column2 Column3
xx xxx xxx
Column4 Column5 column6
xxx xxx xxxx

so..on
The column 5,6,7 fields should always come below the column 1,2,3 fields....Can i format my gridview to look like this or use any other control and in the end this would make my job simple (i guess) to export to excel in same format...Thank you in advance for all you help and suggestions

Re: columns in mutilple rows using any control to be exported to excel?

Sanjay Kunjam21-Jun-12 21:16

Sanjay Kunjam

21-Jun-12 21:16

akpaga22 wrote:
Colum1 Column2 Column3

xx xxx xxx

Column4 Column5 column6

xxx xxx xxxx

Colum1 Column2 Column3

xx xxx xxx

Column4 Column5 column6

xxx xxx xxxx

Hi,

You can use TemplateField for doing the same.
Here is the example

<pre lang="VB">
 <asp:TemplateField>               
              <ItemTemplate>
                 <table>
                        <tr>
                            <td>
                                <asp:Label ID="column1" runat="server" Text=""></asp:Label>
                            </td>
                            <td>
                                <asp:Label ID="column2" runat="server" Text=""></asp:Label>
                            </td>
                            <td>
                                <asp:Label ID="column3" runat="server" Text=""></asp:Label>
                            </td>
                        </tr>
                        <tr>
                            <td>
                                <%#Eval("field1")%>
                            </td>
                            <td>
                                 <%#Eval("field2")%>
                            </td>
                            <td>
                                 <%#Eval("field3")%>
                            </td>
                        </tr>

                        <tr>
                            <td>
                                <asp:Label ID="column4" runat="server" ForeColor="GrayText" Text=""></asp:Label>
                            </td>
                            <td>
                                 <asp:Label ID="column5" runat="server" Text=""></asp:Label>
                            </td>
                            <td>
                                 <asp:Label ID="column6" runat="server" Text=""></asp:Label>
                            </td>
                        </tr>
                        <tr>
                            <td>
                                <%#Eval("field4")%>
                            </td>
                            <td>
                                 <%#Eval("field5")%>
                            </td>
                            <td>
                                 <%#Eval("field6")%>
                            </td>
                        </tr>
                    </table>
              </ItemTemplate>
            </asp:TemplateField>

Sanjay Kunjam
------------------------------------------------------------------
"Computers are useless. They can only give answers" - Pablo Picasso
------------------------------------------------------------------

save image in mvc3

HamedYem20-Jun-12 6:00

HamedYem

20-Jun-12 6:00

Hello all
I hope that one helps me to save image into database by MVC3 razor
Greetings

crystal report

ManjuDipu19-Jun-12 23:13

ManjuDipu

19-Jun-12 23:13

export button in crystal reports are not working in IE7.why?

Re: crystal report

Sandeep Mewara20-Jun-12 1:14

Sandeep Mewara

20-Jun-12 1:14

Care to put some time and effort to form your question properly? D'Oh! | :doh:

See if the following helps:
Crystal Report does not export using Internet Explorer 7[^]
Internet Explorer7 Blocking Crystal Reports 2008 CrystalReportViewer Export[^]

Sandeep Mewara
[My last article]: Server side Delimiters in ASP.NET[^]

Re: crystal report

ashjassi17-Aug-12 3:06

ashjassi

17-Aug-12 3:06

you can enable this button by javascritp

Create Dymanic Controls in MVC

Pankaj Kohli19-Jun-12 17:23

Pankaj Kohli

19-Jun-12 17:23

How do I dynamically populate controls on a MVC page?For example: I have a page to create questions. I have a drop down with questionType; and i have properties of questions which are specifc to question type; so on selecting specific question type, i want to show controls like textboxes and dropdowns to show properties relevant only to the selected option. E.g. If text type is selected, MaxTextlength textbox is shown. If singleselectradio is choosen a choice is shown to use standard options or create custom options, on selection of custom, something like user control is shown to add options . Bottomline: controls on a page, appear and disappear as per user selection in MVC. This can be easily achieved by loading dynamic user controls or show/hide panels in ASP.Net.

Download file without extension issue

Roman Muntyanu19-Jun-12 8:19

Roman Muntyanu

19-Jun-12 8:19

Hi
I need to download file that does not have extension. The file itself is a simple plain text file. I do this from code using WebClient object. I also cannot view this file in browser with the same error.The error was 404 - file not found.

After research I added mime type: .* as application/octet-stream on web server level. Also the file has these permissions:

NetworkService - full access, ASP.NET - full access. Rebooted machine after making changes.

Still the same issue.

Anybody can advise what else to look for?

Thanks a lot,

Roman

Re: Download file without extension issue

Sandeep Mewara20-Jun-12 1:17

Sandeep Mewara

20-Jun-12 1:17

Roman Muntyanu wrote:
.The error was 404 - file not found.

This does not mean that the file extension was missing or file could not be opened via selected application. It simply means that the path used to access the file downloaded is incorrect and there is no file at the given path.

Make sure you download it at a specified location, check file exists visually once downloaded then try to open it using correct filepath.

Sandeep Mewara
[My last article]: Server side Delimiters in ASP.NET[^]

Re: Download file without extension issue

Roman Muntyanu20-Jun-12 1:34

Roman Muntyanu

20-Jun-12 1:34

The file definitely exists. I have access to the server. If I add extension .txt to the file and to the url I can browse the file and download it.

What is puzzling me is that I was able to download files withou extension on one staging server with adding mime type .* as application/octet-stream . Then we built another paralel staging server for development where download fails. I check all settings I know on both servers and they are identical. I am guessing I am still missing some specific setting on this new development server.
Thanks

SQL server 2005

sundaramoorthy.b19-Jun-12 3:19

sundaramoorthy.b

19-Jun-12 3:19

Hi to all,

I have values in sql table like

RollNumber
----------------
101,102,103
----------------

Now i need get count of this cell, how can i get?????

anyone help me......

Thanks in advance......

Re: SQL server 2005

David Mujica19-Jun-12 3:57

David Mujica

19-Jun-12 3:57

select count(*),RollNumber from <yourtable> group by RollNumber

remember to vote !

Re: SQL server 2005

UTHIRASAMY20-Jun-12 6:31

UTHIRASAMY

20-Jun-12 6:31

select count(firstField1),count(firstField2),count(firstField3)from tblname
group by firstField1,firstField2,firstField3

Re: SQL server 2005

AshishChaudha29-Jun-12 22:45

AshishChaudha

29-Jun-12 22:45

comma (,) seperated rollno in a single field??
clarify please

Microsoft Report Viewer runs great on my local machine but not on the web host server !!!

ma.amer18-Jun-12 5:58

ma.amer

18-Jun-12 5:58

I have a website that uses the Microsoft Report Viewer to display a report and it worked great until I uploaded it to web hosting company. It runs great on my local machine but not on the web host server.

more details...
on my local machine the report viewer preview data and it run successfully but on the web hosting server the report viewer preview nothing,the report viewer toolbar appear as disable and no error returned.

modified 19-Jun-12 4:09am.

Re: Microsoft Report Viewer runs great on my local machine but not on the web host server !!!

Sandeep Mewara18-Jun-12 6:40

Sandeep Mewara

18-Jun-12 6:40

Above information is insufficient. You need to provide more details. Updating question with error would help.

Sandeep Mewara
[My last article]: Server side Delimiters in ASP.NET[^]

Re: Microsoft Report Viewer runs great on my local machine but not on the web host server !!!

ma.amer19-Jun-12 0:45

ma.amer

19-Jun-12 0:45

Re: Microsoft Report Viewer runs great on my local machine but not on the web host server !!!

Sandeep Mewara20-Jun-12 1:18

Sandeep Mewara

20-Jun-12 1:18

Check Report Viewer versions present and used. Make sure they are same.

Also, check system EventViewer to see if any error logged there.

Sandeep Mewara
[My last article]: Server side Delimiters in ASP.NET[^]

Re: Microsoft Report Viewer runs great on my local machine but not on the web host server !!!

ma.amer20-Jun-12 5:40

ma.amer

20-Jun-12 5:40

How can if it hosted in a web hosting company and i haven't permission on that server???

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