Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C#3.0
hi , every one:
i am using a attendance concept in my windows application, one table is have all name in the concern all details are filled by admin. Another table is filled by entry of employee in to company. now i have to seperate presented list and absented list.
i am showing 2 different gridview, 1 for present and another one for absent,
i am using a query in presented table:
conn.Open();
            DataTable dtusers = new DataTable();
            
            SqlDataAdapter da = new SqlDataAdapter("select name,tdate,timein from daily_att where tdate='"+tdat+"' ", conn);
 
            SqlCommandBuilder cmd = new SqlCommandBuilder(da);
            da.Fill(dtusers);
            grd_pres_rep.DataSource = dtusers;
            grd_pres_rep.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
            conn.Close();
 

now how can i list out absented employee in my second gridview?
Posted 10-May-13 3:57am
srigates1.2K
Comments
CHill60 at 10-May-13 9:20am
   
Whichever solution below you choose please consider using parameterized queries to protect yourself from sql injection attacks. They also make your code neater and more efficient. http://www.dotnetperls.com/sqlparameter[^]
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

try like this ..
conn.Open();
DataTable dtusers = new DataTable();
            
SqlDataAdapter da = new SqlDataAdapter("select name from admin_table where name not in (select name from daily_att where tdate='"+tdat+"' ) ", conn);
 
SqlCommandBuilder cmd = new SqlCommandBuilder(da);
da.Fill(dtusers);
grd_absent_rep.DataSource = dtusers;
grd_absent_rep.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
conn.Close();
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

Use:
 
select * from master_table where id not in (select id from daily_att);
 
where id is the primary key for the tables
  Permalink  
Comments
srigates at 11-May-13 1:33am
   
it not working
srigates at 11-May-13 1:41am
   
select Emp_name from nat_emp_det where Emp_name not in (select name from daily_att )

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Maciej Los 295
1 OriginalGriff 273
2 Aajmot Sk 234
3 Marcin Kozub 205
4 Richard MacCutchan 200
0 OriginalGriff 7,903
1 Sergey Alexandrovich Kryukov 7,127
2 DamithSL 5,604
3 Manas Bhardwaj 4,986
4 Maciej Los 4,820


Advertise | Privacy | Mobile
Web04 | 2.8.1411023.1 | Last Updated 10 May 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100