C# Discussion Boards - CodeProject

WinForms: How to add any control to a DataGrid column

5-Aug-05 3:24

zaboboa,

Well there is no quick and easy way to do this. However you can do this in two ways. Events on a control are hooked to your function in initialization phase through a simple += statement. before you execute your code you could un hook the event handler add the row and then hook the event handler back in. this is a rather crude way to handle this.

the other option is maintain a flag in your code. when adding the row before adding the row set the flag. check this in the columnchanged event handler. if it is set then ignore the event. after the row is added reset this flag.

Hope this helps...

Prady

Re: Suppress an Event

Alomgir Miah5-Aug-05 3:54

Alomgir Miah

5-Aug-05 3:54

See the example

this.dataGridTextBoxColumnExValue.TextBox.KeyPress -= new KeyPressEventHandler(this.TextBoxFloatValueKeyPress);

//Do your stuff

this.dataGridTextBoxColumnExValue.TextBox.KeyPress += new KeyPressEventHandler(this.TextBoxFloatValueKeyPress);

Live Life King Size
Alomgir Miah

Re: Suppress an Event

zaboboa5-Aug-05 4:50

zaboboa

5-Aug-05 4:50

Thank you.

That's excactly what I am doing, is to keep a flag.

SebbaP5-Aug-05 2:41

SebbaP

5-Aug-05 2:41

Hello,

I have been trying to add a custom control to one of the columns in my DataGrid, but I have failed so far. What I want to do is to add my custom control (or any other standard control for that matter) to the control collection of a certain column style. When I do so, the control will not appear until I click on any of the cells, which is supposed to show the control. Is it even possible to add controls to the control collection of textbox column styles, considering what I want to do? If you have any ideas, please use my sample code below as a starting point and reply to me with a modified version of it.

Also, I am curious to know what causes this kind of weird behaviour. I would have expected the button to appear right away, but that's obviously not the case WTF | :WTF:

. Does anyone have extremely detailed knowledge about how and when controls are painted? I would like to know the exact chain of events that causes this behaviour and why.

Thank you for your patience, I hope you can help!! (I wont settle for a workaround Wink | ;)

)

<br />
using System;<br />
using System.Drawing;<br />
using System.Collections;<br />
using System.ComponentModel;<br />
using System.Windows.Forms;<br />
using System.Data;<br />
<br />
namespace WindowsApplication2<br />
{<br />
  public class Form1 : System.Windows.Forms.Form<br />
  {<br />
    private System.ComponentModel.Container components = null;<br />
<br />
    DataGrid grid = new DataGrid();<br />
    DataTable table;<br />
<br />
    public Form1()<br />
    {<br />
      InitializeComponent();<br />
<br />
      this.Controls.Add( this.grid );<br />
<br />
      // create the table<br />
      this.table = new DataTable("A_Table");<br />
      this.table.Columns.Add( new DataColumn("TextColumn", typeof(string)) );<br />
      this.table.Columns.Add( new DataColumn("ButtonColumn", typeof(string)) );<br />
<br />
      // bind the table to the grid<br />
      DataSet dataSet = new DataSet();<br />
      dataSet.Tables.Add( this.table );<br />
      this.grid.SetDataBinding(dataSet, "A_Table");<br />
<br />
      // set up column style...<br />
      DataGridTableStyle tStyle = new DataGridTableStyle();<br />
      tStyle.MappingName = "A_Table";<br />
      // ...for the left column<br />
      DataGridTextBoxColumn textStyle = new DataGridTextBoxColumn();<br />
      textStyle.MappingName = "TextColumn";<br />
      textStyle.HeaderText= table.Columns[0].Caption;<br />
      textStyle.Width = 200;<br />
      textStyle.ReadOnly = true;<br />
      tStyle.GridColumnStyles.Add(textStyle);<br />
		<br />
      // ...for the right column<br />
      textStyle = new DataGridTextBoxColumn();<br />
      textStyle.MappingName = "ButtonColumn";<br />
      textStyle.HeaderText= table.Columns[1].Caption;<br />
      textStyle.Width = 80;<br />
      textStyle.ReadOnly = true;<br />
<br />
      // add a bytton to the right column's control collection<br />
      Button b = new Button();<br />
      b.Text = "OK";<br />
      b.Dock = DockStyle.Fill;<br />
      textStyle.TextBox.Controls.Add( b );<br />
      tStyle.GridColumnStyles.Add(textStyle);<br />
			<br />
      // set size and location of grid<br />
      tStyle.PreferredRowHeight = 20;<br />
      this.grid.TableStyles.Add(tStyle);<br />
      this.grid.Location = new Point(10, 10);<br />
      this.grid.Size = new Size(400, 100);<br />
			<br />
      // set size of form<br />
      this.Width = 420;<br />
      this.Height = 200;<br />
			<br />
      // add some data to the table<br />
      DataRow row = table.NewRow();<br />
      row[0] = "There should be a button to the right";<br />
      row[1] = "";<br />
      table.Rows.Add(row);<br />
    }<br />
<br />
    protected override void Dispose( bool disposing )<br />
    {<br />
      if( disposing )<br />
      {<br />
        if (components != null) <br />
        {<br />
           components.Dispose();<br />
        }<br />
      }<br />
      base.Dispose( disposing );<br />
    }<br />
<br />
    private void InitializeComponent()<br />
    {<br />
      this.components = new System.ComponentModel.Container();<br />
      this.Size = new System.Drawing.Size(300,300);<br />
      this.Text = "Form1";<br />
    }<br />
<br />
    [STAThread]<br />
    static void Main() <br />
    {<br />
      Application.Run(new Form1());<br />
    }<br />
  }<br />
}<br />

