trouble inserting

MarioRammy

Member
Joined
Feb 1, 2008
Messages
12
Programming Experience
Beginner
<div class="bbWrapper">Hey, I&#039;m kinda new to this and this sounds a bit silly to some, but i&#039;m having trouble inserting from my VB.net app to my DB!!<br /> <br /> I have a textbox called &quot;txtName&quot; on &quot;Main&quot; form, and i want to insert this into a colume &quot;Name&quot; in my table &quot;Details&quot; in the database, which i have set up, called &quot;MyDB&quot;! <br /> <br /> I&#039;m not even sure where to start ! <br /> <br /> Any help would be great thanks,<br /> <br /> Mario</div>
 
<div class="bbWrapper">Drop a SQL connection object on your form, configure it to connect you your DB<br /> <br /> Then drop a SQL dataadapter on the form and configure it to grab the data from the tables you need (using your SQL connection object)<br /> <br /> Then right click on the dataadapter and select &#039;Generate Dataset&#039;, now bind your textbox to the dataset, then in the form load event, fill your dataset by using the Fill() method on your dataadapter<br /> <br /> Now all you need is buttons for moving forward, backward, new record, delete, etc... you can use the BindingManager to adjust the position<br /> <br /> PS. Look @ Cjard&#039;s signature, he has links to pages that explains the &quot;overview&quot; I posted in more detail</div>
 
<div class="bbWrapper">they are on my signature as well <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f609.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=";)" title="Wink ;)" data-smilie="2"data-shortname=";)" /></div>
 
<div class="bbWrapper"><blockquote data-attributes="member: 2260" data-quote="Arg81" data-source="post: 74794" class="bbCodeBlock bbCodeBlock--expandable bbCodeBlock--quote js-expandWatch"> <div class="bbCodeBlock-title"> <a href="/goto/post?id=74794" class="bbCodeBlock-sourceJump" rel="nofollow" data-xf-click="attribution" data-content-selector="#post-74794">Arg81 said:</a> </div> <div class="bbCodeBlock-content"> <div class="bbCodeBlock-expandContent js-expandContent "> they are on my signature as well <img src="https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f609.png" class="smilie smilie--emoji" loading="lazy" width="64" height="64" alt=";)" title="Wink ;)" data-smilie="2"data-shortname=";)" /> </div> <div class="bbCodeBlock-expandLink js-expandLink"><a role="button" tabindex="0">Click to expand...</a></div> </div> </blockquote><br /> Yeah.. we really need to teach you how to make a link text look nice!<br /> <br /> [ URL=&quot;http://ugly-url.com&quot;]NICE TEXT[/ URL]</div>
 
Back
Top