i have a simple application which i couldnt run correctly. My codes;
using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
protected void Page_Load(object sender, EventArgs e)....
When i run that page, and enter the same number with label1 to textbox1 and click to the button, first label1 changes to another number and so the comparement does not match.
I create a table as picture below :
when I insert any character to column Name then A new string random will auto insert into column Random (picture below) I had used Trigger but It was error !
I want to column Random use to code :
DECLARE @myid uniqueidentifier
SET @myid = NEWID()
insert into table_1 values(@myid, substring(CONVERT(varchar(255), @myid), 1, 5))
but It must auto like column Number (column Number is Identity)
How can I compare the data using ADO.NET. I have wrote the following code but don't know what to do next
Code:
Sub LoginCheck()
Dim Conn As OleDbConnection
Dim DbCmd As OleDbCommand
Dim SqlCmd As String
Dim DbRead As OleDbDataReader
Dim MyDbPath As String
MyDbPath = "C:Documents and SettingsAdministratorMy DocumentsVisual Studio 2008WebSitesHwManApp_Data/hwMan.mdb"
Conn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=" & MyDbPath)
Conn.Open()
SqlCmd = "Select * from UserInfo where UserId='" & txtUserName.Text & "' and UserPass='" & txtPassword.Text & "'"
DbCmd = New OleDbCommand(SqlCmd, Conn)
End Sub
I have records that have an initial value of 'blue' and stay 'blue' until after 2 days then they turn to 'green', Turn 'orange' after 15 days and then after 20 days turn 'red'.The results will be pulled into a gridview.What I'm having difficulty is; what's the best way of calculating the days, in sql server or in c#?Trying to get construct date examples is proving to be a bit of a pain:
[Code]....
has anyone done something similar and found a good way of doing this?
I have a few values in c#, how do i compare if a variable is equal to 5.5 ?
here is my code
double res = 4.5;
double ehi = 5.5 ;
bool
ehi= decimal.Compare( res, ehi);
I am a c#/asp.net developer and I am having to work on a VB/asp.net. I started out with VB.NET but after years away from it I'm getting confused with the syntax.
I have two variables
Dim originalDate as DateTime?
Dim newDate as DateTime?
Both nullable datetimes, originalDate is a nullable date I am getting from the database and newDate time is set in code, I need to compare them, they can either both have dates, neither have dates or one have and one not.
I have a bit of code as follows:
if origEndDate = origEndDate then
When both origEndDate and origEndDate are "nothing" this statement is false (well when I run it in the watch window it comes back as nothing)!
I don't understand why this is the case because I was under the impression doing an "=" compares the two values and as they are the same surely it should be true?
What syntax should I be using as in C# I can do the above as so:
if (origEndDate == origEndDate) { }
and it will come back as true.
I set ViewState["zzz"] and Session["zzz"] to the same string.
When I compare using == I get false.
When I do ViewState["zzz"].Equals(Session["zzz"]), I get true.
In the debugger, both their values show the same string, and when I do
? ViewState["zzz"] == Session["zzz"]
I get false.
I thought the ViewState StateBag Item defaults to the set value and the Session Item defaults to the value as well?
I am having trouble comparing two dates. One is captured from input, other one is predefined. Please see the code below: I enter this date in the textfield: 04-12-2001
Dim idatum As Date
If Date.TryParseExact(aankoopdatumIDclm.Text, "dd-mm-yyyy", Nothing, System.Globalization.DateTimeStyles.None, idatum) = False Then 'idatum is true at this point...
[code]....
I have a program that is using credit card info and the expiration date is selected by the user clicking a dropdownlist for the month and a dropdownlist for the year. I want to show a label message if the user tries to proceed while the month and year are evaluated as being earlier that the current month/year.
View 4 RepliesI have a problem that I have to enter float values in my database from a textbox. The problem is I want to enter only float values upto two decimal places(like 12.34, 56.78, etc). How do I do this.? Do I need to first convert the values from my textbox (string values) to Int64 before submitting?
My second problem is that I have to compare that float value in my database to a value in another text box. I am using this sort of code:
[Code]....
I need to check the datetime field in my DB to see if the time that's current set is 12hr's past?What's the command to use? Can I just DATEDIFF?
View 4 RepliesI have a large database of user profile data. I need to be able to compare 1 row against all of the other rows, for all columns to find the best match.There are around 30 columns of data for each row. I need to be able to find the 5 best matching rows.
I.E.
Row 1 matches on 2 column's
Row 2 matches on 12 column's
Row 3 matches on 7 column's
Row 4 matches on 4 column's
Row 5 matches on 9 column's
Row 6 matches on 23 column's
Row 7 matches on 29 column's
In the end it will show me the data for rows 7, 6, 2, 5, 3 Now to make it even harder, Some of the columns are bit, some are varchar.Some of them may be a direct match, some will need to search if the column for row2 contains the text of row 1.
I want to compare value in textbox with some value in my table .
View 4 RepliesIm trying to use the following SQL statement to find every row in Orderable Test List where there is not a row in Results Individual Tests that has a matching entry in the TESTHISCD column. When I run the page everything freezes up.
"SELECT [Orderable Test List].*, [Results Individual Tests].TESTHISCD FROM [Orderable Test List], [Results Individual Tests] WHERE [Orderable Test List].TESTHISCD <> [Results Individual Tests].TESTHISCD"
comparing two dates with comparevalidator
View 2 RepliesI'm pretty sure this is in the wrong forum category, but I couldn't find a relevant category, so here goes!'m looking for a way of highlighting text changes between two sets of content, very similar to how this website's wiki works:For example, if I go to an edit page on the wiki, I can compare two versions and see the difference:[URL]
View 3 RepliesI am trying to compare a login textbox password and username with a custom validator using linq to get information from the database it always returns false though on the validator where my code below is going wrong.
protected void LoginValidate(object source, ServerValidateEventArgs args)
{
TiamoDataContext context = new TiamoDataContext();
var UsernameCheck = from User in context.Users
where User.Username == TextBoxLoginUsername.Text && User.Password ==
[Code]....
I dont know where I am going wrong I know its most probably some sort of silly mistake and me being inexperienced at this...
I'm trying to compare a string from a label to a varchar(50) in my database. String Occasion = '1 2010-07-07 10:00' compared to varchar(50) OccasionID = '1 2010-07-07 10:00'
[Code]....
[Code]....
I've checked that the values really are identical in the debug. I was under the impression that no conversion is neccessary between string and varchar, but maybe I'm wrong.
$("#lstIncludedOBNCategories").change(function () {
var rightSelectedIndex = $("#lstIncludedOBNCategories").get(0).selectedIndex;
<% if(Model.ObnCategoriesDTO.where(x => x.OBNCategoryID == %> rightSelectedIndex
<% ) %> -----I SHOULD DO SOMETHING HERE
});
I do not know whether I can use if statement as below.
<% if(Model.ObnCategoriesDTO.where(x => x.OBNCategoryID == %> rightSelectedIndex <%)%>
It is not letting me do compare like this.
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]...
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".
I am working in asp.net 2.0 application programing.
How to use a compare validator for comparing two date.
How to compare tow date in format using custom validator and else. I have java script function like as. I want to call this function by using custom validator as
< </ asp:CustomValidator id="CustomValidator2" runat="server" ControlToValidate = "tbMyDate1"
EnableClientScript="True" Display="Static" ClientValidationFunction="Compare" SetFocusOnError="True" >asp:CustomValidator>
function { document.getElementById( Compare()"lblrefdate").innerText="";var m_names = new Array(
"Jan",
"Feb",
"Mar",
"Apr",
"May",
"Jun",
"Jul",
"Aug",
"Sep",
"Oct",
"Nov",
"Dec");
var { { dispMM=i+1; } }
dispdate=document.getElementById("tbMyDate");var
dispDD=dispdate .value.split("-")[0];var s1=dispdate.value.split("-")[1];var
dispMM;var i=0;for(i=0;i<=m_names .length ;i++)if(m_names [i]==s1) var { {
refMM=j+1; } } dispYY=dispdate .value.split("-")[2];var
refdate=document.getElementById("tbMyDate1");var refDD=refdate.value.split("-")[0];var
s2=refdate.value.split("-")[1];var refMM;var
j=0;for(j=0;j<m_names .length ;j++)if(m_names[j]==s2)var
refYY=refdate.value.split("-")[2]; if {
document.getElementById(
} (isNaN (refYY))"lblrefdate").innerText=""; else { { { { {
document.getElementById(
} if(refYY<=dispYY)if(refMM <=dispMM )if(refMM==dispMM)if(refDD <=dispDD )"lblrefdate").innerText="";else { document.getElementById(
} } } "lblrefdate").innerText="Ref Date can Not Be Grater then Disp Date";else {
document.getElementById( } }
"lblrefdate").innerText="Ref Date can Not Be Grater then Disp Date";else
document.getElementById( { } } }
"lblrefdate").innerText="Ref Date can Not Be Grater then Disp Date";
at our office we take daily backup of ASP.net application ms access backend for the next few days we need to evaluate the changes made to records in the database tables at the end of each day i want to compare 2 access databases first database is the backup of yesterday and second database is the backup of today i thought of the following algorithm, how to proceed to compare the datatables / gridviews
i need to display th rows / cells containing the differences / updates / deleted data
[code]....
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]....