i followed [URL]. it was fine till server side but how would i be applying client side validation for unique field validation scenario on for example say username. i want to have username as unique.
View 2 RepliesFor example: INSERT INTO table (col1, col2, col3) VALUES ('value1','value2,'value3')But I would only like to insert the row if value3 isnt already present in col3 in some previous row. What is the best way to do that?And the insert command is run 50+ times in a loop (with different values each time for value3)
View 4 RepliesI'm using Visual Web Developer Express 2008 and SQL Management Studio Express 2005. I need to link 2 tables to either present in a Master/Detail or GridView/Form view.The goal is to allow the user to view time card information from the AS400 (read only) and then enter any corrections into a SQL table. My problem is in trying to connect the two tables.I've asked the AS400 administrator to add a unique identifier field to the table (HAPOINT), but he says he can't. I've tried to concatenate a field within Visual Web Developer's Query Builder but keep getting errors.Table 1 - exists in AS400, is non-permanent (cleared every 3 months) and can't be modifiedEmpl ID WO Date In Time In Date Out Time Out Table 2 - exists in SQL Server, newly created for this project (no data yet, so can be modified)Rev ID Empl ID Date (of revision entry) X (Revise - y/n) Revised Time In Revised Time Out I tried finding a solution through the SQL Forum, but haven't gotten a solution, so I'm posting here. There are additional details at that post:http://forums.asp.net/p/1516929/3658517.aspx#3658517Can anyone tell me how to concatenate "Empl ID /WO / Date In / Time In" from Table 1 to produce a unique identifier that I can then use in Table 2, thus providing the link between the two tables? Or, is there another way?
View 8 RepliesHow to get Unique ID of LDAP logged in User? Is GUID is the unique id of each user?
View 1 RepliesIs GUID (globally unique identifier) really unique, or it can be duplicate.
System.Guid.NewGuid().ToString()
How generate the unique no. 1,2,3 and so on .... on button click of each new user ..
the code mentioned below is a readwrite coding in vb.net ...
but the problem is it generate the same id for different users on button click event... but i want the no. of times button clicked the new ids will be generated
[code]....
How can I get unique session ID for every unique user who logs in ?? I'm using asp.net/c#
View 1 RepliesHow To Display Data In Following Format?
In the Format below abc has multiple occurance which count is displayed in brackets as 2669.
[code]....
I am here with a task to generate a unique no of specific length from another unique no.
I want my target unique no of say z length to be generate from combination of a unique no [ that may be a serial no ] of say x length and any secret key of say y length.
I am using a GridView Control to display multiple fileds with 0's and 1's.
I am using template fields where CheckBoxes are used.
Where exactly and how do I apply the Logic to get a checked CheckBox when field Value=1 and unchecked CheckBox when field Value=2 .Also some times to be able to write a YES where fieldValue=1 or NO where filedValue=0
Do I apply this logic using asp or C#? How?
I wanna join all the field as a new col.
but how can i ignore the empty field because i always join the field and separate by space like the following.
select (field_1+' '+field_2+' '+field_3) as new_col from TABLEA
but if the field is empty, then there is the double space
how can i ensure all the space is one space only.
I have 2 fields in my gridview one called ScriptType the other BagNo, when a user click the edit button, I would like the BagNo filed to be disabled if the ScriptType field is = "TTA" and enabled otherwise. How can I do this?..something along these lines see below..I am using VB..
[code]...
I have defined a field validator that works fine on normal behavior on a page:
<asp:RequiredFieldValidator runat="server" ErrorMessage="errroooorr" ControlToValidate="TextBoxHouseNumber" Display="Dynamic"></asp:RequiredFieldValidator>
Now if I dont insert any text in the TextBoxHouseNumber field, and push submit, the FieldValidator fires as it should. But if I now click a button that automatically fills the TextBoxHouseNumber with text from a Jquery/Ajax function, the field validator still shows. Itīs like "Hey, the user hasnt made any changes to the textbox, so I wont bother check it".
I have a DetailsView on the page and I have made one of the fields a TemplateField. In the EditItemTemplate and InsertItemTemplate I have a DropdownList that is databound to a table in my Sql Server database. I wanted to add an initial value to the DropdownList
namely "- select -" .
I set the AppendDataBoundItems property to true and added the initial value as a ListItem.Markup of the DropdownList
<asp:DropDownList ID="DropDownList_HP" runat="server"
AppendDataBoundItems="True" DataSourceID="SqlDataSource_HP" [code]...
This works fine for new input. The problem is however that the database already has records that were entered through a Windows Application and many of these records has a null value in this field and exceptions are thrown when I tried to open these records
and the system tried to set the SelectedValue of the DropdownList.After some more searching I found this help
http://msdn.microsoft.com/en-us/library/ms366709.aspx
So I changed the ListItem in the DropDownList markup to the following:
<asp:DropDownList ID="DropDownList_RefHospDV4" runat="server"
AppendDataBoundItems="True" DataSourceID="SqlDataSource_RefHosp" [code]...
This now solved the problem of opening a record where the value is null in the database, BUT now the RequiredFieldValidator is not validating anymore to make sure that a databound item is selected for this field and not the initial value "- select -". So basically now it is not checking anymore to see if valid input has been entered for the DropDownList and it accepts "- select -" thus it acts as if the field is not a required field anymore.
In short what is required is that I want to make sure that the user enters a valid selection in the DropDownList, but it must also cater for old records that do not have this field entered yet so that those old records can be opened in the DetailsView .Opening Old records (with null in that field):When these old records are opened in the DetailsView the DropDownlist should show "- select -" when the value in the database is null.
Saving records (old or new records):When saving the record in Insert mode or Update mode the RequiredFieldValidator should show that a valid input is not selected if the DropDownList is still on "- select -".
I have a aspx page with a ascx control inside an ascx control and the required field validator is not hit on the action of the page.
The issue is with the 2nd nested ascx control. The field validators in the first ascx control validate correctly, but with the ascx control inside the ascx control there are issues.
The nested ascx control is a repeater control and this may be the reason, but I am unsure.
I'm not exactly sure what question to ask, but I'll list a few below.
How do I attach the field validators up a level to the 1st ascx control?
Is it possible to put required fields into a nested ascx control?
when i am declaring my connection string i am getting error below is my connection string
[Code]....
the error is A field initializer cannot reference the non-static field, method, or property 'Default3.con1' .i am unable to type con1.
Dim query as String = "Select * from openquery (devbook, 'SELECT wb.arrival_time FROM web_bookings wb ')"All I need is to convert my arrival_time into a datetime field in the query
View 1 Replieshow to pick a specific field (besides Primarykey field ) through HQL query ???
View 5 RepliesI have a 20 to 30 fields on a form. Most of them are optional. However, the users can fill out what they want. If a user dosen't fill in a field when data is sent to the database it's sent as blank, instead of NULL. Is there a way I can generically say "for all textboxes if Equals("") then DBNull.Value". Without going through each and every textbox?
View 2 RepliesI have a grid view, and I add new column as a hyper link field, I want the navigationURL for this field to be Pageexample.aspx?ID=other field value like this
[code]...
is that possible ?
provide sessionstate in my web.config file like thissessionstate mode="InProc" cookieless="UseUri
That way each tab generates a new unique session ID in the URL with the format like this :[URL]It worked, but when I copy the url and paste it on another tab then the previous session value is inheriting. How can I solve this issue? Is there anyother method to solve issue?
I have a TreeView in my application,while page loaded TreeNodes Id are Unique.But while me to use for RenderControl Method TreeNodes Id are not unique. Why TreeNodes Id are not Unique?
View 1 Repliesi have an application where users are allowed to fill in a form, once saved the form is given a unqiue # in this format: YYYY/MM/DD/### where ### is a 3 digit number, starts at 001, next one would be 002, etc.. the the YYYY/MM/DD is the date the form was saved, so if we had 2 saved today we would get these two:
2011/01/10/001
2011/01/10/002
I just wanted to know how to be sure that those numbers are always unqiue, if two people submit a form at the same time to make sure they are not given the same number? As we had that happen recently now that the application is being used a lot more, two people saved about the same time and once someone clicked save twice while the first save was happening and 2 of the same IDs were generated. Just want to make sure no matter what a unqiue one is always generated. I 'm able to calculate the ###, just wanted to know if there is a way to make sure it's not being used by a process saving right now.
Is it possible to Extend Textbox to have a Unique Name ? I have tried using UniqueID poperty,but this is not accessible with Request.Form("UniqueID")
View 2 Repliesi like to have unique ids for textboxes and hidden filds .is there any property which will give unique id in asp.net ?
something like
<asp:textbox id="ctr001_1" runat="server" uniqueid="textbox" />