Reading Data from an Excel File Using C#! Help please! - C# Discussion Boards

Re: Starting services programatically

Dave Kreskowiak11-Apr-05 4:19

Dave Kreskowiak

11-Apr-05 4:19

You didn't look very hard. ServiceController.Start Method[^] docs on MSDN.

ServiceController myService = new ServiceController(@"MyServiceName");
if ( (myService.Status.Equals(ServiceControllerStatus.Stopped) ) ||
   ( myService.Status.Equals(ServiceControllerStatus.StopPending) ) )
{
    myService.Start();
}
else
{
    Console.WriteLine("Service is already running...");
}

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Using the FillSchema() method with the Data Access Application Block

Andretux11-Apr-05 2:40

Andretux

11-Apr-05 2:40

Hello people,

i'm using the DAAB (Enterprise Library) to access the data in my system. But I need to use the schema from the tables i'm reading....

when I was using the default DataAdapter, I have used the FillSchema() method, but now, when I use de DAAB to fill de data, I couldn't get the primary keys columns, unique columns neither autoincrement columns...

This is the code that i'm using to get the data with DAAB:

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

Database db = DatabaseFactory.CreateDatabase();

DBCommandWrapper cmd = db.GetSqlStringCommandWrapper("SELECT * FROM Customer");

ds = db.ExecuteDataSet(cmd);

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

But this code don't return the schema from the "Customer" table.

Do you have any tip to do it?

thanks people

André

Change system locale

Mahesh Varma11-Apr-05 1:49

Mahesh Varma

11-Apr-05 1:49

Hi all,

Is there any API to change the system locale ?

I need to write a C# application which takes LCID as input, and based on the LCID it should change the system locale.

Thanks
Mahesh

Re: Change system locale

hooray11-Apr-05 2:21

hooray

11-Apr-05 2:21

how about putting this into the main

CultureInfo ci = new CultureInfo("De-de");
Application.CurrentCulture = ci;

the constructor of the cultureinfo accepts both - a string for the region or the code as int

Re: Change system locale

elizas16-Feb-10 22:46

elizas

16-Feb-10 22:46

SharePoint provides options to create sites with different types of locales available out of the box. Suppose we have a SharePoint site built using the English locale and we want to change the existing site to some other locale then this can be achieved using the following piece of code. Changing the locale of the site helps display the date and number formats with their respective decimal and group separators.

http://www.mindfiresolutions.com/Changing-SharePoint-site-locale-programmatically-834.php[^]

Cheers,
Eliza

Autocad + C#

Newbie_Toy11-Apr-05 0:54

Newbie_Toy

11-Apr-05 0:54

Anybody have a component that can use C# to view Autocad file like zoom in, zoom out?

Re: Autocad + C#

leppie11-Apr-05 1:36

leppie

11-Apr-05 1:36

You have already been answered. D'Oh! | :doh:

