|
Hi all,
I have a datagridview, is it possible to copy data, for example from an excel spreadsheet into the grid, and if so how?
Thanks in advance
He who laughs last is a bit on the slow side
|
|
|
|
|
string strConn;
strConn = "Provider=Microsoft.Jet.OleDb.4.0;data source=File Path;Extended Properties=Excel 8.0;";
OledbConnection objCon = new OledbConnection(strcon);
OledbDataAdapter objDA = new OledbDataAdapter("select * from [sheet1$]", strConn);
DataSet ds = new DataSet();
objDA.Fill(ds);
datagrid1.datasource=ds;
datagrid1.databind();
Gautham
|
|
|
|
|
Thanks for the quick reply.
I have a grid that is bound to a datasource, our clients have an excel file with data, so I want to be able to select data from the excel page, copy that, and then just paste the data onto the grid at runtime, is something like this possible
He who laughs last is a bit on the slow side
|
|
|
|
|
hi! how to change the font in one row in a datagrid..
|
|
|
|
|
DataGridId.Items[row number].ForeColor=System.Drawing.Color.Red;
Gautham
|
|
|
|
|
Hi,
Suppose i have a datagrid,have 1000 records.how can i see the duplicates records
in the datagrid?
thanks.
|
|
|
|
|
I suggest you to change the underlying query (for instance, using ORDER BY) to relocate duplicate records in such a way they are shown adjacently.
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
|
|
|
|
|
Not that way exactly, i want to say that i generate a store procedure,using populate a dataset.now i bind a datagrid on that dataset.
now without using any Store procedure just from front end (using dataview or etc) can i find the duplicate records on that Datagrid?
thanks
|
|
|
|
|
Test270307 wrote: now without using any Store procedure just from front end (using dataview or etc) can i find the duplicate records on that Datagrid?
Of course you can use trhe DataView to order rows and hence find duplicate ones.
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
|
|
|
|
|
Suppose the grid have 1000 rows. and there was two name "Prasad" and "xavier".
So i want to see in the grid only 4 rows.
prasad
prasad
xavier
xavier
not all the rows.
thanks
|
|
|
|
|
as cpallini has said.
Order the grid by the name and loop through the grid removing items where name[n] == name [n+1]
This may be dangerous in a connected world though, not sure how your app is setup.
HTH
Russ
|
|
|
|
|
I'm new to C# and I can't find a comprehensive tutorial on making API calls. An example of one would be nice, preferably of 'GetAsyncKeyState'. Thanks.
|
|
|
|
|
|
Hi,
How can i extend the NameValueCollection class to store string and double
data as key and value (more than a single value). i want to access the
contents inside a lock.
Sakthi.
|
|
|
|
|
SakthiSurya wrote: How can i extend the NameValueCollection class to store string and double
You can't. The documentation[^] clearly states it is designed to hold a string key and a string value.
You might be able to inherit from it and get it to do what you want, but there are better options.
You could use a HashTable, for example. As for storing more than one value. Create a simple class to store the values in and store instances of that class in the collection.
|
|
|
|
|
Hi, I need to put a text box and button within a single DataGridView cell, the user should be able to edit the text or click the button which brings out another dialog. But I am not going to use PropertyGrid, use DataGridView only,
use C#
_________________
text |button|
this is a single cell, user can click the text to modify it, or click the button
I've tried to modify the calender picker example in microsoft.com, but somehow didn't work out, the user cannot edit the text... I think the once I added customized control to derived class from DataGridViewTextBoxCell, the DataGridViewTextBoxCell doesn't allow user to interact with it, instead, user interact with the customized control (eg: CalendarEditingControl). Since button doesn't have a edit area by default, so the user cannot click and edit. Any idea to solve this? Or other method to achieve this?
Thanks!
Nathan
|
|
|
|
|
A question of architecture/implementation...
I have a Windows service that periodically contacts a central server with status information and the intent is that it can also make a request for work to perform. I have also created a systray app that can be used to manually contact the central server and will also have the ability to make a request for work. Think SETI@Home...
What is the best way for these to work together? I've seen plenty of samples on how to get a Windows Forms app to communicate with the SCM to start/stop a Windows service, but what I want is a bit deeper than that. I want to know if the service's last request for work resulted in it starting a job, and if so, what is it working on?
I moved all the common code out of both the service and systray app into a central library that they both reference. Should the common library just be maintaining some local status database that either can query? Or can the service do all the work all the time, and the systray simply connect to the service and drive/monitor it?
Any suggestions/tips/thoughts greatly appreciated. Any references to online samples also appreciated...
Cheers,
Carl
...Every time I press the little black button on the black panel, a little black light lights up to let me know I've pressed it...
|
|
|
|
|
I would hook a database onto the server end of the process. As you receive jobs, drop the info for that job into the DB. As you start it update a progress table. when you finish it etc...
When the client wants to know where its job is, query the DB and return its history. The best thing with doing it this way is that when the service restarts after a system failure (power cut etc) it knows where it was and can start up again where it left off.
Not sure about online references i'm afraid
Russ
|
|
|
|
|
Russ,
Thanks for the response...
Yeah, as I was writing my original post, I was starting to consider that rather than having the systray app be capable of driving the service, I should just hav ethe two operate independently, but reference the same core library which does the work. And the important addition is that the core library needs to persist its state in a local database. I'm trying to keep the client pieces very light however, so hopefully I can construct a reasonable XML file that can maintain all local information...
Thanks again...
Cheers,
Carl
|
|
|
|
|
hi friends
I have created a UDP multicast program. And now my doubt is if I change font properties of the message in server and send it, the client should be able to receive the message with same font or color. Its a windows form application.
thanks in advance
Rahul
-- modified at 0:41 Friday 30th March, 2007
|
|
|
|
|
Font and other look-n-feel properties are not the part of message. If you want send those too send as rich text format instead of sending just text.
M.Sendilkumar
|
|
|
|
|
ya same thing .... how to send data in rich text format
|
|
|
|
|
Rahul Babu wrote: how to send data in rich text format
Like everything you send on a socket, it is just a sequence of bytes. You get the RTF string and send it as a series of bytes.
|
|
|
|
|
Yes exactly.
M.Sendilkumar
|
|
|
|
|
Use Rich Text box to type message which you want to send.And use RichTextBox1.rtf,not Text.
M.Sendilkumar
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
