1
Answer

Search Data With combox,type,shift,FromDate,Todate,Points

Photo of Guest User

Guest User

3y
818
1

SqlCommand cmd = new SqlCommand("UIPKGREPORTING_spFetchAttendanceReport", connection);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@inType", drp_Type.Text);
            cmd.Parameters.AddWithValue("@inShift", drp_Shift.Text);
            cmd.Parameters.AddWithValue("@inFromDateTime", dtp_FromDate.Value);
            cmd.Parameters.AddWithValue("@inToDateTime", dtp_ToDate.Value);
            cmd.Parameters.Add("@inPoints", SqlDbType.Int).Value = -1;
            cmd.Parameters.Add("@inVolunteerID", SqlDbType.Int).Value = 0;
            //int UserId = Convert.ToInt32(cmd.Parameters["@inVolunteerID"].Value);
            SqlDataAdapter sda = new SqlDataAdapter(cmd);
            DataSet dt = new DataSet();
            sda.Fill(dt, "abc");
            dt.Tables["abc"].Columns.Remove("attendancelogid");
            dt.Tables["abc"].Columns.Remove("TotalDuration");
            dataGridView1.DataSource = dt.Tables["abc"].DefaultView;
            return dt.Tables["abc"];

==============================================================================

Search Data In DataGridView 

Send Me Code 

Thank You...

Answers (1)

1
Photo of Amit Mohanty
16 52.3k 6.1m 3y
Hey, try below code.
  1. if (dataGridView1.DataSource != null)  
  2. {  
  3.     string whereClause = "AttendanceType Like '%" + textSearch.Text + "%'";  
  4.     (dataGridView1.DataSource as DataTable).DefaultView.RowFilter = whereClause;  

 "AttendanceType" is the one column name of the datagridview.
Accepted