Forum Visual C# Language

DataGridView Question

Sat, 28 Nov 2009 22:30:16 Z

Every time (well once every half second) the user changes text in a textbox, the current datagridview is completely replaced with a new datatable. The problem is that even when I use ClearSelection right after I assign the new DataTable to the DataGridView, the first row is selected. Anyone know how to stop this?

KeyPressed Backspace Event

Sat, 28 Nov 2009 22:03:07 Z

I have a textbox that is searching an array and displaying the results each time a key is passed. This is handled in the KeyChanged event. However, in the KeyPressed event it is set to clear the array and listbox when the textbox is cleared by using the "BackSpace" key. This works, but the BackSpace key has to be pressed one extra time after clearing the textbox. Any advice would be helpful.

How can i bind the Table Identity to Textbox control on win form

Sat, 28 Nov 2009 19:20:52 Z

string connstring3 = ConfigurationManager.AppSettings.Get("GrandMotorsConnection");
                string query3 = "SELECT IDENT_CURRENT('OrdersIN') AS Current_Identity";
               
                SqlConnection conni3 = new SqlConnection(connstring3);
                SqlCommand cmd3 = new SqlCommand(query3, conni3);


                SqlDataAdapter da3 = new SqlDataAdapter(query3, conni3);
                DataSet ds3 = new DataSet();
                da3.Fill(ds3,"OrdersIN");

                OrderIDtextbox.DataBindings.Add("text", ds3, "Current_Identity");
                OrderIDtextbox.DataBindings.Clear();

this gives me null textbox ,,, how can i do that

thanks for help anyway

problem binding TextBox to DataSet

Sat, 28 Nov 2009 02:11:23 Z

hi there,
i am trying to bind a textBox with a MS-SQL table fiels in this way:

dataAdapter.Fill(dataSet, tableName);
textBox.DataBindings.Add("Text", dataSet.Tables[tableName], "someField");

the thing is, that while using dataAdapter.Fill() method, the textBox is really filled...BUT when i am making changes in the textBox the modification doesn't reflect in the DB.

what am i missing in order to make this bind 2-way???

thx!

Grid Clicker

Sat, 28 Nov 2009 18:20:25 Z

I need the soruce code for a grid clicker like this one

http://www.glsoft.co.uk/gridclicker/

but all the people i ask the source code say it was coded in c++

can anyone help me with one for c#

Kill threads after a specific time?

Fri, 27 Nov 2009 12:33:48 Z

Hi!

I have implemented an ThreadPool and, since I'm running 500+ threads, I can't use the
WaitHandle.WaitAll(doneevents); because it has got a limit of 64 threads. I have used the code below to solve
it:

        static bool WaitForAll(ManualResetEvent[] events)
        {
            bool result = false;
            try
            {
                if (events != null)
                {
                    for (int i = 0; i < events.Length; i++)
                    {
                        events[i].WaitOne();
                    }
                    result = true;
                }
            }
            catch
            {
                result = false;
            }
            return result;
        }

This works just fine. Now, I want to Abort all threads that is not done in 5 minutes, is this possible?

Visual Studio 2008. VB.NET

Disable Button on Different Form

Sat, 28 Nov 2009 15:51:18 Z

how do i disable a button on form1 when i click a button on form2...i have tried the this.owner stuff but cant seem to get it to work

build vb6 dll

Sat, 28 Nov 2009 14:25:59 Z

Hi there,

I have a C # application in which one of the functionality i.e. project is to build/compile vbp's i.e. visual basic project using vb6.exe

Is there a code snippet anywhere which can help me with the above or is there a place where i can look at to start with as i'm a newbie to programming and bit very interested to fix this in the application

please advice

Can't get a record in database with NewRow()

Fri, 27 Nov 2009 22:42:29 Z

I have hit the wall again, and many walls to follow i guess. I want to create a record in a database, which I create with the following code. The table has 4 fields and the database is SQL Compact Edition. I see the new created record in the DataGridView on my Windows Form. When I leave the program and check the table in the database nothing is created. The update() of the tableadapter should do this according to my book. Does anybody know what I am doing wrong in the code below ?

DataTable dt = spyMaster2DataSet.Agent;
DataRow dr = dt.NewRow();
dr[0] = 20 + i;
dr[1] = "K";
dr[2] = "zzz";
dr[3] = "38334";
dt.Rows.Add(dr);
dt.AcceptChanges();
spyMaster2DataSet.AcceptChanges();
agentTableAdapter.Update(spyMaster2DataSet.Agent);
i++;

