Insert to SQL(resolved Mend rawks)

[Beast777]

Okay finally got my first webapp up and its static, has no sql connections. I have been reading and looking at the forum for how to connect to a database. What I want to do is create a webform, fill in a textbox, click the button to save and have it write to the table on the SQL server. My server is called webserver, my database is webtest and my table is answer and the field is answer1. From what I have read it seems you need to put postback code in the form load event, create a datatable from all the data on the sql server, add a datarow and then do an update from the sqladapter. This seems like alot of bandwith usage for a simple update or am I barking up the wrong tree. I don't care what the data is thats there already, I just want to add a new row.

[mendhak]

ADO.NET QUickstart:

http://samples.gotdotnet.com/quickst...sOverview.aspx

No, it does not take up a lot of bandwidth because datasets (which contain datatables) are disconnected. In other words, the dataadapter fills up the dataset, and the dataset is just a collection that exists in memory. There is no connection. An update reopens a connection and sends values back to the databsae.

[Beast777]

I had a look that seems to be just the basic run down on ADO.NET. Can I not just use the same code I use in a windows app like this:

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim strConnString As String = "workstation id=""S-KG_-CFSCE-2098"";packet size=4096; integrated security=SSPI;data source=""WEBSERVER"";persist security info=False;initial catalog=Webtest"
        Dim SqlConn As New SqlClient.SqlConnection(strConnString)
        'Dim strsql As String = "INSERT into Answers(Answer1) values (@Answer)"
          Dim sqlcmd As New SqlClient.SqlCommand(strsql, SqlConn)
        Try
            sqlcmd.Parameters.Add("@Answer", TextBox1.Text)
            SqlConn.Open()
            sqlcmd.ExecuteNonQuery()
 
        Catch ex As Exception
 
        End Try
    End Sub

[mendhak]

Yes, but that is for non queries. If you do a SELECT, then you do need to use a dataset.

[Beast777]

SO if I am just inserting the above should work? because when I click on the button it gives no error but does not insert.

[Beast777]

Maybe I should tell you what the app does and that my clarify what method should be used. It will be an online questionaire that users fill out, click send and it puts the info into the database. Users will not ever edit it.

[mendhak]

Step through your code and see if it's hitting the exception.

[Beast777]

It has a {System.Data.SqlClient.SqlException} with no more info, occurs during the open. Could it be not the code but access rights? I added ASPNET and IUSR accts to sql and to this database and gave them db_owner rights.

[mendhak]

In your catch,

do a Response.Write ex.Message

(or just do a quickview of ex)

and look at its message property.

[Beast777]

Login failed for user null. Reason not associated with a trusted SQL server connection

[mendhak]

Have you set identity impersonate = true in the ASP.NET App?

Does the logged in user (you?) have permission to access the sql server database?

[Beast777]

I just did a quick google, do I need to add Trusted_Connection=yes somewhere?

[Beast777]

No I did not do identity impersonate, I am knew to this. That goes into the web config if I remember what I read somewhere. Does it matter where it goes in that file?

[Beast777]

I added <identity impersonate="true"></identity> and still same error.

[Beast777]

Guess I am pretty new at this. The whole time I have been changing the rights on the live server when I should of been changing the rights on my local web machine. Sorry for all the trouble and thanks for all the help. Mend, you are my the best.

[mendhak]

No problem, we've all been there.