Click here to Skip to main content
15,915,094 members
Home / Discussions / C#
   

C#

 
GeneralRe: Proper use of Refresh() and Invalidate() Pin
mikker_1232-Aug-05 16:20
mikker_1232-Aug-05 16:20 
GeneralRe: Proper use of Refresh() and Invalidate() Pin
Mutty3-Aug-05 2:26
Mutty3-Aug-05 2:26 
GeneralRe: Proper use of Refresh() and Invalidate() Pin
mikker_1233-Aug-05 8:34
mikker_1233-Aug-05 8:34 
GeneralDeleting a Whole Row Pin
tatchung2-Aug-05 15:34
tatchung2-Aug-05 15:34 
GeneralRe: Deleting a Whole Row Pin
Christian Graus2-Aug-05 15:52
protectorChristian Graus2-Aug-05 15:52 
GeneralRe: Deleting a Whole Row Pin
mikker_1232-Aug-05 16:08
mikker_1232-Aug-05 16:08 
GeneralRe: Deleting a Whole Row Pin
tatchung2-Aug-05 16:19
tatchung2-Aug-05 16:19 
GeneralRe: Deleting a Whole Row Pin
Christian Graus2-Aug-05 16:50
protectorChristian Graus2-Aug-05 16:50 
if (Page.Request.QueryString["Mode"] == "Delete")
{
objCol.DeleteColors(Page.Request.QueryString["key"],""); // 2 - you always pass an empty string to compare with c_code, so it will never do anything anyhow
Response.Redirect ("SysColors.aspx");
}// 1. If it hangs here, then there's nothing else for the debugger to show you, it's gone off to another form. Put a break point in the other form to see if it gets there. I assume you've stepped through to see the rest is executed ?


//objCol
public bool DeleteColors(string strObject,string strColors)
{
try
{
strSQL = " DELETE FROM sys_colors";
strSQL += " WHERE object = '" + strObject+ "' ";
strSQL += " AND c_code = '" + strColors + "' ";

OdbcCommand cmdDelete = new OdbcCommand();
cmdDelete.CommandText = strSQL;
cmdDelete.Connection = cnnDS;
cmdDelete.ExecuteNonQuery();

return true;
}
catch (Exception e)
{
throw e;
}


3 - sys_ is the prefix for system tables, so why are you using it ?



Christian Graus - Microsoft MVP - C++
GeneralRe: Deleting a Whole Row Pin
tatchung2-Aug-05 17:10
tatchung2-Aug-05 17:10 
GeneralRe: Deleting a Whole Row Pin
Christian Graus2-Aug-05 17:45
protectorChristian Graus2-Aug-05 17:45 
GeneralRe: Deleting a Whole Row Pin
tatchung2-Aug-05 17:52
tatchung2-Aug-05 17:52 
GeneralRe: Deleting a Whole Row Pin
Christian Graus2-Aug-05 17:57
protectorChristian Graus2-Aug-05 17:57 
GeneralRe: Deleting a Whole Row Pin
tatchung2-Aug-05 18:05
tatchung2-Aug-05 18:05 
GeneralRe: Deleting a Whole Row Pin
Christian Graus2-Aug-05 18:07
protectorChristian Graus2-Aug-05 18:07 
GeneralRe: Deleting a Whole Row Pin
tatchung2-Aug-05 18:13
tatchung2-Aug-05 18:13 
GeneralRe: Deleting a Whole Row Pin
Christian Graus2-Aug-05 18:15
protectorChristian Graus2-Aug-05 18:15 
GeneralRe: Deleting a Whole Row Pin
tatchung2-Aug-05 18:21
tatchung2-Aug-05 18:21 
GeneralRe: Deleting a Whole Row Pin
tatchung4-Aug-05 21:53
tatchung4-Aug-05 21:53 
GeneralRe: Deleting a Whole Row Pin
Christian Graus7-Aug-05 13:18
protectorChristian Graus7-Aug-05 13:18 
GeneralGet control form its NAME Pin
Radgar2-Aug-05 13:15
Radgar2-Aug-05 13:15 
GeneralRe: Get control form its NAME Pin
Christian Graus2-Aug-05 14:41
protectorChristian Graus2-Aug-05 14:41 
GeneralRe: Get control form its NAME Pin
Radgar2-Aug-05 15:09
Radgar2-Aug-05 15:09 
GeneralRe: Get control form its NAME Pin
Christian Graus2-Aug-05 15:19
protectorChristian Graus2-Aug-05 15:19 
GeneralRe: Get control form its NAME Pin
Radgar2-Aug-05 15:31
Radgar2-Aug-05 15:31 
GeneralRe: Get control form its NAME Pin
Christian Graus2-Aug-05 15:55
protectorChristian Graus2-Aug-05 15:55 

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.