column caption

Windows Forms Data Controls and Databinding

- Previous
  - 1
    - Web browser problem Bring the SWF out of Temporary Internet Files (if it's in there, which, it probably is). Tag: Windows Forms Data Controls and Databinding column caption Windows Forms
  - 2
    - Assigning icon from default settings on target machine Thanks for your help but Windows does not automatically assign the PDF viewer icon to the shortcut in the Start menu. Of course, your suggestion of leaving the icon blank was the first thing I tried, but Windows just assigns a generic data file icon rather than the PDF viewer one. I've tried the installation on a number of machines, with 2 different flavours of PDF viewers, and the icon isn't assigned correctly on any. After some experimentation I have written an app that can extract the correct icon from the registry on the target machine, but I have yet to find a way to assign this to the shortcut. Tag: Windows Forms Data Controls and Databinding column caption Windows Forms
  - 3
    - Textbox value lost while validating OK- problem solved. Kind of... I simply gave up trying to make this work with DataSourceUpdateMode.OnValidation. I changed the update mode to DataSourceUpdateMode.OnPropertyChanged, and everything behaves normally. Of course, this means that bad data can find its way into my business object as I am validating the fields when the data is saved rather than when the controls lose focus, but I can force the user to correct any errors before persisting the object back to the database so this is not a disaster. I must say, though, that windows forms databinding leaves a lot to be desired. I don't mind if things don't work as I expect them to, as long as there's an explanation why not. But when .NET quietly swallows an exception somewhere upstream, working out what's going wrong can be very difficult indeed. Tag: Windows Forms Data Controls and Databinding column caption Windows Forms
  - 4
    - DataGridView, CheckBox fields and Strongly Typed datasets.... This keeps happening to me too. However, I am not using strongly typed datasets. It's so frustrating! I want to know what's causing my columns to keep getting moved around without my permission so that I have to keep fixing them all the time! Tag: Windows Forms Data Controls and Databinding column caption Windows Forms
  - 5
    - Find a window control at a point on the screen Thanks, that's what I was looking for. I looked at the pinvoke.net website, and I found the function " GetDlgItemText ” but I can't get it to work. Does anyone know what needs to be passed into the parameters I've searched on other sites for it also, but I still can't figure it out. Tag: Windows Forms Data Controls and Databinding column caption Windows Forms
  - 6
    - MaskedTextbox and allowing only valid int input Thanks for the snippet. Much better than either the masked textbox or the numericUpDown. I modified it a little as follows: Code Snippet public partial class NumericTextbox: TextBox { public NumericTextbox() { InitializeComponent(); this.KeyPress += new KeyPressEventHandler(NumericTextbox_KeyPress); this.Leave += new EventHandler(NumericTextbox_Leave); } void NumericTextbox_Leave(object sender, EventArgs e) { if (this.TextLength == 0) // replaces an empty textbox with 0 this.Text = "0"; else if (int.Parse(this.Text) == 0) // replaces multiple 0's with just 0 this.Text = "0"; else // this removes leading zeros by converting to int, then back to string this.Text = int.Parse(this.Text).ToString(); } void NumericTextbox_KeyPress(object sender, KeyPressEventArgs e) { if (!char.IsNumber(e.KeyChar) && e.KeyChar != '\b') { e.Handled = true; } } } The only problem that I really foresee is that it doesn't handle cut/copy/paste, but I'm fine with that. Thanks. Tag: Windows Forms Data Controls and Databinding column caption Windows Forms
  - 7
    - CheckedListBox DataSource property Thanks for your replay I've noticed that it does expose the DataSource, Display and Value member and it seems to be working. My question is why it isn't recommended to use these properties. Thanks, Gil Tag: Windows Forms Data Controls and Databinding column caption Windows Forms
  - 8
    - DataGridView Scrollbar The DataGridView has two controls in its control collection, the HScrollBar and VScrollBar,i.e. dataGridView1.Controls[0] is a HScrollBar object and dataGridView1.controls[1] is a VScrollBar object, handle the scrollbar's scroll event and MouseLeave event to stop or start the timer. Have a look at my sample write for you: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; namespace Sample4 { public partial class DgvScroll : Form { public DgvScroll() { InitializeComponent(); } Timer timer; DataTable dt; private void DgvScroll_Load( object sender, EventArgs e) { dt = new DataTable (); dt.Columns.Add( "id" , typeof ( int )); dt.Columns.Add( "name" ); dt.Columns.Add( "aa" ); for ( int j = 0; j < 25; j++) { dt.Rows.Add(j, "Row " + j.ToString(), "aa" ); } this .dataGridView1.DataSource = dt; //HScrollBar hScroll = this.dataGridView1.Controls[0] as HScrollBar; VScrollBar vScroll = this .dataGridView1.Controls[1] as VScrollBar ; vScroll.Scroll += new ScrollEventHandler (vScroll_Scroll); vScroll.MouseLeave += new EventHandler (vScroll_MouseLeave); timer = new Timer (); timer.Interval = 10000; timer.Tick += new EventHandler (timer_Tick); timer.Start(); } void vScroll_MouseLeave( object sender, EventArgs e) { timer.Start(); } void timer_Tick( object sender, EventArgs e) { this .dataGridView1.DataSource = null ; this .dataGridView1.DataSource = dt; } void vScroll_Scroll( object sender, ScrollEventArgs e) { timer.Stop(); } } } Hope it helps. Best Regards. Zhixin Ye Tag: Windows Forms Data Controls and Databinding column caption Windows Forms
  - 9
    - Parent, child forms check if open or closed Hi RainX, You can loop through all MDI child forms and check the type of each form. If these is a form whose type matched the type of the form you want to open, you need to create a new instance, you just need to make the match form as the active form. Try the following code: Code Snippet namespace MDIForm { public partial class MainForm : Form { public MainForm() { InitializeComponent(); } private void openChiid1ToolStripMenuItem_Click( object sender, EventArgs e) { int intIndexChild; Form frm; if (!ExistInParent( typeof ( ChildFrm1 ), out intIndexChild)) { frm = new ChildFrm1 (); frm.MdiParent = this ; frm.Show(); } else { MdiChildren[intIndexChild].Activate(); } } private void openChiid2ToolStripMenuItem_Click( object sender, EventArgs e) { int intIndexChild; Form frm; if (!ExistInParent( typeof ( ChildFrm2 ), out intIndexChild)) { frm = new ChildFrm2 (); frm.MdiParent = this ; frm.Show(); } else { MdiChildren[intIndexChild].Activate(); } } bool ExistInParent( Type type, out int intIndexChild) { int count = this .MdiChildren.Length; for ( int i = 0; i < count; i++) { if ( this .MdiChildren[i].GetType() == type ) { intIndexChild = i; return true ; } } intIndexChild = -1; return false ; } } } Hope this helps. Best regards. Tag: Windows Forms Data Controls and Databinding column caption Windows Forms
  - 10
    - Suddenly I'm getting this error: The form referred to itself during construction from a default instance Hi, Thanks for the suggestion, I've tried it unfortunately I'm still getting the error. Louise Tag: Windows Forms Data Controls and Databinding column caption Windows Forms
  - 11
    - datagridview - testing values of an unbound column 1) . For the first question, you can handle the CellContentClick event along with the CurrentCellDirtyStateChanged event, since we want the CheckBox's state to be changed when we click them. Meanwhile, use a variable of int type to count the currently selected records, change the button's Enable property accordingly to this variable as the following code snippet illustrated. Code Snippet public partial class Form8 : Form { public Form8() { InitializeComponent(); } private void Form8_Load(object sender, EventArgs e) { this.button1.Enabled = false; DataTable dt = new DataTable(); dt.Columns.Add("id",typeof(int)); dt.Columns.Add("name"); for (int j = 0; j < 10; j++) { dt.Rows.Add(j, "row" + j.ToString()); } this.dataGridView1.DataSource = dt; this.dataGridView1.VirtualMode = true; DataGridViewCheckBoxColumn ckc = new DataGridViewCheckBoxColumn(); ckc.Name = "CheckBoxColumn"; ckc.HeaderText = "Select"; this.dataGridView1.Columns.Add(ckc); this.dataGridView1.CellContentClick += new DataGridViewCellEventHandler(dataGridView1_CellContentClick); this.dataGridView1.CurrentCellDirtyStateChanged += 　　　　　　new EventHandler(dataGridView1_CurrentCellDirtyStateChanged); } void dataGridView1_CurrentCellDirtyStateChanged(object sender, EventArgs e) { if (this.dataGridView1.CurrentCell.ColumnIndex == this.dataGridView1.Columns["CheckBoxColumn"].Index) { this.dataGridView1.CommitEdit(DataGridViewDataErrorContexts.Commit); } } private int selectedCount = 0; void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == this.dataGridView1.Columns["CheckBoxColumn"].Index) { object obj = this.dataGridView1[e.ColumnIndex,e.RowIndex].Value; if (obj != null) { if ((bool)obj) { this.selectedCount++; } else { this.selectedCount--; } } this.button1.Enabled = this.selectedCount > 0 true : false; } } } 2). For the second, I recommend you adding a few Labels and TextBoxes to the same Form which the DataGridView is set up on, each attaching to a field in the data table, and bind the Text property of each TextBox to the DataSource which is the same as the DataSource of the DataGridView, thus while selecting different records on the DataGridView, the content in the TextBoxes will be changed accordingly ,something like this: this.TextBox1.DataBindings.Add("Text",ds.Table[0],"id"); //….etc.... this.DataGridView.DataSource = ds.Table[0]; Tag: Windows Forms Data Controls and Databinding column caption Windows Forms
  - 12
    - how to host different controls in the same column in DataGridView control Thanks for this working example! First method worked perfect for me! :-) Made my day! Well, part of it... I have now another DGV- or maybe DataSet-related problem down the line... In order to get my changes saved I must leave the edited cell i DGV before saving my DataSet. If I don't leave the cell my database won't be updated. The DataSet seems to be updated, it displays correct in the DGV until I read from database again. I have tried DGV.EndEdit() and DGV.CommitEdit() but no luck. When I examine the DataSet in debug mode it seems ok. The new data is there, but it does reach the database. I did also try DataRowVersion=Proposed on my DbParameter. I used stored procedures and DiscoverParameter (EntLib3) Any help would be appreciated! Rgds, /Claesp Tag: Windows Forms Data Controls and Databinding column caption Windows Forms
  - 13
    - Removing multiple items in a ListView "at the same time" Hi all, Suppose we have 5 items in the ListView: "Alpha", "Bravo", "Charlie", "Delta" and "Echo". When we execute RemoveAt(0) followed by another RemoveAt(0), the first two items got removed. If we execute RemoveAt(0) followed by RemoveAt(1), "Alpha" and "Charlie" got removed. What I want to achieve is: I can multi-select items in the ListView to decide which items i'd like to delete. For example, I select "Alpha" and "Delta", so the index 0 and 3 are stored in SelectedIndexCollection. Then I enumerate this collection to delete these two in one run. At this time, if I run RemoveAt(0) first, the index of "Delta" will be changed to 2. Can I delete multiple items "at the same time" in the collection without having to mess with the indices Tag: Windows Forms Data Controls and Databinding column caption Windows Forms
  - 14
    - How to lock a control on a design form Thanks for the confirmation (appreciated). I omitted error-checking so I could focus on the problem but I am checking for null in production code. Thanks again. Tag: Windows Forms Data Controls and Databinding column caption Windows Forms
  - 15
    - DataGridView ImageCell Description You can create a UserControl to host an Image and a Label, and add thisUserControl to the Controls property of DataGridView, and diplay it where you want. check this thread for example: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1420626&SiteID=1 Tag: Windows Forms Data Controls and Databinding column caption Windows Forms
  - 16
    - Usefullness of any event Miyamoto M, according to your theory, the Paint event would be utterly worthless. I humbly disagree. --mc Tag: Windows Forms Data Controls and Databinding column caption Windows Forms
