Re: Problem Calling CheckListBox - C# Discussion Boards

Re: MS word tables using C#

6-Aug-09 22:09

i'll paste you some of my code and hope it will help you

public void insertTable(Word.Document oDoc, int nr, int nrMoment)
     {

       strct.bla ++;
         object oMissing = System.Reflection.Missing.Value;
         object oEndOfDoc = "\\endofdoc"; /* \endofdoc is a predefined bookmark */
         //object myBook = "clasa";
         Word.Table oTable;
         Word.Table oTable1;
         Object style = "Table Grid v2";
         Word.Range rngC;

         Object defaultTableBehavior = Type.Missing;
         Object autoFitBehavior = Type.Missing;


         object rng = oDoc.Bookmarks.get_Item(ref oEndOfDoc).Range;
         object oPageBreak = Word.WdBreakType.wdPageBreak;
         Word.Paragraph oPara = oDoc.Paragraphs.Add(ref rng);
         oPara.Range.InsertBreak(ref oPageBreak);
         oPara.Range.Font.Bold = 1;
         oPara.Range.Font.Size = 14;
         oPara.Range.Font.Name = "Book Antiqua";
         oPara.Range.set_Style(ref styleHeading2);
         oPara.Range.Text ="M" + strct.nr[1].ToString() +" "+ strct.titluCadru[strct.bla].ToString();
         oPara.Range.InsertParagraphAfter();
         //
         Word.Range wrdRng = oDoc.Bookmarks.get_Item(ref oEndOfDoc).Range;
        // .object.object brk = wdPageBreak


         oTable = oDoc.Tables.Add(wrdRng, 1, 1, ref defaultTableBehavior, ref autoFitBehavior);
         oTable.set_Style(ref style);
         oTable.ApplyStyleLastColumn = false;
         oTable.Range.ParagraphFormat.SpaceAfter = 5;
         rngC = oTable.Cell(1, 1).Range;
         rngC.Font.Name = "Book Antiqua";
         rngC.Font.Bold = 0;
         rngC.Text = "Obiectivele educaţionale  acoperite de moment, submoment şi itemul de învăţare \r\n Obiective operaţionale";
         rngC.ParagraphFormat.SpaceAfter = 3;

         //rngC.InsertAfter(Environment.NewLine);

         rng = oDoc.Bookmarks.get_Item(ref oEndOfDoc).Range;
         //wrdRng = oDoc.Bookmarks.get_Item(ref oEndOfDoc).Range;
         Word.Paragraph oPara1;
         oPara1 = oDoc.Paragraphs.Add(ref rng);
         oPara1.Range.Font.Bold = 1;
         oPara1.Range.Font.Name = "Book Antiqua";
         oPara1.Range.Text = "O1";// + nrMoment.ToString();
         oPara1.Format.SpaceAfter = 2;


         wrdRng = oDoc.Bookmarks.get_Item(ref oEndOfDoc).Range;
         oTable1 = oDoc.Tables.Add(wrdRng, nr + 11, 2, ref defaultTableBehavior, ref autoFitBehavior);
         oTable1.set_Style(ref style);
         oTable1.ApplyStyleLastColumn = false;
         oTable1.Range.ParagraphFormat.Alignment = Microsoft.Office.Interop.Word.WdParagraphAlignment.wdAlignParagraphLeft;
         oTable1.Range.ParagraphFormat.SpaceAfter = 6;

         rngC = oTable1.Cell(1, 1).Range;
         rngC.Font.Bold = 1;
         rngC.Font.Name = "Book Antiqua";
         rngC.Text = "Descriere";


     }
 }

