DataSource Controls :: Modifying WHERE Clause And Change To RegEx?
May 7, 2010[Code]....
modifying WHERE Clause and change to RegEx?
Similar Messages:
Modifying Existing Regex?
Jan 19, 2010 i m using a regex to not allow certain characters, the below code works fine for certain html tags but not for all for i dont want the user to enter html tags for eg if i enter <nitin/> it allows but i dont want this to happen for other html tags it does not allow
!@#$%^&*()+=[]\';,/{}|":<>? or
!@#$%^&*()+=[]\';,/{}|":<>/>?
DataSource Controls :: Using Varibale In The Where Clause?
Apr 21, 2010I am having difficulties using a variable in the "where" clause:
declare @shift_started as datetime
set @shift_started = (SELECT *
FROM OPENQUERY(ADS_RGWP_SERVER, 'SELECT MAX(shift_started) as shift
FROM salestkt AS STK
WHERE NOT EXISTS(SELECT *
FROM SHFTDATE AS SD
WHERE SD.shift_started = STK.shift_started)'))
SELECT *
FROM OPENQUERY(ADS_RGWP_SERVER, ' sum(case when customer_type = ''Inter-Company'' then qty_shipped_today else 0 end) as intercompany_qty,
sum(case when customer_type = ''Charge'' then qty_shipped_today else 0 end) as outside_qty
FROM salestkt
WHERE shift_started ='" & @shift_started & "' ''')
Getting error:
Incorrect syntax near ' & @shift_started & '.
DataSource Controls :: Add Parameter To IN Clause In SQL?
Jan 28, 2010i am developing an application using asp.net and backend server is SQL SERVER 2005.
in my application i have 12 regions. from that 12 regions user will select any of them.
if user select 1,2,3 then i have to pass this string to IN clause
for that i have storedproc like
create procedure sp_updateDistributorContractforAllRegions (
@unitprice float,
@region varchar(50)
)
update employee set UnitPrice=@unitprice where regionid in (@region)
end
GO
here regionid datatype in employee table is INT.
from code behind i am adding the parameter as 1,2,3.when i run the query it gives the error as
Conversion failed when converting the varchar value '1,2,3' to data type int.
DataSource Controls :: Insert Statement And Where Clause?
Apr 7, 2010I am trying to do an insert statement to a table from classic ASP.I tried the below:
[Code]....
But, I am getting the error as: Incorrect syntax near the keyword 'where'.How to insert data, using a where clause in the above scenario?
DataSource Controls :: SqlDataSource - Parameter For IN() Clause
Apr 30, 2010I have an SqlDataSource query that should use an input parameter for multiple integer values, like:
select * from table1 where TableID IN (1,2,3,4,5)
->
select * from table1 where TableID IN (@IDValues)
How do I do that ? Default parameter settings won't work, returning "invalid integer value" . I suppose that parameter should be passed as some kind of array that SQL recognizes as multiple integer values , but what's the correct way of setting this ?
DataSource Controls :: How To Pass Session UserName In Where Clause In Sql
Feb 28, 2010SELECT DISTINCT TblSections.SectionID, TblSections.Description
FROM TblSections INNER JOIN
UMG.Users ON TblSections.SectionID = UMG.Users.SectionID
WHERE (TblSections.Description IS NOT NULL) AND (dbo.Users.LoginName = [@Session(UserName)])
ORDER BY TblSections.Description
I have problem in using Session name in the above BOLD WHERE clause.
DataSource Controls :: EntityDataSource Filtering / ESQL Where Clause?
Feb 28, 2010I have a GridView that's currently bound to an ObjectDataSource. I would like to see if it's possible to instead bind it to an EntityDataSource. However, I need to be able to apply custom filters to it.
One of the filters corresponds to a bit / boolean property in the database / EntityDataModel. It has 3 possible selections:
[Code]....
[code]....
How can I accomplish the same thing in an eSQL Where clause? There is no COALESCE function, is there an equivalent?
DataSource Controls :: How To Update Dynamically A SQLdatasource With A WHERE Clause
Mar 10, 2011I've already spent hours in searching through the forum to be able to do the following:I have a SQL datasource defined with a checkbox in it. Purpose is to update one column (userid) behind the table for only that row when the checkbox is selected.This is the code I'm currently having:
[Code]....
DataSource Controls :: Linq - Update Statement Where Clause?
May 25, 2010I am using Linq to SQL. Tables have timestamp columns and I am using regular Linq methodology in ASP.NET MVC.I do use detached entities and always try to do updates without first querying the database for the original entity. To update an entity I use context.Attach(entity, true) followed by context.SubmitChanges() and all is fine. The sql statement that gets executed looks like:
[Code]...
DataSource Controls :: Use Stored Procedures From LINQ With A Using Clause ?
May 25, 2010Ive created a new LINQ To SQL class and dragged several tables across from my server, in my code I access them like this
[Code]....this is all ok, however, I have several stored procedures that I want to use as well, but when I drag the stored procedures across I get a compilatiopn error
Error 60 'DB_BL.DB_BLDataContext': type used in a using statement must be implicitly convertible to 'System.IDisposable'
how do I use stored procedures from LINQ with a using clause ?
DataSource Controls :: Select Distinct With Where Clause Don't Work?
May 2, 2010I'm using asp.net login on a SQL Database.
I have 12 users in my User tabel - one of the user I don't want to have in my select (the user is an admin).
I tried this:
[Code]....
I also tried:
WHERE (dbo.aspnet_Roles.RoleName <> 'Administrators')
Both time it took the user into the table....
If I instead try this
WHERE (dbo.aspnet_Roles.RoleName = 'Administrators')
I get only one row (as expected).
What is wrong with the above sql statement - why can't I get 11 users and not them all (12 users)?
DataSource Controls :: Modifying The Last Record Of A Filtered SELECT
Mar 4, 2011I have a SQL data source control defined to filter data from a SQL database, sorted according to the date time in descending order. When i try and update a field of the latest record, the entire column, related to the field of the filtered search gets modified. I want to only update a field of the last record i.e. the last entry of the filtered data. How can i achieve it?
View 5 RepliesDataSource Controls :: List Duplicate Records And Group By Clause?
May 27, 2010I have some duplication that I need to clean up. I wrote a SQL query that is supposed to return duplicate customers who are located in the same city and zipcode.
I have 2 questions regarding it:
1. Is the query syntax correct to find duplicate records by same city and zipcode, data is being returned but it just returns the same customer a few times?
2. I only need to do the GROUP BY clause for Fullname and City however it gives an error when the other columns are left out. The error is Address, State and Zip not being in the aggregate function or in the group by clause.
Adding all the remaining columns to the GROUP BY clause works.
Query is as below:
[code].....
DataSource Controls :: LINQ - Adding / Modifying Columns In MS SQL Table?
Apr 19, 2010I have just started using LINQ with VS2008. I have added extra columns to my table, saved the changes, but class ClassName.Designer.CS didn't get updated. What do I have to do to updated the class? Do I have to do it manually, or is there a way to automatically synchronize tables and ClassName.Designer.CS?
View 2 RepliesDataSource Controls :: Modifying The SqlDataSource SelectCommand Prior To Loading A Page?
Sep 28, 2010I have a SqlDataSource setup in the markup on my page. After some new requirements, I am trying to find a way to modify the SelectCommand before the data is filled for the first time. The SelectCommand below will now be used by default since we'll always have the first param. I am faced with a need to modify the SelectCommand though, adding a second session parameter along with it. I tried to override the OnInit method but it didn't seem to help...it still used the default query. Is there a best way to accomplish this? Here is the section of markup I am referring to:
[code]....
DataSource Controls :: Clause Criteria Eliminating Records In Outer Join Query?
Feb 15, 2010I know I'm missing something here but I can't figure out what it is. I've got a query joining three tables....accounts, payments, and a table linking the two (there is a M:M relationship).I'm trying to pull a list of all accounts in the account table that have a payment that needs to be resequenced, and also the maximum payment priority if there are any payments that haven't been fully paid. If all payments HAVE been fully paid, I want to return a 0.
It's that last bit of logic that I can't get right. If I include that in the where clause, I get only the accounts that have a payment that hasn't been fully paid. If I take it out, I get all the accounts I get, but I get the highest payment priority whether or not the payment has been fully met.
Here is the query....how do I include the where clause criteria but still include all accounts?
select distinct
bat.acct_id,
isnull(max(isnull(crt.pymt_priority, 0)), 0)[code].....
DataSource Controls :: How To Wrap The DataContext's SubmitChanges Within A TransactionScope When Modifying Multiple Tables
Feb 20, 2010I am confused about why I would need to wrap the DataContext's SubmitChanges within a transactionScope when modifying multiple tables. I was under the impression that the DataContext would track these changes and would therefore create its own transaction if need be.
In other words, if a change was made to update table A, B and C or if I made changes to 10 out of 20 items in a collection of rows, that the datacontext would track these changes and create its own transaction. If that is correct then why have I seen examples that wrapped these types of updates in a TransactionScope?
C# - Modifying The Query String On Dropdown Index Change In Code Behind?
Mar 1, 2011I have a drop down box that is in the edit template of a formview. I want to be able to add a parrameter to the querystring when the drop down selected index is changed.
I tried
Request.QueryString.Add("tabindex", (sender as WebControl).TabIndex.ToString());
But I got an exception saying the collection is readonly.
Here is my markup
<icms_ref:ReferenceDropDownList ReferenceDataManagerProviderName="ROCSQLReferenceDataProvider"
ID="ddlEnquirerHearType" TabIndex="2" runat="server" ReferenceSetName="EnquiryHearType"
AutoPostBack="true" OnSelectedIndexChanged="EnquirerHearType_SelectedIndexChanged"
DataTextField="ShortName" DataValueField="ReferenceId" />
and here is my code behind.
protected void EnquirerHearType_SelectedIndexChanged(object sender, EventArgs e)
{
var pnlEnquiryHearTypeOther = fvEnquiryInformation.FindControl("pnlEnquiryHearTypeOther") as Panel;
pnlEnquiryHearTypeOther.Visible = DdlEnquirerHearType.SelectedValue == ((int)EnquiryHearType.Other).ToString();
ResetTextBox("txtEnquiryHearTypeOther", fvEnquiryInformation);
Request.QueryString.Add("tabindex", (sender as WebControl).TabIndex.ToString());
}
DataSource Controls :: LINQ To Entities Sub - Query - Doesn't Support The "IN" Clause
Apr 7, 2010I'm having trouble writing what should be a simple sub-query using LINQ to Entities. I have two tables: Customers and Orders that have a relation on the CustID field. Not all Customers have a record in the Orders table, while some have mutiple records. In traditional SQL, you could write the query like this: SELECT * FROM Orders where CustID IN (SELECT CustID FROM Customers) I know this could be done as a JOIN in both SQL and L2E, but my actual query is more complex (about 8-9 joins), so I am hoping to find a L2E sub-query equivalent. Something like this:
[Code]....
I know LINQ to Entities does not support the " IN " clause, so I am looking for something that will work in its place.
DataSource Controls :: LinqDataSource Paging When Using "where" Clause?
Mar 4, 2010Here is my LinqDataSource
[Code]....
Here is a button inside a listview that is using the LinqDataSource and also has a pager:
[Code]....
And here is the Code Behind that is triggered by the linkbutton:
[Code]....
It almost works. When i click it it loads and shows the current page of objects that have dates that are higher then todays date. Which is what i want. But as soon as you use the pager to go back or forward it reverts to the default, which is ALL articles, sorted by ID. How can i make the "where" selection stick through the paging?
Change Password Control RegEx Validating Oddly In IE 7 Only?
Mar 25, 2010I'm using the Asp.net change password control in my application and all seems to be find and dandy until a user tells me she has a problem meeting the strength requirements when changing her password. Looking into this, she is using IE 7 and no matter what she puts in, the validation fails (and ONLY in IE 7. Firefox, IE 8, Chrome etc. all work as expected). Here is the regex i'm using:
^(?=.*d)(?=.*[a-z])(?=.*[A-Z])(?!.*s).{5,15}$
I've tried out a few others that I've found throughout this site and others that folks seem to be using with no issues and I come across the same problem.It seems that which ever pattern I enter in last (digit, upper or lower alpha) is the one that is expected to be repeated min of 5 times. For example:
Hello1 (doesn't work)
11111Hello (doesn't work)
Hello11111 (works)
Again, this is ONLY in IE 7.
Using RegEx With LINQ - Insert A Value Into The Regex?
Feb 19, 2010I'm having a little trouble with using regex in linq. I want to be able to perform a search on values in my database. The goal is to insert a value into the regex and then use that to search a column in a table in my database for that term. I want it to work so that it gets all exact matches and also returns matches in which the search term is a substring of the term in the column.
I was trying to follow this tutorial on msdn, but it doesn't quite fit perfectly with my problem:
[URL]
Code:
[code]....
DataSource Controls :: Change The Primary Key Value?
Jan 4, 2010Let's say I have a table that holds information about books, with a column called bookid as a primary key with auto increment of 1. When I create a couple of records, it assigns 1 to the first row and 2 to the second row for the bookid column. If I delete the second row and enter another row, even though table now only has 2 records, the primary key column says 1 and 3 for their bookids. Is it possible to change back the bookid of the second record from 3 to 2 or is it just server assigned and can't be changed.
View 9 RepliesDataSource Controls :: Change OldValuesParameterFormatString?
Apr 8, 2010By default the OldValuesParameterFormatString sets to original_{0}.I would like it to set to {0}.Is this possible?
View 4 Replies