C# Discussion Boards - CodeProject

Rpc Server Unavailable in Excel Com Object

sakthi dasan8-Aug-07 3:49

8-Aug-07 3:49

Hello All

I m facing one problem in C# Windows Application
That one is RPC Server Unavailable while open excel sheet
I m using excel object com object
i just want to import data into SQL Database
first i open the excel sheet and then read the excel finally store data into sql
but Excel object throw one error RPC Server unavailable

The error occur in the following code

WorkBook = ExpApp.Workbooks.Open(System.Windows.Forms.Application.StartupPath + "\\Clone.xls", 0, false, 5, "", "", false, Excel.XlPlatform.xlWindows, "\t", true, false, 0, true);

anybody plz help me
it s very urgent

Thanks in Advance
Big Grin | :-D

Sak

Re: Rpc Server Unavailable in Excel Com Object

- Pascal -8-Aug-07 18:27

- Pascal -

8-Aug-07 18:27

Take a look at this http://www.codeproject.com/office/excel_using_oledb.asp[^]

Re: Rpc Server Unavailable in Excel Com Object

sakthi dasan8-Aug-07 23:15

sakthi dasan

8-Aug-07 23:15

Thanks for ur command
but i m using Excel COM Object for reading excel data
so i need solution for rpc server unavailable using Excel dll

Thanks
Sak

queue of string arrays syntax

Lord_Veralix8-Aug-07 3:43

Lord_Veralix

8-Aug-07 3:43

How do I declare a queue of string arrays?

Queue<string[]> qVar = new Queue<???>;

Re: queue of string arrays syntax

Hessam Jalali8-Aug-07 4:02

Hessam Jalali

8-Aug-07 4:02

you almost did that just here is the complete one

Queue<string[]> qString = new Queue<string[]>();

good luck

Re: queue of string arrays syntax

Lord_Veralix8-Aug-07 4:07

Lord_Veralix

8-Aug-07 4:07

Ahh, I was trying Queue<string[]> but forgot the () after the fact.

Thanks!

DataGridView multi-column sort on bound data

Dana Tov8-Aug-07 3:38

Dana Tov

8-Aug-07 3:38

Hi,
DataGridView gives only primary sort (by one column).
How can i define a secondary sort in a bound data GridView?
(I saw a solution for unbound data only)

Thanks

dana Tov

Form.Show() and TabControl tab page changed

C-Scharbe8-Aug-07 3:25

C-Scharbe

8-Aug-07 3:25

I have the following problem
-I created a form with an tab control
-I the tab control contains (minimum) 2 tab pages
-In the second (non selected) tab page i have a control
-And there is another formular (irrelevant content)

<br />
            #region PREPERATION<br />
            // instanciate a form<br />
            Form f = new Form();<br />
            // instanciate a tab control<br />
            TabControl t = new TabControl();<br />
            <br />
            // instanciate tab page 1<br />
            TabPage tp1 = new TabPage("page1");<br />
            // instanciate tab page 2<br />
            TabPage tp2 = new TabPage("page2");<br />
<br />
            // instanciate a control (sample: button)<br />
            Button b = new Button();<br />
            b.Size = new Size(100, 20);<br />
            <br />
            // add the control to the tab page<br />
            tp2.Controls.Add(b);<br />
<br />
            // add the tab pages<br />
            t.TabPages.Add(tp1);<br />
            t.TabPages.Add(tp2);<br />
<br />
            // add the tabcontrol<br />
            this.Controls.Add(t);<br />
            t.BringToFront();<br />
            #endregion PREPERATION<br />

When i first open the child-form with Show() and then select the tab page with the control the parent-form is focused again.

// show the form<br />
      f.Show();<br />
      // select the tab with the control<br />
      t.SelectedIndex = 1;

How can i force the child-form to keep its focus, while the parent change the tab page?
I don't want to use ShowDialog() or Show(this).
Is this a bug or a feature of the tab control (tab page)?

(Is the only way to fix it, changing the order of the source code?)

Re: Form.Show() and TabControl tab page changed

snorkie8-Aug-07 3:34

snorkie

8-Aug-07 3:34

Try tp2.Select(); You don't want to select the tab control, but the actual tab with the control on it.

Hogan

Re: Form.Show() and TabControl tab page changed

C-Scharbe8-Aug-07 3:39

C-Scharbe

8-Aug-07 3:39

It does not work.
It don't show the tab page (tp2).

Re: Form.Show() and TabControl tab page changed

C-Scharbe9-Aug-07 2:49

C-Scharbe

9-Aug-07 2:49

Does anyone have another idea?

How to generate Random dates in C#.net

Haj8-Aug-07 3:04

Haj

8-Aug-07 3:04

Hi

Can anyone tell me how to generate a date in random in the interval of two dates (Max date and the Min date)...

