Click here to Skip to main content
15,886,518 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: String or binary data would be truncated.The statement has been terminated. Pin
N a v a n e e t h4-Oct-07 19:13
N a v a n e e t h4-Oct-07 19:13 
QuestionLocking a record while updating Pin
samerh4-Oct-07 18:50
samerh4-Oct-07 18:50 
AnswerRe: Locking a record while updating Pin
Christian Graus4-Oct-07 19:06
protectorChristian Graus4-Oct-07 19:06 
GeneralRe: Locking a record while updating Pin
samerh4-Oct-07 19:26
samerh4-Oct-07 19:26 
Questionmultiple web.sitemap files? Pin
fmlove4-Oct-07 17:44
fmlove4-Oct-07 17:44 
AnswerRe: multiple web.sitemap files? Pin
N a v a n e e t h4-Oct-07 19:17
N a v a n e e t h4-Oct-07 19:17 
Questiontheming problem Pin
mmm!@#4-Oct-07 16:30
mmm!@#4-Oct-07 16:30 
QuestionTrying to update a value in the database. Asp.Net/C#/SQL/VS2005 Pin
foolios4-Oct-07 14:12
foolios4-Oct-07 14:12 
I don't really know how to check why it's not working.
I have a try/catch that tells me in the catch that it didn't succeed but not sure how to really know what's going on with it.

Here's my update attempt:

SqlCommand comm = new SqlCommand("UPDATE inventoryTbl SET categoryID = @category WHERE id = @category", conn);

comm.Parameters.Add("@category", System.Data.SqlDbType.SmallInt);
comm.Parameters["@category"].Value = txtbx_itemCategory.Text;

try
{
// Execute the command
comm.ExecuteNonQuery();
// Reload page if the query executed successfully
//Response.Redirect("addrelatives.aspx");
}
catch
{
// Display error message
bttnApplyChanges.Text = "Error";
}
finally
{
// Close the connection
conn.Close();
}
AnswerRe: Trying to update a value in the database. Asp.Net/C#/SQL/VS2005 Pin
Christian Graus4-Oct-07 14:32
protectorChristian Graus4-Oct-07 14:32 
GeneralRe: Trying to update a value in the database. Asp.Net/C#/SQL/VS2005 Pin
foolios4-Oct-07 15:29
foolios4-Oct-07 15:29 
GeneralRe: Trying to update a value in the database. Asp.Net/C#/SQL/VS2005 Pin
Christian Graus4-Oct-07 15:38
protectorChristian Graus4-Oct-07 15:38 
GeneralRe: Trying to update a value in the database. Asp.Net/C#/SQL/VS2005 Pin
foolios4-Oct-07 16:00
foolios4-Oct-07 16:00 
GeneralRe: Trying to update a value in the database. Asp.Net/C#/SQL/VS2005 Pin
foolios4-Oct-07 17:27
foolios4-Oct-07 17:27 
QuestionThanks Pin
OlieColie4-Oct-07 14:10
OlieColie4-Oct-07 14:10 
AnswerRe: Thanks Pin
Christian Graus4-Oct-07 14:31
protectorChristian Graus4-Oct-07 14:31 
QuestionTextbox C# Pin
OlieColie4-Oct-07 13:30
OlieColie4-Oct-07 13:30 
AnswerRe: Textbox C# Pin
Colin Angus Mackay4-Oct-07 13:44
Colin Angus Mackay4-Oct-07 13:44 
AnswerRe: Textbox C# Pin
N a v a n e e t h4-Oct-07 19:21
N a v a n e e t h4-Oct-07 19:21 
Questiondynamic anchor with onserverclick as control Pin
Chandiv4-Oct-07 9:14
Chandiv4-Oct-07 9:14 
QuestionTrigger validationsummary message box Pin
JimFeng4-Oct-07 8:35
JimFeng4-Oct-07 8:35 
AnswerRe: Trigger validationsummary message box Pin
Christian Graus4-Oct-07 14:43
protectorChristian Graus4-Oct-07 14:43 
QuestionAdding a button to a table created in codebehind Pin
Chajon4-Oct-07 6:40
Chajon4-Oct-07 6:40 
AnswerRe: Adding a button to a table created in codebehind Pin
talasila804-Oct-07 7:26
talasila804-Oct-07 7:26 
GeneralRe: Adding a button to a table created in codebehind Pin
Chajon4-Oct-07 7:41
Chajon4-Oct-07 7:41 
QuestionRemoving anonymous access to web service Pin
gauthee4-Oct-07 5:04
gauthee4-Oct-07 5:04 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.