C# Discussion Boards - CodeProject

Re: windows mobile mouse hook

#realJSOP14-Mar-10 10:44

#realJSOP

14-Mar-10 10:44

You mean the start button in the Windows task bar?

.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001

Re: windows mobile mouse hook

umutumsu14-Mar-10 10:48

umutumsu

14-Mar-10 10:48

thanks for your interests Smile | :)

yes i meant it Smile | :)

imza...

Re: windows mobile mouse hook

#realJSOP14-Mar-10 11:08

#realJSOP

14-Mar-10 11:08

You have to use Spy++ (comes with Visual Studio) to discover the window handle of the button. You may even be able to find that on google by now, but it may be different for each version of windows (Win2K, XP, Vista, Win7).

Are you sure you want to do that?

Re: windows mobile mouse hook

umutumsu14-Mar-10 12:06

umutumsu

14-Mar-10 12:06

thank you but the sunject is about the windows mobile mouse hook, global hook with c# on windows mobile.

imza...

Re: windows mobile mouse hook

#realJSOP15-Mar-10 0:13

#realJSOP

15-Mar-10 0:13

That shouldn't matter. You have to do the same thing, and you have the same requirements/issues to deal with.

Accessing another application's Controls

cdpace14-Mar-10 2:20

cdpace

14-Mar-10 2:20

Hello,

I would like to make a program ta accesses another running exe. And I want it to check the controls on that exe and other members. Can this be done by reflection or by some other method?

Can anyone point me to where I can start?
Thank you very much for your time in advance.

Regards,
Christian Pace

Re: Accessing another application's Controls

#realJSOP14-Mar-10 3:46

#realJSOP

14-Mar-10 3:46

I would think Reflection is the place to start.

Re: Accessing another application's Controls

Ravi Bhavnani14-Mar-10 18:24

Ravi Bhavnani

14-Mar-10 18:24

cdpace wrote:
another running exe.

Is the target program something you've written (and therefore have the source code for) or are you speaking in general - i.e. do you want to be able to send keystrokes to any executing program?

/ravi

My new year resolution: 2048 x 1536
Home | Articles | My .NET bits | Freeware

ravib(at)ravib(dot)com

Problem In bind DATAGRIED

shahramkeyboard13-Mar-10 23:54

shahramkeyboard

13-Mar-10 23:54

MY CONECTION STRIN IS:

private const string CnnStr = "Data Source=(local);Initial Catalog=Library;Integrated Security=SSPI;";

MY datagrid bind is:

dataGridViewX1.DataBindings.Add(new Binding("Data Source", dsDataMember, "tblmembers"));

My Database is Sql server 2008
What is the Problem?

Re: Problem In bind DATAGRIED

OriginalGriff14-Mar-10 0:31

OriginalGriff

14-Mar-10 0:31

shahramkeyboard wrote:
What is the Problem?

That is a very good question!

Unfortunately, you forgot to tell us that bit. What is happening? What is not happening? What do you expect to happen? Does it compile? Does it throw an exception? Go on, you know you want to tell us!

You should never use standby on an elephant. It always crashes when you lift the ears. - Mark Wallace

C/C++ (I dont see a huge difference between them, and the 'benefits' of C++ are questionable, who needs inheritance when you have copy and paste) - fat_boy

Re: Problem In bind DATAGRIED

shahramkeyboard14-Mar-10 1:41

shahramkeyboard

14-Mar-10 1:41

My Book Business logic Layer is:

using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;

namespace Library_Project
{
    public class bookBL
    {
            //Book properties
            private String bookcode;
            private String bookname;
            private String shabok;
            private String nasher;
            private String motarjem;
            private String mozo;

            private bookDA bookData;

       // BUSINESS LOGIC BOOK 
       public bookBL()            
       {
         
           //Data access layer!
     
           bookData = new bookDA();

       }

