Budget Control

07/01/2011

Ol�... Consegui acessar o banco e adicionar um card. No curso de Budget Control do Weliton Flor. Or�amento dom�stico. O problema agora � que quando clico em DisableCard e EnableCard d� o seguinte erro, no Webservice.
System.Data.SqlClient.SqlException: Incorrect syntax near 'SetCardStatus'.
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(TdsParserStateObject stateObj)
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 Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteNonQuery(DbCommand command)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteNonQuery(DbCommand command)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteNonQuery(CommandType commandType, String commandText)
at BudgetBusiness.Cards.EnableDisableCard(Boolean status) in C:\Controle Or�ament�rio\Visual Studio 2005\Projects\Budget\BudgetBusiness\Cards.cs:line 50
at Cards.DisableCard(Int32 CardId)
Gente, eu n�o sei nada. Quero aprender isso, mas est� dif�cil. Eu fa�o tudo igualzinho e passo a passo. E sempre retorna um erro. Est� listando e adicionando card corretamente. S� falta o Desable e o Enable dar certo. Algu�m pode, por favor, ajudar?
Desde j�. Obrigada. Meu MSN � daianamowry@hotmail.com.
At� mais.

Daiana Moura

Curtir t�pico + 0

Responder

Posts

07/01/2011

Silvio Caetano

Tem um DBCommand seu que est� com problema de sintaxe. O erro do tipo SQLException vem do banco de dados, ou seja, alguma coisa que voc� est� mandando para o mesmo est� com erro. Eu n�o tenho acesso as aulas que voc� est� cursando, ent�o n�o tenho como te ajudar exatamente. Veja onde est� o SQLCommand com esse trecho de c�digo 'SetCardStatus' e verifique se n�o h� nenhum problema, de prefer�ncia rode a fun��o de banco no MS SQL Server Manager Studio antes de incluir no seu c�digo.

Responder

Gostei + 0

07/01/2011

Daiana Moura

Deu certo. Muito obrigada, amigo. N�o sei exatamente qual era o erro. Estava no c�digo do m�todo EnableDisableCard. � detalhe. Parece que um "=". Est� dando esse erro agora.

Responder

Gostei + 0

07/01/2011

Daiana Moura

Deu certo. Muito obrigada, amigo. N�o sei exatamente qual era o erro. Estava no c�digo do m�todo EnableDisableCard. � detalhe. Parece que um "=". Est� dando esse erro agora.

Responder

Gostei + 0

07/01/2011

Silvio Caetano

Posta o comando aqui que eu posso tentar ver se acho o erro para voc�.

Responder

Gostei + 0

07/01/2011

Daiana Moura

Est� dando este erro agora quando listo status 1 ou 2.
System.Data.SqlClient.SqlException: Incorrect syntax near '='.
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(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.DoLoadDataSet(DbCommand command, DataSet dataSet, String[] tableNames)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.LoadDataSet(DbCommand command, DataSet dataSet, String[] tableNames)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.LoadDataSet(DbCommand command, DataSet dataSet, String tableName)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteDataSet(DbCommand command)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteDataSet(CommandType commandType, String commandText)
at BudgetBusiness.Cards.ListCards(Int32 cardStatus) in C:\Controle Or�ament�rio\Visual Studio 2005\Projects\Budget\BudgetBusiness\Cards.cs:line 84
at Cards.ListCards(Int32 status)

Responder

Gostei + 0

07/01/2011

Daiana Moura

S�lvio, voc� tem MSN? Adicione-me, por favor, daianamowry@hotmail.com.
Obrigada.

Responder

Gostei + 0