i want to select id ,name,code,sum(deposit) groupby name the code var b = from a in DBContext.ctx.RestrictionsDetails_Views where (a.Relay == true) && (a.ID == grpID) && (a.Restric_Date < DateTime.Parse(dedit_from.Text)) group a by a.Account_Name into g select new { name= g.Key, Account_ID = (from o in g select o.Account_ID, Account_code = from o in g select o.Account_code.Value, RestricDet_Deposit = g.Sum(x =>x.RestricDet_Deposit) }; the result is name RestricDet_Deposit name1 200 Account_ID and Account_code dislayed System.Data.Linq.SqlClient.Implementation.ObjectMaterializer`1+<Convert>d__0`1[System.Data.SqlClient.SqlDataReader,System.Nullable`1[System.Int32]] it doesn't display value

i have two datatable dt1,dt2 i want to merg its columns to newdatatable then make gridview datasource newdatatable

i have datatable contain id name ,date (smalldatetime) i want to fill gridview by this datatable but in date columns display only daymonthyear

ok i will try it

i solved it by another way form1 form2 f2 = new form2(); f2.showdialog(); f2.dispose(); if(f2.IsDispose) { textbox1.text = valuetext; } // value text is static variable in form2 thank u for ur replay

textbox1 i can't see it in form to its modifier private

i have two forms form1 contain textbox1 and buttonsearch //click form2 is opend form2 contains textbox2 i want when user close form2 the value of textbox1 equals value of textbox2 in form2

i have two tables Assest{assestid,name,parentid} account{accountid,name,assestid}//assestid is foreginkey to assest table the code Account account = DBContext.ctx.Accounts.Single( a => a.Account_ID == idacco); account.Account_Name = txt_nameAccount.Text.ToString(); account.Account_code = Convert.ToInt32(txt_CodeAccount.Text); account.AssestID = newid ; DBContext.ctx.SubmitChanges(); this exception Foreifn key reference already has valueexception was caught Operation is not valid due to the current state of the object. note newid is already founded in table assest

i changed AutoCompleteMode ==>suggest Autocmpletesource ==>Customersourc In foreach (DataRow row in (SelectAccounts().Rows) { textBox1.AutoCompleteCustomSource.Add( row["Account_Name"].ToString()); } it worked successfuly and displayed names in table Account now i want to get id for accountname that user enter SelectAccounts() return table accounts{id,Account_Name}