PARTHIBAN

Tuesday, September 10, 2013

c sharp database path

OleDbConnection con = new OleDbConnection("Provider=microsoft.jet.oledb.4.0;data source=E:\\Rice\\Rice.mdb");

TNPSC GROUP - IV
GENERAL TAMIL
(DATE 25.8.13)
NOTE :- MOST OF THE GRAMMAR QUESTIONS ARE DISCUSSED IN OUR CLASS
ROOM
1. jd;tpid thf;fpaj;ijf; fz;lwpf:-a. ,yf;fpah Gj;jhil mzptpj;jhs;
b. ,yf;fpah Gj;jhil mzpe;jhs;
c. Gj;jhil ,yf;fpahthy; mzptpf;fg;gl;lJ
d. ,yf;fpah Gj;jhil mzpahs;
2. jpU.tp.f ,aw;wpa \nghJik Ntl;ly;| vd;Dk; E}ypy;
cs;s ghf;fspd; vz;zpf;if .....................
a. ehD}w;W Kg;gJ
b. ,UE}w;W xd;W
c. Ke;E}w;W MW
d. ehD}w;W vOgJ
Ref:- NR IAS ACADEMY’S Tamil Test 7.1 Qn.No.10
3. joP,: ,yf;fzf; Fwpg;G jUf:-a. nra;Aspir msngil
b. <Wnfl;l vjpHkiw nganur;rk;
c. ,d;dpirasngil
d. nrhy;ypir msngil
4. cyfk; vd;w jkpo;r; nrhy;ypd; NtHr;nrhy; vJ?
a. cyF b. cyT
c. csJ d. csk;
Ref:- NR IAS ACADEMY’S Tamil Test 10.7
5. xUikg; gd;ikg; gpioaw;w njhlH vJ?
a. mtd; ftpQd; my;yH
b. mtd; ftpQd; md;W
c. mtd; ftpQd; my;yd
d. mtd; my;yd; ftpQd;
Ref:- NR IAS ACADEMY’S 8,10th Tamil Book Page-14
6. Qhdg;gr;rpiy vdg; Nghw;wg;gLk; %ypif
a. Jsrp b. fPohney;yp
c. J}Jtis d. fw;whio
Ref:- NR IAS ACADEMY’S Tamil Test 9.6 Qn.No.90
7. nghw;nfhb Mafiy mWgj;J ehd;fpidAk; fw;whs;
- ,t;thf;fpak; vt;tif tpid rhHe;jJ?
a. gpwtpid b. jd;tpid 
c. fyit d. nra;ag;ghl;L tpid
8. nghUe;jhj njhliuf; fz;lwpf:-a. xWj;jhH - nghWj;jhH
b. mQ;rhik - JQ;rhik 
c. mwpTilahH - mwptpyhH
d. itahH - itg;gH
9. tpdhtpw;Fhpa tpil vOJf:-fhkuhrhpd; gpwe;j ehis Mz;L NjhWk; ve;;j ehshf
nfhz;lhLfpNwhk;?
a. fy;tpg; gzp Mw;wpa ehs;
b. fy;tp tsHr;rp ehs; 
c. njhopy; Kd;Ndw;w ehs;
d. Njrpa fy;tp ehs;
Ref:- NR IAS ACADEMY’S Tamil Test 10.7 Qn.No.72
10. ngaHr;nrhy;ypd; tif mwpf:-\ed;ik| vd;gJ
a. nghUl; ngaH
b. rpidg; ngaH
c. gz;Gg; ngaH 
d. njhopw; ngaH
11. \\ehl;LJk; ahk;XH ghl;Lilr; nra;As;|| vd;W ghlj;
njhlq;fpa GytH ahH?
a. fk;gH b. fgpyH
c. ,sq;Nfhtbfs; 
d. rPj;jiyr; rhj;jdhH
Ref:- NR IAS ACADEMY’S +2 Tamil Qn.Bank -Qn.No.26
12. tpdhtpw;Fhpa tpil vOJf:-jkpio Mnyd tsHj;J khz;Gwr; nra;jtH ahH?
a. ghpjpkhw; fiyQH
b. K.tujuh[d;
c. NjtNeag; ghthzH 
d. GJikg;gpj;jd;
Ref:- NR IAS ACADEMY’S 8th Tamil Test Qn.No.26
13. chpa tpiliaj; NjHf:-jpUf;Fwis ehw;gjhz;Lfs; gbj;Jr; Ritj;j Nghg;>
mjid Mq;fpyj;jpy; ve;j Mz;L nkhopngaHj;J
ntspapl;lhH?
a. 1986 b. 1858
c. 1808 d. 1886 
Ref:- NR IAS ACADEMY’S 8th Tamil Test - Qn.No.54
14. tUf - vd;gjd; ,yf;fzf; Fwpg;G NjHf:-a. tpidnar;rk; b. cUtfk;
c. chpr;nrhy; njhlH
d. tpaq;Nfhs; tpidKw;W 
15. nghUe;jhj njhliuf; Fwpg;gpLf:-a. fyk;gfk; - gjpndl;L cWg;Gfs;
b. rpw;wpyf;fpaq;fs; - njhz;Z}w;W
c. gps;isj;jkpo; - gj;Jg; gUtq;fs;
d. guzp - 100 jhopirfs; 
NR IAS ACADEMY
Ref:- NR IAS ACADEMY’S + Tamil Page No.65
16. gpd;tUk; njhlHfspy; ,uhkypq;f mbfshH $wpait?
a. ehd; jdpahf thotpy;iy> jkpNohL tho;fpNwk;
b. ntapYf;F xJq;Fk; tpUl;rk
mopf;fhNj 
c. ngz;fNs r%fj;jpd; fz;fs;
d. rkj;Jtj;jpd; kWngaNu kdpjNeak;
Ref:- NR IAS ACADEMY’S 10th Tamil Test 10.9
17. gpd;tUk; nrhw;fSs; Fw;wpaYfuk; my;yhj nrhy;iyf;
fz;lwpf:-a. khHG b. tuF
c. kL  d. khR
18. rpj;Jfspd; vz;zpf;if
a. gd;dpuz;L b. gjpndl;L
c. gj;J d. vl;L 
19. fliyf; Fwpf;Fk; jkpo;r; nrhw;fs;
a. Mop> mk;gp> MHfyp
b. ngstk;> Ke;ePH> ghprpy;
c. Mop> MHfyp> ngstk;
d. thuzk;> guit> Giz
Ref:- NR IAS ACADEMY’S Tamil
20. nghUj;jkhd tpiliaf; fz;lwp:-\\jkpOf;Ff; fjp|| vd;W Nghw;wg;gLk; E}y;fs;
a. ghl;Lk; njhifAk;
b. rpyk;Gk; NkfiyAk;
c. ,uhkhazKk; FwSk; 
d. ghujKk; ,uhkhazKk;
Ref:- NR IAS ACADEMY’S Tamil Test 10.3 Qn.No.28
21. gl;bay; Iy; cs;s nrhw;nwhliug; gl;bay; II y; cs;s
njhlHfSld; nghUj;jpf; FwpaPLfisf; nfhz;L
rhpahd tpiliaj; NjHT nra;
gl;bay; I gl;bay; II
a. fz; tdg;G 1. nrhy;yhik
b. vz; tdg;G 2. ,j;Jizahk;
c. gz; tdg;G 3. fz;Nzhl;lk;
d. fhy; tdg;G 4. Nfl;lhH ed;nwd;wy;
a b c d
a. 3 2 4 1 
b. 3 1 2 4
c. 1 2 3 4
d. 2 3 4 1
Ref:- NR IAS ACADEMY’S Tamil test - 9.2
22. Mw;Wg;gLj;jy; vd;gjd; nghUs;
a. md;G fhl;Ljy;
b. MWjy; $Wjy;
c. topfhl;Ljy; 
d. MjuT jUjy;
Ref:- NR IAS ACADEMY’S jkpo; ,yf;fpa tuyhW
Page.No.24 Qn.No.6
23. rhpahd nghUs; jUf:-\,e;J|
a. epyT  b. Jd;gk;
c. glF d. jiytd;
Ref:- NR IAS ACADEMY’S Tamil Test - 10th
Question Bank Qn.No.202
24. njhz;Lf;F Ke;J> jiyikf;Fg; gpe;J vdf; $wpatH
a. fhe;jpabfs; b. NguwpQH mz;zh
c. K.tujhrdhH 
d. nghpahH
Ref:- NR IAS ACADEMY’S Tamil Test - 9.4
25. chpa kuGr; nrhy;iy vOJf:-\\kapy;||
a. fiuAk; b. gpspWk;
c. myWk; d. mfTk; 
Ref:- NR IAS ACADEMY’S Tamil Test - 6-8th Ques-tion Bank Qn.No.324
26. te;jhd;| vd;Dk; tpidKw;W ----------------- vd
tpidahyizAk; ngauha; tUk;.
a. tUthd; b. thuhd;
c. te;jtd;  d. te;j
27. Mrphpag;ghtpd; <w;Wr;rPH ................ KbtJ rpwg;G.
a. Mfhuj;jpy; b. Vfhuj;jpy; 
c. Xfhuj;jpy; d. <fhuj;jpy;
Ref:- NR IAS ACADEMY’S 9-10th Question Bank
Qn.No.276
28. \\jpj;jpf;Fe; njs;sKjha;j; njs;sKjpd;|| fPo;f;fhZk;
tpilfSs; rhpahd tpil vJ?
a. vJif kl;Lk; te;Js;sJ
b. Nkhid kl;Lk; te;Js;sJ 
c. vJif>Nkhid> ,iaG te;Js;sd
d. vJifAk;> NkhidAk; te;Js;sd
29. kdpjnuy;yhk; md;Gnewp fhz;gjw;Fk; kNdhghtk;
thidg; Nghy; tphptile;J - ,g;ghlypy; fPo;tUk;
tpilfspy; nghUe;jhjijr; Rl;Lf:-a. mb Nkhid b. mb vJif
c. mb ,iaG 
d. rPH Nkhid
30. tpdhtpw;Fhpa tpil vOJf:-mk;Ngj;fH ve;j Mz;L fy;tpf; fofj;ijj;
Njhw;Wtpj;jhH?
a. 1927 b. 1936
c. 1895 d. 1946 
Ref:- NR IAS ACADEMY’S 10th Tamil Test 10.3
Qn.No.53
31. \\fiyAiuj;j fw;gidNa epiynadf; nfhz;lhLk;
fz;%b tof;fnkyhk; kz;%bg; Nghf|| - vdg; ghbatH
a. ts;syhH  b. ghujpahH
c. ngUe;NjtdhH d. ghujpjhrdhH
Ref:- NR IAS ACADEMY’S 10th Tamil Book
Page.208
32. chpa tpiliaj; NjHe;njOJf:-ngz; mbik Mdjw;F chpa fhuzq;fspy; xd;W
vJ ,y;yhik vd;W nghpahH $WfpwhH?
a. thf;Fhpik b. Ngr;Rhpik
c. nrhj;Jhpik 
d. vOj;Jhpik
Ref:- NR IAS ACADEMY’S Tamil Test 10.2 Qn.No.73
33. jpU.tp.f. gpwe;j Js;sk; vd;w CH jw;nghOJ ............
vd;W miof;fg;gLfpwJ.
a. gy;ytGuk; b. ,yl;RkpGuk;
c. jz;lyk;  d. ,uhktuk;
Ref:- NR IAS ACADEMY’S Tamil Test 7.1 Qn.No.2
34. Nfhbl;l ,lj;ij epug;Gf:-fd;dpahFkhpf;Fk; kJiuf;Fk; ,ilNa mike;j
neLQ;rhiyf;F ngaH .....................
a. jpy;iyahb ts;spak;ik
NR IAS ACADEMY
b. NtYehr;rpahH
c. ,uhzp kq;fk;khs; 
d. [hd;rp uhzp
Ref:- NR IAS ACADEMY’S Tamil Test-9.8 Qn.No.54
35. \\,k;nkd;Dk; Kd;Nd vOE}Wk; vz;Z}Wk;>
mk;nkd;why; Mapuk; ghl;Lk;|| ghlty;y MRftp ahH?
a. fhsNkfg; GytH 
b. ghujpahH
c. ,sQ;#hpaH
d. KJ #hpaH
Ref:- NR IAS ACADEMY’S nghJj;jkpo; Vol-I
Page.No.22 Qn.No.310
36. jtwhd $w;iwj; NjHT nra;f:-a. \\khdpltHf;F vd;W Ngr;Rg;gby; thofpy;Nyd;|| -Mz;lhs;
b. \\thdhSk; nry;tKk; kz;zuRk; ahd;
Ntz;Nld;|| - FyNrfu Mo;thH
c. \\fUtpDk; fUtha; ngUe;jtk; Ghpe;j fUj;jidg;
nghUe;Jjy; fUj;Nj|| - vr;.V. fpU~;zgps;is
d. \\MjpAk; me;jKk; ,y;yh mUl;ngUQ;Nrhjp||
- khzpf;fthrfH 
Ref:- NR IAS ACADEMY’S +2 Tamil Page No.113
37. nghUj;Jf:-a. C 1. jiytd;
b. I 2. Cd;
c. neh 3. flTs;
d. Nj 4. Jd;GW
a b c d
a. 1 4 3 2
b. 2 1 4 3 
c. 4 3 2 1
d. 3 1 2 4
38. nghUj;Jf:-a. rpyg;gjpfhuk; 1. rPHjpUj;jf; fhg;gpak;
b. kzpNkfiy 2. nrhw;NghH fhg;gpak;
c. rPtfrpe;jhkzp 3. Fbkf;fs; fhg;gpak;
d. Fz;lyNfrp 4. tUzidf; fhg;gpak;
a b c d
a. 3 1 4 2 
b. 3 2 4 1
c. 2 1 3 4
d. 4 3 1 2
Ref:- NR IAS ACADEMY’S nghJjkpo; Vol-I Page
4,56
39. \kUfp| vd;gJ ahiuf; Fwpf;Fk;?
a. kUkfs;  b. kfs;
c. nfhOe;jp d. khkpahH
Ref:- NR IAS ACADEMY’S +2 Tamil Question Bank
40. ghujpapd; gilg;gpy; ,irapd; ngUik NgRk; E}y;
vJ?
a. fz;zd; ghl;L
b. Fapy; ghl;L 
c. ghg;gh ghl;L d. ghQ;rhyp rgjk;
Ref:- NR IAS ACADEMY’S +1 Tamil Book Page
No.58
41. \\GJnewpfz;l GytH|| vd;W Nghw;wg;gl;ltH
a. ,uhkypq;f mbfshH 
b. jhAkhdtH
c. jpU.tp.f. d. ftpkzp
Ref:- NR IAS ACADEMY’S 10th Tamil test - 10.9
Page No.69
42. gl;bay;-Iy; cs;s nrhw;nwhliug; gl;bay-;II y; cs;s
nrhw;nwhlUld; nghUj;jp nfhLf;fg;gl;Ls;s
FwpaPLfisf; nfhz;L rhpahd tpiliaj; NjHe;njL
gl;bay; I gl;bay; II
a. md;gpyhH 1. MHtKilik
b. md;GilahH 2. capHepiy
c. md;G <Dk; 3. vd;Gk; chpaH
d. md;gpd;
topaJ 4. vy;yhk; jkf;FhpaH
a b c d
a. 2 3 4 1
b. 4 3 1 2 
c. 1 4 2 3
d. 3 2 1 4
Ref:- NR IAS ACADEMY’S 6th Tamil md;Gilik
mjpfhuk;
43. \nrOq;fdpj; jPQ;Rit| vd;w nrhw;nwhlH rhpahfg;
gphpf;fg;gl;bUg;gJ vJ?
a. nrOik + fdp + jPQ;Rit
b. nrOk; + fdp + jPQ;Rit
c. nrOk; + fdp + jPk; + Rit
d. nrOik + fdp + jPk; + Rit 
Ref:- NR IAS ACADEMY’S 10th Tamil Page No.29
44. \KLfpdd;| vd;w nrhy;Yf;F Vw;w vjpHr;nrhy; VJ?
a. nrYj;jpdhd; b. epWj;jpdhd; 
c. tisj;jhd; d. Khpj;jhd;
Ref:- NR IAS ACADEMY’S 10th Tamil Book Page
No.63
45. \\itafj nky;yh nkknjd; nwOJNk|| vd;w
Gfo;r;rpf;Fhpa kd;dd; ahH?
a. Nrud; b. gy;ytd;
c. Nrhod; d. ghz;bad; 
Ref:- NR IAS ACADEMY’S 9th Tamil Book
Page.No.99
46. rhpahdtw;iwf; fhz;f:-1. eP + I = epd;id
2. eP + mJ = epdJ
3. eP + My; = ePahy;
4. eP + F = ePf;F
a. 2>3 - rhp b. 1>2 - rhp 
c. 3>4 - rhp d. ehd;Fk; rhp
Ref:- NR IAS ACADEMY’S 9th Tamil Book
Page No.69
47. nghUSf;F Vw;w nghUj;jkhd ctikiaj;
NjHe;njLj;J vOJf:-cyf epiyfis mwpahjpUj;jy;
a. fPhpAk; ghk;Gk; Nghy
b. ,yT fhj;j fpsp Nghy
c. fpzw;Wj; jtis Nghy 
d. mdypilg;gl;l GO Nghy
48. ,yf;fzf; Fwpg;gwpjy;:-gpd;tUk; ,yf;fzf; Fwpg;Gf;Fg; nghUe;jhjr;
nrhy;iyj; NjHe;njLf;fTk;.
gz;Gj;njhif
a. neLe;NjH b. kyHr;Nrtb 
NR IAS ACADEMY
c. nrq;Nfhy; d. fUq;Fuq;F
49. ngaHr; nrhy;ypd; tifawpjy;:-\fhpad;| - vd;w ngaHnrhy;ypd; tif mwpf
a. rpidg; ngaH b. nghUl;ngaH
c. gz;Gg;ngaH 
d. njhopw;ngaH
50. \\ehkhHf;Fk; Fbay;Nyhk; ekid mQ;Nrhk;
eufj;jpy; ,lHg;gNlhk; eliy ,y;Nyhk;||
,g;ghlybfspy; ,lk;ngw;Ws;s \eliy|f;F ,izahd
Mq;fpyr; nrhy;iy vOJf:-a. Affection b. Affliction 
c. Attraction d. Addition
51. ngaHr; nrhy;ypd; tifawpjy;:-\Mjpiuahd;| vd;w ngaHr;nrhy;ypd; tifawpf:
a. gz;Gg; ngaH b. njhopw;ngaH
c. fhyg;ngaH
d. Fzg;ngaH
52. \\,Of;f YilAop Cw;Wf;Nfh yw;Nw
xOf;f KilahHtha;r; nrhy;||
mbf;Nfhbl;l nrhy;Yf;F ,izahd Mq;fpyg;
gjj;jpidj; NjHf:-a. An assistant b. Supporter 
c. Staff d. Friends
53. ,yf;fzf; Fwpg;gwpjy;:
gpd;tUk; ,yf;fzf; Fwpg;Gf;F nghUe;jpa nrhy;iyj;
NjHe;njLf;f.
(A) nre;eha; (B) #o;foy; 
(C) ntz;kjp (D) fz;Nzhl;lk;
54. Nfhbl;l ,lj;ij epug;Gf:
jpy;iyahb ts;spak;ik ................... ehl;by; gpwe;jhH.
(A) mnkhpf;fh (B) ,j;jhyp
(C) ,e;jpah (D) njd;dhg;gphpf;fh 
Ref:- NR IAS ACADEMY’S 9th Tamil Test 9.8
Qn.No.25
55. ‘ghit ghba thahy; Nfhit ghLf ’ vd;W nrhy;yf;
Nfl;L ghlg;gl;l E}y; vJ?
(A) mrjpf; Nfhit
(B) Mrhuf; Nfhit
(C) jpUf;NfhitahH 
(D) Kk;kzpf; Nfhit
Ref:- NR IAS ACADEMY’S jkpo; ,yf;fpa tuyhW
Page No.80 Qn.No.9
56. guzp ,yf;fpaj;jpw;Fhpa ghtifiaf; Fwpg;gpLf.
(A) ntz;gh (B) tpUj;jg;gh
(C) fyp tpUj;jk;
(D) fypj;jhopir 
Ref:- NR IAS ACADEMY’S +2 Tamil Page No.65
57. gl;bay; Iy; cs;s nrhw;nwhliug; gl;bay; II y; cs;s
nrhw;nwhlUld; nghUj;jp FwpaPLfisf; nfhz;L
rhpahd tpiliaj; NjHe;njL.
gl;bay;I gl;bay;II
(a) fstop ehw;gJ 1. epiyahik
(b) KJnkhopf; fhQ;rp 2. Ntshz; Ntjk;
(c) ehybahH 3. MW kUe;J
(d) Vyhjp 4. Gwg;nghUs;
(a) (b) (c) (d)
(A) 3 1 2 4
(B) 2 3 4 1
(C) 1 3 4 2
(D) 4 1 2 3 
Ref:- NR IAS ACADEMY’S nghJj; jkpo; Vol-I,
Page 8,9,10
58. Nfhbl;l ,lj;ij epug;Gf:
epfz;Lfspy; kpfg; goikahdJ ..............
(A) Nre;jd; jpthfuk; 
(B) #lhkzp epfz;L
(C) mfuhjp (D) ,jpy; vJTk; ,y;iy
Ref:- NR IAS ACADEMY’S 8th Tamil Book
Page.No.26
59. nghUswpe;J nghUj;Jf:
(a) X 1. Nfhgk;
(b) kh 2. Nrhiy
(c) fh 3. ePH jhq;Fk; gyif
(d) jP 4. jpUkfs;
(a) (b) (c) (d)
(A) 2 4 1 3
(B) 1 3 4 2
(C) 3 4 2 1
(D) 4 1 3 2
60. ‘ KUF nghUehW ghzpuz;L Ky;iy’
,j;njhlhpy; ‘ ghzpuz;L’ vd;w njhluhy; Fwpf;fg;gLk;
E}y;fs; vit?
(A) mfehD}W> GwehD}W
(B) Ky;iyg;ghl;L> FwpQ;rpg;ghl;L
(C) jpUKUfhw;Wg;gil> nghUeuhw;Wg;gil
(D) rpWghzhw;Wg;gil> ngUk;ghzhw;Wg;gil
Ref:- NR IAS ACADEMY’S 10th Tamil Book Page
No.12
61. chpa tpiliaj; NjHf:
mfuhjp vd;Dk; nrhy;iy Kjd; Kjyhf ifahz;ltH
ahH?
(A) jpU%yH  (B) tPukhKdptH
(C) jpUehTf;furH (D) fk;gH
Ref:- NR IAS ACADEMY’S Tamil Test - 8.2
62. nghUj;Jf:
(a) Fanfare 1. ,zf;fKs;s
(b) Fangle 2. tPl;Lg; Gwh
(c) Fantail 3. vf;fhs Kof;fk;
(d) Facile 4. ehfhpfk;
(a) (b) (c) (d)
(A) 3 4 2 1 
(B) 4 1 3 2
(C) 2 3 4 1
(D) 1 4 2 3
63. mbtiuaiw mwpe;J rhpahd thpiriaf; Fwpg;gpLf.
(a) 3 - 6 (b) 4 - 8
(c) 9 - 12 (d) 13 - 31
(A) Iq;FWE}W> FWe;njhif> ew;wpiz>
mfehD}W 
(B) mfehD}W> ew;wpiz> FWe;njhif>
Iq;FWE}W
(C) FWe;njhif> Iq;FWE}W> ew;wpiz>
mfehD}W
(D) ew;wpiz> mfehD}W> Iq;FWE}W>
FWe;njhif
64. jd;tpidiaj; NjHe;J vOJf.
NR IAS ACADEMY
(A) mg;G+jp mbfs; ehd;kiw fw;ftpy;iy
(B) mg;G+jp mbfs; ehd;kiw fw;gpj;jhH
(C) mg;G+jp mbfs; ehd;kiw fw;whH 
(D) mg;G+jp mbfs; ehd;kiw fw;whuh?
65. gl;bay; Iy; cs;s nrhw;nwhliu gl;bay; II y; cs;s
njhlHfSld; nghUj;jp fPNo cs;s FwpaPLfisf;
nfhz;L rhpahd tpiliaj; NjHe;njL.
gl;bay; I gl;bay;II
(a) NgijaH el;G 1. cLf;if,oe;jif
(b) gz;GilahH njhlHG 2. tsHgpiw
(c) mwpTilahH el;G 3. eypy; NjhWk;
(d) ,Lf;fz; fisAk; el;G 4. Nja;gpiw
(a) (b) (c) (d)
(A) 4 3 2 1 
(B) 3 4 2 1
(C) 4 3 1 2
(D) 1 2 3 4
66. rhpahd tpiliaj;NjHT nra;f.
‘ Mapil mzq;fpd; fw;Gk; Ia epd;dUSk; nra;a
J}a ey;ywDk; vd;wpq;fpizad njhlHe;J fhg;g’
,t;thpfspy; rPijia mopahky; fhg;ghw;wpait
vit?
(A) md;Gk; gz;Gk;
(B) mwpTk; Mw;wYk;
(C) mwDk; kwDk;
(D) fw;Gk; mUSk; 
67. ‘ tsd;’ vd;w nrhy;yhy; Fwpf;fg;gLtd; ahH?
(A) jhtPJ (B) Nfhypahj;J
(C) #irag;gH 
(D) rTy; kd;dd;
68. IQ;rpW fhg;gpak; - ,tw;Ws; nghUe;jh E}iyf; fz;lwp.
(A) cjaz Fkhu fhtpak;
(B) ,uhtz fhtpak; 
(C) ehf Fkhu fhtpak;
(D) aNrhjuh fhtpak;
69. gl;bay; I I gl;bay; II -cld; nghUj;jp fPNo
nfhLf;fg;gl;Ls;s FwpaPLfisf; nfhz;L rhpahd tpil
NjHf.
gl;bay; I gl;bay; II
(a) Gs; 1. tpiuT
(b) FyT 2. fyg;ig
(c) Nkop 3. md;dk;
(d) xy;iy 4. tpsq;Fk;
(a) (b) (c) (d)
(A) 2 4 1 3
(B) 4 1 2 3
(C) 3 4 2 1 
(D) 3 1 4 2
Ref:- NR IAS ACADEMY’S 8th Tamil - ,ay; - 3
Page No.43
70. nghUe;jhj ,iziaf; fz;lwpf.
(A) Mishap - tpgj;J
(B) Miserable - Jf;ffukhd
(C) Mislay - jtwhd nrhy; 
(D) Misdeed - nfl;l nray;
71. ‘tho;j;JNthk;’ vd;w nrhy;ypd; NtHr;nrhy;iy vOJf.
(A) tho; (B) tho;j;Jjy;
(C) tho;j;J  (D) tho;j;Jk;
72. gpd;tUk; ,uz;bDk; nghUs; nghUe;jhj ,iziaj;
NjHe;njL.
fio fis
(A) fUk;G - moF
(B) %q;fpy; - fhe;jp
(C) Nta; - rPiy  May be
(D) fop - mfw;W
73. mfu thpirg;gb nrhw;fisr; rPH nra;jy;
a. juq;fk;> ijay;> jpl;gk;> NjhL
b. ijay;> NjhL> jpl;gk;> juq;fk;
c. juq;fk;> jpl;gk;> ijay;> NjhL 
d. juq;fk;> ijay;> NjhL> jpl;gk;
74. nghUj;Jf:-GytH E}y;
a. ckWg;GytH 1. njhd;D}y; tpsf;fk;
b. fk;gH 2. ehptpUj;jk;
c. jpUj;jf;fNjtH3. rpiy vOgJ
d. tPukhKdptH 4. KJnkhopkhiy
a b c d
a. 4 2 3 1
b. 4 3 2 1 
c. 3 1 4 2
d. 2 4 1 3
Ref:- NR IAS ACADEMY’S nghJjkpo; Vol-I Page
No.1,2,3
75. \cWkplj; Jjth ctHepyk;| vd;w thpfs; ,lk;ngw;w
E}y; vJ?
a. GwehD}W 
b. mfehD}W
c. Iq;FWE}W d. jpUf;Fws;
Ref:- NR IAS ACADEMY’S Shortcut - Gwk;Nghf;F
cjtkhl;lhd;
76. jpU.tp.f ve;j ehspjo; Mrphpauhf gzpahw;wpdhH?
a. Njr gf;jd; 
b. njd;wy;
c. ,e;jpah d. RNjrkpj;jpud;
77. \nghW| vd;Dk; NtHr;nrhy;ypd; tpidahyizAk;
ngaiu NjHe;njL:-a. nghWj;jhd; b. nghWj;J
c. nghWj;jy; d. nghWj;jtH 
78. \md;gUf;Fg; gzp nra;tNj cz;ikj; njhz;L| vdf;
$wpatH ahH?
a. ,uhkypq;f mbfs;
b. jhAkhdtH 
c. MWKf ehtyH
d. FkuFUguH
Ref:- NR IAS ACADEMY’S Tamil Test - 11.1
79. chpa tpilia vOJf:-\\cynfy;yhk; czHe;J Xjw;fhpatd;|| vdj;
njhlq;Fk; ghly; ,lk; ngw;Ws;s E}y; vJ?
a. fe;jGuhzk; b. jpUke;jpuk;
c. nghpaGuhzk; 
d. jpUtpisahlw;Guhzk;
Ref:- NR IAS ACADEMY’S Tamil Test - 10.9
Qn.No. 47
80. mfu thpirg;gb nrhw;fisr; rPHnra;jy;:-
NR IAS ACADEMY
a. tPz;> tPo;r;rp> tPL> tPjp
b. tPL> tPz;> tPjp> tPo;r;rp 
c. tPo;r;rp> tPz;> tPjp> tPL
d. tPo;r;rp> tPL> tPjp> tPz;
81. vL - vd;Dk; NtHr;nrhy;ypd; tpidnar;rj;ij vOJf:-a. vLj;j b. vLj;jy;
c. vLj;J  d. vLj;jhd;
82. Nfhbl;l ,lj;ij epug;Gf:-\Qhy;| vd;gjw;F ..................... vd;gJ nghUs;.
a. njhq;Fjy; 
b. Qhyk;
c. njhlq;Fjy; d. thOjy;
Ref:- NR IAS ACADEMY’S 10th Tamil Test - 10.7
83. \\ts;Stidg; ngw;wjhw; ngw;wNj Gfo; itafNk||
- ghbatH ahH?
a. ghujpahH b. Rujh
c. jhuh ghujp d. ghujpjhrd; 
Ref:- NR IAS ACADEMY’S Tamil Test - 8 Qn.No.22
84. tpilf;Nfw;w tpdhitj; NjHf:-\md;Gs ,dp ehk; XH ItHfs; csuhNdhk;|
a. vjdhy; ItuhdhHfs;? 
b. ItH ahH?
c. Ie;jhtjhf te;jtd; ahH?
d. ahhplk; $wpdhd;?
85. jkpo; vOj;Jfspy; xU ey;y rPHjpUj;jj;jpidf;
nfhzHe;jtH ahH?
a. Ntjehafk; gps;is
b. tPukhKdptH 
c. H.A. fpU~;zg; gps;is
d. c.Nt. rhkpehijaH
Ref:- NR IAS ACADEMY’S jkpo; ,yf;fpa
tuyhW Page. No.93 Qn.No.6
86. ruRtjp vd;W rpj;jHfs; vjidf; Fwpg;gpLfpd;wdH?
a. fhrpdpf; fPiu
b. ty;yhiuf; fPiu 
c. griyf; fPiu
d. mfj;jpf; fPiu
87. chpa tpiliaj; NjHf:-jkpo; gbj;jhy; vJ ngUFk;?
a. GJik b. jpwk;
c. mwk;  d. Gwk;
Ref:- NR IAS ACADEMY’S 7th Tamil Book Page
No.22
88. nghUj;Jf:-a. Camphor 1. ngha;f;fij
b. Chide 2. fytuk;
c. Chaos 3. ryryg;G
d. Canard 4. fw;G+uk;
a b c d
a. 1 4 2 3
b. 3 1 4 2
c. 2 4 1 3
d. 4 3 2 1 
89. ebg;Gr; nrt;tpAk; ,yf;fpar; nrt;tpAk; xUq;Nf
mikag; ngw;w fhg;gpak; vJ?
a. rpyg;gjpfhuk;
b. ghQ;rhyp rgjk;
c. kNdhd;kzPak; 
d. kzpNkfiy
Ref:- NR IAS ACADEMY’S +1 Tamil Question Bank
Test - 4
90. ctikf;F Vw;w nghUj;jkhd nghUisj;
NjHe;njLj;J vOJf:-\\nfhf;nfhf;f $k;Gk; gUtj;J||
a. fhj;jpUj;jy; 
b. ntWj;jpUjy;
c. mwpahjpUj;jy;
d. kwe;jpUj;jy;
Ref:- NR IAS ACADEMY’S 10th Tamil Book Page
No.9
91. ngaHr;nrhy;ypd; tifawpjy;:-rpidg; ngaiuj; NjHe;J vOJf.
a. Cud; b. Kf;fd; 
c. twpad; d. filad;
92. kdf;Fif - ,yf;fzf; Fwpg;G vOJf:-a. tpidj;njhif
b. ctikj; njhif
c. cUtfk; 
d. ck;ikj; njhif
93. ,yf;fzf; Fwpg;gwpjy;
rhd;W : cskida jz;zspj;jha; cWNtdpw;
ghptfw;W \cWNtdpy;| - ,yf;fzk; NjHe;J vOJf
a. tpidj;njhif
b. md;nkhopj;njhif
c. njhopy;ngaH
d. chpr;nrhy; 
94. fPo;f;fhZk; njhlHfspy; vj;njhlH rhpahdJ?
a. rd;khHf;f ftp ,uhkypq;f mbfshH 
b. rpyk;Gr; nry;tH ,sq;Nfhtbfs;
c. ,ir;f;Fapy; rNuh[pdp ehAL
d. ftpf;Nfh Kbaurd;
Ref:- NR IAS ACADEMY’S nghJkjpo; Vol-I Page
No.8,9,10
95. rhpahd tpiliaj; NjHT nra;f:-fk;gehlfj;jpd; ahg;G tz;zq;fspd; vz;zpf;if
a. 100 b. 80
c. 96  d. 108
Ref:- NR IAS ACADEMY’S +2 T amil Book
Page.No.58
96. \gz;nzhL jkpnohg;gha;| vdj; njhlq;Fk; ghly;
,lk;ngWk; E}y;
a. jpUthrfk;
b. Njthuk; 
c. jpUf;NfhitahH
d. jpUke;jpuk;
Ref:- NR IAS ACADEMY’S Shortcut Njth gd;D
rhg;gpLfpwhH
97. nghUe;jhj njhliuf; fz;lwp:-a. mlf;fk; mkuUs; ca;f;Fk;
b. fw;f frlw
c. jPJk; ed;Wk; gpwHju thuh 
d. nry;tj;Js; nry;tk; nrtpr;nry;tk;
Ref:- NR IAS ACADEMY’S nghJjkpo; Vol-I Page
No.12 (Shortcut - Gwj;jpw;F te;jhy; ey;yJ
nfl;lJ njhpAk;)
NR IAS ACADEMY
98. nghUj;Jf:-ahUila $w;W
a. Njuh kd;dh nrg;GtJ
cilNad; 1. kzpNkfiy
b. jPAk; nfhy;yhj;
jPtpid ahl;bNad; 2. Nfhtyd;
c. rpiwf; Nfhl;lj;ij
mwf; Nfhl;lkhf;Ff 3. fz;zfp
d. rPwbr; rpyk;G nfhz;LNgha;
khwptUtd; 4. Mjpiu
a b c d
a. 3 4 1 2 
b. 3 4 2 1
c. 4 3 2 1
d. 1 2 3 4
Ref:- NR IAS ACADEMY’S 10th Tamil Test - 10.2
Qn.No.14
99. 63 jdpabahH tuyhw;iwf; $Wk; E}y; vJ?
a. fe;jGuhzk;
b. jpUtpisahlw; Guhzk;
c. nghpa Guhzk; 
d. jzpif Guhzk;
Ref:- NR IAS ACADEMY’S jkpo; ,yf;fpa tuyhW
Page No.62 Qn.No.20
100. nghUj;jkhd gonkhopiaf; fz;lwp.
fw;whiuf; fw;whNu fhKWtH
a. Qhapiwf; ifkiwg;ghH ,y;
b. Ks;spdhy; Ks;fisAk; MW
c. ghk;G mwpAk; ghk;gpd; fhy; 
d. Mw;W czh Ntz;LtJ ,y;
NR IAS ACADEMY