Tab control

deep75-Aug-05 2:26

deep7

5-Aug-05 2:26

i'm working on window application.
I have a usercontrol which contains a datagrid and two buttons for save and close.
When the code is being executed, i use tab key to go from one control to another. However, when i'm in the datagrid control, i enter some details and then press the tab key, it doesn't go to the save button. It just keeps going in the datagrid. It doesn't come out. I've set the tab index for the controls, but they dont seem to have any effect once it goes in the datagrid control...
plz tell me wot to do..
any help is appreciated..
thanks

Re: Tab control

Alomgir Miah5-Aug-05 3:58

Alomgir Miah

5-Aug-05 3:58

You need to subclass DataGrid control, DataGridTextBox control.

In the Derived classes do the following

public override bool PreProcessMessage(ref Message msg)
{
Keys keyCode = (Keys)(int) msg.WParam & Keys.KeyCode;
switch (keyCode)
{
case Keys.Tab:
return true;
default:
break;
}
return base.PreProcessMessage(ref msg);
}

Live Life King Size
Alomgir Miah

Need help with a data set problem..

corkey195-Aug-05 1:38

corkey19

5-Aug-05 1:38

I am trying to get the maximum value in a colum of a data table the table layout is as follows:

dt = new DataTable("Contact");<br />
			///******Primary Key<br />
			dc = new DataColumn("Contact_Number",System.Type.GetType("System.Int32"));<br />
			dt.Columns.Add(dc);<br />
			dc = new DataColumn("JobTitle",System.Type.GetType("System.String"));<br />
			dt.Columns.Add(dc);<br />
			dc = new DataColumn("CompanyName",System.Type.GetType("System.String"));<br />
			dt.Columns.Add(dc);<br />
			dc = new DataColumn("WebPage",System.Type.GetType("System.String"));<br />
			dt.Columns.Add(dc);<br />
			dc = new DataColumn("Department",System.Type.GetType("System.String"));<br />
			dt.Columns.Add(dc);<br />
			dc = new DataColumn("Office",System.Type.GetType("System.String"));<br />
			dt.Columns.Add(dc);<br />
			dc = new DataColumn("Profession",System.Type.GetType("System.String"));<br />
			dt.Columns.Add(dc);<br />
			dc = new DataColumn("ManagersName",System.Type.GetType("System.String"));<br />
			dt.Columns.Add(dc);<br />
			dc = new DataColumn("PAName",System.Type.GetType("System.String"));<br />
			dt.Columns.Add(dc);<br />
			dc = new DataColumn("Catagory",System.Type.GetType("System.String"));<br />
			dt.Columns.Add(dc);<br />
			dc = new DataColumn("AddressStreet",System.Type.GetType("System.String"));<br />
			dt.Columns.Add(dc);<br />
			dc = new DataColumn("AddressCity",System.Type.GetType("System.String"));<br />
			dt.Columns.Add(dc);<br />
			dc = new DataColumn("AddressState",System.Type.GetType("System.String"));<br />
			dt.Columns.Add(dc);<br />
			dc = new DataColumn("AddressZip",System.Type.GetType("System.String"));<br />
			dt.Columns.Add(dc);<br />
			dc = new DataColumn("AddressRegion",System.Type.GetType("System.String"));<br />
			dt.Columns.Add(dc);<br />
<br />
			//Setup primary keys and addtable to dataset<br />
			dt.PrimaryKey = new DataColumn[]{dt.Columns["Contact_Number"]};<br />
			this.contactsDataSet.Tables.Add(dt);

I am using the compute function but I get an error saying type cast invalid

int nextNumber<br />
=(int)contactsDataSet.Tables["Contact"].Compute("MAX(Contact_Number)","");

I need to find the max value in order to use it as a primary key,

Any suggestions would be great...

How do we List Down All User Names and Passwords in SQL Server?

pubududilena5-Aug-05 1:24

pubududilena

5-Aug-05 1:24

hi all,
I need to obtain All users and their passwords of SQL Server 2000.

