|
hi all,
how can i copy content of my datagridview to MS word and to MS Excel ?
i placed two button and 2 savefiledialog. and create files with the extentions xls or doc.
but dont know how to write in them ?
with using :
using Microsoft.Office.Tools.Excel;
using Microsoft.Office.Tools.Word;
these namespaces how will i going to achieve my aim?
would you please help me just for inserting a single row ( or even cell) of datagridview to ms word and ms excel ?
many thanks in advance,
bye.
|
|
|
|
|
try this code to transferring Datagrid control to excelfile
Response.ContentType = "application/vnd.ms-excel";
//create a string writer
string xlFileName = "Report - " + System.DateTime.Now.Ticks.ToString() +".xls";
string xlFilePath = Server.MapPath("../Reports/") + xlFileName;
System.IO.FileStream FS = new FileStream(xlFilePath,FileMode.Create);
StreamWriter Sw = new StreamWriter(FS);
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
//create an htmltextwriter which uses the stringwriter
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
DataGRid1.RenderControl(oHtmlTextWriter);
Sw.Write(oStringWriter.ToString());
Sw.Close();
FS.Close();
Response.AddHeader("content-disposition","attachment;filename="+xlFileName);
Response.WriteFile(xlFilePath);
Response.Flush();
Response.End();
|
|
|
|
|
Message Closed
modified 27-Apr-15 11:11am.
|
|
|
|
|
|
have you any idea about generation of a signature. i am working on it from last many days, but i am unalbe to solve my problem, i read topics about it, every one says signature has this quality, it is secure etc, but no one says do it in this way. so i wrote this query, may some one reply me which can be useful. may any one tell me the algorithm or something useful.
muhammad mahmood ilyas
|
|
|
|
|
|
Hi guys
Can you guys please help me out with a C# program I'm writing? I would like to copy the content of a selection of cells (e.g. Range("A1","M150") from one workbook to another workbook at a specified location (e.g. range("B2",Missing.Value) This process will be repeated x number of times in a loop so I need this to be reasonably fast. My current method is extremely slow..
Thanks guys
Regards
Sydney_Sider
|
|
|
|
|
I have a program with a DataGridView on a Form, and another object that contains a DataTable. The object creates a new Thread and periodically changes the data in the DataTable. The DataGridView is bound to the DataTable, but only updates when the Form is forced to redraw. It seems as if the changes to the DataTable do not fire an event off to the DataGridView.
I use the following command to bind my DataTable to my DataGridView:
gridView.DataSource=dataTable;
and I change the data in my DataTable using:
dataTable.Rows[x][y]=value;<br />
dataTable.Rows[x].AcceptChanges();
Is there an alternate way of changing the data that guarantees an event is fired?
Or is there an alternate way of binding the DataTable to the DataGridView?
Is the problem that there are 2 threads, and they are not allowed to communicate?
Any help/advice is much appreciated.
Iain 
|
|
|
|
|
Are you using a Dataset or not.
If not try using,
DataGrid1.DataSource = ds.Tables[0];
DataGrid1.DataBind();
ofcourse you will need to use a data adapter as well. If you fill the data adapter using the dataset its very easy to update. Try it.
If only they could see what I see in my mind
|
|
|
|
|
I'm using Visual C# 2005 Express and the .NET 2 Framework. Consequently I'm using a DataGridView rather than a DataGrid, and I only have need for 1 table, so I've gone for a DataTable rather than a DataSet containing a DataTable. Reading the Microsoft documentation I should be able to bind a DataGridView to either a DataTable or a DataSet (in fact it seems to be easier to bind to a DataTable as the DataGridView.DataMember property does not need to be set).
Thanks for your input, but if you can answer any of the 3 specific questions I asked, I'd be very grateful.
Thanks, Iain
|
|
|
|
|
Not sure if this is what you are looking for, but...
There is a tiny white [>] looking thing on the datagrid view in the upper right corner of the form object (design mode), and you can set the databinding from there. You can also select the form object and look at the properties list for the databinding section and do the same thing from there.
|
|
|
|
|
I've finally discovered the problem. It's a 'feature' of VC# 2005 which seems to mess up events in debug mode. If I run my code outside of VC# 2005 then the binding works fine, and the DataGridView is updated whenever I change the DataTable.
If anyone knows why VC# works like this, or how I can reconfigure VC# to avoid this problem, let me know.
Cheers, Iain
|
|
|
|
|
I am new to Dot Net.I have a VC++(MFC) application.
I want to add better user interface to my application using c# or may be VB.Net.
Which are the different ways i can do it??...can C++ code call C# code ?? should i implement as C# dll ??...or are there any other ways i can do it?
looking forward for reply
thankx in advance
Shailesh
|
|
|
|
|
Shailesh Halankar wrote: ...can C++ code call C# code ??
No, C++ cannot call C# directly. They cannot coexist in the same project.
Shailesh Halankar wrote: should i implement as C# dll ??
Yes. Two DLLs written in different .NET-compilant languages can coexist in the same solution and they can reference to each other.
Shailesh Halankar wrote: ...or are there any other ways i can do it?
Not any better ones I have known of.
- It's easier to make than to correct a mistake.
|
|
|
|
|
HELLO
Thanks for your reply..
I also want to discuss another thing or 2 with u
First is can i implement my C# developed UI component as a COM and call it from my VC.Net MFC aplication (as u said that VC.Net (mfc) application cannot call a C# DLL)....
Also If i want to give Net connectivity to my VC.Net MFC application i.e to be able to upload certain files over the network may be, then how can i do it in Dot net.Can i use Asp.net or ne other way??
thankx
regards
Shailesh
|
|
|
|
|
It is easier said than done. Firstly, take a look at this article: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/csref/html/vcwlkcominteroppart2cservertutorial.asp[^].
It will tell you that in order for C++ to call C#, the C# assembly should be written in such a way that C++ can treat it as a COM object.
In your case, you want the UI part to be in C#, and for business logic and processing part you want to continue the C++ MFC code. So the better way is to do the opposite - make the C# call your existing C++ code. Create a new C# project, create your UI, and when it is time to code the business logic, make calls to a C++ DLL. Convert your C++ code to a COM object. Then you can call it directly from your C# application. See here on how to do that:http://msdn.microsoft.com/library/default.asp?url=/library/en-us/csref/html/vcwlkCOMInteropPart1CClientTutorial.asp?frame=true[^]
Now if you are too lazy to do COM, and if your C++ MFC code is not really so gigantic, you can consider a re-write. Create a C# project, create your desired flashy cool UI, and type in the business logic part in C# as well. As you have said "I am new to Dot Net" - by doing so you will be 1 step farther from calling yourself "new"...
Koushik Biswas
who else?
|
|
|
|
|
Hello
Thanks for your feedback
I still wana clear certain things
As u know my application is VC++ Doc-View application and, i want to create custom User controls like tree control in C# as a component DLL (may be) and want to add to my DOc View application frame.
Is this possible? if not...which other way can i solve the problem
My Problem is that i cannot rewrite the code as C# (as the VC APP is gigantic)
thnks in Advance
|
|
|
|
|
Sorry you cannot. Reason is simple - a user control in the MFC document-view architechture interacts with the framework using a unique messaging system. It is just not an external assembly that you plug in. The design is from Microsoft days when .NET was not there. A C# assembly can give you a GUI, but you cannot display it from a VC++ MFC document-view project. At least I am not aware of any miracle that will let you do that.
Now coming to what practical alternatives you have. Firstly, believe me the C# tree control is not that great a control. It has numerous limitations that will frustrate you immensely. The very concept of a cool control that lets you do plenty of bells and whistles might have resulted in your brain being "c-sharpized".
With some searching and luck, you will find numerous complex user controls/ Activex objects developed in C++ that you can highly use in your project seamlessly. If it is not a binding to use C# (which you can't), you may look around for cool controls developed in VC++. Codeproject has many, and other forums have many too.
If you are more specific about the exact kind of control that you want, I can do some parallel searching too, if you don't mind that is 
Koushik Biswas
who else?
|
|
|
|
|
Hello
Was nice to get a reply from u. Ill think about the options u told me.
Another issue that i wana discuss with u is that of connectivity to the net.
How can i use ASP.net to connect my VC MFC application to the net.
Also if i want to make my application as Web applcation wat provisions do i have in Dot Net.
Thank you
regards
Shailesh
|
|
|
|
|
I tried to use this http://www.codetools.com/csharp/pdfizer.asp?print=true[^] , this converts good but fails converting HTML to as it looks. It uses the itextsharp and NTidy. The conversion of the <font> tag bgcolor etc dont work, and no images or links can be converted.
I saw the itextsharp http://sourceforge.net/projects/itextsharp/[^] , the tutorials there and all but I figure it real tough to convert HTML (as is) using just itextsharp.dll
So does anyone know a better way to do it?
HELP plz
_____________________________________________________
Yea! I could be wrong...
|
|
|
|
|
See http://html2pdf.seven49.net/seven49.asp?CathActiv1=89&CathActiv2=386
and http://www.easysw.com/htmldoc/software.php
you could if you dont find any other solution, get a php solution and convert that to .Net, at http://www.fpdf.org
it is open source free of all charges, and they have sample php code that convert html file to pdf.
|
|
|
|
|
hi all,
how can i use datagridview footer ?
any document or simple explanation please ?
(or) one more question: i have a dataset in my datagridview. there is a field in access which was formatted as Number. (this access table is the datasource of datagridview)
am i able to add a new row and write a 'string' (lets say TOTAL) in that Number field ?
thanks in advance,
bye.
|
|
|
|
|
|
hi all,
i have two tables (table1 and table2). table1 contains table2's fields and a few extra fields.
example:
table1(x,y,z,t) in this table: x & y are text fields.
table2(x,y) > in this table: x & y are date/time fields.
my question is: i want to search for some data in database according to the field types in table2 but i want to get values from table1.
to make it crystal clear: lets say x is startdate and y is enddate. i can compare date values in table2. but in table1 x & y values are just text fields.
lets consider one example: 6/6/2006 6/16/2006. if you compare these two values as date: second one is bigger. (returns 1) but if you compare these two values as text. first one is bigger!
so my problem is: i want to compare date values and get z,t from table1 according to search comparision results.
finally set the result to a dataset ?
thanks in advance,
bye.
-- modified at 6:52 Thursday 8th June, 2006
|
|
|
|
|
Just use cast(x as datetime) or the convert function with similar syntax and it'll magically convert to a datetime value. That is, if it's properly formatted, although you seem to believe that it is.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