Tuesday, March 5, 2013

image

Monday, March 4, 2013

Purchase Entry

OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=E:\\Rice\\Rice.mdb");

public Purchase()
{
InitializeComponent();
}

private void Idgen()
{
int id = 0;
String str1 = "Select MAX(PurNos) from T_PurMasTable";
OleDbCommand cmd = new OleDbCommand(str1, con);
con.Open();
OleDbDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
if (dr.IsDBNull(0) == false)
{
id = dr.GetInt32(0) + 1;
}
else
{
id = 1;
}
}
cbxpurno.Text = id.ToString();
dr.Close();
con.Close();
}
private void Idshow()
{
cbxpurno.Items.Clear();
cbxpurno.Text = "Select";
String str = "Select * from T_PurMasTable";
OleDbCommand cmd = new OleDbCommand(str, con);
con.Open();
OleDbDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
if (dr.IsDBNull(0) == false)
{
cbxpurno.Items.Add(dr.GetValue(0).ToString());
}
}
dr.Close();
con.Close();
}
private void TextClear()
{
cbxRBname.Text = "";
cbxrtype.Text = "";
txtnopct.Text = "";
txttotkg.Text = "";
txtprice.Text = "";
txttotamt.Text = "";
}

private void RsTot()
{
try
{

double NetAmt = 0;
int c = dataGridView1.Rows.Count - 1;

for (int i = 0; i < c; i++)
{

string NAmt = dataGridView1[5, i].Value.ToString();

double Amt = Convert.ToDouble(NAmt );

NetAmt += Amt ;
}

txtnetamt .Text = Convert.ToString(NetAmt );
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}

private void AddtoGrid()
{
if (cbxRBname.Text != "Select" && txtnopct.Text != "" && txttotkg.Text != "" && txtprice.Text != "")
{
string sn = dataGridView1.Rows.Count.ToString();
string brand = cbxRBname.Text;
string npcts = txtnopct.Text;
string tot = txttotkg.Text;
string pri = txtprice.Text;
string totamt = txttotamt.Text;

string[] add = new string[] { sn, brand, npcts, tot, pri, totamt };
dataGridView1.Rows.Add(add);

}
}

private void Purchase_Load(object sender, EventArgs e)
{
stock();
purchase();

cbxdtppurdate.Text = DateTime.Now.ToShortDateString();
cbxRBname.Text = "Select";
cbxpurno.Text = "Select";
//txtinvono.Text = "Select";
cbxsupname.Text = "Select";
//rice();

String str3 = "Select * from Supinfo";
OleDbCommand cmd = new OleDbCommand(str3, con);
con.Open();
OleDbDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
if (dr.IsDBNull(0) == false)
{
cbxsupname.Items.Add(dr.GetValue(1).ToString());
}
}
dr.Close();
con.Close();

}
private void stock()
{
String str4 = "Select * from StockEntry";
OleDbCommand cmd1 = new OleDbCommand(str4, con);
con.Open();
OleDbDataReader dr1 = cmd1.ExecuteReader();
while (dr1.Read())
{
if (dr1.IsDBNull(0) == false)
{
cbxRBname.Items.Add(dr1.GetValue(1).ToString());
cbxrtype.Items.Add(dr1.GetValue(2).ToString());
}
if (cbxRBname.Items.Count == 1)
{
cbxRBname.DropDownStyle = ComboBoxStyle.Simple;
}
else
cbxRBname.DropDownStyle = ComboBoxStyle.DropDown;
}
dr1.Close();
con.Close();

}

