Browse by Tags

Home ›

All Tags » query » Linq (RSS)

Linq dynamic select query, occur injection

Hi, Im making an c# asp.net webservice and using Linq for my DAL layer. I have an method with some parameters. I would like to use the parameter values in an SELECT query after the WHERE. Something like this: public void GetItems(String filter) { string sql = "SELECT * FROM ConfigurationItems WHERE...

Posted to Data Access and ObjectDataSource Control (Forum) by khalidelmeknesi on 05-28-2009, 12:00 AM
Filed under: Query, Dynamic, Linq, Select
Complicated LINQ query

I'm new to LINQ and working on converting some of my ADO.Net code over to LINQ. I have a fairly complicated query that retrives values from a table using wildcards. The wierd part is the wildcards are in the data, and I need to match a value. e.g.: Value to Match: 12345 Values in table 1&345...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by BluFire739 on 11-07-2008, 12:00 AM
Filed under: query, complex, wild cards, Linq
Dynamic LINQ Objects

I have spent quite some time Googling and looking around for anything relatively related to my subject, and have found very little. My scenario is this: I want to use LINQ in a web application, BUT I need the ability to dynamically create a Data Context, I believe it's called? The .dbml file that...

Posted to Data Access and ObjectDataSource Control (Forum) by JMoore5268 on 09-17-2008, 12:00 AM
Filed under: Query, sql, Visual Studio 2008, "Linq to Sql" LinqDataSource, .NET 3.5 SP1, asp.NET 3.5, asp.net 3.5 Linq, C#, data Acces, Data Access, Database, dynamic LINQ, LINQ in Action, Linq query, LINQ SQL Dynamic predicate builder, Linq to SQL, LinqDataSource, database connection, Linq, linq ado, LINQ databasecontext dbml, LINQ databasecontext dbml System, 3.5, Data Access connections, Data Access Application block, linq databasecontext
datakey, gridview, databinding

hi all. i use a code like this. protected void GridView1_RowDataBound( object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType .DataRow) { ListBox List1 = ( ListBox )e.Row.FindControl( "ListBox1" ); MyDataContext db = new MyDataContext (); var CustomerShopping = from...

Posted to Data Presentation Controls (Forum) by ashkant on 09-11-2008, 12:00 AM
Filed under: Query, databound, datakey, Linq, Gridview
Re: Programmatically set the orderby and ascending/descending clause in a Linq statement

While trying to sort columns in a Silverlight DataGrid using Linq , I ended up on Scott's page : http://weblogs.asp.net/scottgu/archive/2008/01/07/dynamic-linq-part-1-using-the-linq-dynamic-query-library.aspx and downloaded the CSharpSamples.zip file. I then added the Dynamic.cs class (located in...

Posted to Data Access and ObjectDataSource Control (Forum) by oudoulj on 08-29-2008, 12:00 AM
Filed under: orderby dynamic parameterize programmatic, query, dynamic, LINQ to Sql, LINQ
how we get the ":" in xlink please help me

my Xml file code is and my link code is this XElement xelement = XElement.Load("d:/CaseStudyBL.xmi"); XElement xmlDoc = XElement.Parse(xelement.ToString()); var tutorials = from tutorial in xelement.Descendants("ownedMember") // select new // { // Abc = (string)tutorial.Attribute...

Posted to XML and XmlDataSource Control (Forum) by usmanhabeeb on 06-20-2008, 12:00 AM
Filed under: Orcas, query, Blinq LINQ auto-generate web forms, blinq webforms auto-generate, dynamic, linq in web site, LINQ to Sql, Blinq, LINQ