I still find use and write one once a week or so just on my dev machine. I use powershell on the servers.

Hi Fayu, Have a look at trying for xml explicit, try this article for some help http://www.eggheadcafe.com/articles/20030804.asp[^] Hope you get it working

Hi, If they are associated and mapped in the Entity Container, then you can simple load the reference's for your entity set. i.e. var b = from d1 in ents.Department1 select d1; List _departmentlist = b.tolist(); //now you can loop through this and load the sitereference for each department if you like like foreach(Department yourDept in _departmentlist) { yourDept.sitereference.load(); } Alternatively, have you thought about creating a view? A view is imported into your entity container as an entity set on its own, providing nice flexibility for complex situations.

scottgp is correct. dont map the database(s) that you dont want the user to have access to for that login.

It would be usefull if you let us know what technology you are using and where it is that you want to read this xml and why? ...because it might not even be needed to code a custom "class to read the xml data.

Hi Brendan, give this a try style="vertical-align:middle;"

Hi, what about having datetime (datetimestamp) columns, one for last_updated and one for created_date?

for example; declare @query varchar(500) set @query = "your trigger create here, I would suggest using not exists clause to prevent you from trying to create it when it is already created :)" EXECUTE @query Good luck

Hi, what you oculd also try is something like this... SELECT top(20)* FROM _yourtable WHERE _tableID not in (select top(20) tableID from _yourtable)

Perhaps try in your declaration using the @ char before the string ? e.g. string _fileUrl = @"C:\\Documents and Settings\\Administrator\\Local Settings\\Temp\\image0.jpg\";

It depends on the specific control, but generally the format would be somthing like hh:mm....the default is hh:mm:ss, so drop the ss for dropping the seconds from displaying.

Hi MS Lee, Firstly, you have to create a blank solution, then you would add a UI project that would be the interface to the users. After that you can add (dll output class library) projects for each desired tier i.e. data access tier, business logic tier etc. Here is an article that might help you; http://en.wikipedia.org/wiki/Multitier\_architecture Good luck :)

Hi Shree, Have you thought about using master pages or perhaps even Iframes?

Hey there people, I genereate xml from the datatables, but i need to group and structure the xml more correctly. could you please assist me in this matter. Here is the code what i am doing, select 1 AS Tag, NULL AS Parent, NULL AS 'FORMSETXML!1!FORMSETXML', NULL AS 'FORMSET!2!FORMSET', NULL AS 'FORMSET!2!FRM_SET_CDE', NULL AS 'FORMSET!2!SYS_LNG_CDE', NULL AS 'FORMSET!2!FRM_SET_TYP', NULL AS 'FORMSET!2!FRM_SET_CPT', NULL AS 'FORMSET!2!EXT_STP_NME', NULL AS 'FORMSET!2!TIMESTAMP', NULL AS 'FORMSETDEFINITION!3!FORMSETDEFINITION', NULL AS 'FORMSETDEFINITION!3!ENTITY', NULL AS 'FORMSETDEFINITION!3!CTL_IDN', NULL AS 'FORMSETATTRIBUTE!4!FORMSETATTRIBUTE', NULL AS 'FORMSETATTRIBUTE!4!ATR_FRY_NME' UNION ALL SELECT 2 AS Tag, 1 AS Parent, null, frm_set.frm_set_cde, frm_set.frm_set_cde, frm_set.sys_lng_cde, frm_set.frm_set_typ_cde, frm_set.frm_set_cpt, 'TEST STORED PROC', GETDATE(), null, frm_set_def.ent_cde, frm_set_def.ctl_idn, null, frm_set_atr.atr_fry_nme FROM mda_form_set frm_set INNER JOIN mda_form_set_definition frm_set_def ON (frm_set.frm_set_cde = frm_set_def.frm_set_cde and frm_set.sys_lng_cde = frm_set_def.sys_lng_cde) INNER JOIN mda_attribute frm_set_atr ON (frm_set_def.ent_cde = frm_set_atr.ent_cde and frm_set_def.atr_cde = frm_set_atr.atr_cde) UNION ALL SELECT 3 AS Tag, 2 AS Parent, null, frm_set.frm_set_cde, frm_set.frm_set_cde, frm_set.sys_lng_cde, frm_set.frm_set_typ_cde, frm_set.frm_set_cpt, 'TEST STORED PROC', GETDATE(), null, frm_set_def.ent_cde, frm_set_def.ctl_idn, null, frm_set_atr.atr_fry_nme FROM mda_form_set_definition frm_set_def INNER JOIN mda_form_set frm_set ON (frm_set.frm_set_cde = frm_set_def.frm_set_cde and frm_set.sys_lng_cde = frm_set_def.sys_lng_cde) INNER JOIN mda_attribute frm_set_atr ON (frm_set_def.ent_cde = frm_set_atr.ent_cde and frm_set_def.atr_cde = frm_set_atr.atr_cde) UNION ALL SELECT 4 AS Tag, 3 AS Parent, null, frm_set.frm_set_cde, frm_set.frm_set_cde, frm_set.sys_lng_cde, frm_set.frm_set_typ_cde, frm_set.frm_set_cpt, 'TEST STORED PROC', GETDATE(), null, frm_set_def.ent_cde, frm_set_def.ctl_idn, null, frm_set_atr.atr_fry_nme FROM mda_attribute frm_set_atr INNER JOIN mda_form_set_definition frm_set_def ON (frm_set_def.ent_cde = frm_set_atr.ent_cde and frm_set_def.atr_cde = f

Hey there. We are developing a system for contract management. Now, we generate a document with clauses selected by the user (for that document). For each clause that we add to our document, the headers and footers of the richtextbox is put into place, thus eventially when we save the document, you can imagine the complications. Is there a way to filter and delete the headers and footers of the clauses when we load them into the document textbox? Or is the only solution to allow formatting only in the document and not on clause creation level. Thanks, help is greatly appreciated :)

hey there, have you tried System.Data.DataRow myDataRow; Riaan Booyzen

Why do you need the event? there is always an option to access the data that is binded to the datagrid. If you populate your grid with a dataset try foreach (System.Data.DataRow dr in dsModApp.Tables[0].Rows) { myList.Add(dr.ItemArray[0].ToString()); } here i retireve the first column that is my select statement and thus position [0] in the dataset that is returned. Then i add the information to an arraylist for other purposes. hope it helps Riaan Booyzen