tag:blogger.com,1999:blog-20967761272414112762024-09-05T12:45:30.614+05:30Get help about ASP.NET and PHP or ask a question.Anonymoushttp://www.blogger.com/profile/10481401987217715275noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-2096776127241411276.post-9284343103466141942012-08-12T21:29:00.000+05:302012-08-12T21:29:43.204+05:30<div dir="ltr" style="text-align: left;" trbidi="on"> Here i will show you simple loading animation using jQuery. You can make it better for your application.....<br /> <br /> This is the index.php file, which send the data for checking to another file.....<br /> <div style="color: #cc0000;"> <br /></div> <span style="color: #cc0000;">&lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"&gt;</span><br style="color: #cc0000;" /><span style="color: #cc0000;">&lt;html xmlns="http://www.w3.org/1999/xhtml"&gt;</span><br style="color: #cc0000;" /><span style="color: #cc0000;">&lt;head&gt;</span><br style="color: #cc0000;" /><span style="color: #cc0000;">&lt;meta http-equiv="Content-Type" content="text/html; charset=utf-8" /&gt;</span><br style="color: #cc0000;" /><span style="color: #cc0000;">&lt;title&gt;Serialized Data&lt;/title&gt;</span><br style="color: #cc0000;" /><span style="color: #cc0000;">&lt;script type="text/javascript" src="../js/jquery.js"&gt;&lt;/script&gt;</span><br /> <br style="color: #cc0000;" /><span style="color: #073763;">&lt;script type="text/javascript"&gt;</span><br style="color: #073763;" /><span style="color: #073763;">$(document).ready(function() {</span><br style="color: #073763;" /><span style="color: #073763;">&nbsp;&nbsp;&nbsp; var x=$("#loading");</span><br style="color: #073763;" /><span style="color: #073763;">&nbsp;&nbsp;&nbsp; x.hide();</span><br style="color: #073763;" /><span style="color: #073763;">&nbsp;&nbsp;&nbsp; $("#latter form").submit(function(){</span><br style="color: #073763;" /><span style="color: #073763;">&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; //var x=$(this).serialize();</span><br style="color: #073763;" /><span style="color: #073763;">&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; //alert(x);</span><br style="color: #073763;" /><span style="color: #073763;">&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; x.ajaxStart(function() {</span><br style="color: #073763;" /><span style="color: #073763;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $(this).show();</span><br style="color: #073763;" /><span style="color: #073763;">&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; $("#ff").hide('slow');</span><br style="color: #073763;" /><span style="color: #073763;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; });</span><br style="color: #073763;" /><span style="color: #073763;">&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; x.ajaxStop(function() {</span><br style="color: #073763;" /><span style="color: #073763;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $(this).hide();</span><br style="color: #073763;" /><span style="color: #073763;">&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; $("#ff").show('slow');</span><br style="color: #073763;" /><span style="color: #073763;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; });</span><br style="color: #073763;" /><span style="color: #073763;">&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; $.post('result.php',$(this).serialize(), function(result){</span><br style="color: #073763;" /><span style="color: #073763;">&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; $("#rslt").html(result);</span><br style="color: #073763;" /><span style="color: #073763;">&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; });</span><br style="color: #073763;" /><span style="color: #073763;">&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; return false;</span><br style="color: #073763;" /><span style="color: #073763;">&nbsp;&nbsp;&nbsp; });</span><br style="color: #073763;" /><span style="color: #073763;">});</span><br /> <br style="color: #cc0000;" /><span style="color: #cc0000;">&lt;/head&gt;</span><br style="color: #cc0000;" /><br style="color: #cc0000;" /><span style="color: #cc0000;">&lt;body&gt;</span><br style="color: #cc0000;" /><span style="color: #073763;">&lt;div id="loading"&gt;Loading...&lt;/div&gt;</span><br style="color: #073763;" /><span style="color: #073763;">&lt;div id="latter"&gt;</span><br style="color: #073763;" /><span style="color: #073763;">&lt;form id="ff"&gt;</span><br style="color: #073763;" /><span style="color: #073763;">Name : &lt;input type="text" id="txtName" name="txtName" /&gt;</span><br style="color: #073763;" /><span style="color: #073763;">Email :&lt;input type="email" id="email" name="email" /&gt;</span><br style="color: #073763;" /><span style="color: #073763;">&lt;input type="submit" value="Submit" name="submit" id="submit" /&gt;</span><br style="color: #073763;" /><span style="color: #073763;">&lt;/form&gt;</span><br style="color: #073763;" /><span style="color: #073763;">&lt;/div&gt;</span><br style="color: #073763;" /><span style="color: #073763;">&lt;div id="rslt"&gt;</span><br style="color: #073763;" /><br style="color: #073763;" /><span style="color: #073763;">&lt;/div&gt;</span><br style="color: #cc0000;" /><span style="color: #cc0000;">&lt;/body&gt;</span><br style="color: #cc0000;" /><span style="color: #cc0000;">&lt;/html&gt;</span><br /> <br /> <ul style="text-align: left;"> <li>jQuery's <span style="color: #073763;"><span style="color: #b45f06;">serialize()</span><span style="color: black;"> method&nbsp; make very easy to submit form data without any concern. It's send data using query string formal like -</span></span></li> </ul> <br /> <span style="color: #073763;"><span style="color: #b45f06;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; txtName=value&amp;email=value </span></span><br /> <span style="color: #073763;"><span style="color: black;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; so you dont have to access all the form&nbsp; element to send it...</span></span><br /> <ul style="text-align: left;"> <li><span style="color: #073763;"><span style="color: black;">&nbsp;In the "Loading...." section you can use any .gif image for batter animation.</span></span></li> </ul> <span style="color: #073763;"><span style="color: black;"><br /></span></span> <br /> <br /> <span style="color: #073763;"><span style="color: black;">Here is the response file, where data will be checked...I just display the data....You can check against database..... &nbsp;&nbsp;</span></span><br /> <br /> <span style="color: #073763;"><span style="color: black;"><span style="color: #073763;">&lt;?php</span><br style="color: #073763;" /><span style="color: #073763;">if(isset($_REQUEST['txtName']) &amp;&amp; isset($_REQUEST['email']))</span><br style="color: #073763;" /><span style="color: #073763;">{</span><br style="color: #073763;" /><span style="color: #073763;">$name=$_REQUEST['txtName'];</span><br style="color: #073763;" /><span style="color: #073763;">$email=$_REQUEST['email'];</span><br style="color: #073763;" /><span style="color: #073763;">echo $name;</span><br style="color: #073763;" /><span style="color: #073763;">echo "&lt;br/&gt;";</span><br style="color: #073763;" /><span style="color: #073763;">echo $email;</span><br style="color: #073763;" /><span style="color: #073763;">}</span><br style="color: #073763;" /><span style="color: #073763;">else</span><br style="color: #073763;" /><span style="color: #073763;">{</span><br style="color: #073763;" /><span style="color: #073763;">&nbsp;&nbsp;&nbsp; echo "Enter Your Name";</span><br style="color: #073763;" /><span style="color: #073763;">}</span><br style="color: #073763;" /><span style="color: #073763;">?&gt;</span></span></span><br /> <br /> <br /> <span style="color: #073763;"><span style="color: black;"><span style="color: #073763;"><span style="color: black;">Remember this is the very basic example for your Loading animation....You can make batter with this concept for your application....</span>&nbsp;</span> </span></span></div>Anonymoushttp://www.blogger.com/profile/10481401987217715275noreply@blogger.com0tag:blogger.com,1999:blog-2096776127241411276.post-51523944009620664352012-08-12T21:10:00.001+05:302012-08-12T21:10:14.408+05:30<div dir="ltr" style="text-align: left;" trbidi="on"> <br /> <span style="font-family: &quot;Courier New&quot;,Courier,monospace;">A query intended for use as a prepared statement looks a bit different from those you might be used</span><br style="font-family: &quot;Courier New&quot;,Courier,monospace;" /><span style="font-family: &quot;Courier New&quot;,Courier,monospace;">to because placeholders must be used instead of actual column values for those that will change across</span><br style="font-family: &quot;Courier New&quot;,Courier,monospace;" /><span style="font-family: &quot;Courier New&quot;,Courier,monospace;">execution iterations. Two syntax variations are supported, named parameters and question mark</span><br style="font-family: &quot;Courier New&quot;,Courier,monospace;" /><span style="font-family: &quot;Courier New&quot;,Courier,monospace;">parameters. For example, a query using named parameters might look like this:</span><br /> <br /><span style="color: #073763;">INSERT INTO products SET sku = :sku, name = :name;</span><br /> <br /><span style="font-family: &quot;Courier New&quot;,Courier,monospace;">The same query using question mark parameters would look like this:</span><br /> <br /><span style="color: #073763;">INSERT INTO products SET sku = ?, name = ?;</span><br /> <br /> <br /> <span style="color: #073763;"><span style="color: black; font-family: &quot;Courier New&quot;,Courier,monospace;">&nbsp;I will show you how to work with both.....</span></span><br /> <br /> <span style="color: #073763;"><span style="color: black; font-family: &quot;Courier New&quot;,Courier,monospace;">To bind the values to their respective variable name or positional offset in the query using the<span style="color: #bf9000;"> bindParam() </span>method.</span> </span><br /> <br /> <span style="color: #073763;"><span style="color: black; font-family: &quot;Courier New&quot;,Courier,monospace;">Here is the database connection file :&nbsp;</span></span><br /> <br /> <span style="color: #073763;"><b style="color: red; font-family: Arial,Helvetica,sans-serif;">db.inc.php&nbsp;</b></span><br /> <br /> <span style="color: #073763;"><span style="font-size: x-small;"><span style="color: #073763; font-family: Arial,Helvetica,sans-serif;">&lt;?php<br />try{<br />$db=new PDO("mysql:host=host_name;dbname=Database_name","Your_name","Password");<br />}<br />catch(PDOException $exception)<br />{<br />&nbsp;&nbsp;&nbsp; printf("Connection Error..");<br />}<br />?&gt;</span></span><b style="color: red; font-family: Arial,Helvetica,sans-serif;"> </b></span><br /> <br /> <span style="color: #073763;"><span style="color: orange; font-size: large;"><b>Question mark parameters :</b></span></span><br /> <span style="color: #073763;"><span style="color: orange; font-size: large;"><b>&nbsp;</b></span></span><br /> <span style="color: #073763;">&lt;?php</span><br /> <span style="color: #073763;">include_once("db.inc.php");<br />$query="insert into logins set username=? , pswd=?";<br />//<br />//Insert statement<br />//<br />$stmt=$db-&gt;prepare($query);<br />$name="HHH";<br />$pswd="123";<br />//binding parameter<br />$stmt-&gt;bindParam(1,$name);<br />$stmt-&gt;bindParam(2,$pswd);<br />$i=$stmt-&gt;execute();<br />if($i &gt;0)<br />{<br />&nbsp;&nbsp;&nbsp; echo "Value inserted";<br />}<br />else<br />{<br />&nbsp;&nbsp;&nbsp; echo "Not Inserted";<br />}<br />?&gt; </span><br /> <br /> <span style="color: #073763;"><span style="color: orange; font-size: large;"><b>Name parameters :</b></span></span><br /> <br /> <div style="color: #073763;"> &lt;?php</div> <span style="color: #073763;">include_once("db.inc.php");</span><br style="color: #073763;" /><span style="color: #073763;">$query="insert into logins set username=:user,pswd=:pswd";</span><br style="color: #073763;" /><span style="color: #073763;">//</span><br style="color: #073763;" /><span style="color: #073763;">//Insert statement</span><br style="color: #073763;" /><span style="color: #073763;">//</span><span style="color: #073763;"></span><br style="color: #073763;" /><span style="color: #073763;">$stmt=$db-&gt;prepare($query);</span><br style="color: #073763;" /><span style="color: #073763;">$name="John";</span><br style="color: #073763;" /><span style="color: #073763;">$pswd="123";</span><br style="color: #073763;" /><span style="color: #073763;">//bind the parameter</span><br style="color: #073763;" /><span style="color: #073763;">$stmt-&gt;bindParam(':user',$name);</span><br style="color: #073763;" /><span style="color: #073763;">$stmt-&gt;bindParam(':pswd',$pswd);</span><br style="color: #073763;" /><span style="color: #073763;">//execute the query</span><br style="color: #073763;" /><span style="color: #073763;">$i=$stmt-&gt;execute();</span><br style="color: #073763;" /><span style="color: #073763;">if($i &gt;0)</span><br style="color: #073763;" /><span style="color: #073763;">{</span><br style="color: #073763;" /><span style="color: #073763;">&nbsp;&nbsp;&nbsp; echo "Value inserted";</span><br style="color: #073763;" /><span style="color: #073763;">}</span><br style="color: #073763;" /><span style="color: #073763;">else</span><br style="color: #073763;" /><span style="color: #073763;">{</span><br style="color: #073763;" /><span style="color: #073763;">&nbsp;&nbsp;&nbsp; echo "Vlaue Not inserted";</span><br style="color: #073763;" /><span style="color: #073763;">}</span><br style="color: #073763;" /><span style="color: #073763;">?&gt;</span></div>Anonymoushttp://www.blogger.com/profile/10481401987217715275noreply@blogger.com0tag:blogger.com,1999:blog-2096776127241411276.post-48078287636475941092012-08-12T20:53:00.004+05:302012-08-12T20:53:43.791+05:30<div dir="ltr" style="text-align: left;" trbidi="on"> <span style="font-size: large;">PHP data access using PDO</span><br /> <div style="font-family: &quot;Courier New&quot;,Courier,monospace;"> <br /></div> <div style="font-family: &quot;Courier New&quot;,Courier,monospace;"> PDO(PHP Data Object) is the secure process to access the database(like ADO.NET in .NET).</div> <div style="font-family: &quot;Courier New&quot;,Courier,monospace;"> <br /></div> <div style="font-family: &quot;Courier New&quot;,Courier,monospace;"> The database connection file :-</div> <br /> <div style="color: red;"> dp.inc.php</div> <br /> <span style="color: #073763;">&lt;?php</span><br style="color: #073763;" /><span style="color: #073763;">try{</span><br style="color: #073763;" /><span style="color: #073763;">$db=new PDO("mysql:host=Your_Host_Name;dbname=db_name","Your_User_Name","Password");</span><br style="color: #073763;" /><span style="color: #073763;">}</span><br style="color: #073763;" /><span style="color: #073763;">catch(PDOException $exception)</span><br style="color: #073763;" /><span style="color: #073763;">{</span><br style="color: #073763;" /><span style="color: #073763;">&nbsp;&nbsp;&nbsp; printf("Connection Error..");</span><br style="color: #073763;" /><span style="color: #073763;">}</span><br style="color: #073763;" /><span style="color: #073763;">?&gt;</span><br /> <span style="color: #073763;"><br /></span> <br /> <span style="font-family: &quot;Courier New&quot;,Courier,monospace;">To Delete data :-</span><br /> <div style="color: red;"> delete.php</div> <br /> <div style="color: #073763;"> &lt;?php</div> <span style="color: #073763;">include_once("db.inc.php");</span><br style="color: #073763;" /><span style="color: #073763;">echo $query="delete from table_name whereField_name='value'";</span><br style="color: #073763;" /><span style="color: #e06666;">$i=$db-&gt;exec($query);</span><br style="color: #073763;" /><span style="color: #073763;">if($i &gt; 0)</span><br style="color: #073763;" /><span style="color: #073763;">{</span><br style="color: #073763;" /><span style="color: #073763;">&nbsp;&nbsp;&nbsp; echo "&lt;script&gt;alert('Value Deleted :".$i."')&lt;/script&gt;";</span><br style="color: #073763;" /><span style="color: #073763;">}</span><br style="color: #073763;" /><span style="color: #073763;">else{</span><br style="color: #073763;" /><span style="color: #073763;">&nbsp;&nbsp;&nbsp; echo "&lt;script&gt;alert('No Result found...')&lt;/script&gt;";</span><br style="color: #073763;" /><span style="color: #073763;">}</span><br style="color: #073763;" /><span style="color: #073763;">?&gt;</span><br /> <br /> <div style="font-family: &quot;Courier New&quot;,Courier,monospace;"> To insert to the database :-</div> <div style="font-family: &quot;Courier New&quot;,Courier,monospace;"> <br /></div> <div style="color: red;"> insert.php</div> <div style="color: #073763;"> &lt;?php<br />include_once("db.inc.php");<br />$pswd=uniqid(rand());<br />$query="insert into Table_Name values('value1','value2','value2')";<br /><span style="color: #e06666;">$affect=$db-&gt;exec($query);</span><br />if($affect &gt; 0)<br />{<br />&nbsp;&nbsp;&nbsp; echo "&lt;script&gt;alert('Value inserted')&lt;/script&gt;";<br />}<br />else<br />{<br />&nbsp;&nbsp;&nbsp; echo "&lt;script&gt;alert('Error')&lt;/script&gt;";<br />}<br /><br /><br />?&gt;</div> <br /> <div style="font-family: &quot;Courier New&quot;,Courier,monospace;"> Select Query :-</div> <span style="color: red;">select.php</span><br /> <br /> <div style="color: #073763;"> &lt;?php</div> <div style="color: #073763;"> include_once("db.inc.php");<br />$query="select * from table_name";</div> <span style="color: #e06666;">$stmt=$db-&gt;query($query);</span><br style="color: #073763;" /><span style="color: #073763;">while($row= $stmt-&gt;fetch(PDO::FETCH_ASSOC))</span><br style="color: #073763;" /><span style="color: #073763;">{</span><br style="color: #073763;" /><span style="color: #073763;">&nbsp;&nbsp;&nbsp; echo $row['id'];</span><br style="color: #073763;" /><span style="color: #073763;">&nbsp;&nbsp;&nbsp; echo "&lt;br/&gt;";</span><br style="color: #073763;" /><span style="color: #073763;">&nbsp;&nbsp;&nbsp; echo $row['username'];</span><br style="color: #073763;" /><span style="color: #073763;">&nbsp;&nbsp;&nbsp; echo "&lt;br/&gt;";</span><br style="color: #073763;" /><span style="color: #073763;">&nbsp;&nbsp;&nbsp; echo $row['pswd'];</span><br style="color: #073763;" /><span style="color: #073763;">&nbsp;&nbsp;&nbsp; echo "&lt;br/&gt;";</span><br style="color: #073763;" /><span style="color: #073763;">}</span><br style="color: #073763;" /><br style="color: #073763;" /><span style="color: #073763;">?&gt;</span></div>Anonymoushttp://www.blogger.com/profile/10481401987217715275noreply@blogger.com0tag:blogger.com,1999:blog-2096776127241411276.post-10814980450896406312012-08-12T01:55:00.000+05:302012-08-12T03:32:33.985+05:30<div dir="ltr" style="text-align: left;" trbidi="on"> <h2 style="text-align: left;"> <span style="font-family: &quot;Courier New&quot;, Courier, monospace;"><span style="color: #20124d;">The simplest way to access database </span></span></h2> <br /> <span style="font-family: &quot;Courier New&quot;, Courier, monospace;">When you create a Connection object, you can pass the connection string as a constructor<br />parameter. Alternatively, you can set the ConnectionString property by hand, as long as you do it before<br />you attempt to open the connection.<br />There’s no reason to hard-code a connection string.</span><span style="font-family: &quot;Courier New&quot;,Courier,monospace;">The</span><br /> <span style="font-family: &quot;Courier New&quot;,Courier,monospace;">&lt;connectionStrings&gt; section of the web.config file is a handy place to store your connection strings.</span><br /> <br /> <b>Example-</b><br /> <div style="color: #cc0000;"> web.config file :-</div> <br /> <span style="color: #073763;">&lt;configuration&gt;</span><br /> <span style="color: #073763;">&lt;connectionStrings&gt;</span><br /> <span style="color: #073763;">&lt;add name="Northwind" connectionString=</span><br /> <span style="color: #073763;">"Data Source=localhost; Initial Catalog=Northwind; Integrated Security=SSPI"/&gt;</span><br /> <span style="color: #073763;">&lt;/connectionStrings&gt;</span><br /> <span style="color: #073763;">...</span><br /> <span style="color: #073763;">&lt;/configuration&gt;</span><br /> <br /> <div style="font-family: &quot;Courier New&quot;,Courier,monospace;"> You can then retrieve your connection string by name from the<br /> WebConfigurationManager.ConnectionStrings collection. Assuming you’ve imported the<br /> <span style="color: #cc0000;">System.Web.Configuration</span> namespace, you can use a code statement like this:</div> <br /> <div style="color: #073763;"> public partial class _Default : System.Web.UI.Page<br /> { </div> <div style="color: #073763; text-align: left;"> &nbsp;&nbsp;&nbsp; string connectionString =<br /> &nbsp;&nbsp;&nbsp; WebConfigurationManager.ConnectionStrings["Northwind"].ConnectionString.ToString();</div> <span style="color: #073763;">&nbsp;&nbsp;&nbsp; protected void Page_Load(object sender, EventArgs e)</span><br /> <span style="color: #073763;">&nbsp;&nbsp;&nbsp; {</span><br /> <span style="color: #073763;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span><br /> <span style="color: #073763;">&nbsp;&nbsp;&nbsp; }</span><br /> <span style="color: #073763;">}</span><br /> <div style="font-family: &quot;Courier New&quot;,Courier,monospace;"> Declare the connection string veritable&nbsp; at the class label for later user</div> <div style="font-family: &quot;Courier New&quot;,Courier,monospace;"> <br /></div> <div style="font-family: &quot;Courier New&quot;,Courier,monospace;"> Data Access Process from SQL Server :-</div> <br /> <div style="color: #073763;"> protected void InsertData()</div> <div style="color: #073763;"> {</div> <div style="color: #073763;"> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; string InsertSql = "insert into Table_Name values(value1,value2.....valueN)";<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SqlConnection con = new SqlConnection(connectionString);<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SqlCommand cmd = new SqlCommand(InsertSql, con);<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; int innn;<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; try<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; con.Open();<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; innn=cmd.ExecuteNonQuery();<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if (innn &gt; 0)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Label1.Text = "Insert Successfull";<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<br /> <br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; catch (Exception ex)<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Label1.Text = ex.Message;<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; finally<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; con.Close();<br /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }</div> <span style="color: #073763;">}</span><br /> <br /> <span style="font-family: &quot;Courier New&quot;,Courier,monospace;">Call this function from any Event Handler method like</span> <span style="color: red;">Button.Click</span>[<span style="color: #073763;">Buttion_Click(object sender, EventArgs e</span>)] <span style="font-family: &quot;Courier New&quot;,Courier,monospace;">method....</span><br /> <br /> <div style="font-family: &quot;Courier New&quot;,Courier,monospace;"> This is the simple way to access database for DML or DQL execution. If you want you can get more complex execution with more security.....Like Parametrized Query and Query Builder object.......</div> <div style="font-family: &quot;Courier New&quot;,Courier,monospace;"> <br /></div> <b><span style="font-family: &quot;Courier New&quot;,Courier,monospace;">If you need help please post your request...... </span></b><br /> <br /> <br /></div>Anonymoushttp://www.blogger.com/profile/10481401987217715275noreply@blogger.com0