Perpendicular Stuff

<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><br /></span></span>
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><br /></span></span>
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><br /></span></span>
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><br /></span></span>
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"></span></span><br />
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"></span></span><br />
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><br /><b><span style="font-size: x-large;">How to Connect database with visual studio 2010?</span></b></span></span><br />
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><span lang="EN-SG" style="font-size: 26.0pt; line-height: 115%;"><br /></span></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><span lang="EN-SG"><span style="font-family: "trebuchet ms" , sans-serif;">In this <span style="font-family: "trebuchet ms" , sans-serif;">post i will </span></span>discuss the complete procedure of<span class="Apple-converted-space"> </span>connectivity of<span class="Apple-converted-space"> </span>database<span class="Apple-converted-space"> </span>which has been created in  Microsoft 2003 and with<span class="Apple-converted-space"> </span><b>visual studio 2010</b> </span></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><span lang="EN-SG" style="font-size: 12.0pt; line-height: 115%;">  First of all we create a student or any other table in<span class="Apple-converted-space"> </span><b>database</b><span class="Apple-converted-space"> </span>i create a table in database 2003 with name of std in table std i take some table attributes such as s-id s-name and s-roll3 these are all the attributes of the table which i create in database and save this table as Microsoft 2003 for creating a extension {.mdb} this extension is very important for the connectivity with out this extension you did not b able to connect database with visual studio because visual studio accept file or database which is save with the name of extension .mdb visual studio did not accept any other extension for connectivity if you save with any other extension it may cause error.</span></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><span lang="EN-SG" style="font-size: 12.0pt; line-height: 115%;">The table snapshot which<span class="Apple-converted-space"> </span>are given<span class="Apple-converted-space"> </span>blow<span class="Apple-converted-space"> </span>show the table which creates in the<span class="Apple-converted-space"> </span>database<span class="Apple-converted-space"> </span>with the name of<span class="Apple-converted-space"> </span>std</span></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><br /></span></span></div>
</div>
<div style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; margin: 0px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><br /></span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgmQvxK-0wus5-NarX7toR65Qi_l8642VURH1y0gGUT4tkMgr92xdksYPhYGN1giB5migwJfoPnMlBKPMZ9vDcGFpUNNUhO6O54EmjcPqttY46VnPYiijlLBH8cZty69S2vbuqV-4yxwVub/s1600/1..png" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="321" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgmQvxK-0wus5-NarX7toR65Qi_l8642VURH1y0gGUT4tkMgr92xdksYPhYGN1giB5migwJfoPnMlBKPMZ9vDcGFpUNNUhO6O54EmjcPqttY46VnPYiijlLBH8cZty69S2vbuqV-4yxwVub/s640/1..png" style="cursor: move;" width="640" /></a></span></span></div>
<div style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; margin: 0px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><br /></span></span></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><br /></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><br /></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><br /></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><br /></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><br /></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><br /></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><span lang="EN-SG" style="font-size: 12.0pt; line-height: 115%;"> Now save the<span class="Apple-converted-space"> </span>std<span class="Apple-converted-space"> </span>table with<span class="Apple-converted-space"> </span>.mdb extension<span class="Apple-converted-space"> </span>this snapshot which<span class="Apple-converted-space"> </span>are given<span class="Apple-converted-space"> </span>blow<span class="Apple-converted-space"> </span>show that the<span class="Apple-converted-space"> </span>std<span class="Apple-converted-space"> </span>table save with the name of<span class="Apple-converted-space"> </span>.mdb<span class="Apple-converted-space"> </span>extension you can also see<span class="Apple-converted-space"> </span>at<span class="Apple-converted-space"> </span>the picture in the second row where type of file is written<span class="Apple-converted-space"> </span>.<span class="Apple-converted-space"> </span>the<span class="Apple-converted-space"> </span>database is<span class="Apple-converted-space"> </span>save<span class="Apple-converted-space"> </span>as Microsoft office access database (.mdb)</span></span></span></div>
</div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEig_jCsMqWsh5UT55IcS6FE2EBZVJOmTM6Uya2tWsuPbmShepEd6eVnq1ouay5AWGb2vPtFsZcLtdEbEIrDyIVYr3d4IHlJCH3KdjsO4X8prffTBD5so61lQg_2862WBxuJFFi2KICvIoaw/s1600/2..png" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="293" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEig_jCsMqWsh5UT55IcS6FE2EBZVJOmTM6Uya2tWsuPbmShepEd6eVnq1ouay5AWGb2vPtFsZcLtdEbEIrDyIVYr3d4IHlJCH3KdjsO4X8prffTBD5so61lQg_2862WBxuJFFi2KICvIoaw/s320/2..png" style="cursor: move;" width="320" /></a></span></span></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><span lang="EN-SG" style="font-size: 12.0pt; line-height: 115%;"><br /></span></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><br /></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><span lang="EN-SG" style="font-size: 12.0pt; line-height: 115%;">Now we open the visual studio and inset a form from its<span class="Apple-converted-space"> </span>tool bar<span class="Apple-converted-space"> </span> which take three text<span class="Apple-converted-space"> </span>box<span class="Apple-converted-space"> </span>and one button in sequence now We entered data in textbox and this data connect to<span class="Apple-converted-space"> </span>database<span class="Apple-converted-space"> </span>and this data goes<span class="Apple-converted-space"> </span>form<span class="Apple-converted-space"> </span>visual studio database we<span class="Apple-converted-space"> </span>enter data in the visual studio form or in textboxes an when we press the<span class="Apple-converted-space"> </span>ok<span class="Apple-converted-space"> </span>button the data will insert into the database</span></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><span lang="EN-SG" style="font-size: 12.0pt; line-height: 115%;">About this procedure all the<span class="Apple-converted-space"> </span>snapshot<span class="Apple-converted-space"> </span>are given<span class="Apple-converted-space"> </span>blow.</span></span></span></div>
</div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiAVtoVYfxCryUO53YbI-jl0kOPPfWk-92Q6gyQ78La7M-8DgXZvgoJp5B6FQ2MIMhZNDYJNORUZyMn46IMca16ZI-46zxVg3kN04f7ITlPI-pzyY3nTd-jmTyDmfesxJqm-zAZHUxDpB5Y/s1600/3..png" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="260" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiAVtoVYfxCryUO53YbI-jl0kOPPfWk-92Q6gyQ78La7M-8DgXZvgoJp5B6FQ2MIMhZNDYJNORUZyMn46IMca16ZI-46zxVg3kN04f7ITlPI-pzyY3nTd-jmTyDmfesxJqm-zAZHUxDpB5Y/s320/3..png" style="cursor: move;" width="320" /></a></span></span></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><span lang="EN-SG" style="font-size: 12.0pt; line-height: 115%;"><br /></span></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><br /></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><span lang="EN-SG" style="font-size: 12.0pt; line-height: 115%;">Now we enter connectivity code behind the button which<span class="Apple-converted-space"> </span>are given<span class="Apple-converted-space"> </span>blow the code which are given<span class="Apple-converted-space"> </span>beloww<span class="Apple-converted-space"> </span>this code<span class="Apple-converted-space"> </span>in<span class="Apple-converted-space"> </span>write behind the button.</span></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><span lang="EN-SG" style="font-size: 12.0pt; line-height: 115%;"><br /></span></span></span></div>
</div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgCtX_WdPMk7oBDaO46QCoRvzLPG7bbFKaOa6qOkyYKKw8OGIzJkyKxpFocp1sWnjJE0mpy2bvIdYWZCECXxBQ-fAiYcUgMBegQV-j3O7oNMX3y4Q0zkG9mGj0nUQzGNAvq9Xct8uc414yM/s1600/4..png" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="129" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgCtX_WdPMk7oBDaO46QCoRvzLPG7bbFKaOa6qOkyYKKw8OGIzJkyKxpFocp1sWnjJE0mpy2bvIdYWZCECXxBQ-fAiYcUgMBegQV-j3O7oNMX3y4Q0zkG9mGj0nUQzGNAvq9Xct8uc414yM/s640/4..png" style="cursor: move;" width="640" /></a></span></span></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><span lang="EN-SG" style="font-size: 12.0pt; line-height: 115%;"><br /></span></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><span lang="EN-SG" style="font-size: 12.0pt; line-height: 115%;">Private sub button1_click(byval sender as system.object, byval e as<span class="Apple-converted-space"> </span>system.eventargs)handle button1.click</span></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><span lang="EN-SG" style="font-size: 12.0pt; line-height: 115%;">Dim con as new ADODB.connection()</span></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><span lang="EN-SG" style="font-size: 12.0pt; line-height: 115%;">Dim<span class="Apple-converted-space"> </span>rs<span class="Apple-converted-space"> </span>as new ADODB.Recordset()</span></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><span lang="EN-SG" style="font-size: 12.0pt; line-height: 115%;">Con.connection starting<span class="Apple-converted-space"> </span>,,<span class="Apple-converted-space"> </span>“provider<span class="Apple-converted-space"> </span>,,Microsoft.jet.OLEDB.4.0;  data source<span class="Apple-converted-space"> </span>,,<span class="Apple-converted-space"> </span>c,,:\user\ghulam haider\desktop\std.mdb;”</span></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><span lang="EN-SG" style="font-size: 12.0pt; line-height: 115%;">Con.open()</span></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><span lang="EN-SG" style="font-size: 12.0pt; line-height: 115%;">Msgbox<span class="Apple-converted-space"> </span>(“<span class="Apple-converted-space"> </span>congrajulation  connection is open”)</span></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><span lang="EN-SG" style="font-size: 12.0pt; line-height: 115%;">Con. Execute(“<span class="Apple-converted-space"> </span>inseted<span class="Apple-converted-space"> </span>into<span class="Apple-converted-space"> </span>std<span class="Apple-converted-space"> </span>value(‘ “textbox1.text’ “,  ‘ “textbox2.text’ “,‘ “textbox3.text’ “,) “<span class="Apple-converted-space"> </span>)</span></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><span lang="EN-SG" style="font-size: 12.0pt; line-height: 115%;">Msgbox<span class="Apple-converted-space"> </span>(“<span class="Apple-converted-space"> </span>congrajulation<span class="Apple-converted-space"> </span>data are inserted”)</span></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><span lang="EN-SG" style="font-size: 12.0pt; line-height: 115%;">Con.close()</span></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><br /></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><br /></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><span lang="EN-SG" style="font-size: 12.0pt; line-height: 115%;">When you enter the above coding behind the button now you compile the program and when<span class="Apple-converted-space"> </span>program<span class="Apple-converted-space"> </span>is compiled a form of visual studio is<span class="Apple-converted-space"> </span>display<span class="Apple-converted-space"> </span>you can enter<span class="Apple-converted-space"> </span>value<span class="Apple-converted-space"> </span>in the form which are given below you enter your name id and roll number in the given form.</span></span></span></div>
</div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhR8lMNhhVh3YNd3gFrUAGQ0OlDoIeiJTH8vhnSb8Tkn0ETkLz518qthFpEmgCDEVPoDEpkrHCGCsDuJ30ECn0v3473mHtIESHRNtj2ePBRVpBC6GwKT994BgjEcRj2_gi_cSiXQ9B3YnjE/s1600/5..png" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="181" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhR8lMNhhVh3YNd3gFrUAGQ0OlDoIeiJTH8vhnSb8Tkn0ETkLz518qthFpEmgCDEVPoDEpkrHCGCsDuJ30ECn0v3473mHtIESHRNtj2ePBRVpBC6GwKT994BgjEcRj2_gi_cSiXQ9B3YnjE/s320/5..png" style="cursor: move;" width="320" /></a></span></span></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><span lang="EN-SG" style="font-size: 12.0pt; line-height: 115%;"><br /></span></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><br /></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><br /></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><span lang="EN-SG" style="font-size: 12.0pt; line-height: 115%;">In figure which<span class="Apple-converted-space"> </span>are given<span class="Apple-converted-space"> </span>blow you can see and observe that a message is<span class="Apple-converted-space"> </span>display<span class="Apple-converted-space"> </span>that<span class="Apple-converted-space"> </span>connection<span class="Apple-converted-space"> </span>is<span class="Apple-converted-space"> </span>open this<span class="Apple-converted-space"> </span>means that your connectivity is<span class="Apple-converted-space"> </span>occur<span class="Apple-converted-space"> </span>and your visual studio is<span class="Apple-converted-space"> </span>connect<span class="Apple-converted-space"> </span>with<span class="Apple-converted-space"> </span>your database  this<span class="Apple-converted-space"> </span>figure only display your connection.</span></span></span></div>
</div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-pT3MhHqWIV8MrOYySUJqvy3r_Ucn3Z6eCkEM-nYS96AifWbUmVSNgaoq22mWbZsFqdUPDrCvFkqOp5ZYI7gUtU3uI5I8BB2qhTGOax4xRLJbqYB5y1dRuprVJh_wsMuv2TJ98OS-9T44/s1600/6..png" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="252" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-pT3MhHqWIV8MrOYySUJqvy3r_Ucn3Z6eCkEM-nYS96AifWbUmVSNgaoq22mWbZsFqdUPDrCvFkqOp5ZYI7gUtU3uI5I8BB2qhTGOax4xRLJbqYB5y1dRuprVJh_wsMuv2TJ98OS-9T44/s640/6..png" style="cursor: move;" width="640" /></a></span></span></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><span lang="EN-SG" style="font-size: 12.0pt; line-height: 115%;"><br /></span></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><br /></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><span lang="EN-SG" style="font-size: 12.0pt; line-height: 115%;">Now we insert data into the<span class="Apple-converted-space"> </span>textboxes<span class="Apple-converted-space"> </span>for<span class="Apple-converted-space"> </span>example I<span class="Apple-converted-space"> </span>enter my name<span class="Apple-converted-space"> </span>haider<span class="Apple-converted-space"> </span>and id =17 and<span class="Apple-converted-space"> </span>i<span class="Apple-converted-space"> </span>enter my roll number 3417 when<span class="Apple-converted-space"> </span>i<span class="Apple-converted-space"> </span>insert all<span class="Apple-converted-space"> </span>these value<span class="Apple-converted-space"> </span>into the form now<span class="Apple-converted-space"> </span>i<span class="Apple-converted-space"> </span>compile the program after compiling you can see that a message is display your data in inserted this mean that your strong connection with<span class="Apple-converted-space"> </span>database<span class="Apple-converted-space"> </span>is build and values is inserted to the database</span></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><br /></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><span lang="EN-SG">This message shows that data is inserted into<span class="Apple-converted-space"> </span>database</span></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><span lang="EN-SG">Now we open<span class="Apple-converted-space"> </span>database<span class="Apple-converted-space"> </span>and confirm the process  this database table show that the value which<span class="Apple-converted-space"> </span>i<span class="Apple-converted-space"> </span>enter in the above form these all values are inserted into the database<span class="Apple-converted-space"> </span>i<span class="Apple-converted-space"> </span>enter my name id and roll number these all value are<span class="Apple-converted-space"> </span>lie<span class="Apple-converted-space"> </span>in the database</span></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><span lang="EN-SG">Database has created which contain<span class="Apple-converted-space"> </span>std id name<span class="Apple-converted-space"> </span>and roll number</span></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><br /></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><br /></span></span></div>
</div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<div style="margin: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><br /></span></span></div>
</div>
<div style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; margin: 0px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><br /></span></span></div>
<div class="MsoNormal" style="-webkit-text-stroke-width: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<span style="font-size: large;"><span style="font-family: "trebuchet ms" , sans-serif;"><br class="Apple-interchange-newline" /></span></span></div>

How to Connect Database with Visual Studio 2010 ?

How to Connect database with visual studio 2010? In this post i will discuss the complete procedure of connectivity of data...