Click here to Skip to main content
15,925,602 members
Home / Discussions / C#
   

C#

 
AnswerRe: Regrding Control Pin
Mirko19803-Mar-10 4:05
Mirko19803-Mar-10 4:05 
QuestionCreating ShortCut on Desktop. Pin
Anil Kumar.Arvapalli2-Mar-10 21:57
Anil Kumar.Arvapalli2-Mar-10 21:57 
QuestionCustom Busy Window. Pin
The_Collector2-Mar-10 21:30
The_Collector2-Mar-10 21:30 
AnswerRe: Custom Busy Window. Pin
The Man from U.N.C.L.E.2-Mar-10 22:37
The Man from U.N.C.L.E.2-Mar-10 22:37 
GeneralRe: Custom Busy Window. Pin
The_Collector3-Mar-10 14:32
The_Collector3-Mar-10 14:32 
GeneralRe: Custom Busy Window. Pin
The Man from U.N.C.L.E.3-Mar-10 22:43
The Man from U.N.C.L.E.3-Mar-10 22:43 
GeneralRe: Custom Busy Window. Pin
The Man from U.N.C.L.E.3-Mar-10 23:53
The Man from U.N.C.L.E.3-Mar-10 23:53 
GeneralRe: Custom Busy Window. Pin
The Man from U.N.C.L.E.7-Mar-10 23:31
The Man from U.N.C.L.E.7-Mar-10 23:31 
GeneralRe: Custom Busy Window. Pin
The_Collector8-Mar-10 17:12
The_Collector8-Mar-10 17:12 
GeneralRe: Custom Busy Window. Pin
The Man from U.N.C.L.E.8-Mar-10 23:22
The Man from U.N.C.L.E.8-Mar-10 23:22 
AnswerRe: Custom Busy Window. Pin
Kevin Marois5-Mar-10 13:03
professionalKevin Marois5-Mar-10 13:03 
GeneralRe: Custom Busy Window. Pin
The_Collector8-Mar-10 17:13
The_Collector8-Mar-10 17:13 
Questionhow to disable/enable toolstrip menu item [modified] Pin
crisjala2-Mar-10 21:27
crisjala2-Mar-10 21:27 
AnswerMessage Closed Pin
2-Mar-10 22:09
stancrm2-Mar-10 22:09 
GeneralRe: how to disable/enable toolstrip menu item Pin
crisjala3-Mar-10 14:06
crisjala3-Mar-10 14:06 
QuestionEvents from c# DLL not visible in VB7 project (Visual Studio 2008) Pin
hoernchenmeister2-Mar-10 21:22
hoernchenmeister2-Mar-10 21:22 
AnswerRe: Events from c# DLL not visible in VB7 project (Visual Studio 2008) Pin
Dave Kreskowiak3-Mar-10 3:37
mveDave Kreskowiak3-Mar-10 3:37 
GeneralRe: Events from c# DLL not visible in VB7 project (Visual Studio 2008) Pin
hoernchenmeister3-Mar-10 5:49
hoernchenmeister3-Mar-10 5:49 
QuestionUnicode Pin
Maninandan2-Mar-10 21:18
Maninandan2-Mar-10 21:18 
QuestionFind a word using regular expression in c# Pin
PeriyasamyRamachandran2-Mar-10 19:48
PeriyasamyRamachandran2-Mar-10 19:48 
AnswerRe: Find a word using regular expression in c# Pin
sanforjackass2-Mar-10 19:51
sanforjackass2-Mar-10 19:51 
AnswerRe: Find a word using regular expression in c# Pin
Arindam Tewary2-Mar-10 20:26
professionalArindam Tewary2-Mar-10 20:26 
GeneralRe: Find a word using regular expression in c# Pin
PeriyasamyRamachandran2-Mar-10 20:28
PeriyasamyRamachandran2-Mar-10 20:28 
Questiondatagridviewrow conversion Pin
Member 5903102-Mar-10 19:28
Member 5903102-Mar-10 19:28 
Questionhow to write to a specific range in excel ? [modified] Pin
tonyonlinux2-Mar-10 19:15
tonyonlinux2-Mar-10 19:15 
For some reason this code is not writing to my excel file and I can't figure out why.
I have a premade template and it has a worksheet in it called bsheet and I also took and selected my range and hit insert/name and gave it the name btable

I then put this in a button click event to test but the xls is not effected what might i be doing wrong?
private void button1_Click(object sender, EventArgs e)
        {
            string connectionString = "Provider=Microsoft.Jet.OleDb.4.0; data source=c:\\BookList.xls; Extended Properties=Excel 8.0;";
            string selectString = "INSERT INTO btable VALUES('12345′, 'Acme Inc', 'Acme Way', 'CA')";

            OleDbConnection con = new OleDbConnection(connectionString);
            OleDbCommand cmd = new OleDbCommand(selectString, con);

            try
            {
                con.Open();
                cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
            finally
            {
                con.Dispose();
            }
        }
modified on Wednesday, March 3, 2010 1:52 PM

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.