How to validate rows in c#?

Ajay Malik

Midhun T P

Krishna Rajput Singh

thanks to all

1. usingSystem;
2. usingSystem.Data;
3. usingSystem.Data.SqlClient;
4. usingSystem.Windows.Forms;
6. publicclassForm1:System.Windows.Forms.Form
7. {
8. privateDataGridViewdataGridView1=newDataGridView();
9. privateBindingSourcebindingSource1=newBindingSource();
11. publicForm1()
12. {
13. //Initializetheform.
14. this.dataGridView1.Dock=DockStyle.Fill;
15. this.Controls.Add(dataGridView1);
16. this.Load+=newEventHandler(Form1_Load);
17. this.Text="DataGridViewvalidationdemo(disallowsemptyCompanyName)";
18. }
20. privatevoidForm1_Load(System.Objectsender,System.EventArgse)
21. {
22. //AttachDataGridVieweventstothecorrespondingeventhandlers.
23. this.dataGridView1.CellValidating+=new
24. DataGridViewCellValidatingEventHandler(dataGridView1_CellValidating);
25. this.dataGridView1.CellEndEdit+=new
26. DataGridViewCellEventHandler(dataGridView1_CellEndEdit);
28. //InitializetheBindingSourceandbindtheDataGridViewtoit.
29. bindingSource1.DataSource=GetData("select*fromCustomers");
30. this.dataGridView1.DataSource=bindingSource1;
31. this.dataGridView1.AutoResizeColumns(
32. DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
33. }
35. privatevoiddataGridView1_CellValidating(objectsender,
36. DataGridViewCellValidatingEventArgse)
37. {
38. stringheaderText=
39. dataGridView1.Columns[e.ColumnIndex].HeaderText;
41. //AbortvalidationifcellisnotintheCompanyNamecolumn.
42. if(!headerText.Equals("CompanyName"))return;
44. //Confirmthatthecellisnotempty.
45. if(string.IsNullOrEmpty(e.FormattedValue.ToString()))
46. {
47. dataGridView1.Rows[e.RowIndex].ErrorText=
48. "CompanyNamemustnotbeempty";
49. e.Cancel=true;
50. }
51. }
53. voiddataGridView1_CellEndEdit(objectsender,DataGridViewCellEventArgse)
54. {
55. //CleartherowerrorincasetheuserpressesESC.
56. dataGridView1.Rows[e.RowIndex].ErrorText=String.Empty;
57. }
59. privatestaticDataTableGetData(stringselectCommand)
60. {
61. stringconnectionString=
62. "IntegratedSecurity=SSPI;PersistSecurityInfo=False;"+
63. "InitialCatalog=Northwind;DataSource=localhost;PacketSize=4096";
65. //Connecttothedatabaseandfilladatatable.
66. SqlDataAdapteradapter=
67. newSqlDataAdapter(selectCommand,connectionString);
68. DataTabledata=newDataTable();
69. data.Locale=System.Globalization.CultureInfo.InvariantCulture;
70. adapter.Fill(data);
72. returndata;
73. }
75. [STAThread]
76. staticvoidMain()
77. {
78. Application.EnableVisualStyles();
79. Application.Run(newForm1());
80. }
82. }