|
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 ?
|
|
|
|
|
AFAIK, The answer is NO. You have to keep the assembles either in GAC or in the same folder along with the executable.
There is a work around. By using System.Reflection.Assembly.LoadFile() or
System.Reflection.Assembly.LoadFrom() methods, you can load the assemblies from a different folder; but you may have to change the design and the application will suffer a little(regarding performance).
*jaans
|
|
|
|
|
After replying to your post, I did some googling and came across this article. It is possible to keep the assemblies in a sub folder. You have to do the following.
1. Keep a config file (YourExe.exe.config)
2. Keep the following configuration settings
<configuration>
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<probing privatePath="NewFolder"/>
</assemblyBinding>
</runtime>
</configuration>
For more info check this link
http://msdn2.microsoft.com/en-us/library/823z9h8w(VS.71).aspx[^]
Today I learned some more... 
*jaans
|
|
|
|
|
That looks great jaans. I will try it today. Thanks
|
|
|
|
|
Hi,
I want to write a program in VB 6.0 to access files and directories from a remote server using windows authentication .
But I am not familiar with this.
Appreciate your help.
kalam.
|
|
|
|
|
kalam wrote: I want to write a program in VB 6.0 to access files and directories from a remote server using windows authentication .
Then why ask in the C# forum?
|
|
|
|
|
kalam wrote: I want to write a program in VB 6.0
you put the question in wrong forum !!!
try it in VB Section !!!
Good luck!!!
Best Regards
-----------------
Abhijit Jana
Microsoft Certified Professional
"Success is Journey it's not a destination"
|
|
|
|
|
Hi,
I created a hash table with 3 elements.
hashtbl.Add(1, "aaa");
hashtbl.Add(2, "bbb");
hashtbl.Add(3, "ccc");
When I'm trying to modify the hash table as following,
hashtbl[2] ="xxx";
hashtable's length increased by 1.
After the above statement, hashtbl looks as following.
hashtbl[2, "xxx"]
hashtbl[1, "aaa"]
hashtbl[2, "bbb"]
hashtbl[3, "ccc"]
How can I restrict the hash table to add a new element with the same index, 2? I would like to get hashtable as below after the modification.
hashtbl[1, "aaa"]
hashtbl[2, "xxx"]
hashtbl[3, "ccc"]
Thanks in advance..
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
