Click here to Skip to main content
15,891,864 members
Home / Discussions / C#
   

C#

 
QuestionEasiest way to use menustrip as a tabcontrol Pin
Husker4719-May-07 6:37
Husker4719-May-07 6:37 
AnswerRe: Easiest way to use menustrip as a tabcontrol Pin
Scott Dorman19-May-07 7:22
professionalScott Dorman19-May-07 7:22 
GeneralRe: Easiest way to use menustrip as a tabcontrol Pin
PIEBALDconsult19-May-07 11:19
mvePIEBALDconsult19-May-07 11:19 
GeneralRe: Easiest way to use menustrip as a tabcontrol Pin
Scott Dorman19-May-07 13:17
professionalScott Dorman19-May-07 13:17 
GeneralRe: Easiest way to use menustrip as a tabcontrol Pin
Husker4723-May-07 5:06
Husker4723-May-07 5:06 
QuestionExtracting email address from websites Pin
Jahedur Rahman Chowdhury19-May-07 6:29
Jahedur Rahman Chowdhury19-May-07 6:29 
AnswerRe: Extracting email address from websites Pin
Scott Dorman19-May-07 7:24
professionalScott Dorman19-May-07 7:24 
QuestionAdventures in Excel Pin
rahvyn619-May-07 6:27
rahvyn619-May-07 6:27 
Hi All;

I'm working on a simple desktop application that does the following:

1 - Reads in an Excel spreadsheet into a DataGridView as follows:

try
{
string strConnectionString = "";
if (header)
{
strConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + strFilePath + ";Jet OLEDB:Engine Type=5;" +
"Extended Properties=\"Excel 8.0;HDR=Yes\"";
}
else
{
strConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + strFilePath + ";Jet OLEDB:Engine Type=5;" +
"Extended Properties=\"Excel 8.0;HDR=No\"";
}
OleDbConnection cnCSV = new OleDbConnection(strConnectionString);
cnCSV.Open();
OleDbCommand cmdSelect = new OleDbCommand(@"SELECT * FROM [Sheet1$]", cnCSV);
OleDbDataAdapter daCSV = new OleDbDataAdapter();
daCSV.SelectCommand = cmdSelect;
dtCSV = new DataTable("Batch");
daCSV.Fill(dtCSV);
cnCSV.Close();
daCSV = null;
return dtCSV;

}

2 - allows the user to add columns, delete columns, and re-order columns. (I dont update the underlying datatable as if they add a column, it is unbound. But not sure if this is correct)
3 - I then parse through the grid verifying the values in the cells match a specified length, type, etc.
4 - output the grid values to a csv file.

Everything is pretty much working except for parsing the values, and outputing the csv. After the columns are re-ordered, it seems like they retain their original index. So when I parse through like this:

for (int r = 0; r <= dgvMain.Rows.Count - 2; r++)
{
for (int c = 0; c <= dgvMain.Columns.Count; c++)
{
value = dgvMain.Rows[r].Cells[c].Value.ToString();
}
}
The variable value contains the value of the original cell. In otherwords, say I have 2 columns, 0 and 1. I then switch their positions, so now have 1, 0. If I parse through as above, I will still be looking at them as 0, 1, not 1, 0. Or, if I move column 10 to position 1, and read that, I wont read the value until c = 10, but I need to read it when c = 1. What I need to do is to reset the indexes of the columns to be in the order that they are displayed. Has anyone done anything like this before?
AnswerRe: Adventures in Excel Pin
rahvyn619-May-07 9:20
rahvyn619-May-07 9:20 
Questionhow to provide UPDATE PREFERENCES (daily./monthly./yearly) to our c# windows appliction Pin
pashitech19-May-07 2:28
pashitech19-May-07 2:28 
AnswerRe: how to provide UPDATE PREFERENCES (daily./monthly./yearly) to our c# windows appliction Pin
Scott Dorman19-May-07 4:57
professionalScott Dorman19-May-07 4:57 
QuestionHelp in replacing table of web in Windows application Pin
EEmaan19-May-07 2:10
EEmaan19-May-07 2:10 
AnswerRe: Help in replacing table of web in Windows application Pin
Vikram A Punathambekar19-May-07 8:11
Vikram A Punathambekar19-May-07 8:11 
Questionis it is possible to track the installation date ? Pin
pashitech19-May-07 0:19
pashitech19-May-07 0:19 
AnswerRe: is it is possible to track the installation date ? Pin
Scott Dorman19-May-07 5:01
professionalScott Dorman19-May-07 5:01 
Questionchat Pin
Rhydo19-May-07 0:09
Rhydo19-May-07 0:09 
AnswerRe: chat Pin
Christian Graus19-May-07 0:30
protectorChristian Graus19-May-07 0:30 
QuestionCombining Between a DataGridView and a TreeView Pin
OlaMohammed19-May-07 0:06
OlaMohammed19-May-07 0:06 
Questionclsdataclass Pin
Rhydo19-May-07 0:05
Rhydo19-May-07 0:05 
AnswerRe: clsdataclass Pin
Christian Graus19-May-07 0:33
protectorChristian Graus19-May-07 0:33 
QuestionHow can I access to a resource that is created in another thread? Pin
ali_reza_zareian18-May-07 23:46
ali_reza_zareian18-May-07 23:46 
AnswerRe: How can I access to a resource that is created in another thread? Pin
Dave Kreskowiak19-May-07 18:19
mveDave Kreskowiak19-May-07 18:19 
QuestionHow to kill exe ? Windows.NET Pin
NanaAM18-May-07 22:27
NanaAM18-May-07 22:27 
AnswerRe: How to kill exe ? Windows.NET Pin
Giorgi Dalakishvili18-May-07 23:09
mentorGiorgi Dalakishvili18-May-07 23:09 
GeneralRe: How to kill exe ? Windows.NET Pin
NanaAM19-May-07 2:01
NanaAM19-May-07 2:01 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

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