^{xacc-ide 0.0.15 now with C#, MSIL, C, XML, ASP.NET, Nemerle, MyXaml and HLSL coloring - Screenshots}

Reading Data from an Excel File Using C#! Help please!

AfzalHassen11-Apr-05 0:50

AfzalHassen

11-Apr-05 0:50

Hi,

I am trying to read data from an Excel spreadsheet cell by cell which contains data with which I want to perform string manipulation and then save to SQL srvr..all the data in the spreadsheet are of a string data type..

I have recieved some help from one of the members of this site who gave me some direction, but using VB.NET code...I want to specifically use C# for this task.

How do i open the .xls file in order to read data from it??
How do I read the data from the cell(s) in a specified worksheet??
and (if i need to) how do i close the .xls file??

any advice and help will be greatly appreciated.

Thanks a million..
Afzal Hassen

Afzal Hassen

combobox items

chindiwo10-Apr-05 23:45

chindiwo

10-Apr-05 23:45

How do I access the item from the drop down list when I click the button?

Chindiwo
Jnr. Programmer
-----

Re: combobox items

mav.northwind11-Apr-05 0:49

mav.northwind

11-Apr-05 0:49

ComboBox.SelectedItem

mav

Re: combobox items

chindiwo11-Apr-05 2:12

chindiwo

11-Apr-05 2:12

Mav this a good e.g of what I want to do
label1.Text = combobox.SelectedItme.
and if I do that, there's errors

Chindiwo
Programmer
-----

Re: combobox items

hooray11-Apr-05 3:17

hooray

11-Apr-05 3:17

in this case just use:

label1.Text = combobox.SelectedText;

Re: combobox items

chindiwo11-Apr-05 22:21

chindiwo

11-Apr-05 22:21

thanx for your time, but this is how it suppose to be.
label103.Text = IncomeCombo.SelectedItem.ToString();

Chindiwo
Programmer
-----

Re: combobox items

mav.northwind11-Apr-05 5:24

mav.northwind

11-Apr-05 5:24

That's simple: label1.Text is of type string, combobox.SelectedItem is of type object, that's what the error most likely tells you.
Reading (and understanding!) the errors you get is the key to successful programming.

Convert the object to string by using ToString() for example.

Try:

if (combobox.SelectedItem != null)
  label1.Text = combobox.SelectedItem.ToString();

Regards,
mav

Re: combobox items

chindiwo11-Apr-05 22:13

chindiwo

11-Apr-05 22:13

thanx a lot man! It works!

Chindiwo
Programmer
-----

URGENT!! Locking DataGrid Mouse Events

innocent7310-Apr-05 23:25

innocent73

10-Apr-05 23:25

Hello,
I want to lock my data grid mouse events during row based operations.For example when I make an update operations on a row then I should not pass another row by clicking mouse.
How can I do this.Any idea?

Thanks

Re: URGENT!! Locking DataGrid Mouse Events

hooray11-Apr-05 0:22

hooray

11-Apr-05 0:22

normally it should be enough to disable the control.

dataGrid1.Enabled=false;

this way no input reaches the control anymore

URGENT!!!How to Lock DataGrid Mouse Events

Anonymous10-Apr-05 23:21

Anonymous

10-Apr-05 23:21

HELP !!! WHITEBOARD

xinxin_52510-Apr-05 23:18

xinxin_525

10-Apr-05 23:18

i have found the code here (http://www.codeproject.com/dotnet/CSharpWhiteboard.asp) ,but it only can be used by two users . unfortunately, i need one which can support many users (i know that it need a server ,and need to use SOCKET) .
how to finish it ??? need to help !
thanks !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
can u send me some useful things about it ?
my email------------- saxon_100@hotmail.com

help!!!help!!!

Re: HELP !!! WHITEBOARD

afinnell15-Apr-05 14:02

afinnell

15-Apr-05 14:02

I feel compelled to explain that your method for asking for help probably isn't the most effective.

If I were to change the code I would probably change it to use a Message Oriented architecture.

-
Drew

Sharing a winform

StephenMcAllister10-Apr-05 19:46

StephenMcAllister

10-Apr-05 19:46

I have several projects that make up part of a solution. What I would like to do is share two froms across two seperate projects.

Is this possible and how?

Thanks in advance.

Stephen

Re: Sharing a winform

S. Senthil Kumar10-Apr-05 20:56

S. Senthil Kumar

10-Apr-05 20:56

How about putting that form in a separate assembly and accessing it from your two projects?

Regards
Senthil
_____________________________
My Blog | My Articles | WinMacro

Re: Sharing a winform

StephenMcAllister10-Apr-05 22:01

StephenMcAllister

10-Apr-05 22:01

OK. Sounds good but I have not done this before and i am new at C#.

Have you a link to a sample or something?

Thanks.

Re: Sharing a winform

S. Senthil Kumar10-Apr-05 23:14

S. Senthil Kumar

10-Apr-05 23:14

It's fairly simple.

1. Add a new "Class Library" project in your solution.
2. Drag and drop the form that is to be shared, into the new project.
3. Add references to the new project from the projects that need to use the form (Right click on the project in Solution Explorer, click Add References and go to the Projects tab).

That should do the trick. Just make sure the shared form is under the same namespace, otherwise, you need to add a "using" directive.

Regards
Senthil
_____________________________
My Blog | My Articles | WinMacro

Serializing soap message

RajivJain10-Apr-05 19:37

RajivJain

10-Apr-05 19:37

Hi,
i want to generate xml given below using serialization. i have made the class and successfully generated the xml without the "soap:" i am not using any soap attributes. when i mention in [XmlElementAttribute("soap:Header")]
i get some junk char instead of ":" can anyone help me how excatly it should be done..... thanx

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" >
<soap:Header>
<MyCustomSoapHeader soap:mustUnderstand="1" xmlns="http://www.contoso.com">
<custom>Keith</custom>
</MyCustomSoapHeader>
</soap:Header>
<soap:Body>
<MyUnknownHeaders xmlns="http://www.contoso.com" />
</soap:Body>
</soap:Envelope>

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