Rowshan Ali

Rowshan Ali

  • 1.8k
  • 64
  • 111.7k

How to work by datatable from linq in .

Apr 10 2013 3:18 AM
hello dear
i m in problems . firstly i want to load data from database table or view named dt, then i want to search from dt without going to database ho can i solve it.

  DataTable dt = new DataTable();
    DataColumn d1 = new DataColumn("PIId");
    DataColumn d2 = new DataColumn("PINO");
    DataColumn d3 = new DataColumn("LCTRANDAte");
    private void mytable()

        using (SqlConnection conn = new SqlConnection(_connStr))
            string sql = "SELECT PIId, PINo, L_CTransdate FROM PInvoice";
            using (SqlCommand cmd = new SqlCommand(sql, conn))
                using (SqlDataAdapter ad = new SqlDataAdapter(cmd))

i want to search it from dt in button click event.

if any body help me best regurds.

Answers (2)