- Next
  - 1
    - How do I reference a control's properties? I tried that and got the following errors: error C2673: 'Go_Click' : global functions do not have 'this' pointers error C2227: left of '->textBox1' must point to class/struct/union/generic type error C2228: left of '.text' must have class/struct/union Does it matter where the code is placed I placed the following in the Test.cpp file for the project: Void Go_Click(System::Object^ sender, System::EventArgs^ e) { this ->textBox1.text= "Hello World" ; } I also changed the header file as follows: public : System::Windows::Forms::TextBox^ textBox1; Tag: Windows Forms Data Controls and Databinding column caption Windows Forms
  - 2
    - Record Locking and Transactions in Strongly Typed Datasets Hi Kiavash, It is because that you have set the transaction for the connection, but you did not set the transaction for SelectCommand of this TableAdapter. Unfortunately, you can get access to the SelectCommand. So you can not use it that way. Try to use the transaction like this: Code Snippet connection.Open(); SqlCommand command = connection.CreateCommand(); SqlTransaction transaction; // Start a local transaction. transaction = connection.BeginTransaction( IsolationLevel .ReadCommitted); // Must assign both transaction object and connection // to Command object for a pending local transaction command.Connection = connection; command.Transaction = transaction; Hope this helps. Regards. Tag: Windows Forms Data Controls and Databinding column caption Windows Forms
  - 3
    - hide and show a process??? i whant to hide the process (server.exe) not the button. Tag: Windows Forms Data Controls and Databinding column caption Windows Forms
  - 4
    - TreeView Comtrol: Add buttons to nodes in TreeView control I am now using TreeView in my web page. I want to add some buttons next to some of the nodes in the treeview. The button should be aware of the value of its corresponding node in the tree. Is there any good way of doing this Thanks! Tag: Windows Forms Data Controls and Databinding column caption Windows Forms
  - 5
    - Access Denied Reading Registry Hey, that might work for me for reading the key, which I have yet to try but will as soon as after work today; however, what code are you speaking of when and if I want to delete one of those keys I wont ever need to write to it, I just need to read it and perhaps delete it if necessary. thanks in advance and sorry for my late reply. Tag: Windows Forms Data Controls and Databinding column caption Windows Forms
  - 6
    - How do I Find The Product Code? This is driving me crazy and it must be simple. I am trying to find the product code so I can author manifests for installing MSDE. How do I find product codes for things I want to install I must be missing something easy. Do we just make them up For example here is the product code for SqlExpress ProductCode="Microsoft.Sql.Server.Express.1.0" Tag: Windows Forms Data Controls and Databinding column caption Windows Forms
  - 7
    - Menustrip reading XML You would probably have to add the items individually; then you are also stuck creating the events for them too. At least with a treeview you can have one procedure to process the selection based on the selected node. I am not aware that the menustrip has this capability. Tag: Windows Forms Data Controls and Databinding column caption Windows Forms
  - 8
    - Can we Add ListItem objects to ListBox ? Dear Matthew I have added ListItem objects to my ListBox it working fine. but i am getting Exceptions when i try to remove that ListItem Objects from my ListBox the exception is "List that this enumerator is bound to has been modified. An enumerator can only be used if the list does not change." any suggetion. Regards Ranadheer Tag: Windows Forms Data Controls and Databinding column caption Windows Forms
  - 9
    - Using the Windows password in my application I have a WinForms C# application for which I currently have two methods of login - either the user enters their password when they log in, which I store in my SQL 2005 db encrypted, or I just let them in based on their windows login id. In both cases I do not ask for a username, I get this from their Windows network login. What I would like to do is something that I have seen other applications (Lotus Notes) do. If your application password is the same as your windows password, it just lets you in, but if they are different then you must enter the application password. I am not worried about the db login, just the application login. I have been searching for an example of this, but I have not had any luck. If this question has been already asked and answered, my apologies, but please point me in the right direction. Later I will need to do the same thing in an asp.net application, but right now my problem is only winforms. Any help would be appreciated. Tag: Windows Forms Data Controls and Databinding column caption Windows Forms
  - 10
    - Bring to Front Form Problem The problem arises from the fact that i still want the mainForm to be the owner of its children. Tag: Windows Forms Data Controls and Databinding column caption Windows Forms
  - 11
    - How do I allow the user to enter a negative number in a column on a grid with validation? thanks again FD. Very simple. Tag: Windows Forms Data Controls and Databinding column caption Windows Forms
  - 12
    - Programatically trigger keyboard shortcut I want to trigger a behavior for which a third party component provides a keyboard shortcut. The user can trigger this behavior with CTRL+SHIFT+V, but I want to programatically trigger this behavior in certain circumstances. Any ideas Tag: Windows Forms Data Controls and Databinding column caption Windows Forms
  - 13
    - Dump controles to image /saving to image You can use the DrawToBitmap() method to create an image of the SplitContainer. It will draw it exactly as it appears on the screen, you'll have to position the controls yourself if that's your requirement. Any RichTextBox or WebBrowser control embedded on one of the panels won't draw correctly. private void button1_Click(object sender, EventArgs e) { using (Bitmap bmp = new Bitmap(splitContainer1.ClientSize.Width, splitContainer1.ClientSize.Height)) { splitContainer1.DrawToBitmap(bmp, splitContainer1.ClientRectangle); bmp.Save(@"c:\temp\test.bmp"); } } Tag: Windows Forms Data Controls and Databinding column caption Windows Forms
  - 14
    - Value, Text pair in combo box Hi Thank you very much Regards Prash Tag: Windows Forms Data Controls and Databinding column caption Windows Forms
  - 15
    - problem while handling dataerror thanks Rong-Chun Zhang but i could not get it working let me provide u my full code //form save button private void btnSave_Click( object sender, EventArgs e) { try { this .Validate(); this .dONARCODEBindingSource.EndEdit(); result = MessageBox .Show( "Do you want to Save Records" , "EMUGAS ave Confirm,Question" , MessageBoxButtons .YesNo, MessageBoxIcon .Question); if (result == DialogResult .Yes) { this .dONARCODETableAdapter.Update( this .dsDonartab.DONARCODE); MessageBox .Show( "The records are applied and saved." , "EMUGAS:Record Saved,Information" , MessageBoxButtons .OK, MessageBoxIcon .Information); } else { return ; } } catch ( ConstraintException ex) { MessageBox .Show(ex.Message.ToString()); } //tool bar save button private void toolbtnSave_Click( object sender, EventArgs e) { this .Validate(); if (!iserror) this .btnSave_Click( null , null ); } //data error handling private void dgvDonar_DataError( object sender, DataGridViewDataErrorEventArgs e) { this .iserror = true ; if (e.Context == DataGridViewDataErrorContexts .Commit) { if ((e.Exception) is ConstraintException ) { this .dgvDonar.Rows[e.RowIndex].ErrorText = " Cannot contain duplicate value" ; MessageBox .Show( "primary key violation" ); //data error messagebox e.Cancel = true ; } if ((e.Exception) is NoNullAllowedException ) { this .dgvDonar.Rows[e.RowIndex].ErrorText = " All the fields are requierd" ; MessageBox .Show( "Null value cannot be saved" ); //data error messagebox e.Cancel = true ; } } } Now here my toolbtnSave works fine . Whenever error occurs it raise the dataerror messagebox and messagebox.ok click it returns to datagridview and show dataerror text for input correction. My form closing event also works similary. But my problem with btnSave button it shows dataerror messagebox and when I click messagebox.ok it goes to not responding phase(app simply hangs do not show any error). Two buttons are showing two different nature again eventhough calling same method what might be wrong.. Tag: Windows Forms Data Controls and Databinding column caption Windows Forms
  - 16
    - Simulating a paste from the clipboard via code? Rong-Chun, Thanks for your reply, But you perhaps misunderstood me. I am using the Clipboard.SetText method in my application, But the pasting needs to occur at whatever active window\application at the time of pressing the hooked keyboard hotkey. I.e. I could be in a chat program, in a certain textbox and click the hotkey. My application would catch the keypress, do its logic, and set some text into the clipboard. The next stage which i can't seem to acheive, would be simulating a ctrl+v keypress at wherever the user was - Resulting in the info i posted in the clipboard pasted. I've seen the SendInput API method, But i'm not sure how to use it correctly under .NET\Pinvoke - It uses some structs which im unsure as how to represent in .NET. Tag: Windows Forms Data Controls and Databinding column caption Windows Forms

msksurfer

i'm trying to use the column caption but it didn't work. i'm currently using microsoft visual studio .net 2003. i check the online tutorials and did the same, but the caption never turn up at the datagrid. can anyone advise me on this below is my codes. another issue is that, is it possible to change the colour of columns with using tablestyle

count = Db.Observation;

counter = 1;

year = Db.year;

mth = Db.mth;

DataColumn Quantity;

for(int i=0; i<count; i++)

{

if(mth > 12)

{

year++;

mth = 1;

}

Quantity = new DataColumn(year+" / "+mth, typeof(int));

Quantity.Caption = "Data " + counter;

productTable.Columns.Add(Quantity);

counter++;

mth++;

}

Top

Re: Windows Forms Data Controls and Databinding column caption

Ken Tucker

You have to add a tablestyle to the datagrid to change the header text of a datagrid column

http://msdn2.microsoft.com/en-us/library/system.windows.forms.datagridtablestyle.aspx

Top