|
Here i upload the excel file in datagrid
private void button1_Click_1(object sender, EventArgs e)
{
OpenFileDialog FD = new OpenFileDialog();
FD.Filter = "Excel|*.xls";
if (FD.ShowDialog() == DialogResult.OK)
{
textBox1.Text = " " + FD.FileName;
}
string filename = textBox1.Text;
String connectionString =
"Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + filename + ";" +
"Extended Properties=Excel 8.0;";
OleDbConnection connection = new OleDbConnection(connectionString);
connection.Open();
OleDbCommand selectCommand = new OleDbCommand("SELECT * FROM [mybook$]", connection);
OleDbDataAdapter dataAdapter = new OleDbDataAdapter();
dataAdapter.SelectCommand = selectCommand;
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet);
System.Data.DataTable dataTable = dataSet.Tables[0];
dataGridView1.DataSource = dataSet.Tables[0];
MessageBox.Show(dataGridView1.RowCount.ToString());
connection.Close();
}
it may help you
modified on Monday, April 27, 2009 6:15 AM
|
|
|
|
|
I am currently building an application which will deal with several large sets of data from different sources such as databases, csv & xls files. I have been looking at the dis/advantages of using dataset & generic collections.
My conclusion was that I would need to use generic collections because I will be dealing with ~ 300,000 records in most cases (they will not usually be displayed to the user). I have not really delved into generic collections before and I am having trouble figuring the best way to construct the class because each set of data will have a different amount fields but I want to be able to use the same methods to sort, search & filter.
Would the below basis for a class work, is there a better way? I am having trouble thinking how the sorting would work with this, whilst it seems very easy when the class is not made up with an array.
public class Record
{
private string[] cells;
public string[] Cells
{
get { return cells; }
set { cells = value; }
}
|
|
|
|
|
Don't use an array, for exactly the reasons you stated. Use a generic collection, like a List. The list classes have sorting methods built in.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
How do I deal with multiple columns for each record?
List<int> is fine for a list such as 1,4,5,3,2,5 but how would you deal with {5,6,7} {3,5,1} {8,9,1} and it be able to deal with other size sets, for example one with 12 fields per record?
Thank you
|
|
|
|
|
Create a struct for each set which will both name the fields, and group them together.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
Hi all,
I'm using c# in VS 2008, I just found out a single '\r' could be used a new line control code, why's that considering '\r' is to move the position of the cursor to the first position on the same line? Isn't '\r\n' supposed to do that?
Thanks,
modified on Monday, April 27, 2009 4:10 AM
|
|
|
|
|
|
The newline character is a system dependent mix of the carriage return (\r) and line feed (\n) characters. On Unix newline is \n, on Macs newline is \r and on Windows newline is \r\n. If you're using .Net then you should be using Environment.NewLine instead of a specific character sequence.
|
|
|
|
|
Hi friends
can anybody help me to create MDI application using C#.Net 2008
In advance thanks
|
|
|
|
|
So you know how to create MDI applications in the previous versions???
If yes, VS 2008 makes no difference, only with some added features...
Try to search the code project articles on MDI applications....
This would be a better start
Windows Form programming.[^]
Have a Happy Coding.....
|
|
|
|
|
Hi,
I'm trying to read connection string from app.config in .net 3.5, as below
string con = ConfigurationSettings.AppSettings["DBConn"];
But, its not working.
App.config file
===============
<configuration>
<configsections>
<connectionstrings>
<add name="DBConn" connectionstring="Data Source=LALITHA\SQLEXPRESS;Initial Catalog=GSM;Integrated Security=True">
providerName="System.Data.SqlClient" />
Please let me know how to read. Thanks in advance.
|
|
|
|
|
|
Hi there,
I want to change the default Home page of the IE browser using C# console application. For this purpose, I have to manipulate the registry settings. The registry path for doing so is: HKCU\Software\Microsoft\Internet Explorer\Main\Start Page.
Now, suppose the start page (home page) of the browser is set to http://google.com. Then how will I programatically change it to http://msn.com in C#?
Your help will be truly appreciated,
Rajdeeep.NET
|
|
|
|
|
|
Hi there,
Thanks for taking interest in my question. I am trying to create a program which will detect any removable device attached to the System and copy itself to it. Something like this:
//Pseudo code begins:
1). If G:(Removable device) contains myprogram.exe, then goto step (2)
else
Copy myprogram.exe to G:(Removable device).
2). Exit
//Pseudo code ends here
But the problem is that, how will I code the program to detect Removable devices ex. PenDrive attached to the system?
Please help,
Its really urgent,
Long Live Code Project,
Rajdeep.NET
|
|
|
|
|
Sure as hell sounds like a virus to me....
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
Sometimes truth sounds so Apparent
Have a Happy Coding.....
|
|
|
|
|
Hi Rajdeep!
you can find the removable devices like this
System.IO.DriveInfo [] drives = System.IO.DriveInfo.GetDrives ();
foreach (System.IO.DriveInfo drive in drives) {
if (drive.DriveType == DriveType.Removable) {
Console.WriteLine ("Found removable drive {0}", drive.Name);
}
}
I think you are attempting to do something malicious....
You can try and better not to distribute....
Have a Happy Coding.....
|
|
|
|
|
So if he's trying to write a virus, why are you helping him ?
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
I think you remember the previous posts of the same member....
"Why You people are not answering for my questions"
Have a Happy Coding.....
|
|
|
|
|
Hi Christian and a lot thanks to Julien,
Christian said: Christian Graus wrote: So if he's trying to write a virus, why are you helping him ?
Look, every program, whether it be a virus, worm or any other malware stuff is part of programming. I bet you know Sharpie, and I am just trying to understand the way that creep works. Other than that, I have no intention to target the .NET Framework. Got it, Sir? Thanks for your understanding.
Happy programming,
Rajdeep.NET
|
|
|
|
|
Hi Experts
I'm facing issues when i try close the excel file,it's asking me do need save the changes dialog and also still running the excel exe in task manger how i can close th file with put nay dialog and properly cleanup.
This my file op opening code
Microsoft.Office.Interop.Excel.Workbook workbooks = bodynitsApplicationClass.Workbooks.Open(filename,
0,
true,
5,
"",
"",
false,
Microsoft.Office.Interop.Excel.XlPlatform.xlWindows,
"\t",
false,
false,
0,
true,
1,
0);
Microsoft.Office.Interop.Excel.Sheets sheets = workbooks.Worksheets;
Close Method code:
Marshal.ReleaseComObject(worksheetdetail);
worksheetdetail = null;
bodynitsApplicationClass.Quit();
while (Marshal.ReleaseComObject(bodynitsApplicationClass) != 0) { }
bodynitsApplicationClass = null;
GC.Collect();
GC.WaitForPendingFinalizers();
Missing anything ?, Please help me
|
|
|
|
|
Thank you much , i found and corrected.
Here for you.
When you call the CloseMethod(your own method)
private void close()
{
if (bodynitsApplicationClass != null)
{
bodynitsApplicationClass.DisplayAlerts = false;
bodynitsApplicationClass.Workbooks.Close();
Marshal.ReleaseComObject(worksheetdetail);
worksheetdetail = null;
bodynitsApplicationClass.Quit();
Marshal.ReleaseComObject(bodynitsApplicationClass);
bodynitsApplicationClass = null;
}
}
everything dispose and close without dialog.
thank you once again.
|
|
|
|
|
I have a excel file containing 3000 records which i have to convert into a binary and
also i need to read the whole data from binary file .Can you please tell me how to do this.
|
|
|
|
|
You have to define your own binary format, if you don't have one in mind to use. Then you just write the files into it, you defined the format.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