Thursday, February 28, 2013

data grig clear in c#

gridView1.DataSource = null;
gridView1.DataBind();

===============
this.dataGridView1.Rows.Clear();

=============
dataGridView1.Rows.Clear();

-------------------
((DataTable)dataGridView1.DataSource).Rows.Clear();
***************************
------------
dataGridView1.Rows.Clear();
dataGridView1.Refresh();
-------------

stock Entry

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;

namespace Rice
{
public partial class StockEntry : Form
{
OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=E:\\Rice\\Rice.mdb");

public StockEntry()
{
InitializeComponent();
}
private void Idgen()
{
int id = 0;
String str1 = "Select MAX(Riceid) from StockEntry";
OleDbCommand cmd = new OleDbCommand(str1, con);
con.Open();
OleDbDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
if (dr.IsDBNull(0) == false)
{
id = dr.GetInt32(0) + 1;
}
else
{
id = 1;
}
}
cbxRiceId.Text = id.ToString();
dr.Close();
con.Close();
}
private void Idshow()
{
cbxRiceId.Items.Clear();
cbxRiceId.Text = "Select";
String str = "Select * from StockEntry";
OleDbCommand cmd = new OleDbCommand(str, con);
con.Open();
OleDbDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
if (dr.IsDBNull(0) == false)
{
cbxRiceId.Items.Add(dr.GetValue(0).ToString());
}
}
dr.Close();
con.Close();
}

