C# Discussion Boards - CodeProject

Re: excel columns

khosnur14-Sep-09 20:09

khosnur

14-Sep-09 20:09

Loading and reading the Microsoft Excel file contents using C#[^]

Re: excel columns

Member 59031014-Sep-09 20:20

Member 590310

14-Sep-09 20:20

i have bind dataset to my grid but data of excel is loading in grid instead i need to extract the column names and show them in grid and not data.

Re: excel columns

Christian Graus14-Sep-09 20:27

Christian Graus

14-Sep-09 20:27

Are you capable of any sort of research ? Of writing any code ? Have you tried anything ?

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.

Re: excel columns

Member 59031014-Sep-09 20:33

Member 590310

14-Sep-09 20:33

yes i m loading excel data to data grid but i need to get column names of my excel file and load those column names in grid

Re: excel columns

Christian Graus14-Sep-09 21:08

Christian Graus

14-Sep-09 21:08

Someone shoot me.

here[^]

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.

Re: excel columns

Richard MacCutchan14-Sep-09 21:38

Richard MacCutchan

14-Sep-09 21:38

Come on Christian, what don't you understand? He just needs to get column names of his excel file and load those column names in grid WTF | :WTF:

Re: excel columns

carlecomm21-Sep-09 17:53

carlecomm

21-Sep-09 17:53

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

How to uninstall (remove from "Add or Remove Programs") a setup which is build in vs2005?

svt gdwl14-Sep-09 18:52

svt gdwl

14-Sep-09 18:52

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.

Re: How to uninstall (remove from "Add or Remove Programs") a setup which is build in vs2005?

Vimalsoft(Pty) Ltd14-Sep-09 20:45

Vimalsoft(Pty) Ltd

14-Sep-09 20:45

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/

Primary Key in XML File

Tufail Ahmad14-Sep-09 18:31

Tufail Ahmad

14-Sep-09 18:31

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.

Re: Primary Key in XML File

Christian Graus14-Sep-09 18:54

Christian Graus

14-Sep-09 18:54

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.

grid control

Member 59031014-Sep-09 18:28

Member 590310

14-Sep-09 18:28

i have to iterate through all cells of a column in my grid control and list the values...hw can i do that?

Re: grid control

Christian Graus14-Sep-09 18:55

Christian Graus

14-Sep-09 18:55

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.

Re: grid control

Vimalsoft(Pty) Ltd14-Sep-09 20:47

Vimalsoft(Pty) Ltd

14-Sep-09 20:47

List them where ?

Re: grid control

Harvey Saayman14-Sep-09 22:18

Harvey Saayman

14-Sep-09 22:18

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

530 error during FTP Upload

ammoti14-Sep-09 18:03

ammoti

14-Sep-09 18:03

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();

Re: 530 error during FTP Upload

ammoti16-Sep-09 4:38

ammoti

16-Sep-09 4:38

Want me answer please ?

Re: 530 error during FTP Upload

carlecomm21-Sep-09 17:25

carlecomm

21-Sep-09 17:25

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.

How do I “hide” controls that my control uses from the toolbox?

pdohara14-Sep-09 15:39

pdohara

14-Sep-09 15:39

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>

  _      _      _
 /*\==  /*\==  /*\==
&lt;ooo&gt;  &lt;ooo&gt;  &lt;ooo&gt;

Re: How do I “hide” controls that my control uses from the toolbox?

N a v a n e e t h14-Sep-09 16:17

N a v a n e e t h

14-Sep-09 16:17

Try System.ComponentModel.ToolboxItemAttribute

[System.ComponentModel.ToolboxItem(false)]
public class YourControl : YourBaseControl
{
}

Navaneeth

How to use google | Ask smart questions

Re: How do I “hide” controls that my control uses from the toolbox?

carlecomm21-Sep-09 17:34

carlecomm

21-Sep-09 17:34

Hi,

when the control Init ， try to set "control.visible = false ";

how to check if form was activated

Jassim Rahma14-Sep-09 10:14

Jassim Rahma

14-Sep-09 10:14

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?

Re: how to check if form was activated

Abhishek Sur14-Sep-09 10:26

Abhishek Sur

14-Sep-09 10:26

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]

Abhishek Sur

My Latest Articles
Create CLR objects in SQL Server 2005
C# Uncommon Keywords
Read/Write Excel using OleDB
Don't forget to click "Good Answer" if you like to.

Re: how to check if form was activated

Jassim Rahma14-Sep-09 10:38

Jassim Rahma

14-Sep-09 10:38

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.

Re: how to check if form was activated

Abhishek Sur14-Sep-09 11:08

Abhishek Sur

14-Sep-09 11:08

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. Cool | :cool:

Abhishek Sur

My Latest Articles
Create CLR objects in SQL Server 2005
C# Uncommon Keywords
Read/Write Excel using OleDB
Don't forget to click "Good Answer" if you like to.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.