Comments by akoyoon (Top 32 by date)

here is the page after your suggestions and still the same i get error
System.Data.SqlClient.SqlException: Invalid column name 'nick'.


<%@ Page Language="C#" AutoEventWireup="true" %>
<% if (!IsPostBack)
{
if (Request.UrlReferrer == null)
Response.Redirect("/");

Session["EDIT_DS"] = null;
Session["ACTION"] = null;

string strID = Request.QueryString["ugid"];
string strID1 = Request.QueryString["nick"];
string strID2 = Request.QueryString["ip"];
string strID3 = Request.QueryString["LoggedTime"];
int x = new int();
int.Parse(strID1);



System.Data.SqlClient.SqlConnection SQLConnection = new System.Data.SqlClient.SqlConnection();
string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
SQLConnection.ConnectionString = ConnectionString;
if (SQLConnection.State == System.Data.ConnectionState.Closed)
SQLConnection.Open();
System.Data.DataSet ds = new System.Data.DataSet();

string strQuery = "DELETE FROM [USER] WHERE RoomID=" + Session["CURRENTROOM_ID"].ToString() + " AND nick=" + x;
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
cmd.CommandText = strQuery;
cmd.Connection = SQLConnection;
cmd.ExecuteNonQuery();

SQLConnection.Close();

Session["ACTION"] = "Delete";

Response.Redirect("../Main.aspx?Section=BlockedIPs");

} %>

when i use
int x = new int();
int.Parse(strID);

and
nick=" + x
i get error
System.Data.SqlClient.SqlException: Invalid column name 'nick'.
=======================
he same error when i use
Convert.ToInt32(strID1);
System.Data.SqlClient.SqlException: Invalid column name 'nick'.
=======================

can you post me the entire page after passing nick and use it instead if ugid

here is my page can you tell me what to do or how it suppose to be done

<%@ Page Language="C#" AutoEventWireup="true" %>
<% if (!IsPostBack)
{
if (Request.UrlReferrer == null)
Response.Redirect("/");

Session["EDIT_DS"] = null;
Session["ACTION"] = null;

string strID = Request.QueryString["ugid"];
string strID1 = Request.QueryString["nick"];
string strID2 = Request.QueryString["ip"];
string strID3 = Request.QueryString["LoggedTime"];
System.Data.SqlClient.SqlConnection SQLConnection = new System.Data.SqlClient.SqlConnection();
string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
SQLConnection.ConnectionString = ConnectionString;
if (SQLConnection.State == System.Data.ConnectionState.Closed)
SQLConnection.Open();
System.Data.DataSet ds = new System.Data.DataSet();
string strQuery = "DELETE FROM [USER] WHERE RoomID=" + Session["CURRENTROOM_ID"].ToString() + " AND ugid=" + strID;
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
cmd.CommandText = strQuery;
cmd.Connection = SQLConnection;
cmd.ExecuteNonQuery();
SQLConnection.Close();

Session["ACTION"] = "Delete";

Response.Redirect("../Main.aspx?Section=BlockedIPs");

} %>

it didnot work i get now error
'int' does not contain a definition for 'parse'

column nick

can you give me example for the query

thanx so much for your help

i don't get any errors just when i try to insert Arabic character they get saved ?????

waiting to hear from you

hi SAKryukov,
Can you reply me when you see that i need to know your answer

revived and reply you with message 20 minutes ago with details please confirm you received it and waiting your reply hope i get it today

ok waiting you i have couple of projects some small things and some big projects

i sent you message and just checking if you received it to make sure

hi SAKryukov,

Can I hire you to help me with some problems i have and somethings i need ???

waiting your reply
Regards

yes thanx

thanx alot for your help i was able to do what i want like this

<script>
function getSelectValue(){
xxx=document.getElementById("xxxxxxxxxxxx").value;
if (xxx == 1){
i3 = _doBanMe('<%=strName%>', <%=strUid%>,'1');
}
if (xxx == 2){
i3 = _doBanMe('<%=strName%>', <%=strUid%>,'2');
}
if (xxx == 3){
i3 = _doBanMe('<%=strName%>', <%=strUid%>,'3');
}
}
</script>
<select id="xxxxxxxxxxxx" style="font-size:9pt" önChange="getSelectValue();JavaScript:CtrlPan(this.options[this.selectedIndex].value);this.selectedIndex=0">
<option value="0">test 0</option>
<option value="1">test 1</option>
<option value="2">test 2</option>
<option value="3">test 3</option>
</select>

done it like what you said and still the same thing i have to write number 3 myself if i want my code to work but what i want is to make code that will change the word Number with the value i select
i3 = _doBanMe('<%=strName%>', <%=strUid%>,'Number')

