Hi guys:

I have a little problem with inserting data into my database. I am using a form with two text boxes. when i type data into them and press ok, no data is submitted to my database, and in the same time no error message is promted, which i can't understand why.

I am using the following code which does not come with no errors at all.

   Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click


        Dim Objconn As New SqlClient.SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\ECBInvoicing.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True")
        Objconn.Open()

        ObjCmd = New SqlCommand("INSERT INTO hotel (HotelName, HotelAddress) VALUES (@HotelName, @HotelAddress)", Objconn)


        ObjCmd.Parameters.Add("@HotelName", Data.SqlDbType.VarChar).Value = txtHotelname.Text
        ObjCmd.Parameters.Add("@HotelAddress", Data.SqlDbType.VarChar).Value = txtHotelAddress.Text


        ObjCmd.ExecuteNonQuery()


        Objconn.Close()

    End Sub

Can anyone help please??

Hey Bro even i have the same problem if u find solution for this inserting dat into datbase please let me know.. my mail id is [email protected]

I am also having this problem. I suspect that it has something to do with some sort of access permissions because I can't wite to a database using a data grid table either. Can anyone help us?

I came accross this problem myself recently and to tell you the truth, I messed around with about 15 things at once and it worked. The problem is that I don't know what in particular was the issue. I'm keen to find out what it might have been.

Does your SQL table have a primary key?
Does your datagrid display and allow you to enter data into the new row at the end of the grid?

Kia

hi kia my table contains primary key...
i havent used data grid.... i using textbox only... this is very simple code eating my brain still i am not able to find any solution... do u have have any solution fo this....

Thank You,
Jeetesh Supe

[email protected]

Hi all,
  I have found a solution for this
  I will tell you wat i have done...

i was creating database using Visual Studion IDE.. it creates a folder or store in the projct folder...

try using MAnagement Studio available free of download from microsoft site... download it install it...

create database using this... connection string will be now...

Data Source=.\sqlexpress;Initial Catalog=test;Integrated Security=True

where "test" is database name

i am now able to insert a record... it has worked...
try it it works

if u have any other solution for it please let me know

Jeetesh

[email protected]

Thank You

Ahh... now I remember. I've seen this before aswel. A long time ago I used to use VS05 to create the database and place it in the project folder for me. This seemed to always cause the none insert problem. Its when VS moves the database to the project folder.

I now use either SQL Server Enterprise Manager or opt for VS to place the database in the SQL Server's own data folder. Do not copy the database to the project folder.