[C #] usage of datagridview

// Read the supplier table and bind it to the gridview <br/> private void bindgvsupplier () <br/>... {<br/> oracleconnection conn = This. conn (); <br/> oraclecommand cmd = new oraclecommand ("select * from supplier", Conn); <br/> oracledataadapter SDA = new oracledataadapter (CMD ); <br/> dataset DS = new dataset (); <br/> SDA. fill (DS, "supplier"); </P> <p> string [] suppid = new string [Ds. tables ["supplier"]. rows. count]; <br/> for (int I = 0; I <Ds. tables ["supplier"]. rows. count; I ++) <br/>... {<br/> suppid [I] = Ds. tables ["supplier"]. rows [I] [0]. tostring (); <br/>}< br/> This. gvsupplier. datasource = Ds. tables ["supplier"]; <br/> This. gvsupplier. datakeynames [0] = "suppid"; <br/> This. gvsupplier. databind (); <br/> This. lblpageindex. TEXT = convert. tostring (Int. parse (this. gvsupplier. pageindex. tostring () + 1); <br/> This. lbltotalpage. t EXT = This. gvsupplier. pagecount. tostring (); <br/> This. lblcount. TEXT = This. gettotalcount (). tostring (); <br/>}</P> <p> // events triggered by pagination <br/> protected void gvsupplier_pageindexchanging (Object sender, gridviewpageeventargs E) <br/>... {<br/> This. gvsupplier. pageindex = E. newpageindex; <br/> This. bindgvsupplier (); <br/> This. lblpageindex. TEXT = convert. tostring (Int. parse (this. gvsupplier. pageindex. tostring () + 1); <br/> This. cballselect_checkedchanged (this. cballselect, e); <br/>}</P> <p> // event triggered by the delete button <br/> protected void gvsupplier_rowdeleting (Object sender, gridviewdeleteeventargs E) <br/>... {<br/> int id = E. rowindex; </P> <p> gridviewrow gvr = This. gvsupplier. rows [ID]; <br/> int suppid = int. parse (Hyperlink) (gvr. cells [7]. controls [0]). text. tostring (); <br/> string sqlstring = "delete from supplier where sup PID = "+ suppid; <br/> // if there is only one data record on this page, you need to flip the page forward after deletion <br/> If (this. gvsupplier. rows. count = 1) <br/>... {<br/> If (this. gvsupplier. pageindex> 1) <br/>... {<br/> This. gvsupplier. pageindex --; <br/>}< br/> int result = executesql (sqlstring); <br/> If (result = 1) <br/>... {<br/> This. alert ("You successfully deleted a piece of data", this. page); <br/>}< br/> This. bindgvsupplier (); <br/> This. bindgvsupplier (); </P> <p >}</P> <p> // The delete binding button is true. Prompt <br/> protected void gvsupplier_rowdatabound (Object sender, gridviewroweventargs e) <br/>... {<br/> If (E. row. rowtype = datacontrolrowtype. datarow) <br/>... {<br/> linkbutton mylb = (linkbutton) (E. row. cells [8]. controls [1]); <br/> mylb. attributes. add ("onclick", "javascript: Return confirm ('Confirm to delete" + E. row. cells [0]. text +? ') "); <Br/> // change the color of the row when the mouse passes. <br/> E. row. attributes. add ("onmouseover", "this. style. backgroundcolor = '# ffffe7' "); <br/> E. row. attributes. add ("onmouseout", "this. style. backgroundcolor = 'transparent '"); <br/>}</P> <p> // execute an oracle statement <br/> private int executesql (string sqlstring) <br/>... {<br/> // try <br/> // {<br/> oracleconnection conn = This. conn (); <br/> Conn. open (); <br/> oraclecommand cmd = New oraclecommand (sqlstring, Conn); <br/> int export tedline = cmd. executenonquery (); <br/> Conn. close (); <br/> return inclutedline; <br/> //} <br/> // catch <br/> // {<br/> // return 0; <br/>/}< br/>}</P> <p> // events triggered when you click the edit button <br/> protected void gvsupplier_rowediting (Object sender, gridviewediteventargs e) <br/>... {<br/> string S = This. gvsupplier. datakeys [E. neweditindex] [1]. tostring (); <br/> this.txt addr1.te XT = "dddd" + S; <br/> This. gvsupplier. editindex = E. neweditindex; <br/> This. bindgvsupplier (); <br/>}< br/> // events triggered when the cancel button is clicked <br/> protected void gvsupplier_rowcancelingedit (Object sender, gridviewcancelediteventargs E) <br/>... {<br/> This. gvsupplier. editindex =-1; <br/> This. bindgvsupplier (); <br/>}< br/> // events triggered when the update button is clicked <br/> protected void gvsupplier_rowupdating (Object sender, gridviewupdateeventargs E) <br/>... {<br/> int id = E. rowindex; <br/> gridviewrow gvr = This. gvsupplier. rows [ID]; <br/> int suppid = int. parse (Hyperlink) (gvr. cells [7]. controls [0]). text. tostring (); <br/> string name = (textbox) gvr. cells [0]. controls [0]). text. tostring (); <br/> string status = (textbox) gvr. cells [1]. controls [0]). text. tostring (); <br/> string addr1 = (textbox) gvr. cells [2]. controls [0]). text. tostring (); <br/> St Ring addr2 = (textbox) gvr. cells [3]. controls [0]). text. tostring (); <br/> string city = (textbox) gvr. cells [4]. controls [0]). text. tostring (); <br/> string state = (textbox) gvr. cells [5]. controls [0]). text. tostring (); <br/> string zip = (textbox) gvr. cells [6]. controls [0]). text. tostring (); <br/> string sqlstring = "Update supplier set name = '" + name + "', status = '" + status + "', addr1 = '"+ addr1 + "', Addr2 = '"+ addr2 +"', city = '"+ city +"', state = '"+ state + "', zip = '"+ Zip +" 'where suppid = "+ suppid; <br/> int result = executesql (sqlstring); <br/> If (result = 1) <br/>... {<br/> //...... <br/>}< br/> This. gvsupplier. editindex =-1; <br/> This. bindgvsupplier (); <br/>}</P> <p> // Add a record <br/> protected void btnadd_click (Object sender, eventargs E) <br/>... {<br/> string name = this.txt Name. text. tostring (); <br/> string status = this.txt status. text. tostring (); <br/> string addr1 = this.txt addr1.text. tostring (); <br/> string addr2 = this.txt addr2.text. tostring (); <br/> string city = this.txt city. text. tostring (); <br/> string state = this.txt state. text. tostring (); <br/> string zip = this.txt zip. text. tostring (); <br/> string sqlstring = "insert into supplier values (sqsuppid. nextval, '"+ Name + "','" + status + "','" + addr1 + "','" + addr2 + "','" + city + "', '"+ state +"', '"+ Zip +"') "; <br/> If (this. executesql (sqlstring) = 1) <br/>... {<br/> This. alert ("You have successfully added a piece of data", this. page); <br/>}< br/> else <br/>... {<br/> This. alert ("addition failed! ", This. page); <br/>}< br/> This. bindgvsupplier (); <br/>}</P> <p> // view the total number of data records <br/> private int gettotalcount () <br/>... {<br/> // try <br/> // {<br/> oracleconnection conn = This. conn (); <br/> Conn. open (); <br/> oraclecommand cmd = new oraclecommand ("select count (*) from supplier", Conn); <br/> int COUNT = convert. toint32 (CMD. executescalar (); <br/> Conn. close (); <br/> return count; <br/> //} <br/> // catch <B R/> // {<br/> // return 0; <br/> // <br/>}</P> <p> // The warning window is displayed. <br/> Public void alert (string str_message, page) <br/>... {<br/> page. registerstartupscript ("", "<SCRIPT> alert ('" + str_message + "'); </SCRIPT> "); <br/>}</P> <p> // The confirmation dialog box is displayed. <br/> Public void confirm (string str_message, string BTN, page) <br/>... {<br/> page. registerstartupscript ("", "<SCRIPT> If (confirm ('" + str_messag E + "') = true) {document. forms (0 ). "+ Btn + ". click () ;}</SCRIPT> "); <br/>}</P> <p> protected void cballselect_checkedchanged (Object sender, eventargs E) <br/>... {<br/> for (INT I = 0; I <this. gvsupplier. rows. count; I ++) <br/>... {<br/> checkbox cbselect = (checkbox) (gvsupplier. rows [I]. cells [10]. findcontrol ("cbselect"); <br/> cbselect. checked = This. cballselect. checked; <br/>}</P> <p> // Delete when the delete button is clicked. All data selected for the checkbox <br/> protected void btndel_click (Object sender, eventargs e) <br/>... {<br/> // if the user confirms that the btnrealdel event will be triggered <br/> This. confirm ("Do you really want to delete the data you selected? "," Btnrealdel ", this. page); </P> <p >}</P> <p> // real delete operation <br/> Public void btnrealdel_click (Object sender, eventargs E) <br/>... {<br/> int COUNT = 0; <br/> for (INT I = 0; I <this. gvsupplier. rows. count; I ++) <br/>... {<br/> checkbox mycb = (checkbox) (this. gvsupplier. rows [I]. cells [10]. findcontrol ("cbselect"); <br/> If (mycb. checked) <br/>... {<br/> count ++; <br/> hyperlink HL = (Hyperlink) (this. gvsupplier. rows [I]. cells [7]. controls [0]); <br/> int suppid = int. parse (HL. text. tostring (); <br/> string sqlstring = "delete from supplier where suppid =" + suppid; <br/> This. executesql (sqlstring); <br/>}< br/> If (count> 0) <br/>... {<br/> This. alert ("You have deleted" + Count + "data entries", this. page); <br/> This. bindgvsupplier (); <br/>}< br/>