i don know the code insert n delete in database M.Eccess 2007 using button combo box..and arrage the list of combobox follow by alphabet...can 2 help me

Hi,
I am a beginner (vb.net programmer). I have ms access database with 2 tables. I connect to the database successfully but I want the primary key (Auto number) in table two to automatically appear in Foreign Key (Number) in table one after setting up the relationship.
Please I need your help.

honsjoe@yahoo.com

Thanks in advance.

please can you help me with vb.net code to add text and picture from vb. to access...please can mail me at kufuptown@yahoo.com

when ever i update my record it updtae only one record. if i add no-1 and then no-2. so in my view report only 2 will show 1 will delete , why its is happening

Hi,
I am using msaccess 2003 as backend in project.
The code is just saving data which newly added but I want to update existing record of database using bindingnavigator. The code is throwing exception.
Please help me as soon as possible since the date of my project submission is coming nearer.

Thanks
snehalkul007@gmail.com

cant see no codes here although i clicked to download them

i hpe yor code will help me in mine...:)

I need more codess....

i face a problem saving password to Access.
it work nicely if i remove password.
the error occur on INSERT and UPDATE query.
please help.
using OleDb..
i can c the password value from the sqlcommand, but it just pop up the error message.

Please Help me....

im beginner in VB...
after enter the input data, i tried to save in .dat file...but not sure how to write it on using vb2008...
and how to call back that file?
thank you

cleo_2425@yahoo.com

sir please can you send me the SQL Server Example of the Same.
BackEnd :SQL DataBase
FrontEnd :VB.NET

My mail ID is : praveenm_rama@yahoo.co.in

..plz post the step by step on how to add/update/and delete the record using ms access..tnx...i will wait for the response...Godbless....!!!

Hi,

I'm beginner of VB.NET. Pls help me about the database connection using vb.net with sql server,ms access and oracle with step by step process with screen shot. pls pls pls...........

My mail ID is:kananathakowsik@rediffmail.com

Could you please help me i used all types of memory stream code
i have an error parameter in not valid;
here is my code

OleDbCommand cmd = new OleDbCommand("SELECT photo FROM stdetails where stuid='" + txtstid.Text + "'", conn);
 
            DataSet ds = new DataSet();
            OleDbDataAdapter da = new OleDbDataAdapter(cmd);
            da.Fill(ds, "stdetails");
            byte[] content = (byte[])ds.Tables[0].Rows[0]["photo"];
 
            try
            {
 
                MemoryStream stream = new MemoryStream(content,true);
 
// i have problem in this place
             pictureBox2.Image = Image.FromStream(stream,true,true);
 
            }
 
            catch (Exception ex)
            {
 
                MessageBox.Show(ex.Message.ToString());
 
                MessageBox.Show(ex.StackTrace.ToString());
 
            }

Please
provide brother
my email id is vickymade4u007@gmail.com

how we can use " insert command " in vb ?
pls send me some examples which describe the code

hi please send me this software with frontend vb.net and backend access

thank you>>>>>>>>>>>>>>>

Hi ... Thanks for the example,but Could you please provid the same example using SQL?

i want 2 move data without using binding navigator in vb.net but i want to use buttons like first, previous, last & next. please help me!!!

Plz help in creating database by code
my email id prvnkmr449@gmail.com
Praveen

hy i wanted to add images in the ms access 2003, but i forgot how the step is.could u please tell me how?

Nice Sample...
I got a challenge for you...

ListView Groups...
Group the list according to the Header Collumns that is being clicked.

i dont know how to insert record in access database. i have a formCustomer to that has txtLastName, txtFirstName and txtContact.. when i click the add button it should add the record in the database then i should view the list in the main form.. your code is quite hard to understand because im only a beginner. and is it ok to insert the record from 1 form to another or there are codes needed so that i can access it to the other form.?

here is my code.

Private Sub btnAccept_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnAccept.Click
Dim con As New OleDb.OleDbConnection
con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=..\data\YayaDB.mdb"
con.Open()
Dim query = "INSERT INTO Customer(Last Name,First Name, Contact No) VALUES(@LastName, @FirstName, @Contact)"
Dim cmd = New OleDbCommand(query, con)
cmd.Connection = con

cmd.Parameters.AddWithValue("@LastName", txtLastName.Text)
cmd.Parameters.AddWithValue("@FirstName", txtFirstName.Text)
cmd.Parameters.AddWithValue("@Contact", txtContactNo.Text)
cmd.ExecuteNonQuery()

con.Close()

Me.Close()

End Sub

hi,, i copied your code about how to add update delete,,, the one thats above,,,, after ive done everything already (including the module, forms, designs, everything) it shows an error "Error while trying to run your project. could not load file or assembly 'add,deletewithaccess' or one of its dependencies. the given assembly name or code was invalid. (exception from HRESULT:0x80131047)" by the way 'add,deletewithaccess' is the filename of the project i saved in... please help....

hi
i am already design the code using vb.net 2005 for insert data in the table ,
but when i am again run that program then all the previous value of the table will delete and again newly entry value are store in table
my code:
Imports System.Data.OleDb

Public Class Form1
Dim con As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Application.StartupPath & "\raghu1stdb.mdb")

