Error when I want to Insert data in a database(SQLEXPRESS)?
-
Hi everybody I'm making a web custom control which is just for getting feedbacks from visitors so I have created a database and a dataset via SQRExpress and then in my send buttom click event I have this code: void _send_Click(object sender, EventArgs e) { FeedBackDBDataSetTableAdapters.FDTableTableAdapter ta=new FDTableTableAdapter(); tableAdapter.InsertQuery(Category, textBox1.text); tableAdapter.Dispose(); } The problem is here that after I run a project which contains this control and press the send buttom, this Error Appears: :wtf: :confused: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.) Does any one know why? thanks.
-
Hi everybody I'm making a web custom control which is just for getting feedbacks from visitors so I have created a database and a dataset via SQRExpress and then in my send buttom click event I have this code: void _send_Click(object sender, EventArgs e) { FeedBackDBDataSetTableAdapters.FDTableTableAdapter ta=new FDTableTableAdapter(); tableAdapter.InsertQuery(Category, textBox1.text); tableAdapter.Dispose(); } The problem is here that after I run a project which contains this control and press the send buttom, this Error Appears: :wtf: :confused: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.) Does any one know why? thanks.
I think that I found the answer to this problem,(of course if any one knows a better way it's very kind of him/her to post it to me). so my answer to me is this: :-\ probably when you want a SQLEXPRESS database to be included in a web custom control, and then drag the control to a web page the page can not log to database for any insertion or update. I made a SQl database some were out side the control and passed the connection string to a dataset in the control and I was very pleased to see it worked!!.