VS 2010 - TextFieldParser Read Fields Call By Name Instead Of Position
Oct 9, 2012
Is it possible to use TextFieldParser and call .ReadFields and then use field name instead of field position?
For example, I have 40 columns in my .csv file.
field 0 = ID
field 1 = brand
field 2 = model
field 3 = price
field 4 = color
field 5 = something else.....
How the data would appear in the file:
ID,brand,model,price,color,somethingelse
1,Samsung,Galaxy S,200,black,xx
2,Samsung,Galaxy S II,300,black,xy
3,Samsung,Galaxy S III,500,black,xy
4,Samsung,Galaxy S III,500,white,xy
Right now I am calling the array like so CurrentRecord(4) which returns the color field value.
Can I call it like so, CurrentRecord("color") which would return the same value?
Code:
Dim afile As FileIO.TextFieldParser = New FileIO.TextFieldParser(sFullPath)
Dim CurrentRecord As String() ' this array will hold each line of data
afile.TextFieldType = FileIO.FieldType.Delimited
afile.Delimiters = New String() {","}
afile.HasFieldsEnclosedInQuotes = True
' parse the actual file
Dim iRow As Integer = 1
Just started using VS2010. I am not able to move controls, in the CSS styling I checked the "Change position to absolute...." and still I am not able to move controls. Some other set up I missed?
As you can see I have the same amount of fields with a differing amount of comma characters in each. I was using the comma character (',') to split my string into different fields but this gave me varied results.
I have no control over the format of the file so restrucuring it is not an option.
Is there a way where I can split the string by using the comma and maintaining the address field as a single field.
I have created a basic website using ASP.net VB in order to display a diary of various user inputs to a website, I have created a register page, home page and once the user logs in it will direct them to a user logged in page where the diary entries that they have been created or been added to are displayed from the built in SQL database. I am trying to work with roles to ensure that when a certain login user is logged it will link them to a certain page (sort of like a basic admin page, but really its just to link to a page that only they can see).
I have used a session variable to take the username input and to display the diary entries they are linked to. How can I use another session variable to compare the role of the user that is logged in to allow me to direct them to the webpage that should link to their role. I have written code on the .aspx.vb that I thought would have worked, but it complies fine but doesn't work correctly. How can I write the code so that when the person inputs their details in, it would compare the username/password then to the role that they have been associated with in the database (these areas are all in the same table) that will then link to the webpage.
This is the error message I get on running the login page.Input string was not in a correct format.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.FormatException: Input string was not in a correct format.
Source Error:
Line 46: Line 47: Line 48: ElseIf Session("LoginRole") = ("Diary Owner") Then Line 49: Line 50: Response.Redirect("DiaryPage.aspx")
Code: Sub LogBut(sender As Object, e As System.EventArgs) Handles LogButton.Click
Dim connection As New SqlClient.SqlConnection Dim command As New SqlClient.SqlCommand Dim adaptor As New SqlClient.SqlDataAdapter Dim dataset As New DataSet
I have a function which allows me to quickly load SQL results into an SQLDataReader.
This is a very effective way for me to do this as it can be used for inserts, updates and selects very easily throughout my code.
However, I have noticed some potential memory issues with my site while using this (I keep having to do iisresets when working locally because all the pools are used up) so I am trying to use "Using" rather than "Dim" in an effort to ensure that the connection is always disposed.
I call the function in the following way:
Dim RS As SqlDataReader = SQL.Exec("sp_MyStoredProcedure " & ID) If RS.Read Then Return RS("Column_Name") End If RS.Close()
[Code].....
I now get the error "Invalid attempt to call Read when reader is closed" when calling the function on the line "If RS.Read Then".
I'm an New Coder(Just started.) But my problem = I cant connect ASP.NET to this: [URL] I have already added HWID in my program now i want to add: AUTHORIZED OR UNAUTHORIZED to my program in an textbox
Inside my application I created the following class
Code: Public Class clsProject
Public Sub AddData(ByVal cproject As string) ... end Sub end Class
I want to call this procedure from a sub in a form. So in the code behind file I wrote
Code: Imports TextMgmt.clsProject Public Class WebForm1 Inherits System.Web.UI.Page Protected Sub btnAddData_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnAddData.Click Call clsProject.AddData(txtInput.text) End Sub End Class
I get the following design time error: Reference to a non-shared member requires an object reference.I thought making things Public would make them visible.
I've enhanced my web service with a new method. If I open a browser and type the url of the service, I get a list of the methods including the new one, so that looks okay.
I have a snippet of code which I paste to a Firebug console to test the method, and I am getting a 500 internal server error. If I use the same snippet of code and modify it to test one of the other methods, that works fine.
What I can look at to figure out what is wrong with this new method? The other weird thing is if I try to run the URL on the server it says The test form is only available for requests from the local machine. But I am on the local machine. So I don't know if something is screwed up there, too, or it's the same cause or what.
I know there's tons of advice on the Internet regarding server 500 errors but this is unique in that my web service is working except for the new procedure.
I think I will write another new procedure that's simple (like Hello World) and see if I can call that. This new method returns a list of objects but so does one of the older methods, so I don't know what would be unusual there
Environment is : vwd2008, asp.net 3.5, linq to sql object model, formview, stored procedure used for query.On going problem... I have a simplified page with a webform content area from a master page. The content area contains a FormView connected to an object data source thru the design view tag. The O/R designer has the Lease Table and the stored procedure in the method area.
The stored procedure selects all records from a single table. I an using the DatabaseDataContext and selecting stored procedure name which has "return SingleResult".. There is no code written; the design view was used to create everything. The stored procedure executes in VWD 2008 express tab and shows desired records. I would like to use the O/R and Linq to SQL, and objectdatasource BUT.
I'm working on a new C# web application in Visual Studio 2010, and am having problems reading a value in Web.Debug.Config from the GLobal.asax.cs file.
In the Application_Start event I've got the following code:
When running in debugger, I've got a break-point in the Application_Start event in Global.asax.cs. It hits the break point, but in all cases the value coming back from ConfigurationManager is coming back null. What am I doing wrong?
I'm trying to do the equivalent of a "Are you sure you wish to delete?" and then if yes, return to a function in the aspx.vb code. Here is what I have:
And then on the form, the btnCancel does popup the menu, with Yes / No and the text "Are you Sure?"But, even though I have a button called "btnCancelYes", I cannot get the code in there to trigger. Ie:
Code: Protected Sub btnCancelYes_Click(sender As Object, e As EventArgs) Handles btnCancelYes.Click DeleteRecord() End Sub
I've read up on this error from other posts and on other sites, but haven't found a solid resolution to the issue yet. My setup is as follows:
I have a RepositoryBase class that fields certain db calls that all repositories need to perform. In one such call, "GetSecurityGroup", it works most of the time, but will seemingly at random throw an exception with the error "Invalid attempt to call Read when reader is closed." All other Repository classes inherit from this one, and they all use the same DataContext object, which I understand isn't thread safe. Since there could be multiple calls to the DataContext object on the same page, perhaps one is using the DataContext when the next tries to do so. I'm not sure. What can I do to ensure this doesn't happen?
I have a sql data souce that returns several columns of data, and they are displayed in a DetailsView on a pretty simple vb.net page. I'm stuggling with one field though for the details view.
It's a template field, and if ClientType=1 (this value is determined else where on the page), then the label in the template field should have Text='<%# Bind("ClientName") %>', but if the ClientType = 0, then the label in the template field should have Text='<%# Bind("ClientTemporaryName") %>'
How do I tell the details view to set the text for ClientName to one or the other?
I have a relatively complex dataset (numerous tables, some with multiple records) generated from reading in an XML file. I need to connect said dataset fields to an ASP form. At the moment I'm assigning them manually, like so in the pageload:
I did some looking into binding the textboxes (and dropdownlists, and checkboxes, and and and...) directly, but it seemed to be too many formats to use.
So this works fine, but as the number of fields increases, those load and unload lists are going to get unwieldy.
I am working on Crystal Reports 8.5 and SQL Server 2000 as backend. I have a stored procedure which has been added to the Crystal Report. So that fields are visible in the Fields object section from where i can drag and drop the fields on the report and display it. But now as they want more fields i have written two select statements for displaying required fields. But these newly added fields are not visible in the Fields object section in the Crystal Reports. I have done verify database, removed and again attached the SP but the problem is not solved.
Q1: I have an Asp.net page , one textarea there the user can enter all his details like name age gender; how do get the get name, age, gender in seperate fields(text fields). how can i split?
Q:
dawn barric 25 male answer: text1: dawn barric text2: 25 text3: male
I have a GridView, and I want Column1 to be equal to datatable data (filled by a SqlDataAdapter). Then I have two other fields by the SqlDataAdapter (first name, last name), and I want to have those two fields combined to form Column2. I have a TemplateField for my GridView that combines the first name and last name with Eval()'s, but the GridView places this combined field TemplateField and puts it as the first column.
How can I do this so that TemplateField can go in between fields that are databound?
How to call Synchronous service call for combo boxes? As I know Synchronous calls do not create a good user experience because the application is hung waiting for the Web service call to return. Then it is my requirement.
I have an ActiveX object which extends some functions. I have a web page that loads the ActiveX object and calls its methods in Javascript. The ActiveX object has two method; the problem is that Javascript can successfully call one of them but fails to call the other; citing Object doesn't support this property or method which is nonsense because I made a VB6.0 application that successfully calls this other method, so the two functions are indeed extended correctly and performing their job. And yes, the Internet Explorer security zones are all set and everything, as I wrote above the javascript code can call one method but refuses to call the other.
