|
Hi,
Give you a example. Hope it is helpful
/************************************************************
from Web
************************************************************/
private void Automation_CellByCell()
{
// Start a new workbook in Excel.
m_objExcel = new Excel.Application();
m_objBooks = (Excel.Workbooks)m_objExcel.Workbooks;
m_objBook = (Excel._Workbook)(m_objBooks.Add(m_objOpt));
// Add data to cells of the first worksheet in the new workbook.
m_objSheets = (Excel.Sheets)m_objBook.Worksheets;
m_objSheet = (Excel._Worksheet)(m_objSheets.get_Item(1));
m_objRange = m_objSheet.get_Range("A1", m_objOpt);
m_objRange.set_Value(m_objOpt,"Last Name");
m_objRange = m_objSheet.get_Range("B1", m_objOpt);
m_objRange.set_Value(m_objOpt,"First Name");
m_objRange = m_objSheet.get_Range("A2", m_objOpt);
m_objRange.set_Value(m_objOpt,"Doe");
m_objRange = m_objSheet.get_Range("B2", m_objOpt);
m_objRange.set_Value(m_objOpt,"John");
// Apply bold to cells A1:B1.
m_objRange = m_objSheet.get_Range("A1", "B1");
m_objFont = m_objRange.Font;
m_objFont.Bold=true;
// Save the workbook and quit Excel.
m_objBook.SaveAs(Application.StartupPath + "\\Book1.xls", m_objOpt, m_objOpt,
m_objOpt, m_objOpt, m_objOpt, Excel.XlSaveAsAccessMode.xlNoChange,
m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt);
m_objBook.Close(false, m_objOpt, m_objOpt);
m_objExcel.Quit();
}
private void Automation_UseArray()
{
// Start a new workbook in Excel.
m_objExcel = new Excel.Application();
m_objBooks = (Excel.Workbooks)m_objExcel.Workbooks;
m_objBook = (Excel._Workbook)(m_objBooks.Add(m_objOpt));
m_objSheets = (Excel.Sheets)m_objBook.Worksheets;
m_objSheet = (Excel._Worksheet)(m_objSheets.get_Item(1));
// Create an array for the headers and add it to cells A1:C1.
object[] objHeaders = {"Order ID", "Amount", "Tax"};
m_objRange = m_objSheet.get_Range("A1", "C1");
m_objRange.set_Value(m_objOpt,objHeaders);
m_objFont = m_objRange.Font;
m_objFont.Bold=true;
// Create an array with 3 columns and 100 rows and add it to
// the worksheet starting at cell A2.
object[,] objData = new Object[100,3];
Random rdm = new Random((int)DateTime.Now.Ticks);
double nOrderAmt, nTax;
for(int r=0;r<100;r++)
{
objData[r,0] = "ORD" + r.ToString("0000");
nOrderAmt = rdm.Next(1000);
objData[r,1] = nOrderAmt.ToString("c");
nTax = nOrderAmt*0.07;
objData[r,2] = nTax.ToString("c");
}
m_objRange = m_objSheet.get_Range("A2", m_objOpt);
m_objRange = m_objRange.get_Resize(100,3);
m_objRange.set_Value(m_objOpt,"objData");
// Save the workbook and quit Excel.
m_objBook.SaveAs(Application.StartupPath + "\\Book2.xls", m_objOpt, m_objOpt,
m_objOpt, m_objOpt, m_objOpt, Excel.XlSaveAsAccessMode.xlNoChange,
m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt);
m_objBook.Close(false, m_objOpt, m_objOpt);
m_objExcel.Quit();
}
private void Automation_ADORecordset()
{
// Create a Recordset from all the records in the Orders table.
ADODB.Connection objConn = new ADODB.Connection();
ADODB._Recordset objRS = null;
objConn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" +
m_strNorthwind + ";", "", "", 0);
objConn.CursorLocation = ADODB.CursorLocationEnum.adUseClient;
object objRecAff;
objRS = (ADODB._Recordset)objConn.Execute("Orders", out objRecAff,
(int)ADODB.CommandTypeEnum.adCmdTable);
// Start a new workbook in Excel.
m_objExcel = new Excel.Application();
m_objBooks = (Excel.Workbooks)m_objExcel.Workbooks;
m_objBook = (Excel._Workbook)(m_objBooks.Add(m_objOpt));
m_objSheets = (Excel.Sheets)m_objBook.Worksheets;
m_objSheet = (Excel._Worksheet)(m_objSheets.get_Item(1));
// Get the Fields collection from the recordset and determine
// the number of fields (or columns).
System.Collections.IEnumerator objFields = objRS.Fields.GetEnumerator();
int nFields = objRS.Fields.Count;
// Create an array for the headers and add it to the
// worksheet starting at cell A1.
object[] objHeaders = new object[nFields];
ADODB.Field objField = null;
for(int n=0;n
|
|
|
|
|
Hi,
I had an application of BHo developed using Vs2005 c#.
I build a setup in Vs2005.
In the installation folder, I added my dll and Microsoft.Mshtml.dll. In the "Uninstallation" folder also, I added the same (my dll and Microsoft.Mshtml.dll).
while Uninstalling the is an error
"Exception occured while initializing the installation.
'System.IO.FileNotfoundException': could not load file or assembly "file:///C:\Program Files\ AB\SetupName\MyDll.dll' or one of its dependencies. The system cannot find the file specified."
How to solve this?
Now my setup is not getting "UnInstalled". I tried in many ways, but unable to remove it form my "Add or Remove Programs". How to remove this setup from my add remove programs.
|
|
|
|
|
When you add Files that your Application will need in Application Folder, i don't think you need to add then in the uninstall Folder. Only Add what your application will need and when you uninstall your application, all the files in the Programs File --> YourApplicationFolder will be deleted. Why do you want to do it your self
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
I am using c# and xml file for storing data (and not in database). How can i add primary key on xml file so that no duplicate data can enter into it.
|
|
|
|
|
I guess you don't really understand what xml is. It's a string, that's about it. You MAY be able to format an XSD to define that data is not duplicated, but if you can or not, any sort of rules you want to enforce, you'll need to write code to enforce them, and you're on your own if you write any bugs.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
i have to iterate through all cells of a column in my grid control and list the values...hw can i do that?
|
|
|
|
|
With for each loops, I expect.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
List them where ?
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
LIQUID NITROGEN
Harvey Saayman - South Africa
Software Developer
.Net, C#, SQL
you.suck = (you.Occupation == jobTitles.Programmer && you.Passion != Programming)
1000100 1101111 1100101 1110011 100000 1110100 1101000 1101001 1110011 100000 1101101 1100101 1100001 1101110 100000 1101001 1101101 100000 1100001 100000 1100111 1100101 1100101 1101011 111111
|
|
|
|
|
Hi I am I want Ftp Upload File but I have The remote server returned error: (530) did not at logon.
what is problem ?
FtpWebRequest Istek;
try
{
Istek = (FtpWebRequest)FtpWebRequest.Create(new Uri(@"Ftp://" + HostName));
Istek.UseBinary = true;
Istek.Credentials = new NetworkCredential(HostName, Password);
Istek.Method = WebRequestMethods.Ftp.ListDirectory;
WebResponse elcavab = Istek.GetResponse();
|
|
|
|
|
|
Hi,
i think your codes are right.
my codes:
//create the ftpwebrequest object.
FtpWebRequest request = (FtpWebRequest)WebRequest.Create(textServer.Text);
request.Credentials = new NetworkCredential(textUsername.Text, textPassword.Text);
request.Method = WebRequestMethods.Ftp.ListDirectory;
//send the request to the server.
response = (FtpWebResponse)request.GetResponse();
//read the response and fill the list box.
stream = response.GetResponseStream();
FillDirectoryList(stream);
..............................
the error may be : the host user is not logined. the host's ftp is closed.
try to use 'cmd' to check, ping that 'IP'.
modified 27-May-14 5:36am.
|
|
|
|
|
I have developed a control. Among other things this control can popup other controls at runtime. When you include the assembly in Visual Studio, the control that I created shows up, but the other controls (the ones my control uses) show up as well. I would rather not have them show up in the toolbox in Visual Studio. Is there an Attribute that I can apply to these classes to make them not show up? I found the browsable attribute, but it says it is for properties and events.
Tanks for your support
Pat O
<a href="http://currentchaos.blogspot.com/">Blog</a>
_ _ _
|
|
|
|
|
Try System.ComponentModel.ToolboxItemAttribute
[System.ComponentModel.ToolboxItem(false)]
public class YourControl : YourBaseControl
{
}
|
|
|
|
|
Hi,
when the control Init ， try to set "control.visible = false ";
|
|
|
|
|
i have an MDI child (MDI1) form which I am opening another MDI child (MDI2) from that form. How can I check if MDI1 was ctivated after closing MDI to refresh it? do I have to use Enter or Activated events?
|
|
|
|
|
use
this.ActiveMdiChild
It will return the MDI child form that is currently active. If you want to activate another form just use
frm2.focus();
![Rose | [Rose]](https://codeproject.freetls.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
I don't want to focus it.
well, let me explain it more..
MDI2 is an edit form of MDI1 so MDI is just viewing the data where MDI2 is the edit.
when the user clicks on the edit button (on MDI1) it will open MDI2.
when the user click save (on MDI2) it will close MDI2..
now I want to know if any data were changed and refresh the data on MDI accordainaly.
|
|
|
|
|
Well, Do the refresh of data when form is activated. Write the code inside Form_Activated to refresh the form with new data.
Dont forget to set a flag when edit is done and recheck the flag within form_Activated. Otherwise the data will be refreshed every time you activate the form.
|
|
|
|
|
Create a bool on MDI2, set it to true if data is edited.
Create a readonly property for this bool on MDI2 and check it from MDI1.
Refresh if true.
Regards
Mick Curley
|
|
|
|
|
of course, you should use these event.
for example, use 'closing event ' to check if MDI1 was activted.
or you can use WINAPI ('FindWindow')to Find out that 'WinForm', and then check if it was actived.
modified 27-May-14 5:31am.
|
|
|
|
|
Hi guys!
I have a question concerning the Timer Elapse Event and the invoked Method.
Is it possible to add an object to the timer which is passed to the Method?
Something like this:
public Timer MouseHooverTimer
{
get
{
if (mouseHooverTimer == null)
{
mouseHooverTimer = new Timer(2000);
mouseHooverTimer.Elapsed += new ElapsedEventHandler(mouseHooverTimer_Elapsed);
}
return mouseHooverTimer;
}
}
private void StartTimer(object information)
{
mouseHooverTimer.Start(); <== HERE ADD THE OBJECT information
}
void mouseHooverTimer_Elapsed(object sender, ElapsedEventArgs e)
{
}
Thanks in advance!
|
|
|
|
|
No, just use a field. Or derive your own timer class that will do it.
|
|
|
|
|
|
Hi,
of course, you can add an object to the timer.
but you must recognize that 'timer Thread' is not the same to 'main Thread',
so after you create the object in 'timer thread',
if you use it in 'main thread', will throw an error.
modified 27-May-14 5:37am.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