       /// <SUMMARY>
       /// Property BookCode (String)
       /// </SUMMARY>
       public String Bookcode
       {
           get
           {
               return this.bookcode;
           }
           set
           {
               this.bookcode = value;


           }
       }
 
            /// <SUMMARY>
            /// Property BooktName (String)
            /// </SUMMARY>
            public String Bookname 
            {
      
                  get
                  {
                      return this.bookname;
                  }
                  set
                  {
                        try
                        {
                            this.bookname = value;

                            if (this.bookname == "")
                              {
                                    throw new Exception(
                                      "لطفا نام کتاب را وارد نمایید");
                              }
                        }
                        catch(Exception e)
                        {
                              throw new Exception(e.Message.ToString());
                        }
                  }
            }
 
            /// <SUMMARY>
            /// Property ISBN (String)
            /// </SUMMARY>
            public String Shabok
            {
                  get
                  {
                        return this.shabok;
                  }
                  set
                  {
                        //could be more checkings here eg revmove ' chars
                        //change to proper case
                        //blah blah
                        this.shabok = value;
                        if (this.shabok == "")
                        {
                              throw new Exception("لطفا شابک کتاب رو وارد نمایید");
                        }
 
                  }
            }
            /// <SUMMARY>
            /// Property Nasher (String)
            /// </SUMMARY>
            public String Nasher
            {
                  get
                  {
                      return this.nasher;
                  }
                  set
                  {
                      this.nasher = value;

                      if (this.nasher == "")
                        {
                              throw new Exception("لطفا نام ناشر را وارد نمایید");
                        }
                  }
            }
            /// <SUMMARY>
            /// Property Motarjem (String)
            /// </SUMMARY>
            public String Motarjem
            {
                get
                {
                    return this.motarjem;
                }
                set
                {
                    this.motarjem = value;


                }
            }
 
            /// <SUMMARY>
            /// Property Mozoe Ketab (String)
            /// </SUMMARY>
            public String Mozo
            {
                  get
                  {
                      return this.mozo;
                  }
                  set
                  {
                      this.mozo = value;
                      if (this.mozo == "")
                        {
                              throw new Exception("لطفا موضوع کتب رو انتخاب کنید");
                        }
 
                  }
            }
 
            /// <SUMMARY>
            /// Function Add new customer. Calls 
            /// the function in Data layer.
            /// </SUMMARY>
            public void Add()
            {
                  bookData.Add(this);
            }
 
 
            /// <SUMMARY>
            /// Function Update customer details. 
            /// Calls the function in Data layer.
            /// </SUMMARY>
            public void Update() 
            {
                  bookData.Update(this);
            }
        //------------------------------------------
            public DataSet View()
            {
                DataSet dsData = null;

                dsData = bookData.View();

                return dsData;

            }

    }
}

My Data Access Layer Is :

using System;
using System.Data.SqlClient;
using System.Data;
using System.Text;

namespace Library_Project
{
    class bookDA
    {
        private SqlConnection cnn;
        //change connection string as per the 
        //folder you unzip the files
        private const string CnnStr = "Data Source=(local);Initial Catalog=Library;Integrated Security=SSPI;";
 
        //local variables
        private String strTable="";
        private String strFields="";
        private String strValues="";
        private String insertStr="";
        
        //this needs to be changed based on Books 
        //table fields' Name of the database!
        private const String thisTable = "tblbooks";
        private const String book_code = "codebook";
        private const String book_name = "bookname";
        private const String book_nasher = "nasher";
        private const String book_motarjem = "motarjem";
        private const String book_shabok = "shabok";
        private const String book_mozo = "mozo";
        

        public bookDA()
        {

        }
       
        public bookDA(bookBL book)
       
        {
            // A reference of the business object class
        }
        
        //standard dataset function that adds a new customer

        public void Add(bookBL book)
        {

            String str = BuildAddString(book);
            
            OpenCnn();

            //Open command option - cnn parameter is imporant
            SqlCommand cmd = new SqlCommand(str, cnn);


            //execute connection
            cmd.ExecuteNonQuery();
            
            // close connection
            CloseCnn();
            
        }
        
