Searching a data base in visual basic 2005

Searching a data base in visual basic 2005

• Harry Miller - MSFT

  It seems highly likely to me that you're very new to this, and trying to build Rome in a day. The resources you're being pointed to are sufficient for most people, if they're moving too fast for you, it's because you need to slow down, and learn the language on a more basic level before attempting these sort of tasks.

  
  
  

• sumeetamigo

  No it doesn't l have watched those movies and it showes me to add it one way but l need the code to make my own buttons and it still doesn't show me how to search
  

• Hugh Burton

  To search for part of a word use a LIKE clause in your SQL. Have you tried msdn.microsoft.com Sites like www.codeproject.com also have lots of articles on this sort of commonly asked stuff.

  
  
  

• WXU

  Sorry it does show you how to save but not add and delete, or search so l need help with these items
  

• Jaxsurfer

  hi, shirvo

  first of All the vedios shows you how to add , edit, and delete, particulary when he use icons (add-edit-delete folder of channel) follow that part well and you will get it

  //Ok, well l still cant believe that you need all that code to do a simple thing like delete

  believe it or not the vedios show the easiest way to do so, eventhough its not easy thing there are lots of work behind the scene you can take a look to those links as a quick start

  http://msdn2.microsoft.com/en-us/library/ms171918(VS.80).aspx

  http://www.asp.net/QuickStart/howto/doc/adoplus/overviewcontents.aspx

  http://msdn.microsoft.com/vbasic/reference/data/default.aspx pull=/library/en-us/dnsql90/html/mandataaccess.asp#mandataac_topic5

  your question about how to search database not the dataset, but you can do that in the dataset it will be easier and simple as tableadapter.update()

  if you want to search the dataset you can use dataview, table.select, or even bindingsource.filter

  http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=339281&SiteID=1

  you can use wild card selection(search) "MyColumn Like '%value%' "

  % mean any number of letters

  hope this helps

  
  
  

• Hans Pettersson

  l looked there and it didnt really seem to be the help l wanted anyone else have any idea
  

• seand_03

  hi,

  follow up this tutorial and you will know how to write this code yourself http://msdn.microsoft.com/vstudio/express/vb/learning/default.aspx

  hope this helps

  
  
  

• Alex Cane

  OK, if it's for school then your friend should have adequate resources for the task, school doesn't just tell people to do stuff without equiping them to do it.

  I did a google specific to the code project site which I told you to check, and found this right away:

  http://www.codeproject.com/vb/net/SQLEditor.asp

  Google is bursting at the seams with hits on helping people do database stuff with VB.NET.

  http://www.google.com.au/search hl=en&safe=off&q=VB.NET+ado.net&meta=

  Or is adding buttons the thing that you're having trouble with

  I would suggest again that you're in over your head, not because I want to give you a hard time, but because if you keep trying to work at this level, it's likely you'll get discouraged and give up, just because you've not applied yourself to a sensible learning curve. Your friend should do his own homework, that's what homework is for. You could help, if you fully understood the topic at hand. If you're relying on someone giving you the code, you're hardly able to then explain how it works to your friend.

  
  
  

• kubilay

  Ok, well l still cant believe that you need all that code to do a simple thing like delete. for save all you need is this code

  BindingSource1.EndEdit()

  CustomerTableAdapter1.Update(MyCompanyDataSet1.Customer)

  
  

• nalsur8

  l have made a couple of programs so far and l know a bit about what l am doing. All this stuff is for school and l am trying to help a friend out. now this is the first time l have used the forums and l am only really using it to refine my programing skills. This next program l am building needs data base stuff. and the movies dont really show you how to make your own buttons to add delete and save. So if it is posible for some one to help that would be great because l have looked for help else where and can really find any.
  
• Searching a data base in visual basic 2005