Re: upload excel from local drive - C# Discussion Boards

upload excel from local drive

16-Mar-09 22:57

try this

listBox2.Items.Add(port["Caption"].ToString());

TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKQUFK[M`UKs*$GwU#QDXBER@CBN%
R0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y<pjxsg-b$f4ia>

-----------------------------------------------
128 bit encrypted signature, crack if you can

Mangesh Tomar16-Mar-09 22:17

Mangesh Tomar

16-Mar-09 22:17

Hi ,

Anybody please help me in this ..it is an urgent for me.

i am trying to fetch excel workbook dynamically but i am not get any idea about how to create an excel sheet object who help me for uploading the excel file dynamically using fileupload dialog box.

Here is my coad

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using Microsoft.Office.Core ;
using System.Data.OleDb;
using Excel;
using System.Reflection;
using Microsoft.Office.Tools.Excel;

namespace WindowsApplication2
{
public partial class Form1 : Form
{
Excel.Workbook wb;
Excel.Worksheet ws;
public Form1()
{
InitializeComponent();
// wb = new Excel.Workbook();
//ws = new Excel.Worksheet();
}
// string filename = @"C:\tmp\SpreadsheetGearOleDbBenchmark.xls";

private void button1_Click(object sender, EventArgs e)
{
string filename = @"C:\abc.xls

String connectionString =
"Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + filename + ";" +
"Extended Properties=Excel 8.0;";
OleDbConnection connection = new OleDbConnection(connectionString);
connection.Open();
//String connectionString="Provider=Microsoft.Jet.OLEDB.4.0;"+"Data Source="+filename +";"+"Extended Properties=Excel 8.0;";
OleDbCommand selectCommand = new OleDbCommand ("SELECT * FROM [sheet1$]", connection);
OleDbDataAdapter dataAdapter = new OleDbDataAdapter();
dataAdapter.SelectCommand = selectCommand;
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet);

// double sum = 0.0;
// We'll make some assumptions for brevity of the code.
System.Data.DataTable dataTable = dataSet.Tables[0];
dataGridView1.DataSource = dataSet.Tables[0];
MessageBox.Show(dataGridView1.RowCount.ToString());

connection.Close();
openFileDialog1.ShowDialog();
//openFileDialog1.ShowDialog();

// return sum;
// directorySearcher1.FindAll();
}

private void Form1_Load(object sender, EventArgs e)
{

}

private void openFileDialog1_FileOk(object sender, CancelEventArgs e)
{
openFileDialog1.ShowDialog();
Excel.Application excel = new Excel.Application();
}

}
}

Greg Chelstowski16-Mar-09 22:53

Greg Chelstowski

16-Mar-09 22:53

I'm sorry, what it is exactly you're trying to do?
I understand you have an excel spreadsheet on your local drive and want to upload it somewhere...
Where?
What do you mean by "fetch an excel spreadsheet dynamically"?

Rephrase your post or do not, there is no "try" ;>

var question = (_2b || !(_2b));

Mangesh Tomar16-Mar-09 23:34

Mangesh Tomar

16-Mar-09 23:34

here i read only one specific file in that program
i want to fetch excel file using file up load but i am unable to fetch acctual path of the file
I want to upload file on same com

Mangesh Tomar17-Mar-09 0:24

Mangesh Tomar

17-Mar-09 0:24

how i can use the openfiledialod to open excel files in c# appilcation

Fixed columns in DataGridview in windows C#

Greg Chelstowski17-Mar-09 0:46

Greg Chelstowski

17-Mar-09 0:46

openFileDialog1.ShowDialog();
System.Diagnostics.Process.Start(openFileDialog1.FileName);

No need upload anything. You have to have Excel installed, otherwise the system will not know what to do with the file.

var question = (_2b || !(_2b));

Rami.P16-Mar-09 21:49

Rami.P

16-Mar-09 21:49

Hi ,

Anybody please help me in this ..it is an urgent for me.

Actually i have a DataGridview in my window which should be with one fixed row and 2 fixed columns.

Fixedrow is done in Datagridview with the headercolumn property. Now i need to add 2 columns as fixed..

I tried with cell.frozen property, then the column is frozen, but still the tab control goes into this cells.and also it is not appearing same as column header.

Is there a way to make this 2 columns as rowheader?

In VB6 Flexgrid we have the option Fixedcols=2 ....is there any equivalent in DataGrideview windows C#?

Anyone please help me, asap...

Thanks in advance.

- Rami

Spunky Coder16-Mar-09 22:24

Spunky Coder

16-Mar-09 22:24

Use TemplateFields and then set the AutoGenerateColumns= false. Hmmm I think I haven't understood your question clearly...anyways hope this one helps you Smile | :)

"Don't worry if it doesn't work right. If everything did, you'd be out of a job." (Mosher's Law of Software Engineering)

Rami.P16-Mar-09 22:43

Rami.P

16-Mar-09 22:43

Hi Spunky Coder,

Thanks for your reply Smile | :)

Can you explain me how to use Templatefields,

Actually i need to make my first 2 columns of my grid as fixed columns (row header)..

Thanks for your help...

-Rami.

Xmen Real 16-Mar-09 22:54

Re: Fixed columns in DataGridview in windows C# [modified]

16-Mar-09 22:54

he is not asking about asp Smile | :)

-----------------------------------------------
128 bit encrypted signature, crack if you can

Spunky Coder16-Mar-09 23:13

Spunky Coder

16-Mar-09 23:13

~~I was saying about TemplateField property in a GridView. Huhhh I accept that these IDE's make me a bit lazy in remembering the syntax...I wonder how can I code without IDE's Intellisense~~ Hey I'm sorry...I haven't realized that this is a C# forum

"Don't worry if it doesn't work right. If everything did, you'd be out of a job." (Mosher's Law of Software Engineering)

modified on Tuesday, March 17, 2009 6:25 AM

Rami.P17-Mar-09 0:00

Rami.P

17-Mar-09 0:00

Hi Spunky coder,

There is no TemplateField Property in DataGridView of Windows C#...

Can you help me on this....

Thanks.,

-Rami.

Close a Child Form

yesu prakash16-Mar-09 21:05

yesu prakash

16-Mar-09 21:05

I have an form which is called from another form.
How can i close the called form when i click a button in the parent form.

Thankyou,
YPKI

Re: Close a Child Form

Xmen Real 16-Mar-09 21:15

Socket Exception "An address incompatible with the requested protocol was used" on Vista

16-Mar-09 21:15

when you show that child form, keep its intance and call Close() when require.

-----------------------------------------------
128 bit encrypted signature, crack if you can

Re: Close a Child Form

12Code16-Mar-09 22:02

12Code

16-Mar-09 22:02

Here is the code..

public partial class FormParent : Form
{
    public FormParent()
    {
        InitializeComponent();
    }

    FormChild frmChild;
    private void btnLoadForm2_Click(object sender, EventArgs e)
    {
        frmChild = new FormChild();
        frmChild.Show();
    }
    private void btnCloseFrom2_Click(object sender, EventArgs e)
    {
        frmChild.Close();
    }
}

Re: Close a Child Form

jaypatel51217-Mar-09 7:20

jaypatel512

17-Mar-09 7:20

Please Reply back to state whether you got what you want. .
This helps in unnecessary replies from other users. .
So if you are done with your query .. Please reply informing something like got you. .
Or completed . .
Please . .

niharshukla16-Mar-09 20:50

niharshukla

16-Mar-09 20:50

Hi,

I have created a client socket and when I try to connect to a remote IP address, I receice an exception
"An address incompatible with the requested protocol was used".

Code works fine on XP but it throws this exception when run on Vista.
I believe that Vista uses IPV6 by default for IPAddress and not IPV4.
This could be the reason.

But I am not able to find out the solution as how to handle it.

Please suggest.

- Nihar

Re: Socket Exception "An address incompatible with the requested protocol was used" on Vista

Xmen Real 16-Mar-09 21:17