'Dim da As OleDbDataAdapter
Dim da As New OleDbDataAdapter("select * from table1", con)
'Dim x As String = "select *from table1"
' da = New OleDbDataAdapter(x, con)
Dim ds As New DataSet, dt As New DataTable, dr As DataRow
Dim i As Integer
Dim bm As BindingManagerBase : Dim cb As OleDbCommandBuilder
Dim cm As OleDbCommand
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Dim x As String = "select *from table1 "
da = New OleDbDataAdapter
da.SelectCommand = New OleDbCommand(x, con)

da = New OleDbDataAdapter(x, con)
ds = New DataSet
da.Fill(ds, "name1")
dt = ds.Tables("name1")
dr = dt.NewRow
bm = Me.BindingContext(dt)
cb = New OleDbCommandBuilder(da)
''MessageBox.Show()
End Sub

Private Sub Bsave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Bsave.Click
dr = dt.NewRow
dr.Item("ID") = Txtid.Text
dr.Item("Name") = txtname.Text
dr.Item("Address") = txtadd.Text
da.Fill(ds, "name1")
dt = ds.Tables("name1")
dt.Rows.Add(dr)

dt.AcceptChanges()
da.Update(dt)
MessageBox.Show("datais update")
End Sub

End Class

so what i will do
plz send the code for save in db using vb.net
as soon as posible plz send me i need that
plz send in my mail id: raghuramsahu@gmail.com

sir..gud am...can u teach me the hard coding connection of my project to ms access as my back end with out using any control...purely coding???...adding record in table updating retrieving and deleting...thx in advance...

i have two tables using acces database and i need to insert the same records in that two particular tables.The problem is that, "I can only save the records into one table and the other table is empty.".I hope you can help me with this particular problem, i'll apreciated it so much..thank you..

if its ok, heres my eadd: vash_jbv@yahoo.com

Gud day sir!

i want to seek help on how to change the datasource of a report in the choice of the user dynamically..

in short.. one report viewer, multiple rdlc files can be shown simultaneously.. hust a sample code..

hope for your kind help! more power and godbless!

tnx..
aguirre

Hi friend i already download your Code.
But i want to clear that can i able to access Msdatabase File from web server.
if possible please explain me

my id is lightininggroups@gmail.com

hi,
How to insert a data into two table by using acces database with vb.net

Thanx,
Regards,
Sandeep

Hi,
Follwing is the coding of save and retrive the image from ms access database in vb.net2008.but its through input box.I just want that user click on a account no.from combobox and image is displayed.

Imports System.Data.OleDb
Imports System.IO
 
Public Class Form7
Public ImageSlno As Integer
Public con As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source =C:\Documents and Settings\Pankaj Arora\My Documents\database.mdb") ' connection srting 
 
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Call Insert_Image()
End Sub
 
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Try
OpenFileDialog1.Filter = "Bmp Files(*.bmp)|*.bmp|Gif Files(*.gif)|*.gif|Jpg Files(*.jpg)|*.jpg"
OpenFileDialog1.ShowDialog()
PictureBox1.Image = Image.FromFile(OpenFileDialog1.FileName)
Catch
 
End Try
End Sub
Public Sub Insert_Image()
Try
Dim st As New FileStream(OpenFileDialog1.FileName, FileMode.Open, FileAccess.Read)
Dim mbr As BinaryReader = New BinaryReader(st)
Dim buffer(st.Length) As Byte
mbr.Read(buffer, 0, CInt(st.Length))
st.Close()
con.Open()
Dim Str As String = "insert into imageTable(photo) values(?)"
Dim Cmd As New System.Data.OleDb.OleDbCommand(Str, con)
Cmd.Parameters.Add("@photo", System.Data.OleDb.OleDbType.Binary, buffer.Length).Value = buffer
Cmd.ExecuteNonQuery()
con.Close()
MsgBox("Image Saved Successfully")
Catch ex As Exception
con.Close()
MsgBox("Error In Insertphoto", MsgBoxStyle.Critical, "Error")
MsgBox(ex.ToString)
End Try
End Sub
 
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Try
ImageSlno = InputBox("Insert Slno ", , "0")
 
Call LoadPhoto(ImageSlno)
Catch ex As Exception
MsgBox(ex.ToString)
End Try
End Sub
Public Sub LoadPhoto(ByVal slno As Decimal)
' display image from the database
Try
Dim str As String = "SELECT photo FROM ImageTable WHERE slno = " & slno
con.Open()
Dim cmd As New OleDb.OleDbCommand(str, con)
Dim b() As Byte
b = cmd.ExecuteScalar()
con.Close()
If (b.Length > 0) Then
Dim stream As New MemoryStream(b, True)
stream.Write(b, 0, b.Length)
DrawToScale(New Bitmap(stream))
stream.Close()
End If
Catch ex As Exception
'MsgBox(ex.ToString)
End Try
End Sub
'Function to Create Instance For the Image From the Buffer
Private Sub DrawToScale(ByVal bmp As Image)
PictureBox1.Image = New Bitmap(bmp)
End Sub
 
Private Sub Form7_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
 
End Sub
End Class

Thanx,
Regards,
Sandeep

Hello, Could you tell me how to be strong in vb.net.I started in vb.net from beginner,but I don't where should i begin.
Anyway Could you tell me which book should i take a look for the first time? or any website ?

Thank