to use a certain table you can use a bookmark, create it from scratch, or put it in an array (haven't used this last one). Hope this helps

Member 41540747-Aug-09 7:58

Member 4154074

7-Aug-09 7:58

Sorry if i seem a bit thick, could you paste an example of how to call that routine, what would you place in the first argument? This is all rather new to me.

Problem Calling CheckListBox

Member 28652716-Aug-09 7:31

Member 2865271

6-Aug-09 7:31

Can someone help with an issue I'm having with a CheckListBox.

I have two Forms lets say Form1 - Form2, Form2 contains a CheckListBox that accepts input from the user I've also created a Foreach statement to Iterate through the CheckListBox on Form2 Form1 has a button coded to call Form2 Foreach method everything seems to work except for one problem when making the call to Form2 the Foreach method indicates the CheckListBox is Null although the CheckListbox contains item's, so as a test I created a button on Form2 and wired it to call the Foreach method on Form2 and all works the Foreach Method see's the Item's and perform the Iteration on all Item's where as making the call from Form1 indicate a Null CheckListBox. I'm not sure if this is a Threading issue do to the fact Form1 is creating a new Object to access Form2 Foreach method ?

FORM1

button1_Click(object sender, EventArgs e)  
{
    List.Form2 List = new List.From2();
      List.ChkList();
}

FORM 2

Public void ChkList()
 
   foreach (string s in checkedListBox1.Items)
   
    {
        if (s.Equals(dt))
         { Do Work
    }

FORM2 Test Button.

button2_Click(object sender, EventArgs e)

{
   List.Form2 List = new List.From2();
      List.ChkList();
}

Andrew Rissing6-Aug-09 7:56

Andrew Rissing

6-Aug-09 7:56

Works without a problem on my system using the setup you described. It shouldn't be a threading issue based on what you said. It more than likely is an ordering issue of when the items in the list get populated. If you populate them on Load (only called when the Form is shown) or via some other event, those won't be called on construction. So, you might want to start there. Just place breakpoints around the sections that load data into that list and go from there.

Luc Pattyn6-Aug-09 7:56

Luc Pattyn

6-Aug-09 7:56

the situation is completely unclear.

is it From2 or Form2?
is the "List" form shown at all, I see no List.Show()?
where is the declaration of checkedListBox1? and its assignment?
etc etc

and how could it be a threading issue, you haven't shown anything related to threads?

BTW: your button2_Click() method probably proves nothing as it (1) only can work after its Form is fully loaded and shown, (2) creates yet another "From2", and (3) is located inside Form2 class, so it is completely different from what button1_click() is doing.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

Member 28652716-Aug-09 11:48

Member 2865271

6-Aug-09 11:48

Thanks Luc, Im new to the forum and was in a rush and left out details on the other hand the Info Dave and Andrew left might be enough to get me back on track.

DaveyM696-Aug-09 11:14

DaveyM69

6-Aug-09 11:14

What you're trying to do, or at least the way you're trying to do it, seems a little bit strange.

This code works for me. Just a default project with a Form1 and Form2 added - everything else in done in code.

// Form1.cs

using System;
using System.Windows.Forms;

public partial class Form1 : Form
{
    private Form2 form2;

    public Form1()
    {
        InitializeComponent();
        Button button = new Button();
        Controls.Add(button);
        button.Click += button_Click;
    }

    void button_Click(object sender, EventArgs e)
    {
        CheckForm2Instance();
        form2.DoStuffWithCheckBox();
    }

    void CheckForm2Instance()
    {
        if (form2 == null)
        {
            form2 = new Form2();
            form2.FormClosing += form2_FormClosing;
        }
        form2.Show();
    }

    void form2_FormClosing(object sender, FormClosingEventArgs e)
    {
        form2.FormClosing -= form2_FormClosing;
        form2 = null;
    }
}

// Form2.cs

using System.Windows.Forms;

public partial class Form2 : Form
{
    public Form2()
    {
        InitializeComponent();
        CheckedListBox checkedListBox = new CheckedListBox();
        Controls.Add(checkedListBox);
        checkedListBox.Items.AddRange(new object[] { "A", "B", "C" });
    }

    public void DoStuffWithCheckBox()
    {
        MessageBox.Show("Doing Stuff");
    }
}

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)

Member 28652716-Aug-09 15:01

Member 2865271

6-Aug-09 15:01

Dave that worked I modified just a bit of the code and it worked out.

Thanks

read Sql DataBase Error

toby316-Aug-09 7:28

6-Aug-09 7:28

Hi there i'm trying to read data from SQL

This is my Class

class Sql
    {
       public SqlConnection sqlCon;
        public void connectToSql (string adr)
        {
            sqlCon = new SqlConnection(adr);
            
            try
            {
                sqlCon.Open();
            }
            catch (Exception e)
            {
                string str = e.ToString();
                  using (StreamWriter sw = new StreamWriter ("out1.txt"))
                {
                    sw.WriteLine (e.ToString());
                }
            }

        }

        public void readSql(String col, String tab)
        {
            try
            {
                SqlDataReader sqlRead = null;
                SqlCommand sqlCmd = new SqlCommand("SELECT * FROM " + tab + " WHERE Column =" + col, sqlCon);
                sqlRead = sqlCmd.ExecuteReader();
                using (StreamWriter sw = new StreamWriter ("out.txt"))
                {
                    sw.WriteLine(sqlRead.ToString());
                }
            }
            catch (Exception e)
            {
                  using (StreamWriter sw = new StreamWriter ("out.txt"))
                {
                    sw.WriteLine (e.ToString());
                }
            }
        }

        public void exitSql()
        {
            sqlCon.Close();
        }
    }
    }

