C# Access

C# Access

• v-pakote

  there are many samples for ASO.NET with c#

  take a look ath these URLs

  http://www.c-sharpcorner.com/Database.asp

  http://msdn.microsoft.com/library/en-us/vbcon/html/vbconFundamentalDataConceptsInVisualStudioNET.asp frame=true

  http://msdn.microsoft.com/library/en-us/vbcon/html/vbtskCreatingManagingADONETConnectionsAtDesignTime.asp frame=true

  http://msdn.microsoft.com/library/en-us/vbcon/html/vboriDataAdapters.asp frame=true

  http://www.codeproject.com/cs/database/DatabaseAcessWithAdoNet1.asp

  hope this helps

  
  
  

• Dondata

   

  Thank u very much... I checked all your links and msdn tutorial but still I cant get what I want to do... 

  I dont have any problem about dataAdapter,dataset, and connect to db...

  And I dont have anyproblem to show all data to datagridview..

  
  My problem is;

  First of all I must use Access DB, not sql...

  Saving,editing,updating,deleting smth in textboxes to db and get all data to db and show them in different textboxes...

  Plz help me, I gonna be crazy...

  
  
  

• MSDN Student

  Hi,

  Is your problem solved

  Thank you,
  Bhanu.

  
  
  

• PDHB

  Hey thank u very much for your helps, I solved some problems with your helps...

  Now I want to save photographs in Access database and I wanna show it in picturebox...

  I hope we can found an effective solution than writing photo's address to database...

  
  
  

• ScottC_BC

  Thank u Bhanu,

  My problem wasnt solved, I have new problems...

  how can I show database one column to listbox

  and then the selected items in listbox, for example John Lennon, when I selected it, the other data about him will shown to other textboxes... Like his phone number,adress etc... waiting for your help...

  
  
  

• Astrogator

  hi,

  this thread has some links for nice tutorials about ADO.net , you will need to know SQL (structured query language) to query your database this thread also have some links for SQL tutorial

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

  hope this helps

  
  
  

• JohnDurant

  No answer
  
  

• pc-coholic

  Here is a good example (As I think lol) :
  

• PeterMa

  Use SQL queries, for example : "SELECT * FROM Info WHERE Name ='" & ListBox.SelectedItem & "'"
  Hope this helps you, but tell if it doesn't :)
  
  
  

• RichLando

  first of all the way you deal with databases is not much different you suppose to select the right provider , also you need to select the right way to connect to your databas(ie. ADO.net)

  so to deal with .mdb file you will use Oledb but you need to know some SQL to run command againest your database

  search the forums for OledbCommand and you will find many examples to select , update , insert, or delete records

  http://forums.microsoft.com/MSDN/Search/Search.aspx words=OledbCommand&localechoice=9&SiteID=1&searchscope=allforums

  hope this helps

  
  
  

• SpeakerBob

  Hi Lacia,
  Take a look at this article, this may help you : Walkthrough: Editing an Access Database with ADO.NET [This walkthrough demonstrates how to add, delete, and edit records in a MicrosoftR Access database with ADO.NET using a simple Visual C#R code-behind Web application. (11 printed pages)
  Download the sample code ADONETAccessDB.exe. (130KB)]
  
  
  
• C# Access