I am in a situation that i cant solvecos i am new to VB.net. I have a page with both a Detail and Grid view. The Detalview does the inserting to display it on the grid view. My table(Using SQL Server) has 3 field Username, Month and Allocation. I want to give an allocation to a user, but if the user already has one for that month, i want it to cancel.
View 2 RepliesI have detailed view and a grid view, the DetailedView does the inserting into the Grid view. On my table( Ussing SQL Server), i have a username and year and allocation. What do i do so that when an allocation is given to a user for a year that already exit, it refuses.
View 9 Replieswhen click save button,I want to save the textbox values to database table..If the record is already available then just update that value... I have the code for insert and update..but i don't know how to check the already existing record..I need ,check existing record using only auto generated id
View 2 Replieshow can i check if a value exist in my web config using this method?
public
static
bool IsDomain()
{
Uri s =
HttpContext.Current.Request.Url;
return
true;
}
webconfig:
<
add
key="DomainName"
value=http://test-domain></add>
i need to check if some parameter exist in Request.Params any one know how to check that? dont use request.params["para"] != or "" i am not try to check if value exist, i need to check if the parameter himself exist before the checking if his not null or empty.
View 2 RepliesI'm trying to make checkboxes check if they exist in a table.
What I'm initially trying to do is to list the values is a table e.g. product types, and then if a product has those types assigned to it mark the check box as checked. e.g.
Products Table
Prod No Prod Name
1 Silver Bag
2 Black Bag
3 Red Hat
Product_Types Table
Prod_Type_No Prod_Type_Name
1 Bag
2 Leather
3 Hat
Associated_Product_Types
Prod_No Prod_Type_No
1 1
1 2
2 1
3 3
So When I select product 1 (Silver Bag) it shows 3 check boxes for the product types and prod type 1 and 2 are checked as they exist in the Associated_Product_Types
My problem is I cant figure out how to mark them as checked based on the values in that table.
System.ArgumentOutOfRangeException: 'DropDownList' has a SelectedValue which is invalid because it does not exist in the list of items.this question has been for a long time ago but seem no actual answer for it except for catching the exception.I don't want just catch error instead of check first whether the value exist in drop down list. My scenario was different from the other. my data source is bind to a datatable, all is in hard code.
View 14 RepliesBefore a subscription to a newsletter and the record will be inserted, i'd like to check if the record already exist ina sql-server database. This what i've got as dusfar
adres = TxtEmail.Text
DBConn.Open()
If adres <> "" Then
Try
DBCmd = New SqlCommand("SELECT COUNT(*) FROM TBL_Subscribers WHERE email = @adres)", DBConn)
''Add
DBCmd.Parameters.Add("@Email", SqlDbType.NVarChar).Value = adres
DBCmd.ExecuteScalar()
DBAdap = New SqlDataAdapter("SELECT * FROM TBL_Subscribers ORDER BY ActivateDate", DBConn)
DBAdap.Fill(DS)
Catch exp As Exception
Response.Write(exp)
End Try
End if
For MS Access, how to check if the particular field data exist?
View 4 Repliesstring jSFile = ResolveUrl("~/MyProject/JavaScripts/dir/test.js");
if (!System.IO.File.Exists(jSFile))
{
...
}
This code doesn't work and I guess it's the jSFile that doesn't work well with the IO.File.Exists but I know the jSFile has a valid path because when I use few line later
Page.ClientScript.RegisterClientScriptInclude("myfile",jSFile);
it does attach the JavaScript file to the ASPX and all work fine.
I've written a singleton class that exposes the web.config properties in a nice get property kind of way.
I want a Load method to parse the data in the config and set the public properties, and I want to throw exceptions (so they are logged in the EventLog) when a configuration key is missing or can't be parsed.
I tried placing the Load() code in Application_Start of the global.asax but then remembered this will only be run once, or until the application restarts.
Where is the best place to put code that you need to run 'everytime' your site is started/run by the user? I basically want the website to stop functioning if certain config properties cannot be loaded.
I am not using any database for data source.I can enter the some value in text box and the entered value is automatically added in the gridview.How can i validate not adding same item numbers in gridview.And i also calculated grand total for amount column.If i remove any records means how to recalculate current total.Any one can tell solution for this issue.I am waiting for reply ASAP.
View 2 RepliesHow to check username is exist in database or not without postback the page...
View 1 RepliesI am using two checkbox in gridview.I want check only one check box at a time from two checkbox user should not able to check two check box at a time.I m using group of check boxes and i want to allow user to check only one check box at a time like radio button properties GroupName.is this possible to make check box work like radio button groupname?
View 1 RepliesI have .Net web application which connects to Oracle 10g database. I want to check for space availibility before creating Indexes. Also if space is not sufficient then I would like to send an Email message to admin. How to do that from .Net web application?
View 2 RepliesI want to show user already exist erroe in user create wizard but user create wizard is disaply in pop up so after click create user button ot shows error user already exist and pop got closed how i can show error on popup or how can skip postback so clicking on button it will not close popup???
View 6 Repliesi want to allow user to select only one row at a time in gridview by selecting a chechkbox.
View 2 RepliesThere are 10 check boxes in one page. How to code to allow user only check one?
View 1 RepliesThere are 10 check boxes in one page. How to code to allow user only check one?
View 2 RepliesI have developed an asp.net application ... I have a textbox where user will enter is name ... I need to check if the name is already exist in the database table column when ever user enter their name with out post back . If user exist mean it should show a msg user already exist .....
View 6 RepliesI have a GridView on a page for maintainance of the database (mdf). Under this GridView1 I have a FormView1 where I use the ItemInsertTemplate to Insert new rows in my database (which shows the data in GridView1). The first textbox (BIDTextBox) i have on this template, contains text which identify a person. I would like to have a routine which checks if the same value that is entered in the BIDTextBox allready exists in the database. This routine should be fired upon leaving the control BIDTextBox.
I have tried with some stored procedure in my database, but that dosn't seem to do the trick. The most logical to me seems to do a loop thru my table "Ansatte" in my database using sql, selecting any occurence from the field "BID" in my table "Ansatte" that is simillar to the text entered in the BIDTextBox.
i want to check my collection so i can add a new customer as long as the username does not exist in the collection i do not want 2 customers to be able to have the same username.
i have been trying many different things to try to get this to work but i am not exactly sure what i should be doing I have a aspforum and collection C# class of the list.
here is some things that i have tried
CustomerExists() i also have a collection of List<Customers>
//HERE IS MY EXISTS METHOD
public static Boolean IfCustomerExists(string login) {
List<Customer> theGuy = Collections.Customers;
bool exist = false;
foreach (Customer customer in theGuy)
[Code]....
As following code condition statement show that transfer data from Location A to Location B. May i know how if to update the exist data in Location B ?.Example,from Location A Qty is 10 , transfer Qty to Location B is 5, then Location A is 5. So,How if transfer again from location A qty 2 to Location B. then update the location b qty.
USE [CIMProRPT01]
GO
/****** Object: StoredProcedure [dbo].[MMSLocTrans_InsertOrUpdate] Script Date: 01/03/2014 13:46:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
[code]....
I am creating a project in which i want to display my web page in full screen & Does not allow the end user to ext the full screen until he/she press the button. I google/bing but i dint get any help full material. Even i use this code
[Code]....
i want to redirect all my users to a common page if that page do not exist from the security point
that ie. for e.g if he tries to vist
[Code]....
i want he should be redirect to one Page requested not found
do i need to maintain database too ..?if i want to keep check on who all user's are visiting that page