thanx.. was already using that, but had problems with selecting min(id), and name... i can select min(id) but the name was not being selected... Even did that now am having an exception var d = (from a in db.GetTable() group a by a.name into g select new { g.Min().id,g.Min().name }); foreach (var c in d) { dictMinIdPart.Add(c.id, c.name); } runtime exception: invalid operation exception Could not format node 'New' for execution as SQL. if i am mistaking in the query, pls correct me... if i am not mistakin..then why is this excption... i searched for exception and some sites call it a bug... i am not sure thanx for ur help

haseeb

hi, I made the following linq to sql query and it seems to be working fine because the number of rows returned is exactly wat i wanted but now i can't retrieve my information from it... i am pasting the code below, with the error ,please provide help var d = (from a in db.GetTable() group a by a.name into g select new { g.Min().id,g.Min().name }); Dictionary<int,> dictMinIdPart = new Dictionary<int,>(); foreach (var c in d) { dictMinIdPart.Add(c.id, c.name); } Error: runtime error Invalidoperationexception Could not format node 'New' for execution as SQL thanx for ur help in advance best regards

haseeb

hi, i want to use the following query with in linq... select min(id),name from oemparts group by name please provide help best regards

haseeb

hi, thanx for ur reply, i hope it works... thanx

haseeb

thanx... for this beautiful answer... i think you are right,i should use option 2, gridview paging ... though , it is not gonna be that easy. and yeah... can u please help me one more thing, i am confused regarding view state, somebody told me that view state is not created for each user, so if ur using sessions, u should not be using viewstate... i thought each session has separate viewstate... thanx alot... take care

haseeb

yeah... ur right, my list becomes emptied up because of state issue, but my list is 2000 columns, storing that much data for every user , isn't that a bad idea? is viewstate created per user, each user will have own viewstate or do i have to save to someother place thanx...

haseeb

Hi i have a grid and want to allow paging for my custom object stored in a list... the list has 1000 records and i want to show 50 per page... I did the following gridview.allowpaging=true; gridview.pagesize=50; gridview.datasource=mylist; currentlist=mylist; gridview.databind(); it works fine on the first time... when somebody clicks page 2, i called pageindexchanging event and added { grid1.PageIndex = e.NewPageIndex; grid1.DataSource = currentList; // grid1.DataSource=list grid1.DataBind(); } the grid isn't shown at all... i get an empty page... wat should i do; please provid help thanx in advance

haseeb

hi... thanx for ur response... i have already done this and the problem with this is that it isn't efficient... in such example the grid only shows 100 rows but datasource has all data in it... wat i am trying to do is to get count of the no. of rows , somehow make grid generate appropriate page numbers and then pull out only 100 rows at a time... then on pageindexchanging, take get the page index, select another 100 rows this time rows from 100-200... I think,i have explained my problem... if not, lemme know and i will try my best to retype something that makes sense.. thanx... regards

haseeb

i want to select all column for a table which have distinct column name that is select * from table1 where name is distict... Man! i don't even remember doing it in sql... i think it's something like select * from table where name is (select distinct(name) from table) or maybe not... i think, i have explained my problem... Please anybody help with the linq query Thanx in advance

haseeb

Hi, i want to implement an efficient gridview...i have about 1500 rows and it takes time to load into a gridview (with automatic paging), so i want to implement a custom paging scheme in which i show only 100 rows at a time... i have turned on paging, pulled out count for the rows, also pulled out 100 rows but Q1. how do i make gridview generate 15pages link (100 per page,15 pages)... Q2.how would i call the second page with 100 -200 rows.... Please help, ...with question1 especially... also i am binding the gridview at runtime to different tables...i think i am using about 4 different types of tables... so i can't use datasources etc... please help

haseeb

Hi, i don't get any compile time or runtime errors. i have to get values from table1 and then according to data of table 1, get table2 data using a button... i get data for table1 but when i click the btn, because http is stateless, i lose all the data that was in grid1... I need to maintain that data as state,so that in postback, i take out the data, do the searching and show table 2.... because table1 has alot of information, i don't know whether to save it in session,cookie or cache... also the data will change with each session, maybe 1 user will be checking one portion of table1 , other will be checking another portion... so how do i maintain all this detail... Thanx...

haseeb

Hi, I have a gridview (source is a list) which contains information that would be required to pull out more data from the database. actually, i wil be using that list when a btn is clicked to retrieve more information and then assign this second list to the gridview... ie 1 grid and two sources but source 2 is dependent on source1. i am using asp.net so with button click , state is lost and i don't have anything in the list. How would i save this state... list1 has about 10 rows of 10 columns... i tried saving it in viewstate but page is showing error... plz provide help

haseeb

Hi i am making a function that should return id for a column(the column is unique) , so there would be one key per that column. i want to make a function and do some thing like this with linq. please provide help on how to do so void int GetPrimaryKey(string tablename,string columnName,columnvalue) { mydatacontext d=new mydatacontext(); id=//select key from tablename where columnName=columnvalue// } please provid help... thanx

haseeb

HI, i have a formview with an itemtemplate that contains a table and a number of rows and columns. There is a label control in here that i want to assign a value at runtime. i have tried Label lbl=formview.findcontrol("labelname"); but the lbl is never found , possible because of the table. i need the table because i want to show data in different 4 columns making up three rows... how would i find this control and assign it the value thanx

haseeb

hi... how would query in linq for: 1. Selecting top 10 rows for a datagrid on the first time... 2. allowing paging in grid and when somebody pressing 2, re- query linq and get next 10 rows ... i am quite knew to paging (manually)...sorry for inconvenience... fellows thanx...

haseeb

Thanx... I am sorry that i am asking alot of questions. actually, i am assigned a project in the middle. Original person has left and hasn't left any piece of documentation. He has used linq extensively in 2 forms with incomplete functionality and i want to learn linq . Already, i am doin alot of searching and learning on linq but as i mentioned, in dbml file, there is alot of code (designtime generated) and i want to learn doing this.. .i made a new linqto sql class, added tables by dragging them , some code is generated but entities are not generated. how do i generate these entities... Thanks for ur replies. They all have been very useful. also in links that you have forwarded , linq syntax used is var a = from b in db.TableName do something... i have tried this...it doesn't work, when i try like var a = from b in db.gettable do something... it works... what's the concept behind this... Thankyou for helping

haseeb

thanx it worked

haseeb

it worked. thanx

haseeb

thanx it worked

haseeb

I am trying to do a join using linq. i have 2 tables oempart and parttypes. i want to carry out join in linq and select only rows where oempart.id=5; my sql select statement is : (sql statement works fine) Select oemparts.name,parttypes.id,parttypes.product_type from oemparts join parttypes on oemparts.parttype_id=parttypes.id where parttypes.id =5 i want to do same with linq. i tried alot but can't do it. Please help... Question 2: Also this application has been developed partly by other programmer who had very good idea of linq. As i see, his sql to linq file (dbml) has a lot of coding... eg [table(name="dbo.oemparts")] and then 100 lines of code, similar case for associations etc... I want to know if such code is hardcoded or is produced by vs2008. i tried making linq to sql file from scratch but didn't have this code... is there any designer way of doin it or is it hard coding... Thanx

haseeb