        //standard dataset function that updates 
        //details of a customer based on ID
        public void Update(bookBL book)
        {
            OpenCnn();
            
            String selectStr = "UPDATE " + thisTable +
                " set " + book_name + " = '" + book.Bookname + "'" +
                ", " + book_nasher + " = '" + book.Nasher + "'" +
                ", " + book_motarjem + " = '" + book.Motarjem + "'" +
                ", " + book_shabok + " = '" + book.Shabok + "'" +
                ", " + book_mozo + " = '" + book.Mozo + "'" +
                " where book_code = '" + book.Bookcode + "'";

            SqlCommand cmd = new SqlCommand(selectStr, cnn);

            cmd.ExecuteNonQuery();
            
            CloseCnn();
        }
        
        //standard dataset function that finds and 
        //return the detail of a customer in a dataset
        public DataSet Find(String argStr)
        {
            DataSet ds=null;

            try
            {
                OpenCnn();
            
                String selectStr = "select * from " + thisTable + 
                              " where code_book = '" + argStr + "'";
                SqlDataAdapter da = new SqlDataAdapter(selectStr, cnn);
                ds = new DataSet();
                da.Fill(ds,thisTable);
            
                CloseCnn();
            }

            catch(Exception e)
            {
                String Str = e.Message;
            }

            return ds;
        }
        //standard dataset function that finds and 
        //return the detail of a customer in a dataset
        //----------------------------
        public DataSet View()
        {
            DataSet ds = null;

            try
            {
                OpenCnn();

                String selectStr = "select * from " + thisTable + "'";

                SqlDataAdapter da = new SqlDataAdapter(selectStr, cnn);

                ds = new DataSet();

                da.Fill(ds, thisTable);

                CloseCnn();
            }
            catch (Exception e)
            {
                String Str = e.Message;
            }

            return ds;
        }
        //----------------------------
        private void OpenCnn()
        {
            // initialise connection
            String cnnStr = CnnStr;
            cnn = new SqlConnection(cnnStr);
            // open connection
            cnn.Open();
        }

        private void CloseCnn()
        {
            // 5- step five
            cnn.Close();
        }
        
        // just a supporting function that builds 
        // and return the insert string for dataset.
        private String BuildAddString(bookBL book)
        {
            // these are the constants as 
            // set in the top of this module.
            strTable="Insert into " + thisTable;
            strFields = " (" + book_code +
            "," + book_name +
            "," + book_nasher +
            "," + book_motarjem +
            "," + book_shabok +
            "," + book_mozo + ")";
            
            //these are the attributes of the 
            //customer business object.
            strValues = " Values ( '" + book.Bookcode +
            "' , '" + book.Bookname +
            "' , '" + book.Nasher +
            "' , '" + book.Motarjem +
            "' , '" + book.Shabok +
            "' , '" + book.Mozo + "' )";

            insertStr = strTable + strFields + strValues;
            
            return insertStr;
            
        }


    }
}

I want Show Table IN datagrid
My Interface Layer is:

using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using DevComponents.DotNetBar;
using DevComponents.DotNetBar.Rendering;

namespace Library_Project
{
    public partial class ViewInfo : Form
    {
        Boolean StatusUser;
        public ViewInfo()
        {
            InitializeComponent();
        }

