VS 2010 - Comparing Fields From Database
Nov 4, 2011
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
[code]...
View 3 Replies
Similar Messages:
Jan 31, 2011
I am dealing with dynamic fields in a for loop and now I need to retrieve the values that are being typed in the dynamic fields, any idea how can I do that? 2)also when I click the submit button, upon postback, the dynamic fields have gone missing, have been trying to slove that, but i did not, anyone knows how to deal with this? kinda urgent :x
3) and How do you compare the 2 dynamic fields? For eg: Im comparing the tbSch[i] to tbSch[i], so that the dates cannot be the same, am using a compare validator, but it throws me error that im comparing the same fields :) even though i change to ("tbSch" + i) for both, sorry Will provide my code snippet as follow :D tbNum is a textbox where user enter numbers and click generate
protected void btnGen_Click(object sender, EventArgs e)
{
for (int i = 0; i < Convert.ToInt32(tbNum.Text); i++)
{
// label and textbox needed
Label lblSch = new Label();
TextBox tbSch = new TextBox();
Label lblWsGrp = new Label();
DropDownList ddlWsGrp = new DropDownList();
CompareValidator cvSame = new CompareValidator();
cvSame.ID = "cvSame" + i;
cvSame.ErrorMessage = "Date cannot be the same";
cvSame.Operator = ValidationCompareOperator.NotEqual;
cvSame.Type = ValidationDataType.Date;
cvSame.Display = ValidatorDisplay.Dynamic;
cvSame.EnableViewState = true;
cvSame.ControlToValidate = (tbSch.ID);<<<<< what should be the value in here?
cvSame.ControlToCompare = (tbSch.ID);<<<<<<<<<< and here?
//schdule date
lblSch.ID = "lblSch" + i;
lblSch.Text = "Session Date : ";
lblSch.EnableViewState = true;
tbSch.ID = "tbSch" + i;
tbSch.Width = 210;
tbSch.Height = 27;
tbSch.EnableViewState = true;
//workshop grp
lblWsGrp.ID = "lblwsgrp" + i;
lblWsGrp.Text = "Workshop Group : ";
lblWsGrp.EnableViewState = true;
ddlWsGrp.ID = "ddlWsGrp" + i;
ddlWsGrp.Height = 27;
ddlWsGrp.Width = 210;
ddlWsGrp.EnableViewState = true;
ddlWsGrp.Items.Add("1");
ddlWsGrp.Items.Add("2");
//table to store data
TableRow trow = new TableRow();
TableRow trow2 = new TableRow();
//row1
TableCell tc1 = new TableCell();
TableCell tc2 = new TableCell();
TableCell tc3 = new TableCell();
TableCell tc4 = new TableCell();
//row2
TableCell tc5 = new TableCell();
TableCell tc6 = new TableCell();
TableCell tc7 = new TableCell();
TableCell tc8 = new TableCell();
TableCelltc9 = new TableCell();
tc1.Controls.Add(lblSch);
tc2.Controls.Add(tbSch);
tc3.Controls.Add(lblWsGrp);
tc4.Controls.Add(ddlWsGrp);
tc5.Controls.Add(space);
tc6.Controls.Add(CeSess);
tc7.Controls.Add(space);
tc8.Controls.Add(space);
tc9.Controls.Add(cvSame)
trow.Cells.Add(tc1);
trow.Cells.Add(tc2);
trow.Cells.Add(tc3);
trow.Cells.Add(tc4);
trow2.Cells.Add(tc5);
trow2.Cells.Add(tc6);
trow2.Cells.Add(tc7);
trow2.Cells.Add(tc8);
trow2.Cells.Add(t9);
this.table3.Rows.Add(trow);
this.table3.Rows.Add(trow2);
}
}
View 11 Replies
Jul 1, 2010
For this applications, I will have a table that has a list of users who are "moderators" and they are able to see a part of the website that regular users cannot. I will NOT have a login or anything like that - I have a table that lists all the users who are moderators and if the user who is logged in is a moderator they simply see more of the website.
Right now I am able to get the username of the logged user (these are users who log into a Windows machine, and I simply get their login using a method from System.Security).
The thing I have no idea how to do is actually compare the username to the username in the database that I have. can anyone point me to a tutorial or something that searches through a database to compare the given value and see if there is an identical one in a specific database? I don't want the user to see the database, this is all done "behind the scenes".
View 11 Replies
Dec 6, 2010
I am REALLY new to ASP.NET MVC, and it is alien to my way of thinking.In my project, I have managed to get as far as allowing the user to add, edit or delete entries from a table. What I want to do is ensure that a specific field (i.e. "Tank_Number") does not get duplicated. What is the correct way to implement this?
I would like to use custom validation in the model class, the reason being the handy error messages, but am getting more confused as I read more articles. At the moment, I am using an If statement in the Controller, but it isn't ideal.
Here is my example code:
Controller [Code]....
Model
[Code]....
View
[Code]....
View 3 Replies
Dec 31, 2010
I am trying to add new fields in membership table by using createuserwizrad control. is it possible to do that?
View 3 Replies
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
[Code] ....
View 2 Replies
Aug 5, 2010
i am working with a database to create a website i know how to display the data into tables on my website but is there a way of changing the database layout when a button is pressed. i.e. so that when a button is pressed on the website the program sorts all of the first names into order (A to Z) in the database - so that the information is displayed A to Z
View 4 Replies
Oct 28, 2010
I need to populate my textfields from values in database. I also need navigation buttons to scroll through all records, similar to an access form. Below is what I have on the OnLoad event:
[code]....
View 1 Replies
Feb 20, 2011
i have three pages named first.aspx, second.aspx, third.aspx. i fillup some fields in first.aspx, then click next,i fillup some fields in second.aspx then click next, i fillup some fields in third.aspx and here i click submit button.now i want to save those all fields in to the database at once.
View 5 Replies
Mar 14, 2011
I have taken over development of a asp.net 3.5, c#, MSSQL website, which I did not create.
There is a form on the website which adds all kinds of information into my SQL database. I have added two fields to the database, two corresponding extra form questions and added to the c# code behind so that these new fields are treated in exactly the same way as the existing ones.
I am therefore completely stumped as to why those two fields aren't populated in the database when I submit the form.
No page errors or anything, it's just the fields remain empty when the other pre-existing ones are populated just fine.
Is there something obvious I'm missing - for example is there a setting in the database I'm not enabling to allow the two new fields to be written to by my c# file?
I was not a programmer before this, I'm just picking it all up as I go along.
View 4 Replies
Dec 5, 2010
If I am going to use the AdRotator with Database and set the properties from the table fields, how can I set the impression?
View 5 Replies
Mar 20, 2011
How can i make this work like i have 5 fields in my database table . 2) i created a model for validation with datannotation and created the compare password field as well with comparepassword attribute. (now my model has 6 fields including one external field compare password and 5 database fields)3) i created a view with that model.(User)4) now i created a controller as well but the problem arise here that when calling that actionmethod the compiler complains about the external field and tells it cannot find any extension method . how can i create the extension method or solve this error?
[Code]....
View 5 Replies
Apr 6, 2010
Have created a Webform based on a master page.The code executes OK and sends data to the database, but inserts null values for all entries except the GetDate.
If I use exactly the same code in a new webform which isn't based on the master page, it inserts everything correctly.Here is a snippet from the form which uses the master page: -
<%@ Page Title="" Language="C#" MasterPageFile="~/SpeedDateMasterPage.master" %>
<script runat="server">
private void AddToDatabase(object source, EventArgs e) [code].....
View 10 Replies
Jul 6, 2010
I have an SQL datasource that successfully enters customer details into a table. What it includes is the persons address. First of all we add the persons address, then we add the persons name to that address in a seperate physical procedure. i.e. on a different form.
What I need to do is try and stop users entering the same address twice. The way I have thought of doing this is by making a string field called AddressIdentity and have this contain the door number and the postcode of the address with all the spaces stripped out. Then when adding the address, it checks if this exists before adding it. However I cannot work out how to put the 2 fields together without using the codebehind file, which I don't mind doing if I need to, but I'm sure its avoidable.
Here is my code - I have only included the relevant parts:
InsertCommand="INSERT INTO [tbl_shop_client_addresses] ([FlatNo], [Address1], [Address2], [Town], [County], [Postcode],
[Country], [Telephone], [DoorNo]) VALUES (@FlatNo, @Address1, @Address2, @Town, @County, @Postcode, @Country, @Telephone, @DoorNo)"
<InsertParameters>[code]......
So how do I do it? I was trying:
InsertCommand="INSERT INTO [tbl_shop_client_addresses] ([FlatNo], [Address1], [Address2], [Town], [County], [Postcode],
[Country], [Telephone], [DoorNo], [AddressIdentity]) VALUES (@FlatNo, @Address1, @Address2, @Town, @County, @Postcode, @Country, @Telephone, @DoorNo, @Postcode + @DoorNo)"
but of course AddressIdentity is a string. Do I use ' ' marks with an & sign? Or can't I do this?? Maybe I need to use the codebehind anyway to see if the field exists before inserting it?
View 2 Replies
Dec 11, 2010
how to disabled and uncheck the checkbox values from database fields..if i have entry in my database records as :Name Seats DateSumit 1,3 11-Dec-2010Sanjeev 2,4 12-Dec-2010Manish 1,3,4 11-Dec-2010I want on page load event the default date for todays is 11-Dec-2010 then checkbox1, checkbox2, checkbox3, checkbox4 will be disabled and unchecked state for 11-Dec-2010as you see on the above database structure the seats for 11-Dec-2010 is 1,2,3,4 so the chekbox1, checkbox2, checkbox3, checkbox4 will be disabled..
View 1 Replies
Mar 25, 2010
I have an issue where I am running out of database space on my hosting provider. As it turns out, the aspnetdb database is more than 6x our application database. We are using anonymous profiles and there are 21 fields stored in each user profile.
Upon analysis, most of this data is not required to be stored - it is simply wasting space. The part that is wasting the most space (5 binary objects) are not even used by any of the public users. I would like to remove these binary objects from all of the user's profiles without deleting the profiles, but I can't seem to find any documentation on how to do this.
I can remove the fields, which will take care of users going forward, but I need to retroactively delete these fields from the aspnetdb database to free up space. Since each user manages their own profiles, I am unsure how to create an automated procedure to delete these fields out each anonymous user's profile.
View 1 Replies
Aug 29, 2010
I'm currently developing a software application for my client. Part of the project is to keep track of his stock's shipping status. The client must insert the stock's pick-up date, expected time of departure (ETD) and expected time of arrival (ETA). The stocks will be called out using Grid View and the status, being one of the keys of the database, will be shown. Before the current date reaches pick-up date, the status must show "in warehouse", and after the current date reaches pick-up date and is before ETD, status must show that its "on the way to the port", and after ETD and before ETA, "in freight", and finally after ETA, "arrived". What datatype should I use for the database and where should I program it so that it changes automatically accordingly ?
View 5 Replies
Feb 7, 2011
i want to make sure all product names are unique so i tried to do the following. but it is causing an infinity loop at the lambda expression.
public partial class Product
{
partial void OnProductNameChanging(string value)
{
using(var ctx = new MyEntityContext()){
var val = value;
var item = ctx.Products.Where(o=>o.ProductName == val).FirstOrDefault();
if(item != null)
throw new ValidationException("Product Name existed.");
}
}
}
i'm using asp.net 4.0 with dynamic data and entity framework.
View 1 Replies
Feb 1, 2010
I'm not sure if I can explain this properly, I just need some advise. I'm working with a formview and datasets to populate the information. However I have a table specifiying which fields to display. In my table If cell, work and home fields are selected then those fields must be populated in the formview if they not selected then it shouldn't be shown. These are 2 different datasets being pulled into the formview.
Right now I have a datasource populating the formview via the wizard, not sure what to do next.
View 5 Replies
Mar 11, 2011
I am trying to populate database fields by reading text from a Word or PDF document. Like if a user uploads a file then certain text from that file can be usd to populate a database table.
View 1 Replies
Jan 4, 2010
I would like to create dynamic fields to search data from Databbase, The interface should be as below:
CustomerID
View 5 Replies
Feb 24, 2010
I am working on an application and am attempting to use Linq with and ObjectDataSource but I only want to display/update 50% of the fields that are in the corresponding table. It appears to me that for this to work correctly, I need hidden fields on my form for all of the data fields from the table that the user cannot access. Is this the only way to do this? I have the following in my update method of my ODS:
[Code]....
The problem is, only the fields that appear on the form have data in them.
View 1 Replies
Jan 30, 2011
I have a database containing various datafields that I need to display to a user based on their userID (which is assigned during login).
I need the data to be displayed in a specific format. i already have a table with input (text) fields and select fields created in html.
I need to know the easiest way to populate these fields with the data found in my database in an MVC fashion.
View 2 Replies
Jun 2, 2010
I am working on a search engine application and was hoping there was a way to take multiple fields from the database and combine the values (separated by spaces) into a single virtual field, without having to actually add it to the database
Let's say I have 2 fields, FirstName and LastName - can I take these 2 fields and combine them into a Name field where Name = FirstName + " " + LastName
What I'm going to be attempting has a lot more to it than that, but if I can get an example on how to achieve that, I can apply that same principle on a larger scale
ways of doing this with AND/OR, I want to combine multiple fields into a single field
View 6 Replies
Jul 4, 2013
How can we use multiple field of database in one cell of gridview.
Like we have name,age,salry,address
i want in personal cell, in address cell
name=***** address=*****
Age=***** salary=*******
View 1 Replies