private void TextClear()
{
txtRname.Text = "";
cbxRunit .Text = "";
txtRUPkg.Text = "";
cbxRiceId.Text = "Select";
}

private void newToolStripMenuItem_Click(object sender, EventArgs e)
{
TextClear();
Idgen();
}

private void openToolStripMenuItem_Click(object sender, EventArgs e)
{
if (cbxRiceId.Text == "Select")
{
MessageBox.Show("Select The Rice Id");
cbxRiceId.Focus();
return;
}
else
{
String str = "Select * from StockEntry where Riceid=" + cbxRiceId.Text + "";
OleDbCommand cmd = new OleDbCommand(str, con);
con.Open();
OleDbDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
if (dr.IsDBNull(0) == false)
{
txtRname.Text = dr.GetValue(1).ToString();
cbxRunit .Text = dr.GetValue(2).ToString();
txtRUPkg.Text = dr.GetValue(3).ToString();
}
}
dr.Close();
con.Close();
}
}

private void saveToolStripMenuItem_Click(object sender, EventArgs e)
{
String str1 = "Select * from StockEntry";
OleDbCommand cmd1 = new OleDbCommand(str1, con);
con.Open();
OleDbDataReader dr1 = cmd1.ExecuteReader();
while (dr1.Read())
{
if (dr1.IsDBNull(0) == false)
{
string rid = dr1.GetValue(0).ToString();
if (cbxRiceId.Text == rid)
{
MessageBox.Show("This Number Already Exist");
cbxRiceId.Focus();
con.Close();
goto l1;
}
}
}
con.Close();

if (cbxRiceId.Text == "Select")
{
MessageBox.Show("Select The Rice Id");
cbxRiceId.Focus();
return;
}
if (txtRname.Text == "")
{
MessageBox.Show("Enter The Brand Name");
txtRname.Focus();
return;
}
if (cbxRunit .Text == "")
{
MessageBox.Show("Enter The No Unit Rice");
cbxRunit.Focus();
return;
}
if (txtRUPkg.Text == "")
{
MessageBox.Show("Enter The Rice Unit Per Kg");
txtRUPkg.Focus();
return;
}

String str = "Insert into StockEntry(Riceid,Ricename,Riceunit,Ricepkg)Values(" + cbxRiceId.Text + ",'" + txtRname.Text + "'," + cbxRunit.Text + "," + txtRUPkg .Text + ")";
OleDbCommand cmd = new OleDbCommand(str, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Saved");
Idshow();
TextClear();

l1:
dr1.Close();
}

private void updateToolStripMenuItem_Click(object sender, EventArgs e)
{
if (cbxRiceId.Text == "Select")
{
MessageBox.Show("Select The Rice Id");
cbxRiceId.Focus();
return;
}
else
{
String str = "Update StockEntry SET Ricename='" + txtRname.Text + "',Riceunit=" + cbxRunit.Text + ",Ricepkg=" + txtRUPkg.Text + " where Riceid=" + cbxRiceId.Text + "";
OleDbCommand cmd = new OleDbCommand(str, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Updated");
Idshow();
TextClear();

}
}

private void deleteToolStripMenuItem_Click(object sender, EventArgs e)
{
if (cbxRiceId.Text == "Select")
{
MessageBox.Show("Select The Rice Id");
cbxRiceId.Focus();
return;
}
else
{
String str = "Delete * from StockEntry where Riceid=" + cbxRiceId.Text + "";
OleDbCommand cmd = new OleDbCommand(str, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Deleted");
Idshow();
TextClear();
}
}

private void StockEntry_Load(object sender, EventArgs e)
{
cbxRiceId.Text = "Select";
String str = "Select * from StockEntry";
OleDbCommand cmd = new OleDbCommand(str, con);
con.Open();
OleDbDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
if (dr.IsDBNull(0) == false)
{
cbxRiceId.Items.Add(dr.GetValue(0).ToString());
}
}
dr.Close();
con.Close();
}
private void OnlyNumberWithDot(object sender, KeyPressEventArgs e)
{
if (!(char.IsNumber(e.KeyChar)) && (e.KeyChar != 8) && (e.KeyChar != 46))
{
e.Handled = true;
}
}
private void OnlyNumber(object sender, KeyPressEventArgs e)
{
if (!(Char.IsNumber(e.KeyChar)) && (e.KeyChar != 8))
{
e.Handled = true;
}
}
private void cbxRunit_KeyPress(object sender, KeyPressEventArgs e)
{
OnlyNumberWithDot(sender, e);
}
private void txtRUPkg_KeyPress(object sender, KeyPressEventArgs e)
{
OnlyNumberWithDot(sender, e);
}

private void exitToolStripMenuItem_Click(object sender, EventArgs e)
{
Application.ExitThread();
}

private void txtRUPkg_TextChanged(object sender, EventArgs e)
{

}

private void cbxRunit_SelectedIndexChanged(object sender, EventArgs e)
{
if (cbxRunit.Text != "")
{

txtRUPkg.Text = ((Convert.ToInt32(cbxRunit.Text) * 25).ToString());
}

}

}
}

