I have created a demo application to read data from the CSV and after read the data from the csv file there is a button to save all the CSV loaded data in the database. When i load the large CSV (2MB) file . after load all the data from the file i will save all the data in datatable and store in view state.
when i click on another Link the page doesn't work and page become expires. Where is the problem.
Its simple doing read CSV file .. file stream closed. store all the csv data in view state. and click on the another link save into the database. but click save database button page expire.
I know this is probably a pretty easy thing to do and it is if I can upload the file and store it onto the hard drive of the server. What I need to do is read the text file into memory and then parse through it one line at a time. Anyone have any code that demonstrates that?
in other words, reading the content (records that lies within) of a LinqDataSource object programatically (i.e. similar to what the GridView class does internally when binding to a LinqDataSource object).
I have a databound gridview with 3 columns. I enumerate through each row to get values and put into an array. I would like to make column1 NOT visible to the user. but when I set Visible="False", it no longer can retieve that columns value as it enumerates.
Is there a way I can make the first column invisible to the user but still retrieve the values of that column when enumerating?
I have made an application to read data from an excel file and save to database "Access". It's working perfect except one thing that..There are 4 columns in excel file as :
Shop no owner address alternate member address permanent member address
For all fields i have kept same datatype in database as "text". As in above image In Column A "shop no" in some rows there are same shop no with A,B,C classes. Now when I am uploading this excel file it saving all data, but in Column A cells which having only numbers would be saving to database eg: 185, 187, 188. And the cells which has both number and class eg: 185 A, 185 B would be reading as null values.
I have a web page (Provider) that creates an XML file to be send to the Requester in this fashion:
1. A Requester page needs to send an XML file to the provider page 2. Provider will read the XML file to authenticate the request 3. Provider will Create an xml file with some data. 4. Provider will send the xml file back to the Requester.
Can anyone provide sample code for both the Requestor page (step 1) and the Provider page (steps 2 & 3)
I am using Adobe Captivate 5, and ime trying to create an ASP script which will store the results from a quiz in an SQL database. The problem I am having is that captivate is posting the results from the quiz in multipart/form-data format and I am unable to retrieve the variables in my ASP script.
I have tried request.form("test") and fileUpload("test") and neither retreives the varibales.
What is the syntax to retrieve data that has been posted in the multipart/form-data format???
I have a form with several controls. I'm trying to read from database and navigating through single record per page. I'm displaying a single record but not navigating through. My customerID field is the primarykey. But there are gaps btw records (1,2,5,6,10...etc). Some of them were deleted.
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Dim myReader As SqlDataReader Dim myConnection = New SqlConnection("server=myPCSQLEXPRESS; database=CustomersDB; uid=myPC est; Password=; Trusted_Connection=yes") myConnection.Open() Dim myCommand = New SqlCommand("SELECT * FROM Customers", myConnection) Dim intFirstRecord As Integer = CInt(myCommand.ExecuteScalar()) myReader = myCommand.ExecuteReader() If myReader.Read Then lblCustomerID.Text = myReader("customerID") lblCustomerName.Text = myReader("CustomerName") End If myReader.Close() myConnection.Close() currentRecord = lblCustomerID.Text End Sub
Sub Next_OnClick(ByVal sender As Object, ByVal e As System.EventArgs) Dim myCommand As SqlCommand Dim myConnection As SqlConnection Dim myReader As SqlDataReader myConnection = New SqlConnection("server=myPCSQLEXPRESS; database=CustomersDB; uid=myPC est; Password=; Trusted_Connection=yes") myConnection.Open() myCommand = New SqlCommand("SELECT TOP 1 customerID, CustomerName FROM Customers WHERE customerID > @customerID", myConnection) myCommand.Parameters.Add("@customerID", SqlDbType.Int, 5).Value = currentRecord myReader = myCommand.ExecuteReader()
If myReader.Read Then lblCustomerID.Text = myReader("customerID") lblCustomerName.Text = myReader("CustomerName") End If myReader.Close() myConnection.Close() End Sub
I'm being able to read first record. If I click Next button, my page goes to next record for only once. If i click several times, nothing happens. Does not go to next available records.
Im trying to input the value in the table into the checkboxes but i keep getting an error that states: "Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index"When i do a quick on this part of the code :"DirectCast(GridView1.Rows(i).FindControl("DescriptionA1"), Label).Text", i get "Run-time exception thrown". This is my first time trying something like that, i have search for solutions but now im more confused than ever.
I have a page with is basically a few Gridviews that I want to email to some users. The Gridviews are connected to sqldatacontrols. I create the select statements in the code behind. This all works fine.
To email the page I read the page into a streamreader and then creates an email and sends it. So when I get the email the Gridviews show no data.
I stepped through my code and found that the issue is with a variable. The Select statement has a few parameters one of which comes from a profile variable. When the page is read the profile variable is empty. I tried it as a session variable and that fails as well so my question is if I cannot use profile variables or session variables what other way is there to save this data?
In VB I can place module level variables so that say when a form loaded and I wanted to save a variable I would load the module variable which made it available to any form in the project but I assume that I cannot do the same in VB.net asp.Net? On the first page load the variable is available I just have to figure out a way to save it to pull out again when the page posts back.
I have some code that reads records from an excel file and then imports that data into an sql database. The issue only happens when the excel file has more then 350 rows in it. In the middle of the import it just stops executing and I get directed to the 'Internet Explorer cannot display the webpage' page or just a blank page when using firefox.
I dont get any time out errors or any error at all but still I tried messing around with the script timeout settings but still does the same thing at about the 2 min 30 sec mark.
I understand how to use a connection string object to read excel sheets. What I don't know is how to follow a hyperlink inside excel, grab matching data from the linked page and return it to my database. Essentially, the spreadsheet has two columns:
Title | Class#
Class# has the hyperlink which links to an internal web site. The connected page has a course description and any pre-required classes that must be taken before you can take this class. This is where I'm rather stumped as I've not had to do this type of thing before.
I'm a new in ASP and I have this problem. I do some small websurwey. Random questions per page, random count of questions, 4 types of questions (answears 1 .. 10, Text answears, ... atc.) I created webuserscontrol for each type of questions and these controls I dynamicly add to place holder in some page. There is everything OK, but when I click button on the bottom of the page, I need save the results from client, I need to know which radiobutton is selected and save it to DB and make some operation, and then, after saving, this page is reloaded and show next
Questions. This questions and settings I have in DB. My problem is, how to read data from my UserControls after button click (button on page, not on my controls)? Controls in placeholder are NULL in PostBack and after postback there are new controls. I endclose a small code which is "like" my original code, it is testcode to explaine to you.
have created a gridview with input text boxes inside which can be added by the user.
So in order to populate the gridview on form load I use grdView.DataSource = PopulateDT(); this.grdView.DataBind();
Now is there a neat way of retriving the data content after the user has entered data from the gridview and store as a datatable. The only way is doing a for next loop which i think its time wasting.
I have a website written in C# that was running fine on one server. We moved it to another server and have a couple issues. I am mainly a VB.NET coder but can do a few things in C#. This is not a project - it is a website and can open it in VS2008 no problem. This is an admin site for the whole website where the user can add customer comments, etc. When logging in, it works fine. I can go to one of the admin pages after logging in and works. If I go to two other different pages, I get this error:
Object reference not set to an instance of an object.
[Code]....
It turns out this is in the main.master page and it is used by the other pages that load fine. The ApplicationTitle variable is set right in the web.config file and like I said, it shows on the other pages.
My question is why would this code work fine for some pages and not two others? All of these admin pages are under a folder called Admin and the web.config file is in the root folder of the website. Its almost like these two pages cannot see the web.config file in the root folder? Why would that be if thats the case?
Btw, when I have this loaded in VS2008 and try to do a Build, it says:
It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS.
I would assume the folders on the server are set right since all but two .aspx pages run fine. Just something I thought I would mention. This does not really seem to be a coding issue but something not set right especially since it ran on the other server just fine.
I am working on a comparison tool that will take an excel file and a .csv file and find differences. The user is going to be selecting the two files from their local machine via the .NET FileUpload control. The issue I am running into is that I don't want to write the files to the server first so using something like below won't work for me, as "Book1.xls" or even " + FilePath + " in place of it won't work. I need to be able to read the posted files into memory, then create maybe datatables of them, then do my comparison code.
[Code]....
I have some code that reads the PostedFile into a stream but I don't know how I can use that stream with the above code. Then I have some that can read the .csv file, but if it is an excel file, I get a bunch of Excel garbage along with the data...
[Code]....
How can I read into clean data from a FileUpload control of an Excel document?
1. I know about collections but I dont remember the precess. I know you drag a sqldatasource control on the form(Select everything in the database ie. selct *) and then delete it. But how do I use it i code.
Example. I need to select services where country=canada from the Agencies table.
2. I know how to manually pull data from an access database using the code below. I want to know how to pull data from a sql database just like the one below.
3. explain the difference between Collections and manually pulling it like the one bellow?
have an annoying problem. i'm trying to update single items in a databound listview. but when i click the update button it gives me the cannot insert NULL value. it doesnt seem to read anything from the textboxes which i have databound from the database. even though text is clearly shown...
i have setup my update statement and parameters, it uses the Update command name and ItemUpdating event. i catch the data from the textboxes by using e.ItemIndex and use the text assigned to the parameters in a SqlCommand.
The thing i'm aiming for too is that when an item is updated it stays on the page where the item was updated, (i was using response.redirect before but it went against my aim since the whole page reloaded)
I am using reading data from excel file and inserting into sql server using following article, it seems to be working correctly except when I do page refresh normally, it again execute the the btnUpload_click. I want that once the record imported and if user refresh the page again it should ask for enter file name again. let me know how do I resolve this? [URL]