C# Discussion Boards - CodeProject

Re: Serial port communication

DaveyM695-Mar-08 1:25

DaveyM69

5-Mar-08 1:25

Maybe check if it's null before doing any operations?

public static bool IsPortAvailable(System.IO.Ports.SerialPort portToTest)
{
   return !(null == portToTest);
}

Dave

Re: Serial port communication

t_nedelchev5-Mar-08 1:40

t_nedelchev

5-Mar-08 1:40

Thanks DaveyM69 and sorry to loosing your time.In this moment nothing
help.Now I will relax and try again later to decide the problem
Thanks for all

Problem programatically deleting worksheet from excel file

Goalie354-Mar-08 3:38

Goalie35

4-Mar-08 3:38

I'm creating an excel file using c# and the ms office object library. In a few circumstances, after I've created a new worksheet tab and filled it with data, I need to go back and delete it, but unfortunately, this isn't working. My system seems to just ignore my delete command. How can I delete a worksheet I just created?

Here's some of my code. This code would delete worksheet #25:
------------------------------------------------
using MSExcel = Microsoft.Office.Interop.Excel;

private MSExcel._Application excel;
private MSExcel._Workbook workbook;
private MSExcel._Worksheet worksheet;
private MSExcel.Sheets sheet;

worksheet = (MSExcel._Worksheet)this.workbook.Worksheets[25];
((MSExcel._Worksheet)worksheet).Delete();
--------------------------------------------------
When I run this code, the program runs through each line but it simply doesn't delete that worksheet. Any idea why?

Thanks in advance.
-Goalie35

Re: Problem programatically deleting worksheet from excel file

Laddie4-Mar-08 4:53

Laddie

4-Mar-08 4:53

Try putting null to all the columns of that row. The row will be removed.

Thanks
Laddie

Kindly rate if the answer was helpful

Re: Problem programatically deleting worksheet from excel file

Goalie354-Mar-08 4:59

Goalie35

4-Mar-08 4:59

Hi Laddie. Thanks for the reply.

The problem is I'm not trying to remove a single row from a worksheet but rather I'm trying to remove the entire worksheet tab.

Thanks again.
-Goalie35

Re: Problem programatically deleting worksheet from excel file

jchalfant4-Mar-08 9:11

jchalfant

4-Mar-08 9:11

I poked around at this and almost gave up and said it was impossible.

But it looks like all you'll have to do is turn off alerts when you delete.

Your code would look something like:

excel.Application.DisplayAlerts = false;<br />
this.workbook.Worksheets[25].Delete();<br />
excel.Application.DisplayAlerts = true;

Re: Problem programatically deleting worksheet from excel file

Goalie3510-Mar-08 4:05

Goalie35

10-Mar-08 4:05

That was it!

Thinking about it, it seems so obvious, yet I probably never would have thought of that. Naturally, excel wants to throw up a warning before deleting the worksheet. It seems the most obvious solutions are the ones most often overlooked.

Thanks a million.

-Goalie35

how to save and read an office file from SqlServer 2000 with format?

mahmoud wafy4-Mar-08 2:07

mahmoud wafy

4-Mar-08 2:07

hi,
I want to save an office file with his formats in database SqlServer 2000
and Read It from database with his formats .
thanks

Wafy

Re: how to save and read an office file from SqlServer 2000 with format?

Giorgi Dalakishvili4-Mar-08 2:24

Giorgi Dalakishvili

4-Mar-08 2:24

Here you go: How To Read and Write BLOB Data by Using ADO.NET with Visual C# .NET[^]

You can add a new column to store file format.

BTW, I have already answered your question before so don't double post and just reply to your older questions.

#region signature
my articles
#endregion

Re: how to save and read an office file from SqlServer 2000 with format?

mahmoud wafy4-Mar-08 2:58

mahmoud wafy

4-Mar-08 2:58

hi,
thanks for your answered but what i mean how to save with his format that
such as font ,color ,background and so on not Extension .
thanks Giorgi. Smile | :)

Wafy

Re: how to save and read an office file from SqlServer 2000 with format?

Giorgi Dalakishvili4-Mar-08 3:06

Giorgi Dalakishvili

4-Mar-08 3:06

When you save whole file to a database everything will be saved such as font, color and so on. You can later recreate the file by writing the content stored stored into database to a file by binaryreader.

#region signature
my articles
#endregion

Import access table to SQL Server database [modified]

new2pgrmg4-Mar-08 1:02

new2pgrmg

4-Mar-08 1:02

Is it possible to import a table containing data(everything is indexed and ready for import) in MSAccess to SQL Server 2005 database table using C#.
The database and table is already created using C# code.If so can anybody tell me how this can be done?

While researching on the issue i heard about BCP;But even that i am not sure how exactly it works.

Thanking You

modified on Tuesday, March 4, 2008 7:10 AM

Loading and using image from binary file

eyalbi0074-Mar-08 0:50

eyalbi007

4-Mar-08 0:50

Hi all,

I have a flow of things I need to do, and by now I couldn't find a covenient (or any) way doing it:

1. Loading image from binary file. The image is a 3D image, and I know each slice dimentions. Each pixel in this picture is of type Int16 (2 bytes per pixel).

