|
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
|
|
|
|
|
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;
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
|
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.
Wafy
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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!
|
|
|
|
|
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.
|
|
|
|
|
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?
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
SelectedItem retrieves the item with focus. SelectedItems returns a SelectedObjectCollection of all selected items. You can itterate through this.
Dave
|
|
|
|
|
ListBox1.SelectedItems...
|
|
|
|
|
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
|
|
|
|
|
but there is still problem like that
Error 1 'System.Web.UI.WebControls.ListBox' does not contain a definition for 'SelectedItems'
|
|
|
|
|
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
|
|
|
|
|
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 />
}
|
|
|
|
|
Hi Everyone,
Bit of an obscure question but i can't find an answer elsewhere online so i thought I'd post here.
I'd like to know if there's a way to retrieve a serial port description, as found in Device Manager, i.e. :
Communications Port (COM1)
I can easily get the serial port name using the static SerialPort method GetPortNames() (COM1, COM2 etc) but I cannot seem to find a way of getting the extra description information.
Id like to know because our support team regularly have to launch device manager to check which comm port our USB-Serial converter has been assigned and getting garage monkeys to launch device manager over the telephone is sometimes harder than it sounds!
Thanks for looking!
Chris.
|
|
|
|
|
as far as i know you cannot retrieve additional information about serial ports with the System.IO.Ports classes, but you can use WMI to get the information you need.
check out the win32_serialport class.
/********************************************
* dies & das - dot & net
* http://blog.joachim.at
********************************************/
|
|
|
|
|
|
Is there any method to keep the assemblies in separate folder rather than putting it in the same folder where program is executed ? I am trying to deploy a windows application with dlls kept in a sub directory where application is installed. But it's throwing error which said "Assembly could not be loaded". Is there any other way to do this ?
|
|
|
|