How to validate rows in c#?

Question

i have tow columns and 14 rows in this table. how to validate rows means if Any empty rows in this table to show the validation message like 'some duplicate value is inserted' how to do it?

Midhun Tp · Answer

Hi, You can use below code - foreach (DataRow row in dt.Rows) { if (AreAllColumnsEmpty(row)) { //Datatable has empty rows } else { } } public bool AreAllColumnsEmpty(DataRow dr) { if (dr == null) { return true; } else { foreach (var value in dr.ItemArray) { if (Convert.ToString(value) != "") { return false; } } return true; } }

Ajay Malik · Answer

using System; using System.Data; using System.Data.SqlClient; using System.Windows.Forms; public class Form1:System.Windows.Forms.Form { private DataGridViewdataGridView1= new DataGridView(); private BindingSourcebindingSource1= new BindingSource(); public Form1() { //Initializetheform. this .dataGridView1.Dock=DockStyle.Fill; this .Controls.Add(dataGridView1); this .Load+= new EventHandler(Form1_Load); this .Text= "DataGridViewvalidationdemo(disallowsemptyCompanyName)" ; } private void Form1_Load(System.Objectsender,System.EventArgse) { //AttachDataGridVieweventstothecorrespondingeventhandlers. this .dataGridView1.CellValidating+= new DataGridViewCellValidatingEventHandler(dataGridView1_CellValidating); this .dataGridView1.CellEndEdit+= new DataGridViewCellEventHandler(dataGridView1_CellEndEdit); //InitializetheBindingSourceandbindtheDataGridViewtoit. bindingSource1.DataSource=GetData( "select*fromCustomers" ); this .dataGridView1.DataSource=bindingSource1; this .dataGridView1.AutoResizeColumns( DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader); } private void dataGridView1_CellValidating( object sender, DataGridViewCellValidatingEventArgse) { string headerText= dataGridView1.Columns[e.ColumnIndex].HeaderText; //AbortvalidationifcellisnotintheCompanyNamecolumn. if (!headerText.Equals( "CompanyName" )) return ; //Confirmthatthecellisnotempty. if ( string .IsNullOrEmpty(e.FormattedValue.ToString())) { dataGridView1.Rows[e.RowIndex].ErrorText= "CompanyNamemustnotbeempty" ; e.Cancel= true ; } } void dataGridView1_CellEndEdit( object sender,DataGridViewCellEventArgse) { //CleartherowerrorincasetheuserpressesESC. dataGridView1.Rows[e.RowIndex].ErrorText=String.Empty; } private static DataTableGetData( string selectCommand) { string connectionString= "IntegratedSecurity=SSPI;PersistSecurityInfo=False;" + "InitialCatalog=Northwind;DataSource=localhost;PacketSize=4096" ; //Connecttothedatabaseandfilladatatable. SqlDataAdapteradapter= new SqlDataAdapter(selectCommand,connectionString); DataTabledata= new DataTable(); data.Locale=System.Globalization.CultureInfo.InvariantCulture; adapter.Fill(data); return data; } [STAThread] static void Main() { Application.EnableVisualStyles(); Application.Run( new Form1()); } }

Krishna Rajput Singh · Answer

Hello Raja thank you for writing below links helpful for you..........:) https://msdn.microsoft.com/en-us/library/1120xds5.aspx https://msdn.microsoft.com/en-us/library/7ehy30d4(v=vs.110).aspx http://www.codeproject.com/Questions/307107/how-to-validate-datagridview-cell-in-Csharp-a

Raja · Answer

Ajay Malik Midhun T P Krishna Rajput Singh thanks to all

How to validate rows in c#?

Answers (4)