The Issue is that I want to use the same instance i am using this in a web application and what I am doing is that I am creating this instance when the session starts and use the same instance for every operation that the user does in the application. And for every operation I want to open and close the connection to make sure that no connections are ever left open.

Hello everyone,

ActiveDB.DBContractsClient _Proxy = new ActiveDB.DBContractsClient();

        \_Proxy.Open();

        \_Proxy.ExecuteQuery("Select 1", new object\[\] { });

        \_Proxy.Close();

        \_Proxy.Open();
      \_Proxy.Close();

I have the following code to demonstrate my problem. Till the point where is the second open it works fine, but when it tries to open to connection for the second time it says cannot open object because it is disposed. Am I doing something worng or any ideas on how i may fix it? Thank you for any help.

Hi, I have a DataTable that is being generated during runtime with values from the memeory. Now my question is,is there a way you can run a sql query against the data in the datatable so that it can return data in a specifik format? In my datatable there is for example three columns called A,B,C and I want to do someting to retrieve that data with the column names Name,Surname,Age instead of A,B,C for example. Like giving an alias to the column names when retrieving the data from the datatable. Any Help is greatly appreciated.

thx

Hello, I have the following file called index.html

and this code in another file called test.svg

<svg width="100%" height="100%"
xmlns="http://www.w3.org/2000/svg">

<rect id="mytestrectangle" width="300" height="100"
style="fill:rgb(255,0,255);stroke-width:1;
stroke:rgb(0,0,255);fill-opacity:0.9;"/>

<polygon points="0,0 100,100 170,250 20,10"
style="fill:#cccccc;
stroke:#000000;stroke-width:1"/>

</svg>

now what i am tring to do is from the file index.html try to access the element called "mytestrectangle" that is in the file test.svg. But I am incliding this file in index.html via the embed object. Is there a way I can access that element via javascript from the index.html page?

hope i expained clear what i need.

Thank you in advance for the help.

Hello everyone, I have the following peace of code in a WPF application.

System.Threading.ThreadStart threadstartdelegate = delegate()
{
for (int i = 0; i < 100; i++)
{
System.Threading.Thread.Sleep(1000);
OnlineClientListBoxItem item = new OnlineClientListBoxItem();
item.SetUserDetails(Name: "Client " + i.ToString(), Userid: i);

                lstbOnlineClients.Dispatcher.Invoke(new Action<OnlineClientListBoxItem>((x) =>
                    {
                        lstbOnlineClients.Items.Add(x);
                    }), System.Windows.Threading.DispatcherPriority.Normal, item);
            }
        };
        System.Threading.Thread mainThread = new System.Threading.Thread(threadstartdelegate);
        mainThread.SetApartmentState(System.Threading.ApartmentState.STA);
        mainThread.Start();

and at this part lstbOnlineClients.Items.Add(x); it is giving me the following error "The calling thread cannot access this object because a different thread owns it." can anyone help me because this is the method in which you can invoce a control's method from another thread. Any ideas? Thank you in advance

Hay everyone, I am using CDOSYS to send emails from my sql server 2000. Now the problem is that when i am sending normal emails it's working fine but when i am sending emails that are larger than 8k it timeouts. By the way the email content is also html. anyone has any ideas or has delt with this problem before? Regards, Christian Pace

Thank you

Hi, I was wondering is there some kind of addon for Visual Studio that lets you develop excel sheets or addons with C#. Anyone have any links? Thank you in advance Regards, Christian Pace

Hello, I would like to make a program ta accesses another running exe. And I want it to check the controls on that exe and other members. Can this be done by reflection or by some other method? Can anyone point me to where I can start? Thank you very much for your time in advance. Regards, Christian Pace

Hello everyone, I have a MS SQL Server 2005 Express Edition and I want to restrict Login access to the database to only one specific domain account. How can I do this any ideas? because when I went to try and create a windows login and specified the domain account that I want it worked ok, but when then I tried to Login into the database again with a different domain account to test it still let me in. Is there some particular setting that I don't know about that anyone can help me with? Thank you very much.

Hello guys, Anyone knows how to script SQL jobs from a sql server database so that i can script them back into another database? I am using Quest Toad For sql server to view the sql jobs on the server. Regards, Christian Pace

Hi again, I found the following error message in the Event log: The description for Event ID ( 2001 ) in Source ( Microsoft Office 11 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Microsoft Office Word, . Have any idea how i can proceed on this? Thank you very much for your help Regards, Christian Pace

I did the file path is correct, there are no restrictions and the office version is correct i am using the same installation on both the development machine and the server so the word version is the same. and how can it be a code bug when i went trough it on the development machine and it worked fine.

Hello Guys, At work I am developing a new reporting system where this small application will generate the report from an XML file and then gather the data from a database and the process the report in WORD Format. Now after i developed this application and tested it on my development machine it worked compleetly fine. But when i put it into production it was always giving me the same error "Object not set to an instance of an object". After investigating more i found out that it was crashing when it was trying to query how many boookmars there are in the word document, I found out that the Document was not being opend. This is my code below: Microsoft.Office.Interop.Word.ApplicationClass WordApp = new Microsoft.Office.Interop.Word.ApplicationClass(); object filename = System.Configuration.ConfigurationSettings.AppSettings["ReportPath"].ToString() + @"\template\" + TemplateNode.Attributes["path"].Value; object _readonly = false; object isVisable = true; object missing = System.Reflection.Missing.Value; Microsoft.Office.Interop.Word.Document WordDocument = WordApp.Documents.Add(ref filename, ref missing, ref missing, ref missing); This code is resulting in the Object "WordDocument" being null. Now the funny thing is that this works fine in my developemtn machinie but id dosent work correctly on the server. My Development Machine = Windows XP Server = Windows server 2003 Anonye has any ideas as i am lost? Regards, Christian Pace

Thank you that did the trick! ;) thx for all the help

Hello guys, I am creating a database script and in this script i am declareing a datetime variable like below

DECLARE @ENDDATE DATETIME

Now my question is that i want to initialize the value of this variable and i am doing it this way

SET @ENDATE '30/12/2009'

and this is giving me an error saying that i cannot covert from char to datetime. How can this be done guys? Thank you in advance Regards, Christian Pace

Yes but can i somehow incorporate MYSQL into my installation?

Yes this is really a good idea but i want to ask you one thing. This way you are "saying" that has knowledge in IT and knows how deploy a database and maintain it etc. What I would like to implement in my application is a database that is installed automatically in the system when the user installs the application so the user doesn't need to have any IT know how. Do you understand what I am saying? and thank you for your post anyways I agree with it and its a really good idea

Hello everyone, I am planning on developing an accounting application, and while planning what language to use etc... I came started to think about databases, and my question is here. I need a database that can be distributed with a setup file but is still powerful enough to handle a large amount of data and multiple users accessing the database at the same time but also offers good security which is also important, so can anyone recommend me a good database? and if it is open source its much better. I was maybe thinking of using MS SQLSERVER EXPRESS 2005. Thank you very much everyone really appreciate any help. Regards, Christian Pace