function _doBanMe write a line in table in the db that contain Name and Uid and Number
so i put this at the beginning of my code

<script type="text/javascript"><!--
function eventHandler(value) {

i3 = _doBanMe('<%=strName%>', <%=strUid%>,'3')
}
--></script>


and replaced the drop-down menue with this

<select style="font-size:9pt" önChange="CtrlPan(value);this.selectedIndex=0;eventHandler(value)">
<option value="0">test 0</option>
<option value="1">test 1</option>
<option value="2">test 2</option>
<option value="3">test 3</option>
</select>

the code work and the row get add to the db fine what i need to do is make the Numer= selected item value
so my problem is how to write this line

i3 = _doBanMe('<%=strName%>', <%=strUid%>,'3')

so instead of Number 3 he write the value

i found that i can excute the function that i want by modifing the code to

<script type="text/javascript"><!--
function eventHandler(value) {


i3 = _doBanMe('<%=strName%>', <%=strUid%>,'2')
}
--></script>

whats missing and i cannot make is i want instead of number 2 i can send the selected item value
itried this but it didnot work

i3 = _doBanMe('<%=strName%>', <%=strUid%>,'(value)')

let me explain to you every thing i am a designer i donot have knowledge a bout programmer very simple things i know and i am making some changes to a customer the customer
have alot of buttons and every button do different things for examples
<input type="button" name="test" value="0" önclick="CtrlPan(0);_doBanMe('<%=strName%>', <%=strUid%>,'0');"">
<input type="button" name="test1" value="1" önclick="CtrlPan(1);_doBanMe('<%=strName%>', <%=strUid%>,'1');"">
<input type="button" name="test2" value="2" önclick="CtrlPan(2);_doBanMe('<%=strName%>', <%=strUid%>,'2');"">

for designing reasons i have to make these buttons in a drop-down menu any way after doing all your change like this

<script type="text/javascript"><!--
function eventHandler(value) {
alert(value);
}
--></script>

<select style="font-size:9pt" önChange="CtrlPan(value);this.selectedIndex=0;eventHandler(value)">
<option value="0">test 0</option>
<option value="1">test 1</option>
<option value="2">test 2</option>
<option value="3">test 3</option>
</select>

now i donot know who do i execute function doBanMe with different value for every item
thats my problem

i tried onChange like what you said
<select önChange="CtrlPan(value);this.selectedIndex=0;_doBanMe('<%=strName%>', <%=strUid%>,'(value)');">
as you see the onChange do 3 things
-call CtrlPan(value) ---- work fine
-retern the drop-down menu after selection to test ---- work fine
-execute function _doBanMe and send it 3 data
_doBanMe('<%=strName%>', <%=strUid%>,'xxxxxxxxxxxx');
my problem with xxxxxxxxxxxx instead i want to send the selected item value when i try like what you said it doesnot work
_doBanMe('<%=strName%>', <%=strUid%>,'(value)');"

you are correct my way didn't work at all i thought it can be done like this
<td align="center">
<select style="font-size:9pt" önChange="JavaScript:CtrlPan(this.options[this.selectedIndex].value);this.selectedIndex=0;">
<option value=0 önChange="_doBanMe('<%=strName%>', <%=strUid%>,'0');">test</option>
<option value=1 önChange="_doBanMe('<%=strName%>', <%=strUid%>,'1');">test1</option>
<option value=3 önChange="_doBanMe('<%=strName%>', <%=strUid%>,'3');">test2</option>
<option value=4 önChange="_doBanMe('<%=strName%>', <%=strUid%>,'4');">test3</option>
</select></td>

i am not a programmer and i donot understand how your way work or what i am suppose to do can you help me

thnx for your help but i found a very easy way to do what i want

i am not really sure how to use this code with my onChange

onChange="JavaScript:CtrlPan(this.options[this.selectedIndex].value);this.selectedIndex=0;_doBanMe('<%=strName%>', <%=strUid%>,'xxxxxxxxxxxx');">

when i press on any item one of the things the onchange function do is to
execute function _doBanMe('<%=strName%>', <%=strUid%>,'xxxxxxxxxxxx');
i need to send to function doBanMe instead of the value xxxxxxxxxxxx the selected item value
for example when i press on item test3
i need the onchange execute _doBanMe('<%=strName%>', <%=strUid%>,'4');
when press item test2
i need the onchange execute _doBanMe('<%=strName%>', <%=strUid%>,'3');

your code will not be useful in case someone try to upload image with name like hi.asp;.jpg for example

your code do exactly what the code i posted do but it doesn't solve the problem

i donot understand what you mean