Create proc SearchAllSupp
@Search nvarchar(50)
as
SELECT [SuppID] as 'المعرف'
      ,[SuppName] as 'اسم المورد'
      ,[SuppPhone] as 'الهاتف'
      ,[SuppEmail] as 'الايميل'
      ,[SuppCompany] as 'الشركة'
      ,[SuppAddress] as 'العنوان'
      ,[SuppDateAdd] as 'التاريخ'
      ,[SuppUserAdd] as 'مستخدم البرنامج'
      FROM TSupplier
      where
      CONVERT(nvarchar,[SuppID]) + [SuppName] + [SuppPhone] + [SuppEmail] + [SuppCompany] + [SuppAddress] +
      [SuppUserAdd] like '%' + @Search + '%'

//Abufahmi Code Generator -------- Public Function Between 2 Date ---------
public DataTable Between_TSupplier(DateTime date1, DateTime date2)
{
bool state = false;
SqlConnection con = new SqlConnection(@"Server = .\SQLExpress; Database = SuperM_DB; Integrated Security = True;");
SqlParameter[] param = new SqlParameter[2];

param[0] = new SqlParameter("@date1", SqlDbType.Date);
param[0].Value = date1;

param[1] = new SqlParameter("@date2", SqlDbType.Date);
param[1].Value = date2;

DataTable dt = new DataTable();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddRange(param);
cmd.CommandText = ("Between_TSupplier");
SqlDataAdapter da = new SqlDataAdapter(cmd);
try
{
da.Fill(dt);
state = true;
}
catch
{
state = false;
}
return dt;
}

try
{
DataTable dt = new DataTable();
dt = Between_TSupplier(DTP1.Value, DTP2.Value);
DataGridView.DataSource = dt;
}
catch
{ return; }