79 Topics
i need to show mesage box that show "RECORED ALreay exist ind datatabse " uisng linq and silverlight have single on code .xaml fiel code is here [CODE] private void createSurvey_Click(object sender, RoutedEventArgs e) { Service3Client client = new Service3Client(); //Int32 i; client.CheckSurveyExistAsync(this.Title.Text, this.SurveyQuestion.Text, this.Surveyoption1.Text, this.Surveyoption2.Text, this.Surveyoption3.Text); }[/CODE] and service3.cs …
I have a stored procedure that I am using through LINQ to SQL as a data source for a gridview. Rather than editing my stored procedure is there a way to use Linq to search the result set? [code] Dim DC As New DistributionDataContext GridView1.DataSource = (DC.usp_GetInvestorData(GridView1.PageIndex, GridView1.PageSize, "InvestorName", Session("sort"))) …
i have a employee class and a userlogin class in the mdf file. there is an foreign key between the employee and the userlogin tables. the EID in the Employee class is in the uesrlogin class which is a foreign key in the userlogin. but when i try to access …
Hi, I am working on a application which is base on ADO.NET Entity Data Model. I want to insert Current Timestamp of Server while insertion and updation using LINQ query. Fox Example [CODE]INSERT INTO table SET time_field=CURRENT_TIMESTAMP() WHERE id=?"[/CODE] I need to execute CURRENT_TIMESTAMP() in LINQ Query because I need …
I have this list of object: [CODE]public List<XHTMLError> Report = new List<XHTMLError>(); [/CODE] Which is defined this way: [CODE] public class XHTMLError { public List<string> Errors = new List<string>(); private string _errorType; public string ErrorType { get { return _errorType; } set { _errorType = value; } } }[/CODE] I …
Ok im trying to get my head around this and i could do with some input from someone else, brains about ready to shut up shop! So im looking at LINQ to try and pull off records where a confirmed field is equal to null. The confirmed field is a …
Dear All, I am having a login page where I need to enter the login name and password for a user, which I need to verify with the backend database, using LINQ. I have tried but I am not getting. Can anybody assist. Following is the underlying code. [CODE] protected …
Hey all I have a mdb file. I need to use this file as a datasource to display in the gridview. Can anyone suggest me how to use a LINQ to add to that gridview. here the purpose of gridview is simply to display some rows....... Regards, Prasanth.
Hi all i seem to be having an issue with LINQ, i am currently maintaining an in house Intranet application at work,When Saving logs it seems to slow down now,upon debugging i have came to realise that everytime it saves a log the application pauses at these two section lines …
Hi i have a simple question i was wondering how to display the existing data in C# objects like Textbox, combobox or labels. At the moment a sql database file, one of the tables data is currently displayed in the datagridview control just fine. But what i would like to …
Hey all, I am relatively new to C# and I'm finished with a project, however I am getting two errors that, for the life of me, I cannot figure out why they are coming up. I am doing some queries from the array I created and I am writing the …
Hey guys, I've got 2 collections (one datatable and one list of an object) i need to compare them and get a collection of the matches and a collection of the items that dont match (from both collections) i've got the matched collection sorted: [CODE] var yourNumbers = from DataRow …
hi, I have a linq query which fetches a collection of datas. I want to do some functionality with each collection of data. I am not getting how to pass var object to a thread. My linq to xml query looks like this: XDocument readStorelist = LoadData(); var searchResult = …
is there any website where i can find some Linq Excercise.. or you guys can setup a scenario..
Hi, I want to left outer join 2 tables called a and b.In the Where clause I want to check properties from both tables i.e like this [CODE] var query = from a in data.A join b in data.B on a.id == b.id where a.marks = 1 && b.archived == …
hi, plz tell the select command of linq in asp.net i know all sql command , but linq dont know.
Hey Guys... I've got a bit of a fiddly problem... I have an XML doc in the following format: <row> <DNOrPattern>0444</DNOrPattern> <HuntList>HL-1104 C Capital</HuntList> <LineGroup>LG-1000-COREVM1</LineGroup> <RNAReversionTimeout>4</RNAReversionTimeout> <DistributionAlgorithm>Top Down</DistributionAlgorithm> <Member>20130</Member> </row> <row> <DNOrPattern>1015</DNOrPattern> <HuntList>HL-1104 B Ltd</HuntList> <LineGroup>LG-1000-COREVM1</LineGroup> <RNAReversionTimeout>4</RNAReversionTimeout> <DistributionAlgorithm>Top Down</DistributionAlgorithm> <Member>20110</Member> </row> <row> <DNOrPattern>0444</DNOrPattern> <HuntList>HL-1104 C Capital</HuntList> <LineGroup>LG-1000-COREVM1</LineGroup> <RNAReversionTimeout>4</RNAReversionTimeout> <DistributionAlgorithm>Top Down</DistributionAlgorithm> …
I've been working on something with alot of iteration (foreach) and now that everything is working I'd like to optimize it by changing it to link. Currently I am trying to translate this foreach code to LINQ [CODE] int count = 0; foreach( string file in Directory.GetFiles( path )) { …
Hi All, Well I have a WCF service in which I query an SQL datatable that is there in the LINQ to SQL class. While querying i used the select statement for eg: from c in db.sample1 select new{c.col1,c.col2} I'm not able to covert this into a List which i …
Hello, I have 3 Combos on a toolbar which i need to bind to sql database (using linq). On my form i have several data text fields. What i need to do is this: Combo1 = bind it to a specific linq query that i make that can bring my …
I'm having a hard time geting access to properties in the var output of the query (I know I can use foreach on the result that I've got but I'm not sure which elements values I'm accessing). I think my query is just plain wrong, so I'd appreciate some help. …
Hey All I'm having a tad of trouble with a couple of WCF services I've built, and it's with LINQ. Having written the service, which uses LINQ to SQL classes, I am now trying to test it. Now the Service builds perfectly, but Whenever I try to use any of …
Hello there, i have a class user, and i also have implemented a collection for the same user class - users. users will store user objects. users collection class implements the generic collection class - collection<user>. i want to cast the LINQ query result into an object of my collection …
Hi fellas I'm having problem in querying ArrayList with Linq. I'm using VS2005. I installed Linq Preview (May 2006) setup to enable Linq in VS-2005. I created a Linq ASP.NET WebSite Template and wrote the following code. [CODE]using System; using System.Data; using System.Data.DLinq; using System.Configuration; using System.Collections; using System.Collections.Generic; using …
Hi, I have a small problem, I am trying to insert a new row into a batabase table using linq to sql. I have Microsoft publication on Linq but it was based on the beta of Linq and does not match the current version completly. I have a class P11Entry …
Hi there, I have a question about Linq and casting from a var data type to list of a specific class. A.)Is it possible, I thought that as Linq was IEnum that it would be simple to cast from the var type to a specific type, but have tried <> …
Hi. I'd like to know if there's a feature available in LINQ that let's you know if the data you received from a query is outdated because of the database being modified at a later time(outside the program). Also if there's is a kind of listener function that updates the …
Hello people, I need your advice, what to do. I use LINQ stored procedure to select all data from sql table to DataGridView: EtiketyLINQDataContext EtiketyData = new EtiketyLINQDataContext(); IEnumerable VypisDat = EtiketyData.Vypis("Cislo", "Typ", "Hrubka", "MaterialTyp"); LINQdataGridView.DataSource = VypisDat; The problem occurs with this line: `IEnumerable VypisDat = EtiketyData.Vypis("Cislo", "Typ", "Hrubka", …
Overview I have a form that the user fills in. A event to my C# codebehind page fires on the save button click. The btnSave_Click method load up the 3 LINQ Entities with the correct values. I call the LINQ method "InsertProject" to insert the data into the SQL tables. …
The End.