DataSource Controls :: How To Get A String For Comparison Purposes
Jan 19, 2010
I have a table with userID's stored in it and I want to SELECT a user out of that table to see if it's the current logged in user. I'm using this as logic to determine what action a button click will do. For example the button click will do something like this:
[Code]....
My broblem is getting the UserName from my table of data. I've tried it like this:[Code]....
But when I try debugging it shows that CurrentUser's value = Nothing
My UserNames (ToUser) contain letters and numbers (nvarchar(30)).
View 10 Replies
Similar Messages:
Feb 8, 2010
comparing integer values which are actually in string (varchar(9)) right now...I'm trying to do the following in a stored procedure..
SET @MinProjectYear = SELECT ProjYear FROM P_A WHERE ID = @ID
SET @MaxProjectYear = SELECT ProjYear FROM P_A WHERE UserId = @UserID AND...
IF EXISTS(SELECT 1 FROM P_A WHERE MinProjectYear <= MaxProjectYear)
return true
The MinProjectYear and MaxProjectYear are varchar(9) values stored as "2007-2008", "2009-2010", etc.
How do I split and compare the years?? i.e. check if 2007-2008 <= 2009-2010 ??
View 6 Replies
May 24, 2010
I have a bit of code in a clickevent handler like this:-
Dim products = From p In db.Products where p.product_name = "Tool" Select New With {p.Product_ID,p.Product_name}
Gridview1.Datasource = products
GridView1.Databind()
But causes error=SQL Server does not handle comparison of NText, Text, Xml, or Image data types?
where product_name field is set as type text
View 1 Replies
Dec 13, 2010
Is there a better way to do this than to check for Exception string?
I would rather have this catch-all error handled on the page, but for SOAP exceptions (web-service calls) I need to log the details of the actual exception that occured on the server, not the client.
The ".Detail.InnerText" property isn't in a generic exception, and can only be gotten after casting a generic exception to a SOAP exception.
[Code]....
I would think there is a way to get at the underlying Exception's type without using string comparison.
View 3 Replies
Mar 23, 2011
I am getting this warning:Possible unintended reference comparison; to get a value comparison, cast the left hand side to type 'string'I tried this:
if (Convert.ToString(Session["message"]) == SESSIONTIMEOUT)
or
if (Session["message"].ToString() == SESSIONTIMEOUT)
But I'm still getting the above message.
View 1 Replies
Mar 11, 2011
how to get the ID of a label inside a Repeater for jquery purposes? I've tried clientID, but doesn't work because it's inside the repeater ofc
View 1 Replies
Jul 7, 2010
I'm concatenating a string in codebehind to use in a sql select statement.
in aspx
<asp:Label ID="LabelHidden" runat="server" Visible="False"></asp:Label>
SelectCommand="SELECT * FROM [Data] WHERE [ActivityName] IN (@ActivityName) AND ([ID] = @ID)"
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList_Employees" Name="ID"
PropertyName="SelectedValue" Type="Int32" />
<asp:ControlParameter ControlID="LabelHidden" Name="ActivityName"
Type="String" />
</SelectParameters>
in codebehind
foreach (ListItem li in ListBox_Activities.Items)
{
if (li.Selected)
{
queryBuilder += li + "', ";
}
queryBuilder = queryBuilder.Substring(0, queryBuilder.Length - 1);
LabelHidden.Text = queryBuilder;
When i run the code it comes up blank. I did a query trace and it seems to be running as
exec sp_executesql N'SELECT * FROM [Data] WHERE [ActivityName] IN (@ActivityName) AND ([ID] = @ID)',N'@EmployeeID int,@ActivityName nvarchar(50)',@EmployeeID=4,@ActivityName=N'Production Technical Support'', Tools Development'','
with exta "'s
How can i format the queryBuilder string correctly in my code?
View 3 Replies
May 20, 2010
I have several web forms which use a GridView linked to a DataSource control which is defined at design time as follows:
<cc1:pgsqldatasource
id="dsStates"
runat="server"
connectionstring="<%$ ConnectionStrings:PgSqlConnection %>"
oldvaluesparameterformatstring="Original_{0}"
providername="<%$ ConnectionStrings:PgSqlConnection.ProviderName %>" >
</cc1:pgsqldatasource>
As you can see, the connectionstring parameter is defined to a specific connection string name and I need to be able to set such a parameter to a different value, for example, to a session variable content.
View 1 Replies
Jul 3, 2010
I am having problems in deploying my first project in asp.net and for about 3 days still I haven't deploy yet my first web app. First, I need to deploy my web in windows xp for demonstration purposes before deploying it in the dedicated server. Is there a best tutorial that I can follow in order for me to easily deploy my first web app? I feel so disappointed with it because, it seems that it is not easy to deploy a web app that is made of ASP.NET.
View 3 Replies
Jan 30, 2010
In my web application I want to log certain user interactions etc, like "User ABC joined Group XYZ" Therefore I want to set up a logging mechanism that logs into a Mssql database. I'm now trying to find a good database design to achieve flexibility.
First of all, I don't want to log strings like "User ABC joined Group XYZ". I'd like to separate the content "ABC" and "XYZ" from the template. So I'm looking for a templated logging database.
Something like this:
table: UserLog
IDLog int primary key [code]......
I think this database structure would give me enough flexibility to add/remove/edit specific log types (like 'User ABC did something else'). For example I might want to add some information to a specific log entry for future entries. Therefore I create a new UserLogTemplate that references the same UserLogType. That is how I would achieve downward compatibility.
Is that a database design that will work?
View 2 Replies
Mar 26, 2010
When a user clicks a button to print a page from a website, I want to apply a different css file to the masterpage to get a different setting for print purposes. How do I code the change to a different css style to the masterpage. Do I change the css style or do I apply a different masterpage with the css style ? ALso, how do I code for the print the page?
View 4 Replies
Sep 4, 2012
<script type="text/javascript">
function configureDropDownLists(ddl_religion,ddl_caste) {
var Hindu = new Array('Ahom', 'Brahmin-other', 'Intercaste','Kalita','Kayastha','kshatriya','Manipuri','Maratha','Nepali','Rajbonshi','Rajput','SC','ST','Vishwakarma','Other');
var Muslim = new Array('Ansari', 'Arain', 'Awan','Bohra','Dekkani','Dudekula','Jat','Malik','Qureshi','Khoja','Memon','Mughal','Pathan','Mapila','Shafi','Sheikh','Syed','Siddiqui','Other');
[Code] ....
Everything is working fine and i am able to update the second dropdownlist based on the item selected in the first dropdownlist.
The problem is that i am not able to capture the data to a cs file and upload then it to database and i am getting this error:
For security purposes, this feature verifies that arguments to postback or callback events originate from the server control that originally rendered them.
If the data is valid and expected, use the ClientScriptManager.RegisterForEventValidation method in order to register the postback or callback data for validation
View 1 Replies
Mar 6, 2010
Trying to add another 2nd dropdownlist to Query String... Below This Query String works Perfectly:
Query = String.Format("SELECT {0} FROM {1} WHERE NACategory = '{2}' ORDER BY {3}", PrimaryKeyColumn, TableName, DDLCategory.SelectedItem.Text, SetSorting())
I've tried to add a 2nd DDLSubCategory.SelectedItem.Text - But its throwing and error message.
Exception of type System.StackOverflowException was thrown.
Query = String.Format("SELECT {0} FROM {1} WHERE NACategory = '{2}' AND NASubCategory = '{3}' ORDER BY {4}", PrimaryKeyColumn, TableName, DDLCategory.SelectedItem.Text,
DDLSubCategory.SelectedItem.Text, SetSorting())
Can Someone take a look I'm not sure how to write (add) 2nd DropdownList (DDLSubCategory.SelectedItem.Text)
View 6 Replies
Sep 13, 2010
I am thinking of putting a drop down list to choose a couple of options. Depending on what is selected I want to then specify a specific connection string. I use the ConnectionString="<%$ ConnectionStrings:SomeConnectionString %>" format. How can I handle this in the .aspx page?
View 4 Replies
Sep 12, 2010
I need to set the SQLDataSource connection string on the fly. Right now, this is what I have:
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
OnSelecting="SqlDataSource1_Selecting"
SelectCommand= (working select stmt here)</asp:SqlDataSource>
Then, I have this:
[code]....
View 4 Replies
Apr 25, 2010
I have tried to break the below string like
DECLARE
@strFilterCond Varchar(Max)
set @strFilterCond=''
SET @strFilterCond=' ISNULL(Cast(EmpID as Varchar(1500)),''Undefined'') = ''000012946'' AND ISNULL(Cast(EmpName
as Varchar(1500)),''Undefined'') = ''Abosch, Karen'' AND ISNULL(Cast(tblEmployees.JobLookupID as Varchar(1500)),''Undefined'') = ''Undefined'' '
The Result String are like:
ISNULL(Cast(EmpID as Varchar(1500)),''Undefined'')
= ''000012946''
ISNULL(Cast(EmpName as Varchar(1500)),''Undefined'')
= ''Abosch, Karen''
ISNULL(Cast(tblEmployees.JobLookupID as Varchar(1500)),''Undefined'')
= ''Undefined''
I am unable to Break the string. break this string in sp. I do not know how to loop through the string.
View 2 Replies
Jun 16, 2010
I am using CLR project in my website.I have used bulk insert in there.I am not able to use context connection in the procedure.Is there any way to get the connection string from web.configor from context connection.
View 5 Replies
May 15, 2010
i work with sql database i want to connect to sql server i dont have sql manegment who could i c the connection string the palce of the sql that wen i write these comand sqlconnection con = new sqlconnection("the connection string")
View 4 Replies
Feb 10, 2010
I am trying to insert some string values into database.
The problem here is that, the string is truncated without warning..
Here is my vb.net code
[Code]....
And here is how I declared the varible in stored procedure
[Code]....
And If I insert "myCode01234567890" then it's truncated without warning at all.
How can I let it throw an exception rather then truncate the string without any warnings ?
View 9 Replies
Feb 16, 2010
Datecol is a datetime in a sql table.
q="select convert(char(8),datecol1,112) from tblone where datecol2 is null"
is what I use for my query string for sqlcommand(). I'm getting the error "a field or property datecol1 could not be found in the datasource". Without the convert, the query is ok.
View 2 Replies
Mar 16, 2010
ive an access database with a table, in this table there is only one data column and one counter column (id, pet) i want to draw random a record. Reading on the web i came with this SQL solution: "SELECT TOP 1 tab_pets.pet FROM tab_pets ORDER BY Rnd(id)" and it works perfectly.
The problem is while using this statement in my code behind (in a class) as it draw always the same record, hence generates the same random each time. I though that the access Rnd() function would be handled by the access driver and not by my application, how can i resolve this?
View 4 Replies
Apr 7, 2010
I have an app that connects to only one db for all of the data that the app has access to. My connection string is in the Web.Config file. In each of my DAL classes I have the following code that gets the connection string from the Config file. This works with no issues but I thought there might be a better way of doing this that I don't know.
If I wanted to change the name of the connection string that any of the DAL classes would use then I would have to change the name of the connection string in each of the files. I thought about creating a new class that would hold this then I could just instantiate a new instance of the class to access this with each of the DAL classes that needs access to it. Then if I needed to change the name of the connection string then it would only be in one place. I suspect there is an even better way of doing this that i don't know about.
[Code]....
View 3 Replies
Feb 2, 2010
Having a bit of trouble with a logon page I created using text boxes for a User ID number and a password.
Basically, my original design was to have a textbox for a username and one for a password. Due to some complications, I changed the username to the User ID number input and as such, the input credentials went from being a string to an integer. I've changed this successfully, however when I now type in a string, rather than the integer it requires, the page fails.
how to edit this so if a user enters a string value instead of a numeric value, an error message can show up on a label instead of the whole project coming to a halt because of an error?
Here's the code I have for the page so far, which does the job (apart from this problem!)
using System;
using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Data.SqlTypes;
[Code]....
View 2 Replies
Jun 9, 2010
I'm using the following code to select a number of fields from a Table, this works perfectly, however I actually want to select from a stored procedure not a table and im not sure what the correct syntax is,
[Code]....
View 6 Replies
Mar 7, 2010
i try to return string value from the function i wrote for getting string value from the table for that i havecommon stored procedure
public string getdata(string str)
{
string datanew;
[code]...
View 2 Replies