And this is the error that i get

System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at longliveSorin.functiiSql.Sql.connectToSql(String adr) in D:\work\cte\C#\cifru\longliveSorin\longliveSorin\functiiSql\Sql.cs:line 19

Can someone help me plz

musefan6-Aug-09 7:32

musefan

6-Aug-09 7:32

Could be your connection string, can you post it please

Life goes very fast. Tomorrow, today is already yesterday.

toby316-Aug-09 7:34

6-Aug-09 7:34

 private Sql sql = new Sql();
public Form1()
{
    InitializeComponent();
}

private void Form1_Load(object sender, EventArgs e)
{

}

private void button1_Click(object sender, EventArgs e)
{
    String adr = @"Address=localhost;Initial Catalog=Cifru;connection timeout=10;";
    sql.connectToSql(adr);
    sql.readSql("NumePrenume","contacte");
    sql.exitSql();
}

I tried it without the @ but it still didn't work

Ashfield6-Aug-09 8:51

Ashfield

6-Aug-09 8:51

Looks like your connection syring is all wrong. Take s visit to connectionstrings.com/[^]

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

dan!sh 6-Aug-09 8:52

dan!sh

6-Aug-09 8:52

Check if your connection string is correct. You can find all sorts of connection strings here[^].

It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD

toby317-Aug-09 0:33

7-Aug-09 0:33

Thank you i'll take a look

C# PDB symbols

nachiket076-Aug-09 7:23

nachiket07

6-Aug-09 7:23

Hi,
There is a compiler switch to create pdb symbols in VC++. What needs to be done to create symbols for a C# app?
I couldn't find any setting in the project properties page. I have noticed that when I compile the project, it creates a pdb in
the debug/release folder.

MSDN says we can use csc /debug /pdb:tt t.cs to create PDB, but is there a way to create PDBs from the GUI?

Thanks in advance,
Nachiket

Eddy Vluggen6-Aug-09 8:19

Eddy Vluggen

6-Aug-09 8:19

Yes, by compiling your code.

The file maps the binary back to the source-code, and is as such, dependent on the binary. Without the binary there is nothing to map.

nachiket076-Aug-09 8:24

nachiket07

6-Aug-09 8:24

Thanks Eddy.

So what kind of symbols are created when I compile the code? public or private?
I am looking for a way to create private symbols so that I can see source file and line number information from a crash dump through windbg.

Eddy Vluggen6-Aug-09 8:46

Eddy Vluggen

6-Aug-09 8:46

I just copy them to the bin\debug-directory. You might be interested in this[^] article.

I are Troll Smile | :)

nachiket076-Aug-09 8:54

nachiket07

6-Aug-09 8:54

Thanks again.