Can I do that?

thanks in advance.

Re: How do we List Down All User Names and Passwords in SQL Server?

Dave Kreskowiak5-Aug-05 4:50

Dave Kreskowiak

5-Aug-05 4:50

Usernames, yes. Passwords, no.

Think about the HUGE security violation that would be if that function call got into the wrong hands.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Loop through combobox items

fady_sayegh5-Aug-05 0:06

fady_sayegh

5-Aug-05 0:06

hi to all,

how can i loop through all the items of a combobox and get the index, value and text of each item

best regards and thanks in advance

fady

Pradyumna Gogte5-Aug-05 0:20

5-Aug-05 0:20

Hi fady,

The combobox has a property called Items. This is a collection so you could use something like this:

foreach(String str in combobox.Items)
{
...
}

Prady

Guffa5-Aug-05 0:21

Guffa

5-Aug-05 0:21

The combobox has an Items collection. Each item in the collection has properties for the text and value.

---
b { font-weight: normal; }

fady_sayegh5-Aug-05 0:29

fady_sayegh

5-Aug-05 0:29

thanks to your reply,

i tried to use the items but i doesn't work because my combo is binded with a dataset

comboBox1.DisplayMember = "LIBL";
comboBox1.ValueMember = "ID";
comboBox1.DataSource = oDs.Tables[0];

the dataset is filled through a stored procedure

best regards,

fady

capturing the right click and paste mouse events

Guffa5-Aug-05 4:43

Guffa

5-Aug-05 4:43

When you bind the data, the Items collection is populated. Then it doesn't matter where the data came from.

---
b { font-weight: normal; }

pjoseph9994-Aug-05 23:33

pjoseph999

4-Aug-05 23:33

Could someone please give me an example in c# on capturing the right click and paste mouse events from any forms/applications. I can capture/monitor this using the keyboard but cannot do so when using mouse cut/copy and paste. Need help please.

I looked at the Globalhooksdemo (project in code project) in c# but only helped me on keyboard cut/copy and paste.

Thanks in advance

.net equivalent of ddx + q about anchoring

roel_4-Aug-05 22:58

roel_

4-Aug-05 22:58

Hi,

I'm quite new to c# and windows.forms, so these are probably very basic questions Smile | :)

The first one is: what's the .net equivalent of ddx in mfc? Meaning, how do I associate the values of textboxes and checkboxes etc on forms with members of that forms? I've found ControlBindingsCollection and friends but that seems to be only for binding to databases, I want to bind to normal variables.

Secondly, in my dialog I have the following:

|---|       |---|
| A |  XXX  | B |
|---|       |---|

where the two squares A and B are list boxes and the XXX is a button. Now what I want is when the dialog is resized that the button stays the same size and that the two listboxes take up the rest of the space, so that the distance between the right of A and the left of the button stays the same, and the distance between the left of B and the right of the button stays the same as well. I cannot simply set the 'Anchor' property of A and B to 'Left,Top,Right' because that will make them overlap each other, which in turn is caused by the fact that the Anchor is relative to the parent container which is the dialog in this case. How do I do this? (Apart from overriding the dialog's OnSize and positioning everything manually).

cheers,

roel

Pradyumna Gogte5-Aug-05 0:17

5-Aug-05 0:17

Hi Roel,

First you have a much better option in c# than the one offered by MFC through the ddx functions. c# or .net controls on your form are true objects and not wrappers as in case of the of MFC. You could directly access the value of the control so in a sence there is no real need to have another variable in the form to store it. You could do something like TextBox.Text to access the value any time you want. However if you still wanted the MFC like functionality then you could probably hook the form validate event and code the actual transfer of data from control to variable manually. Why have this over head when you can access the values directly?

For the second problem you cannot do this through setting properties. You have to do this programatically.

Cheers,
Prady

roel_5-Aug-05 1:17

roel_

5-Aug-05 1:17

Hello Pradyumna,

Thank you for your explanation. The reason I wanted to save to another variable was first because I thought that the controls would not be available anymore once the dialog is closed, and secondly because I'd like to encapsulate the type of control (if I decide to change a textbox with a combobox I'd have to go around around change calls to .Text with calls to .SelectedText). But I've found another way to encapsulate the functionality that I require in my dialog, so for now this problem is not relevant to me any more - but still, it's good to know for the future that there is no equivalent to ddx and that I'll have to save data manually.

As for the second part, that's too bad, I thought that with windows forms we'd have layout managers that would be just as powerful as those in eg Java's AWT or in the GTK toolkit. Looks like I was wrong Frown | :(

Thanks for your time!

cheers,

roel

Pradyumna Gogte5-Aug-05 2:01

5-Aug-05 2:01

Roel,

The version 2.0 for the .net framework has the layout mangers in the forms. So may be you can wait for that.

Prady