delete sql row asp.net

Question

0.00/5 (No votes)

See more:

i have sql query
string strQuery = "DELETE FROM [USER] WHERE RoomID=" + Session["CURRENTROOM_ID"].ToString() + " AND ugid=" + strID;

i pass the ugid from another page and it work fine

i want to modify sql query to delete row where
ugid=" + strID
nick=" + strID1
ip=" + strID2
LoggedTime=" + strID3

i can pass all the value fine only need the sql query

i tried everything every time i get
error converting the nvarchar value to a column of data type int.

can anyone help me with that

note :
[ugid] [bigint] NOT NULL CONSTRAINT [DF_ChatUser_ugid] DEFAULT ((0)),
[nick] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ip] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LoggedTime] [datetime] NULL

Posted 30-Jun-11 10:19am

akoyoon

Updated 30-Jun-11 10:21am

v2

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**theanil** · Answer 1 · 2011-06-30T12:34:00

Solution 3

k...
just try this
string a = strID1;
int x = new int();
x = int.parse(a);

Posted 30-Jun-11 12:34pm

theanil

Comments

akoyoon 30-Jun-11 18:43pm

when i try this i get
'int' does not contain a definition for 'parse'

theanil 30-Jun-11 18:49pm

Parse (capital p)

akoyoon 30-Jun-11 18:52pm

now i get
System.Data.SqlClient.SqlException: Conversion failed when converting the nvarchar value 'akoyoon' to data type int.

**theanil** · Answer 2 · 2011-06-30T10:33:00

Solution 2

int x = new int();
x = int.Parse(strID);

ugid=" + x
nick=" + strID1
ip=" + strID2
LoggedTime=" + strID3

Posted 30-Jun-11 10:33am

theanil

Updated 30-Jun-11 11:46am

v3

Comments

akoyoon 30-Jun-11 16:37pm

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

theanil 30-Jun-11 16:43pm

it is working at my side.. i am updating it just check

akoyoon 30-Jun-11 16:47pm

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");

} %>

theanil 30-Jun-11 16:47pm

and if it also dosen't work then try this
Convert.ToInt32(strID1);

theanil 30-Jun-11 16:50pm

Man you said me you want to pass nick but your code shows ugid

theanil 30-Jun-11 16:51pm

int x = new int();
int.Parse(strID);

akoyoon 30-Jun-11 17:27pm

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

theanil 30-Jun-11 17:47pm

i have edited

theanil 30-Jun-11 17:45pm

ugid=" + x
nick=" + strID1
ip=" + strID2
LoggedTime=" + strID3

akoyoon 30-Jun-11 18:06pm

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");

} %>

akoyoon 30-Jun-11 18:10pm

ignore my last reply wait i will update you inn minutes

akoyoon 30-Jun-11 18:19pm

now when i make the query like this

string strQuery = "DELETE FROM [USER] WHERE RoomID=" + Session["CURRENTROOM_ID"].ToString() + " AND nick=" + x;

if field nick have a word like theanil i get the error

Exception Details: System.FormatException: Input string was not in a correct format.
Source Error:
Line 15: int.Parse(strID1);

**theanil** · Answer 3 · 2011-06-30T10:20:00

Solution 1

convert the value using
store the value in variable x
int.parse(x);

Posted 30-Jun-11 10:20am

theanil

Updated 30-Jun-11 10:22am

v2

Comments

akoyoon 30-Jun-11 16:22pm

can you give me example for the query

theanil 30-Jun-11 16:26pm

just a min...

theanil 30-Jun-11 16:27pm

please let me know which column value you want to convert it to int

akoyoon 30-Jun-11 16:29pm

column nick

theanil 30-Jun-11 16:33pm

int x = int.parse(strID1);