.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

Use of PATINDEX function in select clause With Linq

Posted By:      Posted Date: September 06, 2010    Points: 0   Category :ASP.Net
 
hello       i have an problem to use of PATINDEX function in select clause with Linq.      if anyone have any clue about it then please update me its urgent.Thanks In Advance.


View Complete Post


More Related Resource Links

Function and Variable declaration with out an 'As' clause

  

I get a message - "Function without an 'As' clause" for HMAC_MD5 and "Variable declaration without an 'As' clause" for Key and Value.  But the code works.  But the messages still exists.  Is there a way to fix this to avoid the messages?

Function HMAC_MD5(ByVal Key, ByVal Value)


 


LINQ to XML - Example on how to replicate the SQL "IN" clause in LINQ

  


Can anyone please show me the example as how to replicated the functionality same as SQL "IN" clause using LINQ to XML ?

I have an XML file that I want to filter by passing multiple values to attribute parameters.


Any help will be greately appreciated


Can we use Select clause in Case statement

  
SELECT CASE OT.ItemTypeID WHEN 6 THEN SELECT SUM(ISNULL("Item Cost",0)) FROM SUBTABLE IT WHERE IT.OrderID = OT.OrderID AND IT.ItemTypeID IN(6,11,12) WHEN 7 THEN SELECT SUM(ISNULL("Item Cost",0)) FROM SUBTABLE IT WHERE IT.OrderID = OT.OrderID AND IT.ItemTypeID IN(7,14,15) WHEN 8 THEN SELECT SUM(ISNULL("Item Cost",0)) FROM SUBTABLE IT WHERE IT.OrderID = OT.OrderID AND IT.ItemTypeID = 8 WHEN 9 THEN SELECT SUM(ISNULL("Item Cost",0)) FROM SUBTABLE IT WHERE IT.OrderID = OT.OrderID AND IT.ItemTypeID = 9 WHEN 10 THEN SELECT SUM(ISNULL("Item Cost",0)) FROM SUBTABLE IT WHERE IT.OrderID = OT.OrderID AND IT.ItemTypeID = 10 WHEN 11 THEN SELECT SUM(ISNULL("Item Cost",0)) FROM SUBTABLE IT WHERE IT.OrderID = OT.OrderID AND IT.ItemTypeID IN(6,11,12) WHEN 12 THEN SELECT SUM(ISNULL("Item Cost",0)) FROM SUBTABLE IT WHERE IT.OrderID = OT.OrderID AND IT.ItemTypeID IN(6,11,12) WHEN 14 THEN SELECT SUM(ISNULL("Item Cost",0)) FROM SUBTABLE IT WHERE IT.OrderID = OT.OrderID AND IT.ItemTypeID IN(7,14,15) WHEN 15 THEN SELECT SUM(ISNULL("Item Cost",0)) FROM SUBTABLE IT WHERE IT.OrderID = OT.OrderID AND IT.ItemTypeID IN(7,14,15) WHEN 18 THEN SELECT SUM(ISNULL("Item Cost",0)) FROM SUBTABLE IT WHERE IT.OrderID = OT.OrderID AND IT.ItemTypeID = 18 WHEN 19 THEN SELECT SUM(ISNULL(&qu

Write select query with a paremetrized where clause, and populate database with the retrieved column

  
I want to be able to retrieve column values using the dropdownlist values as parameters then populate the tbPO table with the retreived values. Where and how do I do it. ImportsSystem.Data.OleDb ImportsSystem ImportsSystem.IO Imports ?directcostDataSetTableAdapters PartialClass po_header  Inherits System.Web.UI.Page  Dim cn As OleDbConnection  Dim cmd As OleDbCommand  Dim dr As OleDbDataReader  Dim icount As Integer  Dim str As String  Dim vendor_id As Object   ?  Public Sub btn_click(ByVal sender As Object, ByVal e As System.EventArgs) Handles button1.ClickTry   context.Items.Add(     cmd.CommandType = System.Data.   cmd.CommandText = Dim context As HttpContext = HttpContext.Current"Company_Name", DropDownList3.Text)Dim cn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Users\Owner\Documents\Visual Studio 2010\WebSites\WebSiteJun25\App_Data\directcost.mdb;")Dim cmd As New OleDbCommand()CommandType.Text"insert into tbPO(ponumber, suppliername, ShipTo, basictype, DateNeeded, Purpose,ShippingInstr, ProjId) values(?,?,?,?,?,?,?,?)" cmd.Parameters.AddWithValue( cmd.Parameters.AddWithValue( cmd.Parameters.AddWithValue( cmd.Parameters.AddWithValue( cmd.Parameters.AddWithValue( cmd.Parameters.AddWithValue( cmd.Parameters.AddWithValue( cmd.Parameters.Add

Dynamic where clause - Linq or SPQuery?

  
Has anyone tried to build a dynamic where clause in Linq to Sharepoint (i.e. search criterias are being modified at run time)? I think SPQuery/CAML is a better choice for this one..

use function in select

  
Hi Guys. I used an function in select statement. the select return 3 rows but the function return same value in this 3 rows. may u help me.declare @id_TD int; select @id_TD = 2 select idTo,sum(payCost),dbo.udfMyFunc(@id_TD,idTo) from wallet where idFrom = @id_TD group by idTo order by idTo Best Regards. Morteza 

use function in select

  
Hi Guys. I used an function in select statement. the select return 3 rows but the function return same value in this 3 rows.(the value of first row) may u help me. 01.declare @id_TD int; 02.select @id_TD = 2 03. 04.select idTo,sum(payCost),dbo.udfMyFunc(@id_TD,idTo) from wallet 05.where idFrom = @id_TD 06.group by idTo 07.order by idTo best regards. morteza

Nested SELECT clause in SQL Compact 3.5 SP1

  
In this related question "http://social.msdn.microsoft.com/Forums/en/sqlce/thread/ac926272-2382-4acb-84e3-fc32945c7cea "  I read that SQL Compact 3.5 (SP1) support nested SELECT clause. But my request not work. I have got an error : "There was an error parsing the query. [ Token line number = X,Token line offset = XX,Token in error = select ] " t1 - table 1; t2 - table 2; c1, c2 = columns; select t1.c1, t1.c2, (select count (t2.c1) from t2 where t2.id = t1.id) as count_t from t1 Does SQL Compact 3.5 SP1 support nested SELECT clause in this case?

Insert a "Select User" row in Linq for a dropdown list

  
I'm new to Linq. I have searched and searched the web for a soluion, and can't find anything. I have a Linq query and I want to insert a row ("Select User") to the top before I pass it to the drop down list. I've been trying to use the Union but to now avail (it keeps telling me that my object doesn't support the Union method). My code, prior to attempting to inser a row, is very simple.public SelectList DropDown_Users()        {            var context = new VivarianDataContext();            var query = from t in context.AspnetUsers                        select new { t.UserId, t.LastName };            list = new SelectList(query.AsEnumerable(), "UserId", "LastName");            return list;        }Now I try to insert a row and I found this on the internet and it seems to say that his solution will work. But it is filled with syntax errors. http://magicode.wordpress.com/2009/08/20/inserting-an-item-in-iqueryable-object-using-union-met

a function in the where clause?

  
I have this where clause that I use in so many different places, I wanted to see if it is possible to have it as a function or something so that in the case I have to ever change it, I won't have to go through 50+ queries to change it.   Select * From Table1 Where IsTableAvailable = 1 AND (IsTableBroken = 0 OR IsTableFixed = 1)    

Linq Where Clause (on class that has an [array])

  
Hi There.I have the following query that return the below class type.var results = from r in _returnListOfItem(XMLFile)                       select r;   // Image BluePrint    public class OneImageBluePrint    {        public int UniqueID { get; set; }        public string VirtualFilePath { get; set; }        public string URL { get; set; }        public string Title { get; set; }        public string Subject { get; set; }        public string[] Keywords { get; set; }        public string Author { get; set; }        public string Collection { get; set; }        public string DateAdded { get; set; }        public string Copyright { get; set; }        public int PriceRange { get; set; }        public string LocationPlace { get; set; }        public string LocationCity { get; set; } &nbs

Return linq query in function

  
I try to return a var query from a function, but i'll get the error: Error:Error 41 Cannot implicitly convert type 'System.Collections.Generic.IEnumerable<AnonymousType#1>' to 'System.Collections.Generic.IEnumerable<System.Xml.XmlElement>'. An explicit conversion exists (are you missing a cast?)  Code: protected static IEnumerable<XmlElement> GetModels(byte MerkID) { string rawXML = AutoDisk.GetModels(12345, true, MerkID, "2010", ""); XmlDocument xml = new XmlDocument(); xml.LoadXml(rawXML); var query = from feed in xml.DocumentElement.ChildNodes.Cast<XmlNode>() select new { nModelID = feed.SelectSingleNode("nModelID").InnerText, Modelnaam = feed.SelectSingleNode("Modelnaam").InnerText }; return query; } Whats wrong and how can i make this working ?  

Error: "Select statements included within a function cannot return data to a client"

  
hi all, Not sure if there is an easier way to do this but this is my first ever Function I created so far. I am getting the error: "Select statements included within a function cannot return data to a client" All I am trying to do is ...if the date is NOT passed then apply NULL as the default value and run the SELECT statement. If the date IS NOT null then run a different SELECT statement. CREATE FUNCTION [SchemaTest].[fn_Test] ( @instance as uniqueidentifier ,@date as datetime = null ) RETURNS varchar(8000) AS BEGIN If (@date is null) --@date = null ?? Begin Select * From Uds.RealtimeLogging Where instanceID = @instance End Else Begin Select * From Uds.RealtimeLogging Where instanceID = @instance and [timeStamp] > @date End Return @stepIds END Thank you!JCD

LINQ. select query with OR.

  
Executing 'SELECT' query with 'WHERE' clause which have 'OR' and 'AND' operators give wrong result. Example: Have 4 tables: table1,table21,table22,table3. Relations between it: 'table1' OneToMany 'table21' and 'table22',  'table3' OneToMany 'table21' and 'table22'. tables 'table21' and 'table22' store relations between 'table1' and 'table3'. Example query { from t1 in table1 from t21 in table21 from t22 in table22 from t3 in table3 where (t1.ID==t21.t1ID & t21.t3ID==t3.ID) | (t1.ID==t22.t1ID & t22.t3ID==t3.ID) select t3; } give huge amount duplicate results Although similar query { ( from t1 in table1 from t21 in table21 from t3 in table3 where (t1.ID==t21.t1ID & t21.t3ID==t3.ID) select t3 ).Union( from t1 in table1 from t22 in table22 from t3 in table3 where (t1.ID==t22.t1ID & t22.t3ID==t3.ID) select t3) } give right result (much less duplicate results). In spite of we can filter result with 'DISTINCT' operator - difference in performance between two examples is enormous.

Use ASP Request.QueryString in SQL Select Clause... can I?

  

I want to use the QueryString to specify the column names in the SQL Select expression of <asp:SqlDataSource.

One of several data bases I referr to in the select clause has the columns:

MOSS_Personal.horas_pres,
MOSS_Personal.horas_sep,
MOSS_Personal.horas_pres,
MOSS_Personal.horas_torn

pres, sep, temp, torn are the possible values transmitted by the Query String for the column "Seccion"

Is there an elegant way to bind the column names to the Query String?

Something like MOSS_Personal.horas_<%=Request.QueryString["Seccion"] %>... which is unfortunatly not working!

Martin


Order By clause in RowNumber function slowing down the performance of my query.

  

Hi,

I have a query which has a paging functionality and for which i'm using ROW_NUMBER() function. The order by clause in my rownumber function is dynamic and gets changed all the time when ever the sp is called. It works fine for few columns but for one column which is of datetime datatype, it takes lot of time. Amazing thing is with when i sort by the same column in descending order, the query runs in a sec but ascending order takes lot of time :(.

I tried creating a non clustered index(as i already i have a clustered index on that table) on that datetime column but it did not help me.

Could you please suggest what i can do to improve the performance.

Thanks,

Deepti

 

 

 


Linq to entities: Always select before delete and update?

  

Hi,

With linq to entities, how can I delete and update data inside a database without first selecting the complete entity at first?
The idea behind this is to improve performance.

Thanks!


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend