upload and read excel file in asp.net with mvc3 and c# - ASP.NET Discussion Boards

sandy kreative11-Sep-12 22:19

11-Sep-12 22:19

i am using crystal report in asp.net 2.0.
the report is showing perfectly when clicked on report button,

But after showing the report if i clicked on print or export or any button the report is invisible.

Its very urgent.

Thanks in advance.

Sandy

Re: crystal report designing issue

Sandeep Mewara12-Sep-12 0:41

Sandeep Mewara

12-Sep-12 0:41

Sounds like clicking on print or any other export buttons trigger page postback. You need to re-bind the crystal report document object to the report viewer in the Page_Load event when a postback occurs in order to use export and print functionality.

Similar discussion here: Report dissapear on postback[^]

Sandeep Mewara
Microsoft ASP.NET MVP

[My latest Article]: Server side Delimiters in ASP.NET[^]

crystal report

sandy kreative11-Sep-12 20:07

sandy kreative

11-Sep-12 20:07

I am using asp.net 2.0 with vb.
I have created a dataset(.xsd) and added a datatable in that. through query i am filling the value to ds.
Then i added a rpt file.
In the form i added one crystal report viewer.

but i dont know how to load the crystal report using that values. (code for the crystal report).

Please help me out. its very urgent.

Re: crystal report

Sandeep Mewara11-Sep-12 21:02

Sandeep Mewara

11-Sep-12 21:02

Here, have a look at these, learn and try:
Step by Step Creation of Crystal Report using its Features Group, Graph, Cross-Tab and Sub Report[^]
Crystal Reports in ASP.NET[^]
Generate a Report using Crystal Reports in Visual Studio 2010[^]
Step-by-step: Crystal Reports In ASP.NET[^]

Now, you posted same question twice here. Please delete the above one. No need to repost.

Sandeep Mewara
Microsoft ASP.NET MVP

[My latest Article]: Server side Delimiters in ASP.NET[^]

Re: crystal report

sandy kreative11-Sep-12 21:07

sandy kreative

11-Sep-12 21:07

thanks a lot

How to read a VBscript Command on a textbox

vipfangirl11-Sep-12 17:27

vipfangirl

11-Sep-12 17:27

Hi!

Can someone please help me on how to read a VBScript command when a user enter it on a textbox. This logic is similar to this How to run PowerShell scripts from C#[^]. Thanks in advance.

Re: How to read a VBscript Command on a textbox

Eddy Vluggen11-Sep-12 21:53

Eddy Vluggen

11-Sep-12 21:53

Read the contents of a textbox?

string zeText = textBox1.Text

To execute them, use the MSScriptControl.

Bastard Programmer from Hell Suspicious | :suss:

if you can't read my code, try converting it here[^]

upload and read excel file in asp.net with mvc3 and c#

emadq11-Sep-12 14:31

emadq

11-Sep-12 14:31

I have a task to upload excel file on server and then read data from multiple sheets, specific rows and columns and display it on web. I have completed uploading and displaying data from 1st sheet only. Please someone can help me out. Thanks

Re: upload and read excel file in asp.net with mvc3 and c#

Sandeep Mewara11-Sep-12 19:29

Sandeep Mewara

11-Sep-12 19:29

Once is enough, no need to repost. Have patience and someone will reply.

Further, at any given time you can use 'Edit' link to edit your question if needed.

Sandeep Mewara
Microsoft ASP.NET MVP

[My latest Article]: Server side Delimiters in ASP.NET[^]

upload and read excel file using mvc3 with asp.net and c#

emadq11-Sep-12 14:22

emadq

11-Sep-12 14:22

I have a task to upload excel file and then display multiple sheets data on web. I have completed uploading and reading excel file and data is displaying on web but only from 1st col and rows, whereas I need to pickup data from specific row and column. Some one can help me out please and send me a complete code.

Highlight row on click event gridView

byka11-Sep-12 8:30

byka

11-Sep-12 8:30

How can I hightlight full row in gridView on row click event and display rowID in label

Re: Highlight row on click event gridView

Sandeep Mewara11-Sep-12 19:28

Sandeep Mewara

11-Sep-12 19:28

You can do the following by:
1. Inject Javascript function on mousehover/onclick & mouseout of the link in a grid row.
2. Using JavaScript, show a div/text that contains the needed details
3. Using JavaScript, hide the div/text onmouseout.

For injecting JS, you need to use RowDataBound of GridView, something like:

// Not exactly same but similar scenario smaple
protected void GridView_RowDataBound(Object sender, GridViewRowEventArgs e)
{ 
   DataControlRowType rtype = e.Row.RowType;  
   if (rtype == DataControlRowType.DataRow && rtype != DataControlRowType.Footer
       && rtype != DataControlRowType.Separator && rtype != DataControlRowType.Header
       && rtype != DataControlRowType.Pager)  
   { 
      // Show div   
      // You can show text in some label in methods attached
      e.Row.Attributes.Add("onmouseover", "ShowDiv(this);");
      //Hide div
      e.Row.Attributes.Add("onmouseover", "HideDiv(this);");
   }
}

Try!