removing empty line haaving jsut white space

Fri, 27 Nov 2009 17:21:02 Z

hi,

i am reading a file line by line

there are some lines coming with nothing but white space so they are not considered as null.

How can i get rid of them??

Thanks.

generating buttons(more than 1 row)

Sat, 28 Nov 2009 01:58:22 Z

Hi,
i'm generating buttons through programing(not by design), like this:

            ButtonArray = new System.Windows.Forms.Button[10];
                  
            int x;

            for (x = 1; x <= 8; x++)
            {
                ButtonArray[x] = new System.Windows.Forms.Button();
                ButtonArray[x].Location = new System.Drawing.Point(x * 25 + 25, 430);
                ButtonArray[x].Size = new System.Drawing.Size(20, 20);
                ButtonArray[x].Text = x.ToString();
                this.Controls.Add(ButtonArray[x]);
                
            }

but all the buttons are showing in one row like this:
1 2 3 4 5 6 7 8 .

how can i show them with two or more rows like this:??
1 2 3 4
5 6 7 8

thanks

upcast

Sat, 28 Nov 2009 06:45:53 Z

Hi all,

I bit confused about the Upcasting of the object, please conside the sample below:

    class Program
    {
        static void Main(string[] args)
        {
            DeriveClass x = new DeriveClass();
            x.someProperty = "Some Value";
            BaseClass y;
            y = x;
        }
    }

    public class BaseClass
    {
        
    }

    public class DeriveClass : BaseClass
    {
        public string someProperty;
    }

Here when we assign the object of derived class to the base class variable, Are we losing the data for the "someProperty" property as object y doesn't hold the value for "someProperty" ? if yes , then why doesn't the compiler give an error for this?

Thanks,
Rajiv

How do I retrieve all Resources

Fri, 27 Nov 2009 16:54:44 Z

Hello,

How do I get all Resource elements from Properties.Resources?
I can get those from Properties.Settings.Default with gettype().GetProperties(), but this ain't working for Resources.

Any ideas?

regards,
L.

"veritas vos liberabit"

How can i format the Value that in Textbox after bind it to some Database Value ???

Thu, 26 Nov 2009 22:15:55 Z

i have Textbox for Date and for Number okay and its bind its Data from Database so

my Textbox for Date show me the value with some way i didnt want How can i format it to become with that 2009/11/25 as example

and how i can format the number Textbox that bind a Money Value from 3000.000 to become Double or anything like that 3000.50 as example

Windows Service Start Failure error..

Mon, 19 Oct 2009 09:03:14 Z

All,

I'm getting an error message like "Cannot start service from the command line or a debugger. A windows service must frist be be installed (using installutil.exe) and then started with the ServerExplorer, Windows Services Administrative tool or the NET START command." when I started debugging my service from VS 2008 Professional Edition. Following is how I using my 'OnStart(...)' method:

private bool IsStarted = true;
private NotificationProcessBusiness notificationProcess = null; // Initializes in CTOR

...

protected override void OnStart(string[] args)
{
   if (IsStarted)
   {
      notificationProcess.StartNotificationProcess();
      IsStarted = false;
   }
}

...

I am not sure why this error is occuring. I googled all sites but no idea about the solution.

Please can some one help me in resolving this problem.

Kiran (www.ggktech.com)

Calling C functions with variable number of arguments from C# using PInvoke

Fri, 27 Nov 2009 14:06:28 Z

We want to call C functions with variable number of arguments from C# using PInvoke. Here’s an example:

The C declaration with variable number of arguments looks something like this:
int SetValue(void*, int, ...);

