I have a form that allows a user to import a spreadsheet. This spreadsheet is generally static when it comes to column headers, but now the users want to be able to include an optional column (called Notes). My code crashes when I try to read the column from the spreadsheet if it doesn't exist.
[code]...
I have to import the contents of a spreadsheet in my asp.net project. The code behind is c#. how to locate the spreadsheet on the user's computer and how to import the data from a given worksheet into a datable. The problem is I may not know the name of the worksheet ahead of time. How do I present the user with a list of available worksheets and have them pick one?
View 2 Repliesimporting excel/spreadsheet into sql server using C#? Whenever I run the webpage by selecting excel file, first it will empty sql server table then import data from excel.
View 3 RepliesI have a requirement that the user will need to import a list of ID's to the asp.net website from their own spreadsheet. I will provide a button 'btnImport' which will use an OleDbConnection to read the spreadsheet and pull in the id's. I have that working fine in my local dev environment. My question is, when this app is running on a production server, will the user have to upload her spreadsheet to the server first? Or do I need to provide code that will find the file on her machine? I'm not sure how this part of it works.
View 4 RepliesI have an ASP.NET 3.5 Web Application using the Default membership provide provided by .NET - I have created a login page and create user page, etc. etc... The problem is, if you're on the site and you are authenticated, and then you go to a link on the same authenticated folder (Called MemberPages) but you go to a SSL location, it asks you to enter your username and password again! Is there anyway to fix this bug.HomePage -> Login.aspx -> Enter your username and password -> Access MemberPages/Default.aspx -> Then a link called Purchase a Product -> suppose to take you to[URL]
View 1 RepliesI have created a nested repeater using dataset relations before, but am having real trouble adign a third level
Code:
<asp:Repeater ID="rptModules" runat="server">
<HeaderTemplate>
<table>
[code]...
Do I have to cast the third repeater and then databind it the same as the second one?
I have a project who build in MVC 1 and i make a new fresh project to migrate them in MVC 3. so it's work fine. but whenever it's come to done or complete we hear that not make changes in Admin panel.so i copy paste the model [logic module] from MVC 1 to MVC3 and now many of code was not worked. they used dll to use logic. when i try to use them in my project who is new version that's not worked.now i thing to migrate the MVC 1 project to MVC 3 and the taks and changes i do last days i integrated in old one.well tell me the way i can use to migrate the MVC 1 project to MVC 3 razor without making new project. means changes in old and make them work fine in razor.
View 2 RepliesEdit: I solved my problem but if you have anything to add do. Note: I did not create the DB it was created by Wordpress hosted on GoDaddy with my site I have a MySql Database called "wordpress" (for clarity). I want to be able to grab the most recent post from my blog and show it on the landing page for my url.
So my thought is this: connect to the MySql DB, run a query to grab the most recent post, display the post.
I built a class to handle the connection and process the request:
public class DAL
{
private string connectionString = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=[server here]; PORT=[port]; DATABASE=wordpress;
USER=[user name here]; PASSWORD=[password here];";
private OdbcConnection blogConnection;
[Code]....
having trouble defining bindings using ninject.I am in a standard ASP.NET WebForms application. I have defined an http handler to Inject dependencies in pages and controls (Property injection).Here is what I am trying to do:I am creating a custom combobox usercontrol. Based on the value of an enum on that combobox, I want to be able to Inject a different object in a property (What I am trying to do is a bit more involved than that, but answer to this should be enough to get me going).
View 1 RepliesHaving trouble putting together a good solid newsletter.Can some of you experts help me with this problem.
Either with code or link tutorials.everything!
I have a repeater that retrieves questions from a database and displays them on the screen along with a group of radiobuttons. The radiobuttons display correctly and seem to work (only one can be selected per question), but I'm having trouble referencing the buttons from code-behind (C#) to see which button has been checked. So far I've been trying to access the radio buttons this way:here "current" references the index of the current question,
Repeater1.Items[current].FindControl("RadioButton1")
Things like .Checked (after the code above) do not work since the code does not recognize the returned item as being of type Radiobutton. The radio buttons are grouped, so if there is a way to find out via the groupname
I have a table that could look like the left table in the following picture, but i want to present it as the right table in the picture. http://pici.se/549963/?size=fullsize
So i've found out that i could use pivots to do this, but am having some trouble getting it to work, so if you know how to do this.
I have a panel on my page called pnlLogin.In the code behind I have the following line.pnlLogin.Visible = FalseThis errors out when run everytime with the "Object reference not set to an instance of an object." I have done these a million times before, but this page is giving me all sorts of trouble.How could an existing control give this error?
View 9 RepliesI'd like to pull several NewValues from a FormView and write them to a database as part of the Update command.For some reason, I am unable to do this using the following code. Is there something I am missing?
[Code]....
So I've been teaching myself ASP.NET and VB for about 3 weeks now, having trouble with datatables, not sure how to get the rows to line up like I think they should. My code:
[Code]....
Which gives me the data output I want, but the days are adding rows underneath the previous day instead of lining up side-by-side. The idea is that once it's working I'll replace the specific dates with calendar controls. The gridview currently outputs like this:
I am actually bit confused to say. I googled for applying styles in my spreadsheet i got some functions in which they mention about the font, borders etc which i need but i dont know where should i use or how should i implement. When i tried to implement like cell.StyleIndex=8 // Which is modified as per my need but there is no effect in the cells
View 1 RepliesPossible Duplicate: Create Excel (.XLS and .XLSX) file from C#
I have some code that generates a zip file that contains multiple CSV files and streams it back to the user (no file is saved on the server). However, I want to create an excel workbook instead (can be traditional xls or Office Open XML xlsx format) with each CSV 'file' being a spreadsheet.
How can I do this, without resorting to Office Automation on the server or a commercial 3rd party component?
I'm working on a project which requires me to plot a graph using Visual Studio ASP.Net from a data I've collected either in .txt or .xml format. The data consist of, eg. 15 records, but I'm only needed to plot 8 graphs out of the 15 records.
View 1 RepliesI'm exporting an ASP.NET gridview to Excel using the following function. The formatting is working really well, except I need to freeze the header row in Excel on the export. I'm really trying to avoid using a 3rd party Excel plugin for this, but unless there's some archaic excel markup in my AddExcelStyling function.
[code]....
I have a 2 dimensional array, I want to convert it to an Excel document using C#.
View 2 RepliesI have a datasource of an excel spreadsheet provided by a customer. The data is biographic information about clients. The last row contains a web link to view an image of the subject. I have open access to download the spreadsheet and can click each image to view the full jpg in IE.
What would be the best method to loop through the image link to deposit the image into a central file location? The datasource contains 50K subjects and is updated monthly, this is why a manual process is out of the question.
I'm trying to upload an excel spreadsheet using the FileUpload control, read the excel sheet using OleDb connection, and save the strings onto a sql server database.Then, I'm trying to read each string in another method.My web app is currently hosted on the network on my local box, and using savePath= @"C:desktop" like I had it previously wasn't working, so I figured using a sql server database would work for being able to save the file and open it again... but I'm getting confused on how to do so, so i tried using my old savePath but it's not working anymore. So... I'm really at a lost on what to do and how to fix it.
[Code]....
How to do something like this without actually downloading the spreadsheet to the local machine? Any tools or what not out in the world for doing something like this? Does sharepoint allow for .xlsx editing in a page?
Anything short of writing all the inputs and mapping them with backend code?
On an .aspx page in a web site I need to retrieve some data from a sql server database and, instead of displaying it in a Gridview, I need to put the data in a spreadsheet and present the user with a Save As dialog.
I'd prefer to do it without using the Office / Excel / Interop com object - so, from what I've read so far, I can do this by returning XML data from SQL Server?
Normally I get data from SQL Server and populate a dataset or datareader with it - and then use this as the Datasource of a GridView.
If I run this in SQL Server ...
Code:
SELECT UserID, UserName FROM tblUsers FOR XML Auto, Root('Users')
It produces this ...
Code:
<Users>
<tblUsers UserID="1" UserName="Steve" />
<tblUsers UserID="2" UserName="Andrea" />
<tblUsers UserID="3" UserName="Zebedee" />
</Users>
So, first question - how do I get the data from SQL Server into my .aspx page? (All data access is done with stored procedures - so, from my data access class normally I create, for example, a SQLDataReader and populate it by calling a stored procedure. What object would I populate with the results of a stored procedure that contains a select statement with 'FOR XML Auto'
Then, assuming I get the XML into the .aspx page - how do I get it into a spreadsheet so that there are two columns called UserID and UserName and 3 rows with 1, 2 and 3 in the first cell and Steve, Andrea and Zebedee in teh second cell?
My company has new customers in Brazil and we realized that our excel reports are not working when our Brazilian customers tried to open the reports in their Brazilian versions of excel.
For excel output we use spreadsheet gear in our vb.net web application. Our excel worksheets are fairly simple. Mostly outputted text/numbers/dates, a couple of formulas (sum, if) and formatting on the currency and dates.
I've tried several methods to get my excel reports to work: First I left the excel workbook in the "en-US" culture and tried simply chaging the number format for Brazil to:
_-[$R$-416] * #.##0,00_-;-[$R$-416] * #.##0,00_-;_-[$R$-416] * "-"??_-;_-@_-
And this formatted the regular cells but the formulas still failed to show a value. Instead they showed a 0 value.
Next I tried changing the workbook to the "pt-BR" culture and that also forced me to translate the formula names (Sum -> Soma, If -> Se) but they still wouldn't should a value and instead showed a #Name/#Nome error. Interestingly enough the formulas would work if I edited the cell and hit enter. The formula wouldn't change but it would some how fix that cell.
I need to be able to out excel reports that can format dates/currencies and apply simple formulas (IF, Sum) for other excel cultures.