Sandeep Mewara
Microsoft ASP.NET MVP

[My latest Article]: Server side Delimiters in ASP.NET[^]

Re: Highlight row on click event gridView

Manzoorali2912-Sep-12 22:18

Manzoorali29

12-Sep-12 22:18

Hi i think you need not to highlight the row using click event you can highligt it using selectedindexchang event

Re: Highlight row on click event gridView

Sandeep Mewara12-Sep-12 23:18

Sandeep Mewara

12-Sep-12 23:18

SelectedIndexChange event for a grid row? I doubt that.

Sandeep Mewara
Microsoft ASP.NET MVP

[My latest Article]: Server side Delimiters in ASP.NET[^]

Build Deploment Package Error

ahmed zidane11-Sep-12 6:27

ahmed zidane

11-Sep-12 6:27

hello
i have problem when i try to publish my web application
i publish my web application folder in my ftp server
but when i try to build deploment package i have one error and asp.net show this message

The value is not a valid connection string or an absolute path
Keyword not supported: 'provider'

Re: Build Deploment Package Error

Sandeep Mewara11-Sep-12 7:32

Sandeep Mewara

11-Sep-12 7:32

Possible causes include invalid connection strings, login failures, or SQL Server settings that block connections.

Look at this Microsoft support article: MS Support: is not a valid connection string or an absolute path. Error: Keyword not support...[^]

Sandeep Mewara
Microsoft ASP.NET MVP

[My latest Article]: Server side Delimiters in ASP.NET[^]

Re: Build Deploment Package Error

ahmed zidane11-Sep-12 14:37

ahmed zidane

11-Sep-12 14:37

ok thank you
i'll try it now

ASP.Net

Habib00711-Sep-12 5:05

Habib007

11-Sep-12 5:05

How to declare connection string into web.config file ?

habib

Re: ASP.Net

Pete O'Hanlon11-Sep-12 5:54

Pete O'Hanlon

11-Sep-12 5:54

There's a ConnectionStrings section that you can add an individual connection string into. You can see a sample here[^].

*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington

"Mind bleach! Send me mind bleach!" - Nagy Vilmos

CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

Re: ASP.Net

Sandeep Mewara11-Sep-12 5:56

Sandeep Mewara

11-Sep-12 5:56

Place something like this in your Web.Config file root:

HTML

<connectionStrings>
  <add 
    name="NorthwindConnectionString" 
    connectionString="Data Source=serverName;Initial 
    Catalog=Northwind;Persist Security Info=True;User 
    ID=userName;Password=password"
    providerName="System.Data.SqlClient"
  />
</connectionStrings>

Here, have a look at details: MSDN: How to: Read Connection Strings from the Web.config File[^]

Sandeep Mewara
Microsoft ASP.NET MVP

[My latest Article]: Server side Delimiters in ASP.NET[^]

Message Closed

11-Sep-12 18:36

kianurieves

11-Sep-12 18:36

Message Closed

Re: Cache property

Pete O'Hanlon11-Sep-12 22:59

Pete O'Hanlon

11-Sep-12 22:59

What question are you answering? Your answer has absolutely nothing to do with the question, and is merely spamming the site to link to an external site. Consequently, I have voted to remove your answer and your account.

*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington

"Mind bleach! Send me mind bleach!" - Nagy Vilmos

CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

HttpMethod and PostBack Testing

KaptinKrunch11-Sep-12 4:47

KaptinKrunch

11-Sep-12 4:47

Just a quick question.
Is this test logical or possible in ASP.NET? If so, under what scenario(s) would you
expect to see such a positive result of the test.

Thanks

if (Request.HttpMethod == "POST" && !IsPostBack)
{...}

Just because we can; does not mean we should.

Re: HttpMethod and PostBack Testing

Eddy Vluggen11-Sep-12 5:30

Eddy Vluggen

11-Sep-12 5:30

I ain't no web-programmer, but sounds like homework, and I know where the documentation is, so shouldn't be too hard to come up with something. Let's try.

HttpRequest.HttpMethod[^]

Gets the HTTP data transfer method (such as GET, POST, or HEAD) used by the client.

Docs also state it's a String, so the first part of the evaluation looks correct. The English implies that the Request was a POST action on the server.

IsPostBack looks like a property, not a method. Guess it must be part of the Page[^].

Gets a value that indicates whether the page is being rendered for the first time or is being loaded in response to a postback.

Ah, interesting. So, the block would be executed if:

It's being POST-ed
It's not a postback (meaning, the page is being rendered the first time)

The action is determined in the Form;

HTML

<form name="input" action="html_form_action.asp" method="post">

..and that is why I kinda like MSDN. Hope this helps a bit Smile | :)

Bastard Programmer from Hell Suspicious | :suss:

if you can't read my code, try converting it here[^]

Re: HttpMethod and PostBack Testing

KaptinKrunch11-Sep-12 6:06

KaptinKrunch

11-Sep-12 6:06

Thanks for the reply, not quite the answer I was hoping for, but thanks anyway.
p.s. its not "homework" in the traditional sense but rather me attempting to expand my knowledge on my own time.

Just because we can; does not mean we should.

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