2. Now, I need to set the 'Image' property of my PictureBox to one of my image slices (let's say the first one).

I'll be grateful if someone could explain how to perform these procedures.

Thanks!

Eyal.

Re: Loading and using image from binary file

MidwestLimey4-Mar-08 4:12

MidwestLimey

4-Mar-08 4:12

1) Write a test app to extract a slice and then test it by viewing it. If you don't have anything to view a slice of your 3D image with, this could be a very long day. You'll need to confirm your knowledge of how the slices are assembled in the 3D image first.

2) You'll need to know more than the pixel depth for a slice. The .Net framework will work with jpg/gif/bmp/dip/tiff/png that I recall so you'll have to convert the slice to one of these if it is not already. To do that you'll need to know the slice layout wrt it's storage technique (i.e. raster etc), any compression and the palette configuration. Then write the conversion routine (if needed) and load up the resulting image.

I'm largely language agnostic  
     After a while they all bug me  

Re: Loading and using image from binary file

eyalbi0074-Mar-08 4:22

eyalbi007

4-Mar-08 4:22

Hi,

I think I know all there is to know regarding how my binary file is assembled. However, there are unresolved issues:

1. Can you please explain how I can create a known-format image after loading the data I need?

2. Since every pixel is represented by 16bit (2 bytes and not 1), the only way I see for loading the image is loop for reading pixel-pixel BinaryReader. Any better suggestions? FileStream.read reads 1 byte at a time...

Thanks!

Re: Loading and using image from binary file

Guffa4-Mar-08 4:25

Guffa

4-Mar-08 4:25

You can use a BinaryReader to easily read Int16 values.

Create a Bitmap object with the pixel dimensions of the image that you want to show.

Get the values from the 3D data and insert as color values in the Bitmap. An easy way to set the pixels in the Bitmap is to use the SetPixel method. A more complicated way (but somehing like 100 times faster) is to use the LockBits and UnlockBits methods and unsafe code (pointer operations) to write directly to the memory area for the Bitmap.

Despite everything, the person most likely to be fooling you next is yourself.

DirectX.Capture

schnepfi4-Mar-08 0:46

schnepfi

4-Mar-08 0:46

Hello,

i want to capture a Stream from an webcam. I used the Directx.dll and it worked fine. But i now need to know how to grab a single picture from the webcam and to put it into a bmp or jpeg. Does anyone know?

ListBox Problem

zeeShan anSari4-Mar-08 0:26

zeeShan anSari

4-Mar-08 0:26

hi,
how i can retrive the selected items from the listbox at a time?
although i change the selectionmode with the multiple.

protected void ListBox1_SelectedIndexChanged(object sender, EventArgs e)<br />
  {<br />
     <br />
      TextBox3.Text = "" + ListBox1.SelectedItem;<br />
  }

above code retrive the only one item even that i select the more then one items.

Re: ListBox Problem

Nouman Bhatti4-Mar-08 0:53

Nouman Bhatti

4-Mar-08 0:53

Listbox provides a collection which returns all the selected items.. and you can loop through that collection to get each selected item

ListBox.SelectedItems
for more help

ms-help://MS.MSDNQTR.v80.en/MS.MSDN.v80/MS.NETDEVFX.v20.en/CPref17/html/P_System_Windows_Forms_ListBox_Items.htm

Re: ListBox Problem

DaveyM694-Mar-08 0:55

DaveyM69

4-Mar-08 0:55

SelectedItem retrieves the item with focus. SelectedItems returns a SelectedObjectCollection of all selected items. You can itterate through this.

Dave

Re: ListBox Problem

stancrm4-Mar-08 0:55

stancrm

4-Mar-08 0:55

ListBox1.SelectedItems...

Re: ListBox Problem

Xmen Real 4-Mar-08 3:08

Xmen Real

4-Mar-08 3:08

try this :

string[] mySitems = new string[lb.SelectedItems.Count];
lb.SelectedItems.CopyTo(mySitems,0);
textBoxX1.Lines = mySitems;

TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87??6?N8?BcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN%
Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-i?TV.C\y<p?jxsg-b$f4ia>
--------------------------------------------------------
128 bit encrypted signature, crack if you can

Re: ListBox Problem

zeeShan anSari4-Mar-08 7:04

zeeShan anSari

4-Mar-08 7:04

but there is still problem like that
Error 1 'System.Web.UI.WebControls.ListBox' does not contain a definition for 'SelectedItems'

Re: ListBox Problem

DaveyM694-Mar-08 9:26

DaveyM69

4-Mar-08 9:26

You never said it was a Web application - we all assumed you were using System.Windows.Forms.Listbox

I believe you have to loop through all the items in the list and test the Selected property.

Dave

Re: ListBox Problem

zeeShan anSari5-Mar-08 1:12

zeeShan anSari

5-Mar-08 1:12

yes..... i found solution which is following:

protected void Button7_Click1(object sender, EventArgs e)<br />
    {<br />
        TextBox4.Text = "";<br />
        foreach(ListItem Isitem in CheckBoxList1.Items)<br />
            if (Isitem.Selected == true)<br />
            {<br />
<br />
                TextBox4.Text += "\n" + Isitem.Text;<br />
<br />
            }<br />
    }

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