supplier information

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;

namespace Rice
{
public partial class SupplierInfo : Form
{
OleDbConnection con = new OleDbConnection("Provider=microsoft.jet.oledb.4.0;data source=E:\\Rice\\Rice.mdb");
public SupplierInfo()
{
InitializeComponent();
}
private void TextClear()
{
cbxSupplierid.Text = "Select";
txtAddress.Text = "";
txtBalamount.Text = "";
txtContactno.Text = "";
txtEmail.Text = "";
txtMobile.Text = "";
txtSname.Text = "";
}
private void Idgen()
{
int id = 0;
String str2 = "select MAX(Supid) from Supinfo";
OleDbCommand cmd2 = new OleDbCommand(str2, con);
con.Open();
OleDbDataReader dr2 = cmd2.ExecuteReader();
while (dr2.Read())
{
if (dr2.IsDBNull(0) == false)
{
id = dr2.GetInt32(0) + 1;
}
else
id = 1;
}
cbxSupplierid.Text = id.ToString();
cbxSupplierid.Focus();
dr2.Close();
con.Close();
}
private void Idshow()
{

cbxSupplierid.Items.Clear();
String st1 = "Select * from Supinfo order by Supid";
OleDbCommand cm = new OleDbCommand(st1, con);
con.Open();
OleDbDataReader dr = cm.ExecuteReader();
while (dr.Read())
{
if (dr.IsDBNull(0) == false)
{
cbxSupplierid.Items.Add(dr.GetValue(0).ToString());
}
}
dr.Close();
con.Close();
}

private void newToolStripMenuItem_Click(object sender, EventArgs e)
{
txtBalamount.Enabled = false;
TextClear();
cbxSupplierid.Focus();
Idgen();
}
private void OnlyNumberWithDot(object sender, KeyPressEventArgs e)
{
if (!(char.IsNumber(e.KeyChar)) && (e.KeyChar != 8) && (e.KeyChar != 46))
{
e.Handled = true;
}
}
private void OnlyNumber(object sender, KeyPressEventArgs e)
{
if (!(Char.IsNumber(e.KeyChar)) && (e.KeyChar != 8))
{
e.Handled = true;
}
}
private void txtMobile_KeyPress(object sender, KeyPressEventArgs e)
{
OnlyNumber(sender, e);

}

private void openToolStripMenuItem_Click(object sender, EventArgs e)
{
if (cbxSupplierid.Text == "Select")
{
MessageBox.Show("Select The Supplier ID");
cbxSupplierid.Focus();
return;
}
else
{
String str = "Select * from Supinfo where Supid=" + cbxSupplierid.Text + "";
OleDbCommand cmd = new OleDbCommand(str, con);
con.Open();
OleDbDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
if (dr.IsDBNull(0) == false)
{
txtSname.Text = dr.GetValue(1).ToString();
txtAddress.Text = dr.GetValue(2).ToString();
txtContactno.Text = dr.GetValue(3).ToString();
txtMobile.Text = dr.GetValue(4).ToString();
txtEmail.Text = dr.GetValue(5).ToString();
txtBalamount.Text = dr.GetValue(6).ToString();
}
}
dr.Close();
con.Close();
}
}

private void saveToolStripMenuItem_Click(object sender, EventArgs e)
{
txtBalamount.Enabled = false;
String str1 = "Select * from Supinfo";
OleDbCommand cmd1 = new OleDbCommand(str1, con);
con.Open();
OleDbDataReader dr1 = cmd1.ExecuteReader();
while (dr1.Read())
{
if (dr1.IsDBNull(0) == false)
{
string sid = dr1.GetValue(0).ToString();
if (cbxSupplierid.Text == sid)
{
MessageBox.Show("This Number Already Exist");
cbxSupplierid.Focus();
con.Close();
goto l2;
}
}
}
con.Close();

if (cbxSupplierid.Text == "Select")
{
MessageBox.Show("Select The Supplier ID");
cbxSupplierid.Focus();
return;
}
if (txtSname.Text == "")
{
MessageBox.Show("Enter The Supplier Name");
txtSname.Focus();
return;
}
if (txtAddress.Text == "")
{
MessageBox.Show("Enter The Address");
txtAddress.Focus();
return;
}
if (txtContactno.Text == "")
{
MessageBox.Show("Enter The Contact Number");
txtContactno.Focus();
return;
}
if (txtMobile.Text == "")
{
MessageBox.Show("Enter The Mobile Number");
txtMobile.Focus();
return;
}
if (txtEmail.Text == "")
{
MessageBox.Show("Enter The Email Id");
txtEmail.Focus();
return;
}

//if (txtBalamount.Text == "")
//{
// MessageBox.Show("Enter The Balance Amount");
// txtBalamount.Focus();
// return;
//}

String str = "Insert into Supinfo(Supid,Supname,Address,Contactno,Mobile,Email)Values(" + cbxSupplierid.Text + ",'" + txtSname.Text + "','" + txtAddress.Text + "','" + txtContactno.Text + "','" + txtMobile.Text + "','" + txtEmail.Text + "')";
OleDbCommand cmd = new OleDbCommand(str, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Details Saved");
TextClear();
Idshow();

l2:
dr1.Close();
}

private void updateToolStripMenuItem_Click(object sender, EventArgs e)
{
if (cbxSupplierid.Text == "Select")
{
MessageBox.Show("Select The Supplier ID");
cbxSupplierid.Focus();
return;
}
else
{
String str = "Update Supinfo SET Supname='" + txtSname.Text + "',Address='" + txtAddress.Text + "',Contactno='" + txtContactno.Text + "',Mobile='" + txtMobile.Text + "',Email='" + txtEmail.Text + "' where Supid=" + cbxSupplierid.Text + "";
OleDbCommand cmd = new OleDbCommand(str, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Details Updated");
TextClear();
Idshow();
}
}

private void deleteToolStripMenuItem_Click(object sender, EventArgs e)
{
if (cbxSupplierid.Text == "Select")
{
MessageBox.Show("Select The Supplier ID");
cbxSupplierid.Focus();
return;
}
else
{
String str = "Delete * from Supinfo where Supid=" + cbxSupplierid.Text + "";
OleDbCommand cmd = new OleDbCommand(str, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Details Deleted");
TextClear();
Idshow();
}
}

private void exitToolStripMenuItem_Click(object sender, EventArgs e)
{
this.Close();
}

private void SupplierInfo_Load(object sender, EventArgs e)
{

cbxSupplierid.Text = "Select";
String str = "Select * from Supinfo";
OleDbCommand cmd = new OleDbCommand(str, con);
con.Open();
OleDbDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
if (dr.IsDBNull(0) == false)
{
cbxSupplierid.Items.Add(dr.GetValue(0).ToString());
}
}
dr.Close();
con.Close();

cbxSupplierid.Focus();

}

private void cbxSupplierid_SelectedIndexChanged(object sender, EventArgs e)
{

}
}
}