We found that one way is to provide a C# declaration using __arglist:
[DllImport("sample.dll", CallingConvention = CallingConvention.Cdecl]
static extern int SetValue(IntPtr desc, int param, __arglist);
and then call:
SetValue(desc, parameter, __arglist(value));

We are reluctant to use the __arglist methodology because we can’t find it documented anywhere. Is it officially supported?

Thanks,
Vladimir

Order String

Fri, 27 Nov 2009 14:51:47 Z

Good afternoon,

I'm trying to create a structure with the following objective

The first from a file is read the following set of data and order .

//File exer.txt
Items
f,a,c,d,g,i,m,p
a,b,c,f,l,m,o
b,f,h,j,o
b,c,k,s,p
a,f,c,e,l,p,m,n

file = "C:\\exer.txt";

StreamReader sr = new StreamReader(ficheiro);

           while ((line = sr.ReadLine()) != null)
            {
              ....
            }

C = List_Ini.Where(num => num.count > 2).OrderByDescending(num => num.count).ToList() ;

//List_Ini order by count
f
c
a
m
p
b

what is needed in each lina order according to the order of the list. I am not able to do this
for example
line 1:f,a,c,d,g,i,m,p
order: f,c,a,m,p

Thanks

line 2:a,b,c,f,l,m,o
order: f,c,a,b,m

thanks

installation pack for windows forms application

Fri, 27 Nov 2009 14:11:04 Z

Hi,

I 2 windows forms application, which take some input files and make new files at specific location in C drive. I want to know is there any way to make an installation pack for making those folders in C:\ and placing the icon of exe at desktop.

Any kind of Tips tricks and suggestions are welcomed.

Thanks a lot indeed.

Best Regards

Setting MDI Child Form Position

Wed, 25 Nov 2009 20:13:30 Z

Situation:

I am learning how to make Multiple Document Interface applications in C# using Visual Studio 2008. There are features like cascade, tile, etc. that can be used to place the child form within the parent form. I'm using show and hide properties to display only one child form at a time. They are displayed as expected but they keeping moving further and further away from location (0,0) of the parent form in the process of switching forms using command buttons. I'd like to have every child form to be at location (0,0) of the parent form so that that the active form (the one where "Show" is "True") can be completely visible in the parent form which is just slightly bigger than all the child forms. I can always resized the parent form during program execution but that shouldn't be necessary, I think.

Question:

Is there a way to specify the position of a child form when showing it? E.g. what would I need to add to the following code in order to make frmchild always appear at location (0,0) or (20,10) of frmparent?

public class frmparent
{
.
.
.

private void FileNew_clicked(object sender, EventArgs e)
{
Form frmchild=new Form();
frmchild.MDIParent=this;
frmchild.Show();
}

.
.
.

}

Random Group Name

Thu, 26 Nov 2009 12:23:08 Z

Hi,

I am helping in a planning of a camp. Therefore, i planned to use a randomizer to randomize the people into respective group. This would not appears to be bias as it is computer random. I would be gald if someone could help me get the code. Please give examples. Please allow the user to select the number of groups he/she wants. I write in C# and please try not to use SQL if possible.

Thanks

Need help in threads...

Fri, 27 Nov 2009 05:41:08 Z

Hi,
I have a function which I want to execute after every 2-3 seconds. This thing I tried with Timer..but in that case the UI is not responsive.. So I implemented it through thread.

Thread timerRefreshCache;      

private void Form1_Load(object sender, EventArgs e)
{
          //some lines of code

          timerRefreshCache = new Thread(timer_RefreshCache_Tick);
          timerRefreshCache.IsBackground = true;
          timerRefreshCache.Start();

           //some lines of code
}



 private void timer_RefreshCache_Tick()
        {
            while (true)
            {
                try
                {
                    RefreshCacheData();
                    if (this.InvokeRequired)
                    {
                        this.Invoke(new RefreshCacheUICallBack(FillUsersInGridUI));
                    }

                    #region Refresh the chat window if required
                       //Some lines of code here
                    #endregion

                    Thread.Sleep(2000);
         //I want to execute the same functions after 2 seconds interval, so I wrote Thread.Sleep(2000)
                }
                catch (Exception ex)
                {
                    //code to log the exception.
                }
            }

        }

Now, because of Thread.Sleep() ..the functionality is one. But I have a text box on the form and due to this statement, when I am writing in the texbox it's a bit sloe responding...the same case for clearing the textbox.

So, my question is...
1. Is "Thread.Sleep()" is sleeping the application thread..instead of the created thread.. "timerRefreshCache" ?
2.And what is the replacement for THread.Sleep(..) if it's sleeping the main thread.. as I want to timerRefreshCache.sleep(..)

can anybody tell me the solution?
Plz..it's urgent !!

C#.net code for IO StreamReader to read data from .txt file for smartphone 6

Thu, 19 Nov 2009 11:56:25 Z

Sorry to my English....i am new to this.

Hi Sir/Madam!

Present i am working on windows mobile 6(smartphone) on c#.net, i am facing problem when i using stream reader(read the text from .txt file).Why because......actually when we were using stream reader with windows application we will give the full path of that text file("c:\documents\sri.txt") , but in this windows mobile application we will give text file name("sri.txt") only.If how can this application(windows mobile) find this file path,where we will save/put the text file, and please give me suitable code for read the data from .txt file and explanation of above my questions.

Thank you sir/madam.

Once again sorry to my English.

sitecollection creation

Fri, 27 Nov 2009 05:47:12 Z

hi
i am new to sharepoint

so please provide me the complete walk through of creating a sitecollection using c# code in vs 2005 by creating a webpart .

Please help to fix the HRESULT: 0x8007007E error

Fri, 27 Nov 2009 11:42:51 Z

Hi all:

I am using Visual Studio 2005. I had written some coding as follow:

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

using System.Runtime.InteropServices;

namespace WindowsApplication1

{

public partial class Form1 : Form

{

bool CAMexist = false;

public struct DEVMGR_DEVICE_INFORMATION

{

public uint dwSize;

public IntPtr hDevice;

public IntPtr hParentDevice;

[MarshalAs(UnmanagedType.ByValTStr, SizeConst = 6)]

public string szLegacyName;

[MarshalAs(UnmanagedType.ByValTStr, SizeConst = 260)]

public string szDeviceKey;

[MarshalAs(UnmanagedType.ByValTStr, SizeConst = 260)]

public string szDeviceName;

[MarshalAs(UnmanagedType.ByValTStr, SizeConst = 260)]

public string szBusName;

}

public enum DeviceSearchType : int

{

DeviceSearchByLegacyName = 0,

DeviceSearchByDeviceName = 1,

DeviceSearchByBusName = 2,

DeviceSearchByGuid = 3,

DeviceSearchByParent = 4

}

public static readonly Guid GuidCamera = new Guid("CB998A05-122C-4166-846A-933E4D7E3C86");

[DllImport("coredll.dll")]

public static extern IntPtr FindFirstDevice(

[In] DeviceSearchType searchType,

//[In] int searchType,

[In] IntPtr searchParam,

[In, Out] ref DEVMGR_DEVICE_INFORMATION pdi);

[DllImport("coredll.dll")]

public static extern int FindClose([In] IntPtr hFindFile);

public Form1()

{

InitializeComponent();

}

private void timer1_Tick(object sender, EventArgs e)

{

IntPtr handle = IntPtr.Zero;

DeviceSearchType searchType = DeviceSearchType.DeviceSearchByGuid;

IntPtr searchParam = Marshal.AllocHGlobal(Marshal.SizeOf(typeof(Guid)));

Marshal.StructureToPtr(GuidCamera, searchParam, false);

DEVMGR_DEVICE_INFORMATION di = new DEVMGR_DEVICE_INFORMATION();

di.dwSize = (uint)Marshal.SizeOf(typeof(DEVMGR_DEVICE_INFORMATION));

handle = FindFirstDevice(searchType, searchParam, ref di);

if (CAMexist == true)

{

CAMtextBox.Text = "Camera exist";

}

else

{

CAMtextBox.Text = "Camera not exist";

}

After compile, I run it under debug mode. An error occur at FindFirstDevice with HRESULT: 0x8007007E. What should I do to fix it?

I am just a novice in Visual Studio and the project is under pressure in time. Please help.

The process cannot access the file because it is being used by another process

Wed, 25 Nov 2009 21:22:05 Z

Hello there,

I created a little app that basically watches over the file system and if a specific file is created does stuff with the file.
I'm having a little problem here.
First, if a file was created, the Filewatcher eventhandler gets active.
After this and some other steps I try to create a XMLReader with the path of the new file (the same path, that the filewatcher watches).
But at this point I get the IOexception "The process cannot access the file 'D:\blah\file.xml' because it is being used by another process".

However if I add a messagebox in the filewatcher or a Thread.sleep(), I get no error message.

My guess is, that the file watcher somehow still has exclusive control to the file or filepath and so the XMLReader can't retrieve it.
If I add a pause in between, the file watcher "has enough time to release the filepath or the file". (please excuse my wording)

Could somebody explain to me what the reason to this problem is?

Info: Filewatcher and XMLReader are in differen classes (filewatcher static method in static class and XMLReader Method of class instance).

regards,

L.

"veritas vos liberabit"

How to use BigInteger in C#

Wed, 25 Nov 2009 01:30:08 Z

The following c# sample program on VS2005 gives the following error:

No overload for method 'BigInteger' takes '1' arguments

Could this be because of vjslib.dll? I have J# installed. Anyway that is a dll, is there any lib to be used? Or any reference to be done? My .Net is 2.0, should I go tp .net 4.0? Would that help?

using System;
using System.IO;
using Microsoft.CSharp;

namespace Test
{
    class BigInteger
    {
        static void Main(string[] args)
        {
            BigInteger bigIntFromDouble = new BigInteger(179032.6541);
            Console.WriteLine(bigIntFromDouble);
            BigInteger bigIntFromInt64 = new BigInteger(934157136952);
            Console.WriteLine(bigIntFromInt64);
        }
    }
}

BinarySearch array, can't get it to find anything case insensitive

Thu, 26 Nov 2009 13:47:03 Z

Hi, I have an array and I want to search this array based on the input of a textbox (txtSearch).
This works but only if I type it exactly as it is stored in the array. But I want it to search case insensitive

This is my line of code (sortedSt is an array, txtSearch.Text is input).

theIndex =

Array.BinarySearch(sortedSt,0,sortedSt.Length,txtSearch.Text);

What should I add to let it search case insensitive ?

TIA

Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154

Wed, 21 Oct 2009 12:58:16 Z

I have created web application in that I am using Excel Functionalities
When I run the app I got this error

Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154

I have found one solution here
but for this Excel is needed and In my system Excel is not installed

Please help me to solve this problem.

Regards,
Jaydeep

regex help

Thu, 26 Nov 2009 16:56:40 Z

Hi,

I am using following regex in C#. but i am getting error message "ArgumentException was unhandled"

Regex test1 = new Regex(@"^\[*(.*?)\]*(+|-|*|/).*");

i am trying to match following

[ -4, -4, -4, -4, -4, -4, -3, -2, -0, 0, 0 ] + Heat.levl_min;

starting with "[" followed by anything, followed by "]" followed by "+"or"-"or"*"or"/" followed by anything, followed by ";"

Any suggestion please??

Regards

tcpListener.Server.ReceiveTimeout doesn't work as expected

Fri, 27 Nov 2009 05:16:31 Z

Though I set the tcpListener.Server.ReceiveTimeout TIMEOUT 5 seconds, it doesn't work and keep waiting foreever. Could you please tell me what is wrong there?

                IPAddress localAddress = IPAddress.Parse("127.0.0.1");
                TcpListener tcpListener = new TcpListener(localAddress, serverPort);
                tcpListener.Server.ReceiveTimeout = 5000;
                tcpListener.Start();
                TcpClient tcpClient = tcpListener.AcceptTcpClient();
                tcpClient.Close();
                tcpListener.Stop();

Thanks.

Problem in File Upload with Tamperdata plugin

Fri, 27 Nov 2009 07:16:12 Z

I want to upload txt files.
For this I have placed CustomValidator which checks the extension of the file.
But, with tamperdata plugin if i change the file name of the upload file CustomValidator's ServerValidate event will not execute.
Please help me on this issue.

private void CustomValidator1_ServerValidate(object source, System.Web.UI.WebControls.ServerValidateEventArgs args)
		{
			string UploadFileName = FileUpload.PostedFile.FileName;
 
			if(UploadFileName == "")
			{
				// There is no file selected
				args.IsValid = false;
			}
			else
			{
				string Extension = UploadFileName.Substring(UploadFileName.LastIndexOf('.') + 1).ToLower();
 
				if (Extension == "txt")
				{
					args.IsValid = true; // Valid file type
				}
				else
				{
					args.IsValid = false; // Not valid file type
				}
			}
		}

Regards,
Jaydeep

quit application if bool = false:: help req

Thu, 26 Nov 2009 09:49:52 Z

Hi,

I have generated a windows forms application in c#. At the start i want to put a check.

If bool cond = false i want to display messagebox and quit that application and

if bool is true then it must run normally.

Any suggestion??

Best regards.

How to get the value of a LinkTextBox created at runtime

Wed, 25 Nov 2009 13:23:17 Z

Hi,

I have a cutom control called ScrollBox( A control like a textbox) where I am creating a LinkTextBox at runtime and showing the values of the linktextbox inside the scrollbox one by separated by commas.

I have completed the avove part.Now My doubt is I need to iterate through the ScrollBox control and remove an item on click of a LinkTextBox

Somehow I have done like this..

private void r_bonTextBox_Service_AfterMenuItemClick(object sender, EventArgs e)---->click event of the LinkTextBox created at runtime
  {
   for (int i = 0; i < r_bonTextBox_Service.PanelMain.Controls.Count; i++)
   {
    LinkTextBox link = (LinkTextBox)r_bonTextBox_Service.PanelMain.Controls[i];

       Remove(((BOLinkData)link.llLinkLabel.Tag).BOID); // remove service ID
   }
  }

Note:

My remove method accepts an integer as follows

public void Remove(int ServiceID)
{
//code to delete the selected item from the textox

}

But r_bonTextBox_Service.PanelMain.Controls.Count (Name of my ScrollBox is r_bonTextBox_Service) returns 0 if I run the above piece of code. Can anybody suggest an alternative method to achieve the same?

Thanks in advance

Pep

Compare two XML Schema

Thu, 26 Nov 2009 11:15:35 Z

Hi,

I have a standard XML schema file, and i need to compare an another schema file with the standard Schema file programatically(C#).

Can anyone please suggest me some solution?

With regards

Biju Software Engineer,MCP

Can we dynamically create Stored queries ( or simply queries) in MS Access using C#?

Wed, 25 Nov 2009 09:33:00 Z

I am facing problem with regard to creating stored queries in MS Access dynamically (at runtime using C# and VS 2005). I have been searching since 2 days but havnt got any related info. Can anybody plz tell me the way to do it?? Actually, I wanted to create Access database, tables and stored queries in MS Access using C#. I am done with first two but only last one is remaining. If this is not the right forum for this query, please suggest the right forum to ask the same.

Thanks in advance
Shreesh Onkar

Windows Service

Wed, 25 Nov 2009 04:43:47 Z

How to create a windows service to clear the event log. Can anyone help me out ???

Need to "re"-search an xml file each time a key is pressed while textbox is the focus

Fri, 27 Nov 2009 01:35:56 Z

I am trying to figure out the most efficient way to search a file in such a way as to make it seem like a "real-time" search; while the textbox is the focus, each time a character key is pressed the search is run again. For example, if the letter "h" is pressed, immediately returns all values containing "h". If "e" is pressed next, immediately returns all values containing "he". If backspace is pressed next, immediately reverts to values containing "h". Thank you for any and all who are able to help!

Changing Calendar Type in DateTimePicker ?

Tue, 24 Nov 2009 19:06:51 Z

Hi all.
Is it possible to change type of calendar in DateTimePicker ?
e.g : I'm gonna replace Persian Calendar with the default calendar in DateTimePicker !
Thanks

Beauty is a great God blessing

c# excel range.FormulaArray

Fri, 26 Jun 2009 20:25:44 Z

hi, can anyone tell me why this does not work

Excel.Worksheet ws_res = (Excel.Worksheet)
                  wb.Worksheets.Add(mis, mis, mis, mis);
Excel.Range range_res = (Excel.Range)ws_res.get_Range("A1","HM232");
range_res.FormulaArray =
           "=ROUND((IF((IF(Sheet4!A1:HM232=1,0,"+
           "IF(Sheet4!A1:HM232=0,1,Sheet4!A1:HM232)))=1,0,"+
           "IF((IF(Sheet4!A1:HM232=1,0,"+
           "IF(Sheet4!A1:HM232=0,1,Sheet4!A1:HM232)))=0,1,("+
           "IF(Sheet4!A1:HM232=1,0,"+
           "IF(Sheet4!A1:HM232=0,1,Sheet4!A1:HM232)))))),0)";

but this does

   Excel.Worksheet ws_res = (Excel.Worksheet)
                  wb.Worksheets.Add(mis, mis, mis, mis);
Excel.Range range_res = (Excel.Range)ws_res.get_Range("A1","HM232");
range_res.FormulaArray =
"=ROUND((IF(Sheet4!A1:HM232=1,0,IF(Sheet4!A1:HM232=0,1,Sheet4!A1:HM232))),0)";

=======================================================

but if i copy and paste the above two formulas to the formula bar of excel-2007 and press Ctrl+Shift+Enter, both work perfectly!

=======================================================

i have also changed in the above two formulas A1:HM232 to R1C1:R232C221, again from c# the shorter one works fine, but the longer one still generates the exception!

How would you deserialize an xml when you don't know its type?!

Thu, 26 Nov 2009 23:02:06 Z

Is it something impossible?

I have an XSD file from which I have created classes using xsd.exe. There are over 20 different classes.

I receive a string data containing the xml and I have to deserialize it to use the object later.

At the time of deserialization, I don't know what type that string data would be, so how could I deserialize this xml?!

One awful approach would be to use try/catch for every class of my XSD which are 20, then finally finding out the deserialized object.

Any idea?