Please anyone suggest the answer soon as my due date is nearing

Thx

Anjum

Re: How to generate Random dates in C#.net

originSH8-Aug-07 3:20

originSH

8-Aug-07 3:20

search on google for "c# random" it'll tell you about the random class ... the random class takes a min int and a max int ... the rest you just need to code.

Re: How to generate Random dates in C#.net

Hessam Jalali8-Aug-07 3:25

Hessam Jalali

8-Aug-07 3:25

I think you can do that with Random Class and DateTime Struct

you can get number of available days in each month with DateTime.DaysInMonth method for correct random date generating and then simply put your generated random numbers from random class in the Constructor of DateTime struct and you will have it.

Smile | :)

Re: How to generate Random dates in C#.net

Michael Potter8-Aug-07 4:44

Michael Potter

8-Aug-07 4:44

1) Calculate the number of days between MIN & MAX.
2) Get random number within that range.
3) Add the random number to MIN.

TimeSpan ts = DateTime.Parse("12/31/2006") - DateTime.Parse("1/1/2006");
Random r = new Random();
int randomDays = r.Next(ts.Days + 1);
DateTime randomDate = DateTime.Parse("1/1/2006").AddDays(randomDays);
MessageBox.Show(randomDate.ToShortDateString());

How can I load a chm file in a form?

Zahrashahla8-Aug-07 2:51

Zahrashahla

8-Aug-07 2:51

It means that when user press F1, help of the application will load in a special form. How can I do this?

Pls help!

Re: How can I load a chm file in a form?

sakthi dasan8-Aug-07 3:52

sakthi dasan

8-Aug-07 3:52

Hi
You just use c# namespace
using System.Runtime.InteropServices;

Process.Start("Test.Chm")

so you can call anykind file using the above code and also connect to internet use these code

Sak
Smile | :)

Re: How can I load a chm file in a form?

Zahrashahla8-Aug-07 4:05

Zahrashahla

8-Aug-07 4:05

Thanks Sak,

What is the Process is?

Re: How can I load a chm file in a form?

PIEBALDconsult8-Aug-07 5:40

PIEBALDconsult

8-Aug-07 5:40

See System.Windows.Forms.Help.ShowHelp

Smart Part and User controls

umashankergr88-Aug-07 2:40

umashankergr8

8-Aug-07 2:40

Hi All,

I have a smart part views which is calling a user control named "A". I want to call a another user control named "B" from previously loaded user control "A". Is that possible or otherwise i have to change the user control "A" to a smart view.

Please anyone help me in this, if possible with a sample code...

Thanks in advance,

Uma Shanker.K

Listview ploblem?

abcomp018-Aug-07 2:35

abcomp01

8-Aug-07 2:35

when i double click in listview i want to do something i have 4 item i listview
but how i get item line 1 is id? line2 id? but idont know to use method
if (listview1.???????? = =1) { do somthing }

srry i begin Blush | :O

Re: Listview ploblem?

Hessam Jalali8-Aug-07 3:14

Hessam Jalali

8-Aug-07 3:14

you can use listView.Items[...] property generally
in double click

and ListView.SelectedItems[...] Property or List.View.SelectedIndices[...] which the first one returns the selected ListViewItem and another one returns the index of the selected ListViewItem

and if you do not use multi selection you can simply access to the selected Item like

ListView.SelectedItem[0]

<br />
<br />
        void listView1_DoubleClick(object sender, EventArgs e)<br />
        {<br />
            MessageBox.Show((sender as ListView).SelectedItems[0].Text);<br />
        }<br />

good luck

Re: Listview ploblem?

abcomp018-Aug-07 3:41

abcomp01

8-Aug-07 3:41

can show id in listbox?

Re: Listview ploblem?

Hessam Jalali8-Aug-07 4:00

Hessam Jalali

8-Aug-07 4:00

can you give some hints about what exactly you mean about id?

Using the ListBox is very similar except it has too more ListBox.SelectedItem and ListBox.SelectedIndex Properties and another difference is it will return an object which must be casted to what you put inside for using it after retrieving from the list

and about showing things in ListBox

when you add something in listbox it simply use your object's ToString method for showing that in the list So all things you want to show from your class in the listBox must be set into overridden version of ToString method so it can show that.

Hope this one helps

mouse posistion on a control when drag and dropped onto

racing578-Aug-07 2:34

racing57

8-Aug-07 2:34

As title really, i have an app with the ability to drag an item from a list box onto another grid type control, i can drag and drop no problem, i can also get the x,y coords of the mouse within the control when not dragging, but i need to get them when i have dropped the item onto the grid control. the problem is, the coords i am getting are not the withing the control but the screen ( i think ) any ideas how i can covert to the controls coords or how to get the coords from the control ??

Thanks in advance

Lee

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.