        private void ViewInfo_Load(object sender, EventArgs e)
        {
            //StatusUser=false;
            if (StatusUser == false)
            {
                addbook.Enabled = false;
            }

            //----------DataGrid Book Header  & View
            //---------------------------------------
            DataSet dsDataBook = null;
            bookBL thisBook = new bookBL();
            dsDataBook = thisBook.View();
            if (dsDataBook == null)
            {
            }
            else
            {
                dataGridViewX2.DataBindings.Add(new Binding("DataSource", dsDataBook, "tblbooks"));
                dataGridViewX2.Columns[0].HeaderText = "کد کتاب";
                dataGridViewX2.Columns[1].HeaderText = "نام کتاب";
                dataGridViewX2.Columns[2].HeaderText = "ناشر";
                dataGridViewX2.Columns[3].HeaderText = "مترجم";
                dataGridViewX2.Columns[4].HeaderText = "شابک";
                dataGridViewX2.Columns[5].HeaderText = "موضوع";
                //---------TextBox Books Information
                //--------------------------------------
                try
                {
                    textBox12.DataBindings.Add(new Binding("Text", dsDataBook, "tblbooks.codebook"));
                    textBox13.DataBindings.Add(new Binding("Text", dsDataBook, "tblbooks.bookname"));
                    textBox14.DataBindings.Add(new Binding("Text", dsDataBook, "tblbooks.nasher"));
                    textBox15.DataBindings.Add(new Binding("Text", dsDataBook, "tblbooks.motarjem"));
                    textBox16.DataBindings.Add(new Binding("Text", dsDataBook, "tblbooks.shabok"));
                    textBox17.DataBindings.Add(new Binding("Text", dsDataBook, "tblbooks.mozo"));
                }
                catch (Exception err)
                {
                    MessageBox.Show(err.Message.ToString());

                }
            }



        }

        private void dataGridViewX1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            textBox1.Text = dataGridViewX1.CurrentRow.Cells[0].Value.ToString();
            textBox2.Text = dataGridViewX1.CurrentRow.Cells[1].Value.ToString();
            textBox3.Text = dataGridViewX1.CurrentRow.Cells[2].Value.ToString();
            textBox4.Text = dataGridViewX1.CurrentRow.Cells[3].Value.ToString();
            textBox5.Text = dataGridViewX1.CurrentRow.Cells[4].Value.ToString();
            textBox6.Text = dataGridViewX1.CurrentRow.Cells[5].Value.ToString();
            textBox7.Text = dataGridViewX1.CurrentRow.Cells[6].Value.ToString();
            textBox8.Text = dataGridViewX1.CurrentRow.Cells[7].Value.ToString();
            textBox9.Text = dataGridViewX1.CurrentRow.Cells[8].Value.ToString();
            textBox10.Text = dataGridViewX1.CurrentRow.Cells[9].Value.ToString();

        }
    }
}

Re: Problem In bind DATAGRIED

OriginalGriff14-Mar-10 2:12

OriginalGriff

14-Mar-10 2:12

That's a lot of code to wade through! Without your database, no one can run it - not that they would, probably. Don't try to post your database here - just answer the questions:
1) What is happening when you run the program?
2) What did you expect to happen?

Re: Problem In bind DATAGRIED

shahramkeyboard14-Mar-10 2:56

shahramkeyboard

14-Mar-10 2:56

I WANT TO DATA SHOW IN DATAGRID BUT IN DATASOURCE EOOR
error is in line:

dataGridViewX2.DataBindings.Add(new Binding("DataSource", dsDataBook, "tblbooks"));

Re: Problem In bind DATAGRIED

OriginalGriff14-Mar-10 3:05

OriginalGriff

14-Mar-10 3:05

shahramkeyboard wrote:
WANT TO DATA SHOW IN DATAGRID BUT IN DATASOURCE EOOR

No need to shout!

shahramkeyboard wrote:
error is in line:
dataGridViewX2.DataBindings.Add(new Binding("DataSource", dsDataBook, "tblbooks"));

And what is the error? I assume it is an exception - what is the exception saying?

Re: Problem In bind DATAGRIED

Luc Pattyn14-Mar-10 3:24

Luc Pattyn

14-Mar-10 3:24

you have shown lots of useless code and wasted three hours already. You should have given detailed symptoms in your very first message. We still don't know what error occurred. If it is an exception, show all of the Exception.ToString() output and point at the right line of code.

