|
Hi,
I am trying to read data from an Excel spreadsheet  which contains data with which I want to perform string manipulation and then save to SQL srvr.. any advice and help will be greatly appreciated. 
all the data in the spreadsheet are of a string data type..
Thanks
Afzal Hassen
|
|
|
|
|
Hi,
if u want to retrieve data using OLEDB Object than this link will help u.
http://support.microsoft.com/default.aspx?scid=kb;en-us;316831[^]
else
u if u want to read data cell wise u can use...........
Dim exlApp As New Excel.Application()<br />
Dim exlBook As Excel.Workbook = exlApp.Workbooks.Open(tbFileName.Text.Trim)<br />
Dim exlSheet As Excel.Worksheet = exlBook.Worksheets.Item(tbWorkBook.Text.Trim)<br />
<br />
for intCounter = 1 to TotalRows<br />
<br />
strFirstColValue= exlSheet.Cells.Range("A1" & intCounter).Value<br />
'after reading values u can insert these into Datatable using New dataRow....\<br />
next
I hope this will help u................:->
Regards,
Ritesh
|
|
|
|
|
|
Hi all
Has anyone done any development of desktop sharing across networks /internet?
I would be very interested in any who has or has the skill to write such a product!! (and I know all the others that are free like VNC - but they are no good for this)
Serious Very Experienced Developer needed for this one. And I am willing to pay a reasonable amount for this.
If you think you are the person and very able to do this email me at
ian"at"ianhutty.karoo.co.uk with a rough price.
Basically look at Gotoassit.com or Webex.com (smart-tech by webex) and you will know what I am aiming for.
Regards
IH
IH
|
|
|
|
|
You're mistaking us for Rent-A-Coder. Try there...http://www.rentacoder.com[^].
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi,
I have three forms. Form1 have i datagrid1 and Form2 have datagrid. First data come from form3 to Form2 datagrid and then a button click data transfer to form1 datagrid. here i add some more row and then i click on save button grid data save in to db.
I work i have do in code base not designer mode. I hope you understand me points.
Please help me as soon as possible.
|
|
|
|
|
Hi,
When you add a Crystal report file into the project you can create an object like CrystalReport1 report = new CrystalReport1();
then you can bind this object to the viewer. (push method)
You can also open a .rpt file and bind this to the viewer. (pull method)
My question is: can you create an object like method 1 with an .rpt file?
I want to read out which data is needed and then perform the query manually via code, not via the Crystal Report. (the problem is that the data has to be sent through port 80.)
So the customer can create an rpt file and we want to analyze it and do our stuff before passing it to (another) client.
I've tried the Load button, but this one doesn't seem to have correct intellisense. (always says, no overloaded method of Load takes n parameters.)
Hope somebody can help me.
No hurries, no worries.
|
|
|
|
|
Hello folks 
I am in the process of improving the stability and usability of a program I wrote (which uses plugins).
Currently, I simply load every DLL in a certain directory, assuming that noone would ever put a DLL in there which did NOT implement my interface.
I have read some articles on CP, all dealing with PlugIns - and every single article I read does it the same way, also assuming that every file is a valid plugin.
Can someone help me out here?
I have this feeling that I am definitely missing something very basic and that I will slam my head against a wall as soon as someone replies here...
Cheers
Sid
|
|
|
|
|
Hi Sid!
There's no way to decide whether an assembly contains a type that implements your interface without loading the assembly.
You have to load the assembly to get access to the types defined in the assembly and when none of the types implements your interface then you have found out that this dll isn't a valid plugin.
In order to be able to unload the assembly you must load your assemblies into a separate AppDomain, but that's shown in the existing articles I guess...
Regards,
mav
|
|
|
|
|
Hey!
If i Create a MemoryStrem, and write data to this stream at the folowing way
<br />
StreamWriter sw = new StreamWriter(StrmStore.getUnitStream);
sw.Write(data);
And then i want to read the data in the stream from another part of the program that have access to this MemoryStream
<br />
char[] buffer = new char[memoryStream.Length];<br />
sr.Read(buffer, 0, (int)memoryStream.Length);<br />
<br />
string test = new string(buffer);<br />
The problem is that the position where the streamreader will read is set to the last element in the stream(probly by the stream writer that writed the data), and when the stream reader is reading it is not removing the readed elements?
What am i doing wrong? Maby i shold solve this problem another way?
BestRegards
Jimmy
|
|
|
|
|
A MemoryStream is basically an array of bytes that's growing dynamically when data is written into the MemoryStream.
Like every Stream, MemoryStream also has a Position property that is marking the position where the next read or write will occur.
So if you want to read from the beginning, you'll have to set memoryStream.Position to 0.
Just reading from the MemoryStream doesn't remove the bytes read, so if you want this behaviour you should look for a FIFO stream implementation.
I think Ianier Munoz has such a class in his
A low-level audio player in C#[^].
Regards,
mav
|
|
|
|
|
Thanks!
Say that im about to read the stream, and i sets the position to 0. Then my writer whant to write to the stream in anohter part of the program, then it will write the new data on position 0, this would make alot of problem i think?
The ultimate solution would be a stream where i write data last in the array, and when reading i read from the beginning, and every readed byte will be removed from the array.
Is a stream like this cald a FIFO stream?
BestRegards
Jimmy
|
|
|
|
|
FIFO first in first out
(http://www.codeproject.com/cs/media/cswavrec.asp)
|
|
|
|
|
Hi
i needed to import a picture in a word document
problem is not to import the picture but get the picture at the end of
the document
Can someone help me please
thanks
|
|
|
|
|
hi all
i am having a problem. I have a tree view having some nodes. the same nodes are also present in the rtb(rich text box). what i want to do is that when i click on a perticular node, that node in the rtb should be highlighted. also reverse.
can anyone help me in this regards?
|
|
|
|
|
Nodes are present in the Richtextbox? What does that mean? Do you have the text of all the nodes in the textbox? If so, you can just subscribe to the Clicked event on the Tree, get the selected node and find the text of the node in the textbox..
Regards
Senthil
_____________________________
My Blog | My Articles | WinMacro
|
|
|
|
|
hi.
yes the text of the node is in the rtb.
but how can i get a perticular text from a rich text box?
thanks for replying
|
|
|
|
|
You could subscribe to the SelectionChanged event.
Then, using the SelectionStart property, you can find out where the new selection is and extract the word from there.
Regards,
mav
|
|
|
|
|
when i click on the rich text box, how can i get the character number?
like 7th character from the start?
|
|
|
|
|
The SelectionStart property gives you that. SelectionLength gives the number of characters selected from SelectionStart.
For the reverse, ie. selecting text when a node is clicked, that's easy, you can just call the Find method on the text box and select it.
Regards
Senthil
_____________________________
My Blog | My Articles | WinMacro
|
|
|
|
|
thanks for the help.
it works now
|
|
|
|
|
Hello everyone!
I'm designing datetime textbox by C# & ASP.NET, I want data type is datetime but users access in my website enter datetime such as mm/yyyy.
How can I do?
Please tell me!
Thank you!
|
|
|
|
|
You can simply parse the TextBox into a DateTime. If the entered Date is of a recognized format, this will automatically convert the string into a DateTime.
e.g.:
DateTime myDate = DateTime.Parse(textBox1.Text);
If you want to force the users to use a certain format, check the textbox for the compliance before you parse it. Show some error-message if it does not.
Cheers
Sid
|
|
|
|
|
how to use char** from C library to C# using invoke.
[C]
int TestFn( char** UserBuffer);
[C#]
[DllImport[("My_C_DLL")]
public static extern int TestFn( ref IntPtr UserBuffer);
[USE in C# CODE]
IntPtr pBuffer = new IntPtr();
TestFn(ref pBuffer);
When I used it like that, I did get NULL values. What are we doing wrong here?
Shail Srivastav
shailsrivastav@hotmail.com
blog
|
|
|
|
|
try this
[DllImport[("My_C_DLL")]
public static extern int TestFn([In, Out] string[] UserBuffer)
it's in MSDN at ms-help://MS.MSDNQTR.2005APR.1033/cpguide/html/cpconarrayssample.htm
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
