Bonjour à tous,
Je debute dans avec la programmation et SQL.
Je suis entrain de faire un formulaire web.
C'est assez simple pourtant, j'ai quelques soucis.
J'utilise visual Studio 2010 pour faire le formulaire web et SQL server 2005.
Voic le code pour le formulaire :
*****************
************Code:
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23Public Class WebForm1 Inherits System.Web.UI.Page Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load End Sub Private Sub btn_agregar_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btn_agregar.Click Dim con As New System.Data.SqlClient.SqlConnection con.ConnectionString = "Data Source=JEREMIE1;Initial Catalog=db_IT;User Id=sa;Password=LCC@Spain@28045;" Dim myCommand As New System.Data.SqlClient.SqlCommand myCommand.CommandText = myCommand.CommandText = "insert into Material_TAG values('" & txt_typo.Text & "','" & txt_marca.Text & "','" & txt_modelo1.Text & "','" & txt_modelo2.Text & "','" & txt_tag.Text & "','" & txt_cantidad.Text & "','" & Cal_fecha_entrada.SelectedDate & "')" myCommand.Connection = con con.Open() myCommand.ExecuteNonQuery() con.Close() End Sub End Class
Et voici le message d'erreur :
*************
Citation:
System.Data.SqlClient.SqlException was unhandled by user code
Class=16
ErrorCode=-2146232060
LineNumber=1
Message=Could not find stored procedure 'False'.
Number=2812
Procedure=""
Server=JEREMIE1
Source=.Net SqlClient Data Provider
State=62
StackTrace:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Material_IT.WebForm1.btn_agregar_Click(Object sender, EventArgs e) in c:\documents and settings\jeremie_mallie\my documents\visual studio 2010\Projects\Material_IT\Material_IT\Resources\WebForm1.aspx.vb:line 18
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
InnerException:
Merci d'avance.
