Datatable, DataSet, Dataview and SQL query

Task: Datatable, DataSet, Dataview and SQL query

Description: Datatable, DataSet,  Dataview and SQL query.

1) Merge two DataTable into one.

var dt1 = new DataTable(); //contain data

var dt2 = new DataTable(); //contain data

var result = dt1.AsEnumerable()

    .Union(dt2.AsEnumerable());

DataTable dtnew = result.CopyToDataTable();

2) DataView Example of rowfilter, distinct and sorting .

DataTable dt= new DataTable(); //contain data
DataView dv = new DataView(dt);

dv.RowFilter = "status =1";

dt = dv.ToTable();

DataTable dtprod= new DataTable(); //contain data

DataView dv = new DataView(dtprod);

dv.RowFilter = "status =1";

string[] colname = { "product_id", "product_name", "product_code", "price", "quantity" };

dv.Sort = "product_code asc";

dtprod= dv.ToTable(true, colname);

3) SQl query for permission of execution of execute/create/delete/update and and few more quries.

sp_helptext StoredProcdeureName

GRANT privileges ON object TO user;

REVOKE privileges ON object FROM user;

Execute permission stored procdeure for user

GRANT EXECUTE TO username;

other permission to user

GRANT SELECT, INSERT, DELETE, UPDATE TO username;


//Delete Duplicate Rows in a Table.

DELETE

FROM TABLENAME

WHERE ID NOT IN

(

SELECT MAX(ID)

FROM TABLENAME

GROUP BY duplicateColumn1, duplicateColumn2)