Frown | :(

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

I only read code that is properly formatted, adding PRE tags is the easiest way to obtain that.

Message Closed

14-Mar-10 3:44

stancrm

14-Mar-10 3:44

Message Closed

modified 23-Nov-14 6:32am.

Re: Problem In bind DATAGRIED

shahramkeyboard14-Mar-10 4:31

shahramkeyboard

14-Mar-10 4:31

error text is:Argument Eception Was Unhandled
Cannot bind to the property or column tblmembers on the DataSource.
Parameter name: dataMember

Re: Problem In bind DATAGRIED

OriginalGriff14-Mar-10 4:51

OriginalGriff

14-Mar-10 4:51

Does this not suggest to you what the problem is?
Have a look at your database. Does it have a table called "tblmembers"? Does your connection actually connect to the database at all? Does the database exist?

Re: Problem In bind DATAGRIED

shahramkeyboard14-Mar-10 7:15

shahramkeyboard

14-Mar-10 7:15

yes
i can save record in database
but i can not view in datagrid

Re: Problem In bind DATAGRIED

0x3c014-Mar-10 11:31

0x3c0

14-Mar-10 11:31

shahramkeyboard wrote:

String selectStr = "UPDATE " + thisTable +
" set " + book_name + " = '" + book.Bookname + "'" +
", " + book_nasher + " = '" + book.Nasher + "'" +
", " + book_motarjem + " = '" + book.Motarjem + "'" +
", " + book_shabok + " = '" + book.Shabok + "'" +
", " + book_mozo + " = '" + book.Mozo + "'" +
" where book_code = '" + book.Bookcode + "'";

shahramkeyboard wrote:

String selectStr = "select * from " + thisTable +
" where code_book = '" + argStr + "'";

shahramkeyboard wrote:
String selectStr = "select * from " + thisTable + "'";

SQL injection. What happens if somebody decides to set argStr to ' DROP TABLE tblbooks;? You might want to use parameterised queries instead of just crossing your fingers and hoping that the user will play nice.

OSDev

Can You Import 1 Finished C# Project Into Another C# Project

Pmarten813-Mar-10 21:26

Pmarten8

13-Mar-10 21:26

 is it possable to import another program i built in c# into a diffrent c# project  <br />
<br />
so that i have my main program then a sub program inside <br />
<br />
<br />
ive built a web browser and download manager in to seperate projects<br />
id like to put a the two together to make one program<br />
<br />
<a href="http://tinypic.com/view.php?pic=6jpvkh&s=5">http://tinypic.com/view.php?pic=6jpvkh&s=5</a>[<a href="http://tinypic.com/view.php?pic=6jpvkh&s=5" target="_blank" title="New Window">^</a>]<br />
<br />
Ive also tried everything to post a screen shot but the html in there some copy it to browser to see what i mean

Re: Can You Import 1 Finished C# Project Into Another C# Project

Sandeep Mewara13-Mar-10 21:36

Sandeep Mewara

13-Mar-10 21:36

You can always add any existing project to another one.
Just in case, keep a backup of the projects. Use VS File menu to add 1 exisitng project to other.

Re: Can You Import 1 Finished C# Project Into Another C# Project

OriginalGriff13-Mar-10 22:48

OriginalGriff

13-Mar-10 22:48

Yes - the easiest way is:
1) Right click on you solution in the Solution explorer window.
2) Hover the mouse over "Add", and select "Existing Project".
3) Use the dialog as you would expect.

Form Header

jojoba201113-Mar-10 19:30

jojoba2011

13-Mar-10 19:30

How can i change the form Header heigh ? ( in C# )

Re: Form Header

Kristian Sixhøj14-Mar-10 1:25

Kristian Sixhøj

14-Mar-10 1:25

If you mean the titlebar, then the answer is you can't. However, you can create your own custom titlebar very easily by using components from the toolbox (panels, buttons etc.), and you can make your titlebar as big as you want. Just set the FormBorderStyle to none to hide all borders (including the titlebar), and you're ready to go.

Kristian Sixhoej
"You can always become better." - Tiger Woods

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