for example two columns of table1 , have relation to the id column of table2 for example: tbl_city: (id , title) tbl_person: (id , name , CurrentCityID , LastCityID , ...) now , I want to make two relations from tbl_person to tbl_city CurrentCityID and LastCityID must relation to tbl_city this query is wrong: SELECT tbl_person.name , tbl_city.title , tbl_city.title FROM tbl_person JOIN tbl_city ON tbl_person.CurrentCityID = tbl_city.id JOIN tbl_city ON tbl_person.LastCityID = tbl_city.id can you help me ?

H.R

hi Microsoft.Office.Interop.Excel.ApplicationClass ExcelApp = new Microsoft.Office.Interop.Excel.ApplicationClass(); // in this line of code: ExcelApp.Application.Workbooks.Add(Type.Missing); error: Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD)) can any one help me ?

H.R

hi Microsoft.Office.Interop.Excel.ApplicationClass ExcelApp = new Microsoft.Office.Interop.Excel.ApplicationClass(); // in this line of code: ExcelApp.Application.Workbooks.Add(Type.Missing); error: Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD)) can any one help me ?

H.R

In my windows application project , I have several user-forms and letters , that should stored in SQL database. * User must be able to change contents and format of the forms and some parts of the letters. (editing the forms and letters by user) * Program must be able to change or fill some parts of a letter for a person and print it. (filling and editing the forms and letters by program at runtime) ---------------------------- What is the best idea for this program ? Should I have a builtin text editor in my program ? How can I change or fill some parts of a letter or form at runtime ? What about office-word to use for this program ? ---------------------------- what I should to do ? please help me.

H.R

I want to connect to a sqlserver instance on another computer in the workgroup network. ---------------------------------- my application: VS.NET 2008-C# my DB: SQL Server 2000 Personal Edition my OS: Win XP Profesional sp3 ---------------------------------- I have done these steps: 1. in target sql server instance: Enterprise Manager -> server -> right click -> Properties -> Connections tab -> tick: -allow other sql servers to connect remotely to this sql server using RPC -enforce distributed transactions 2. in target sql server instance: Enterprise Manager -> server -> right click -> Properties -> General tab -> Network Configuration... button -> enabling TCP/IP 3. in target sql server instance: Enterprise Manager -> server -> right click -> Properties -> Security tab -> Authentication -> SQL Server and Windows 4. I created a New Login in target sql server instance: Name=admin , Password=1001 , SQL Server Authentication , Database=Exam 5. my SqlConnection in application: "Server=192.168.0.205\\MYSQLSRV; Initial Catalog=Exam; Integrated Security=False; Persist Security Info=False; User ID=admin;Password=1001"; 6. I removed anti virus softwares and turned off Windows Firewall. 7. I tested both of my computers to ping to another But I have an error yet: an error was occured while establishing a connection to the server. when connecting to sql server 2005, this failure may be caused by the fact under the default settings sql server dose not allow remote connections. (provider:sql network interfaces, error:26-error locating server/instance specified) ---------------------------------- can any one help me ?

H.R

thanks, I did them but I could not to connect. ---------------------------------- my application: VS.NET 2008-C# my DB: SQL Server 2000 Personal Edition my OS: Win XP Profesional sp3 ---------------------------------- I have done these steps: 1. in target sql server instance: Enterprise Manager -> server -> right click -> Properties -> Connections tab -> tick: -allow other sql servers to connect remotely to this sql server using RPC -enforce distributed transactions 2. in target sql server instance: Enterprise Manager -> server -> right click -> Properties -> General tab -> Network Configuration... button -> enabling TCP/IP 3. in target sql server instance: Enterprise Manager -> server -> right click -> Properties -> Security tab -> Authentication -> SQL Server and Windows 4. I created a New Login in target sql server instance: Name=admin , Password=1001 , SQL Server Authentication , Database=Exam 5. my SqlConnection in application: "Server=192.168.0.205\\MYSQLSRV; Initial Catalog=Exam; Integrated Security=False; Persist Security Info=False; User ID=admin;Password=1001"; 6. I removed anti virus softwares and turned off Windows Firewall. 7. I tested both of my computers to ping to another But yet I have an error: an error was occured while establishing a connection to the server. when connecting to sql server 2005, this failure may be caused by the fact under the default settings sql server dose not allow remote connections. (provider:sql network interfaces, error:26-error locating server/instance specified) ---------------------------------- can any one help me ?

H.R

I saw many articles but i could not do that. can any one help me with details ? my application: VS.NET 2008 - C# my DB: SQL Server 2000 personal edition my windows: xp profesional sp3

H.R

how to set sqlserver 2000 for accept remote connections ?

H.R

hi I want to connect to a sqlserver instance on another computer in the workgroup network. my program is win application with c# VS.NET 2008 and SQL Server 2000. what settings are needed for my sqlserver instance and my application? can you help me?

H.R

hi I want to connect to a sqlserver instance on another computer in the workgroup network. my program is win application with c# VS.NET 2008 and SQL Server 2000. what settings are needed for my sqlserver instance and my application? can you help me?

H.R

how can LogOff the computer in c# ? can anybody help me ?

H.R

how can LogOff the computer in c# ? can anybody help me ?

H.R

is it possible to copy some files from a client to an unshared location of the server ?

H.R

thanks Virtual1ty ... I have done this and I have relation with Windows Media Player but 'IWMPRemoteMediaServices.GetCustomUIMode' method is not in the list. bye

H.R

hi I want to embed the Windows Media Player to my C# win app I did it successfully. and I know that for changing it's skin, have to use of 'IWMPRemoteMediaServices.GetCustomUIMode' method. but I can not find this method at all. I do not know how can select a desired skin for my WMP object in my application. anybody help me ?!

H.R

hi I want to embed the Windows Media Player to my C# win app I did it successfully. and I know that for changing it's skin, have to use of 'IWMPRemoteMediaServices.GetCustomUIMode' method. but I can not find this method at all. I do not know how can select a desired skin for my WMP object in my application. anybody help me ?!

H.R

hi I want to embed the Windows Media Player to my C# win app I did it successfully. and I know that for changing it's skin, have to use of 'IWMPRemoteMediaServices.GetCustomUIMode' method. but I can not find this method at all. I do not know how can select a desired skin for my WMP object in my application. anybody help me ?! -- modified at 16:09 Sunday 21st October, 2007

H.R

hi I receive an exception at runtime when try to execute: System.Diagnostics.Process[] Proc = System.Diagnostics.Process.GetProcesses(); exception type: System.InvalidOperationException exception message: Process performance counter is disable, so the requested operation cannot be performed.

H.R

thanks for your leading

H.R

many thanks it is an e-examination project that for some things , must use of a winform in. end user is dealt with the winform to testing, and the webform should be aware of winform running from first to end of the exam. (momentarily the winform should reporting to the webform about itself running and result of tests) web service is the best ?!!!

H.R