RepresentantTableAdapter.TableMappings.Add("Representant", "Representant") 'RepresentantTableAdapter.UpdateCommand New SqlClient.SqlCommand("UPDATE Representant SET User @User, Password = @Password, Fonction = @Fonction, Locked = @Locked, Icone = @Icone, Config_Columns = @Config_Columns, Nom_Prenom = @Nom_Prenom WHERE ID = @ID)", conn) RepresentantTableAdapter.UpdateCommand.Parameters.Add("@ID", System.Data.DbType.Int32, 4, "ID") RepresentantTableAdapter.UpdateCommand.Parameters.Add("@Nom_Prenom", System.Data.DbType.String, 50, "Nom_Prenom") RepresentantTableAdapter.UpdateCommand.Parameters.Add("@User", System.Data.DbType.String, 10, "User") RepresentantTableAdapter.UpdateCommand.Parameters.Add("@Password", System.Data.DbType.String, 10, "Password") RepresentantTableAdapter.UpdateCommand.Parameters.Add("@Fonction", System.Data.DbType.String, 10, "Fonction") RepresentantTableAdapter.UpdateCommand.Parameters.Add("@Locked", System.Data.DbType.Boolean, 2, "Locked") RepresentantTableAdapter.UpdateCommand.Parameters.Add("@Icone", System.Data.DbType.String, 10, "Icone") RepresentantTableAdapter.UpdateCommand.Parameters.Add("@Config_Columns", System.Data.DbType.String, 10, "Config_Columns")
ProspectTableAdapter.Fill(myDataset, "Prospect") RepresentantTableAdapter.Fill(myDataset, "Representant")
Échec de la conversion de la valeur de paramètre d'un String en un Int16.
UPDATE [Prospect].[dbo].[Representant] SET [Nom_Prenom] = <Nom_Prenom, nvarchar(50),> ,[User] = ,[Password] = ,[Fonction] = <Fonction, nvarchar(10),> ,[Locked] = <Locked, bit,> ,[Icone] = ,[Config_Columns] = <Config_Columns, ntext,> WHERE <Conditions de recherche,,>
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionRepresentantTableAdapter.UpdateCommand.Parameters.Add(New SqlClient.SqlParameter("@ID", SqlDbType.Int, 4, "ID")) RepresentantTableAdapter.UpdateCommand.Parameters.Add(New SqlClient.SqlParameter("@Nom_Prenom", SqlDbType.NVarChar, 50, "Nom_Prenom")) RepresentantTableAdapter.UpdateCommand.Parameters.Add(New SqlClient.SqlParameter("@User", SqlDbType.NVarChar, 10, "User")) RepresentantTableAdapter.UpdateCommand.Parameters.Add(New SqlClient.SqlParameter("@Password", SqlDbType.NVarChar, 10, "Password")) RepresentantTableAdapter.UpdateCommand.Parameters.Add(New SqlClient.SqlParameter("@Fonction", SqlDbType.NVarChar, 10, "Fonction")) RepresentantTableAdapter.UpdateCommand.Parameters.Add(New SqlClient.SqlParameter("@Locked", SqlDbType.Bit)) RepresentantTableAdapter.UpdateCommand.Parameters.Add(New SqlClient.SqlParameter("@Icone", SqlDbType.NVarChar, 10, "Icone")) RepresentantTableAdapter.UpdateCommand.Parameters.Add(New SqlClient.SqlParameter("@Config_Columns", SqlDbType.NText))
SqlConnection("data source=192.168.1.15;initial catalog=Prospect;uid=Server;pwd=")
Public ProspectTableAdapter As New SqlDataAdapter("SELECT * FROM Prospect", conn)
Public ProspectTableAdapter As New SqlDataAdapter("SELECT * FROM Prospect; SET IDENTITY_INSERT Representant ON", conn)