Click here to Skip to main content
15,944,166 members
Home / Discussions / C#
   

C#

 
GeneralRe: Multi-threaded debugging Pin
Gerry Schmitz11-Dec-22 14:50
mveGerry Schmitz11-Dec-22 14:50 
AnswerRe: Multi-threaded debugging Pin
Randor 11-Dec-22 8:46
professional Randor 11-Dec-22 8:46 
GeneralRe: Multi-threaded debugging Pin
Richard Andrew x6411-Dec-22 14:36
professionalRichard Andrew x6411-Dec-22 14:36 
PraiseRe: Multi-threaded debugging Pin
Randor 11-Dec-22 15:50
professional Randor 11-Dec-22 15:50 
QuestionRegarding a line in code Pin
vineeth s5-Dec-22 7:06
vineeth s5-Dec-22 7:06 
AnswerRe: Regarding a line in code Pin
Richard MacCutchan5-Dec-22 8:02
mveRichard MacCutchan5-Dec-22 8:02 
AnswerRe: Regarding a line in code Pin
OriginalGriff5-Dec-22 8:22
mveOriginalGriff5-Dec-22 8:22 
AnswerRe: Regarding a line in code Pin
BillWoodruff6-Dec-22 0:51
professionalBillWoodruff6-Dec-22 0:51 
GeneralRe: Regarding a line in code Pin
Richard Deeming6-Dec-22 1:08
mveRichard Deeming6-Dec-22 1:08 
GeneralRe: Regarding a line in code Pin
BillWoodruff6-Dec-22 1:29
professionalBillWoodruff6-Dec-22 1:29 
GeneralRe: Regarding a line in code Pin
Richard MacCutchan6-Dec-22 1:34
mveRichard MacCutchan6-Dec-22 1:34 
GeneralRe: Regarding a line in code Pin
BillWoodruff6-Dec-22 1:43
professionalBillWoodruff6-Dec-22 1:43 
GeneralRe: Regarding a line in code Pin
Richard MacCutchan6-Dec-22 2:03
mveRichard MacCutchan6-Dec-22 2:03 
QuestionMessage Closed Pin
29-Nov-22 0:17
zystein29-Nov-22 0:17 
AnswerRe: A Problem about Collections Pin
Richard MacCutchan29-Nov-22 0:50
mveRichard MacCutchan29-Nov-22 0:50 
AnswerRe: A Problem about Collections Pin
OriginalGriff29-Nov-22 1:47
mveOriginalGriff29-Nov-22 1:47 
QuestionSimple Broadcast Message on Local Host Pin
CodaNV28-Nov-22 21:49
CodaNV28-Nov-22 21:49 
AnswerRe: Simple Broadcast Message on Local Host Pin
OriginalGriff28-Nov-22 23:04
mveOriginalGriff28-Nov-22 23:04 
GeneralRe: Simple Broadcast Message on Local Host Pin
CodaNV28-Nov-22 23:34
CodaNV28-Nov-22 23:34 
GeneralRe: Simple Broadcast Message on Local Host Pin
jschell29-Nov-22 6:27
jschell29-Nov-22 6:27 
AnswerRe: Simple Broadcast Message on Local Host Pin
Richard Deeming28-Nov-22 23:09
mveRichard Deeming28-Nov-22 23:09 
GeneralRe: Simple Broadcast Message on Local Host Pin
CodaNV28-Nov-22 23:37
CodaNV28-Nov-22 23:37 
AnswerRe: Simple Broadcast Message on Local Host Pin
Gerry Schmitz1-Dec-22 5:27
mveGerry Schmitz1-Dec-22 5:27 
AnswerRe: Simple Broadcast Message on Local Host Pin
CodaNV11-Dec-22 16:09
CodaNV11-Dec-22 16:09 
QuestionMy winform resize when i open an OleDbConnection Pin
Le@rner27-Nov-22 18:42
Le@rner27-Nov-22 18:42 
i am using OleDbConnection to read excel files.

excel file is read properly.

but my form is resize and all text looks bigger and buggy when i open the connection.

i really dont understand whats happend.

please help me for this.

thanks in advance.

C#
DataTable sheet1 = new DataTable("Excel Sheet");
               OleDbConnectionStringBuilder csbuilder = new OleDbConnectionStringBuilder();
               csbuilder.Provider = "Microsoft.ACE.OLEDB.12.0";
               csbuilder.DataSource = filename;
               csbuilder.Add("Extended Properties", "Excel 12.0 Xml;HDR=YES");
               string selectSql = @"SELECT * FROM [Sheet1$]";



               using (OleDbConnection connection = new OleDbConnection(csbuilder.ConnectionString))


               using (OleDbDataAdapter adapter = new OleDbDataAdapter(selectSql, connection))
               {

                   connection.Open();
                   adapter.Fill(sheet1);

                   connection.Close();


               }

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.