Cannot convert bool to string

Question

1.00/5 (3 votes)

See more:

The OP posted this as an Answer:
"return blnSucess;
search this code in every place where it is typed the main error is this.here the error message is "cannot convert implicitly type bool to string."

using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data.SqlClient;
using System.Web.Security;
using System.Configuration;

[WebService(Namespace="http://tempuri.org/"), WebServiceBinding(ConformsTo=WsiProfiles.BasicProfile1_1), Microsoft.VisualBasic.CompilerServices.DesignerGenerated(), System.Web.Script.Services.ScriptService()]
public class ChatService : System.Web.Services.WebService
{

	[WebMethod()]
	public string GetMessages(string strFromUserID, string strToUserID)
	{
		bool blnSucess = false;
		string strMessage = null;
		DateTime dDateSent = DateTime.MinValue;

		strMessage = "";

		using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
		{
			conn.Open();

			SqlCommand cmd = null;

			MembershipUser MemUser = null;
			string strFromUserGUID = null;
			MemUser = Membership.GetUser(HttpUtility.UrlDecode(strFromUserID));
			strFromUserGUID = MemUser.ProviderUserKey.ToString();
			string strToUserGUID = null;
			MemUser = Membership.GetUser(HttpUtility.UrlDecode(strToUserID));
			strToUserGUID = MemUser.ProviderUserKey.ToString();

			cmd = new SqlCommand("SELECT TOP(1) Message, DateSent FROM [IMChats] WHERE ([SenderUserID] = @SenderUserID AND [RecipientUserID] = @RecipientUserID) ORDER BY DateSent DESC", conn);
			cmd.Parameters.AddWithValue("@SenderUserID", strToUserGUID);
			cmd.Parameters.AddWithValue("@RecipientUserID", strFromUserGUID);
			SqlDataReader reader = cmd.ExecuteReader();
			while (reader.Read())
			{
				dDateSent = (DateTime)reader["DateSent"];
				//If dDateSent > DateAdd(DateInterval.Minute, -5, DateTime.Now) Then
				strMessage = (string)reader["Message"];
				blnSucess = true;
				//End If
			}
			reader.Close();
			cmd.Dispose();

			if (blnSucess)
			{
				cmd = conn.CreateCommand();
				cmd.CommandText = "DELETE FROM [IMChats] WHERE ([SenderUserID] = @SenderUserID AND [RecipientUserID] = @RecipientUserID)";
				cmd.Parameters.AddWithValue("@SenderUserID", strToUserGUID);
				cmd.Parameters.AddWithValue("@RecipientUserID", strFromUserGUID);
				cmd.ExecuteNonQuery();
				cmd.Dispose();
			}
			conn.Close();

		}
		return strMessage;
	}
	[WebMethod()]
	public string SendMessage(string strSenderUserID, string strRecipientUserID, string strMessage)
	{
		bool blnSucess = false;
		using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
		{

			conn.Open();

			SqlCommand cmd = null;

			MembershipUser MemUser = null;
			string strRecipientUserGUID = null;
			MemUser = Membership.GetUser(HttpUtility.UrlDecode(strRecipientUserID));
			strRecipientUserGUID = MemUser.ProviderUserKey.ToString();
			string strSenderUserGUID = null;
			MemUser = Membership.GetUser(HttpUtility.UrlDecode(strSenderUserID));
			strSenderUserGUID = MemUser.ProviderUserKey.ToString();

			cmd = conn.CreateCommand();
			cmd.CommandText = "DELETE FROM [IMChats] WHERE ([SenderUserID] = @SenderUserID AND [RecipientUserID] = @RecipientUserID)";
			cmd.Parameters.AddWithValue("@SenderUserID", strSenderUserGUID);
			cmd.Parameters.AddWithValue("@RecipientUserID", strRecipientUserGUID);
			cmd.ExecuteNonQuery();
			cmd.Dispose();

			cmd = conn.CreateCommand();
			cmd.CommandText = "INSERT INTO IMChats(RecipientUserID, SenderUserID, Message, DateSent) VALUES (@RecipientUserID, @SenderUserID, @Message, @DateSent)";
			cmd.Parameters.AddWithValue("@RecipientUserID", strRecipientUserGUID);
			cmd.Parameters.AddWithValue("@SenderUserID", strSenderUserGUID);
			cmd.Parameters.AddWithValue("@Message", strMessage);
			cmd.Parameters.AddWithValue("@DateSent", DateTime.Now);

			cmd.ExecuteNonQuery();
			blnSucess = true;
			cmd.Dispose();
			conn.Close();
		}
		<big>return blnSucess;</big>
	}

	//ENQ = chr(5)                            # Request to send
	//EOT = chr(4)                            # Ready to receive
	//ACK = chr(6)                            # Correct reception
	//NAK = chr(21)                           # Incorrect reception
	//////////////////////////////////
	//// Sender init chat
	//////////////////////////////////
	//// Sender ENQ     Wait 4 ACK
	//// Recip  ACK ENQ Wait 4 ACK ACK
	//// Sender ACK ACK Wait 4 EOT
	//// Recip  EOT
	//////////////////////////////////
	//// Recip wait 4 chat
	//////////////////////////////////
	//// Recip  ACK ENQ Wait 4 ACK
	//// Sender ACK ACK Wait 4 EOT
	//// Recip  EOT

	[WebMethod()]
	public string CheckChatReq(string strMyUserID)
	{
		string strSenderUserID = null;
		string strMessage = null;
		DateTime dDateSent = DateTime.MinValue;
		strSenderUserID = "";
		using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
		{
			conn.Open();

			SqlCommand cmd = null;

			string strMyUserGUID = "";
			string strSenderUserGUID = "";
			MembershipUser MemUser = Membership.GetUser(HttpUtility.UrlDecode(strMyUserID));
			strMyUserGUID = MemUser.ProviderUserKey.ToString();

			cmd = new SqlCommand("SELECT TOP(1) SenderUserID, Message, DateSent FROM [IMChats] WHERE ([RecipientUserID] = @RecipientUserID) ORDER BY DateSent DESC", conn);
			cmd.Parameters.AddWithValue("@RecipientUserID", strMyUserGUID);
			SqlDataReader reader = cmd.ExecuteReader();
			while (reader.Read())
			{
				dDateSent = (DateTime)reader["DateSent"];
				//If dDateSent > DateAdd(DateInterval.Minute, -5, DateTime.Now) Then
				strMessage = (string)reader["Message"];
				// ENQ
				if (strMessage == "~::::=[(HANDSHAKE)]=::::~[ENQ]")
				{
					strSenderUserGUID = reader["SenderUserID"].ToString();
					strSenderUserID = Membership.GetUser(new Guid(strSenderUserGUID)).UserName;
					//End If
				}
			}
			reader.Close();
			cmd.Dispose();

			if (! (string.IsNullOrEmpty(strSenderUserGUID)))
			{
				cmd = conn.CreateCommand();
				cmd.CommandText = "DELETE FROM [IMChats] WHERE ([SenderUserID] = @SenderUserID AND [RecipientUserID] = @RecipientUserID)";
				cmd.Parameters.AddWithValue("@SenderUserID", strSenderUserGUID);
				cmd.Parameters.AddWithValue("@RecipientUserID", strMyUserGUID);
				cmd.ExecuteNonQuery();
				cmd.Dispose();
			}
			conn.Close();

		}
		return strSenderUserID;
	}
	[WebMethod()]
	public bool SendChatReq(string strSenderUserID, string strRecipientUserID)
	{
		bool blnSucess = false;
		using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
		{

			conn.Open();

			SqlCommand cmd = null;

			MembershipUser MemUser = null;
			string strRecipientUserGUID = null;
			MemUser = Membership.GetUser(HttpUtility.UrlDecode(strRecipientUserID));
			strRecipientUserGUID = MemUser.ProviderUserKey.ToString();
			string strSenderUserGUID = null;
			MemUser = Membership.GetUser(HttpUtility.UrlDecode(strSenderUserID));
			strSenderUserGUID = MemUser.ProviderUserKey.ToString();

			cmd = conn.CreateCommand();
			cmd.CommandText = "DELETE FROM [IMChats] WHERE ([SenderUserID] = @SenderUserID AND [RecipientUserID] = @RecipientUserID)";
			cmd.Parameters.AddWithValue("@SenderUserID", strSenderUserGUID);
			cmd.Parameters.AddWithValue("@RecipientUserID", strRecipientUserGUID);
			cmd.ExecuteNonQuery();
			cmd.Dispose();
			cmd = conn.CreateCommand();
			cmd.CommandText = "DELETE FROM [IMChats] WHERE ([SenderUserID] = @RecipientUserID AND [RecipientUserID] = @SenderUserID)";
			cmd.Parameters.AddWithValue("@SenderUserID", strSenderUserGUID);
			cmd.Parameters.AddWithValue("@RecipientUserID", strRecipientUserGUID);
			cmd.ExecuteNonQuery();
			cmd.Dispose();

			cmd = conn.CreateCommand();
			cmd.CommandText = "INSERT INTO IMChats(RecipientUserID, SenderUserID, Message, DateSent) VALUES (@RecipientUserID, @SenderUserID, @Message, @DateSent)";
			cmd.Parameters.AddWithValue("@RecipientUserID", strRecipientUserGUID);
			cmd.Parameters.AddWithValue("@SenderUserID", strSenderUserGUID);
			// ENQ
			cmd.Parameters.AddWithValue("@Message", "~::::=[(HANDSHAKE)]=::::~[ENQ]");
			cmd.Parameters.AddWithValue("@DateSent", DateTime.Now);

			cmd.ExecuteNonQuery();
			blnSucess = true;
			cmd.Dispose();
			conn.Close();
		}
		<big>return blnSucess;</big>
	}
	[WebMethod()]
	public string ChatCleanUpAll(string strMyUserID)
	{
		bool blnSucess = false;
		using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
		{
			conn.Open();

			SqlCommand cmd = null;

			string strMyUserGUID = null;
			MembershipUser MemUser = Membership.GetUser(HttpUtility.UrlDecode(strMyUserID));
			strMyUserGUID = MemUser.ProviderUserKey.ToString();

			cmd = conn.CreateCommand();
			cmd.CommandText = "DELETE FROM [IMChats] WHERE ([RecipientUserID] = @RecipientUserID)";
			cmd.Parameters.AddWithValue("@RecipientUserID", strMyUserGUID);
			cmd.ExecuteNonQuery();
			cmd.Dispose();
			conn.Close();
			blnSucess = true;
		}
		<big>return blnSucess;</big>
	}
	[WebMethod()]
	public bool CleanUp(string strMyUserID, string strSenderUserID, bool blnSendEOT)
	{
		bool blnSucess = false;
		using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
		{
			conn.Open();

			SqlCommand cmd = null;

			string strMyUserGUID = null;
			MembershipUser MemUser = Membership.GetUser(HttpUtility.UrlDecode(strMyUserID));
			strMyUserGUID = MemUser.ProviderUserKey.ToString();
			string strSenderUserGUID = null;
			MemUser = Membership.GetUser(HttpUtility.UrlDecode(strSenderUserID));
			strSenderUserGUID = MemUser.ProviderUserKey.ToString();

			cmd = conn.CreateCommand();
			cmd.CommandText = "DELETE FROM [IMChats] WHERE ([SenderUserID] = @SenderUserID AND [RecipientUserID] = @RecipientUserID)";
			cmd.Parameters.AddWithValue("@RecipientUserID", strMyUserGUID);
			cmd.Parameters.AddWithValue("@SenderUserID", strSenderUserGUID);
			cmd.ExecuteNonQuery();
			cmd.Dispose();

			if (blnSendEOT)
			{
				cmd = conn.CreateCommand();
				cmd.CommandText = "INSERT INTO IMChats(RecipientUserID, SenderUserID, Message, DateSent) VALUES (@RecipientUserID, @SenderUserID, @Message, @DateSent)";
				cmd.Parameters.AddWithValue("@RecipientUserID", strSenderUserGUID);
				cmd.Parameters.AddWithValue("@SenderUserID", strMyUserGUID);
				// EOT
				cmd.Parameters.AddWithValue("@Message", "~::::=[(HANDSHAKE)]=::::~[EOT]");
				cmd.Parameters.AddWithValue("@DateSent", DateTime.Now);
				cmd.ExecuteNonQuery();
				cmd.Dispose();
			}
			conn.Close();
			blnSucess = true;

		}
		<big>return blnSucess;</big>

	}
	[WebMethod()]
	public bool SendNak(string strSenderUserID, string strRecipientUserID)
	{
		bool blnSucess = false;
		using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
		{

			conn.Open();

			SqlCommand cmd = null;

			MembershipUser MemUser = null;
			string strRecipientUserGUID = null;
			MemUser = Membership.GetUser(HttpUtility.UrlDecode(strRecipientUserID));
			strRecipientUserGUID = MemUser.ProviderUserKey.ToString();
			string strSenderUserGUID = null;
			MemUser = Membership.GetUser(HttpUtility.UrlDecode(strSenderUserID));
			strSenderUserGUID = MemUser.ProviderUserKey.ToString();

			cmd = conn.CreateCommand();
			cmd.CommandText = "DELETE FROM [IMChats] WHERE ([SenderUserID] = @SenderUserID AND [RecipientUserID] = @RecipientUserID)";
			cmd.Parameters.AddWithValue("@SenderUserID", strSenderUserGUID);
			cmd.Parameters.AddWithValue("@RecipientUserID", strRecipientUserGUID);
			cmd.ExecuteNonQuery();
			cmd.Dispose();

			cmd = conn.CreateCommand();
			cmd.CommandText = "INSERT INTO IMChats(RecipientUserID, SenderUserID, Message, DateSent) VALUES (@RecipientUserID, @SenderUserID, @Message, @DateSent)";
			cmd.Parameters.AddWithValue("@RecipientUserID", strRecipientUserGUID);
			cmd.Parameters.AddWithValue("@SenderUserID", strSenderUserGUID);
			// NAK
			cmd.Parameters.AddWithValue("@Message", "~::::=[(HANDSHAKE)]=::::~[NAK]");
			cmd.Parameters.AddWithValue("@DateSent", DateTime.Now);

			cmd.ExecuteNonQuery();
			blnSucess = true;
			cmd.Dispose();
			conn.Close();
		}
		<big>return blnSucess;</big>
	}
	[WebMethod()]
	public bool SendAck(string strSenderUserID, string strRecipientUserID)
	{
		bool blnSucess = false;
		using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
		{

			conn.Open();

			SqlCommand cmd = null;

			MembershipUser MemUser = null;
			string strRecipientUserGUID = null;
			MemUser = Membership.GetUser(HttpUtility.UrlDecode(strRecipientUserID));
			strRecipientUserGUID = MemUser.ProviderUserKey.ToString();
			string strSenderUserGUID = null;
			MemUser = Membership.GetUser(HttpUtility.UrlDecode(strSenderUserID));
			strSenderUserGUID = MemUser.ProviderUserKey.ToString();

			cmd = conn.CreateCommand();
			cmd.CommandText = "DELETE FROM [IMChats] WHERE ([SenderUserID] = @SenderUserID AND [RecipientUserID] = @RecipientUserID)";
			cmd.Parameters.AddWithValue("@SenderUserID", strSenderUserGUID);
			cmd.Parameters.AddWithValue("@RecipientUserID", strRecipientUserGUID);
			cmd.ExecuteNonQuery();
			cmd.Dispose();

			cmd = conn.CreateCommand();
			cmd.CommandText = "INSERT INTO IMChats(RecipientUserID, SenderUserID, Message, DateSent) VALUES (@RecipientUserID, @SenderUserID, @Message, @DateSent)";
			cmd.Parameters.AddWithValue("@RecipientUserID", strRecipientUserGUID);
			cmd.Parameters.AddWithValue("@SenderUserID", strSenderUserGUID);
			// ACK
			cmd.Parameters.AddWithValue("@Message", "~::::=[(HANDSHAKE)]=::::~[ACK]");
			cmd.Parameters.AddWithValue("@DateSent", DateTime.Now);

			cmd.ExecuteNonQuery();
			blnSucess = true;
			cmd.Dispose();
			conn.Close();
		}
		<big>return blnSucess;</big>
	}
	[WebMethod()]
	public bool GetAck(string strRecipientUserID, string strSenderUserID)
	{
		bool blnSucess = false;
		string strMessage = null;
		DateTime dDateSent = DateTime.MinValue;

		using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
		{
			conn.Open();

			SqlCommand cmd = null;

			MembershipUser MemUser = null;
			string strRecipientUserGUID = null;
			MemUser = Membership.GetUser(HttpUtility.UrlDecode(strRecipientUserID));
			strRecipientUserGUID = MemUser.ProviderUserKey.ToString();
			string strSenderUserGUID = null;
			MemUser = Membership.GetUser(HttpUtility.UrlDecode(strSenderUserID));
			strSenderUserGUID = MemUser.ProviderUserKey.ToString();

			cmd = new SqlCommand("SELECT TOP(1) Message, DateSent FROM [IMChats] WHERE ([SenderUserID] = @SenderUserID AND [RecipientUserID] = @RecipientUserID) ORDER BY DateSent DESC", conn);
			cmd.Parameters.AddWithValue("@SenderUserID", strSenderUserGUID);
			cmd.Parameters.AddWithValue("@RecipientUserID", strRecipientUserGUID);
			SqlDataReader reader = cmd.ExecuteReader();
			while (reader.Read())
			{
				dDateSent = (DateTime)reader["DateSent"];
				//If dDateSent > DateAdd(DateInterval.Minute, -5, DateTime.Now) Then
				strMessage = (string)reader["Message"];
				// ACK
				if (strMessage == "~::::=[(HANDSHAKE)]=::::~[ACK]")
				{
					blnSucess = true;
					//End If
				}
			}
			reader.Close();
			cmd.Dispose();

			if (blnSucess)
			{
				cmd = conn.CreateCommand();
				cmd.CommandText = "DELETE FROM [IMChats] WHERE ([SenderUserID] = @SenderUserID AND [RecipientUserID] = @RecipientUserID)";
				cmd.Parameters.AddWithValue("@SenderUserID", strSenderUserGUID);
				cmd.Parameters.AddWithValue("@RecipientUserID", strRecipientUserGUID);
				cmd.ExecuteNonQuery();
				cmd.Dispose();
			}
			conn.Close();

		}
		<big>return blnSucess;</big>
	}
	[WebMethod()]
	public bool GetNak(string strRecipientUserID, string strSenderUserID)
	{
		bool blnSucess = false;
		string strMessage = null;
		DateTime dDateSent = DateTime.MinValue;

		using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
		{
			conn.Open();

			SqlCommand cmd = null;

			MembershipUser MemUser = null;
			string strRecipientUserGUID = null;
			MemUser = Membership.GetUser(HttpUtility.UrlDecode(strRecipientUserID));
			strRecipientUserGUID = MemUser.ProviderUserKey.ToString();
			string strSenderUserGUID = null;
			MemUser = Membership.GetUser(HttpUtility.UrlDecode(strSenderUserID));
			strSenderUserGUID = MemUser.ProviderUserKey.ToString();

			cmd = new SqlCommand("SELECT TOP(1) Message, DateSent FROM [IMChats] WHERE ([SenderUserID] = @SenderUserID AND [RecipientUserID] = @RecipientUserID) ORDER BY DateSent DESC", conn);
			cmd.Parameters.AddWithValue("@SenderUserID", strSenderUserGUID);
			cmd.Parameters.AddWithValue("@RecipientUserID", strRecipientUserGUID);
			SqlDataReader reader = cmd.ExecuteReader();
			while (reader.Read())
			{
				dDateSent = (DateTime)reader["DateSent"];
				//If dDateSent > DateAdd(DateInterval.Minute, -5, DateTime.Now) Then
				strMessage = (string)reader["Message"];
				// NAK
				if (strMessage == "~::::=[(HANDSHAKE)]=::::~[NAK]")
				{
					blnSucess = true;
					//End If
				}
			}
			reader.Close();
			cmd.Dispose();

			if (blnSucess)
			{
				cmd = conn.CreateCommand();
				cmd.CommandText = "DELETE FROM [IMChats] WHERE ([SenderUserID] = @SenderUserID AND [RecipientUserID] = @RecipientUserID)";
				cmd.Parameters.AddWithValue("@SenderUserID", strSenderUserGUID);
				cmd.Parameters.AddWithValue("@RecipientUserID", strRecipientUserGUID);
				cmd.ExecuteNonQuery();
				cmd.Dispose();
			}
			conn.Close();

		}
		<big>return blnSucess;</big>
	}
	[WebMethod()]
	public bool SendEot(string strSenderUserID, string strRecipientUserID)
	{
		bool blnSucess = false;
		using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
		{

			conn.Open();

			SqlCommand cmd = null;

			MembershipUser MemUser = null;
			string strRecipientUserGUID = null;
			MemUser = Membership.GetUser(HttpUtility.UrlDecode(strRecipientUserID));
			strRecipientUserGUID = MemUser.ProviderUserKey.ToString();
			string strSenderUserGUID = null;
			MemUser = Membership.GetUser(HttpUtility.UrlDecode(strSenderUserID));
			strSenderUserGUID = MemUser.ProviderUserKey.ToString();

			cmd = conn.CreateCommand();
			cmd.CommandText = "DELETE FROM [IMChats] WHERE ([SenderUserID] = @RecipientUserID AND [RecipientUserID] = @SenderUserID)";
			cmd.Parameters.AddWithValue("@SenderUserID", strSenderUserGUID);
			cmd.Parameters.AddWithValue("@RecipientUserID", strRecipientUserGUID);
			cmd.ExecuteNonQuery();
			cmd.Dispose();

			cmd = conn.CreateCommand();
			cmd.CommandText = "INSERT INTO IMChats(RecipientUserID, SenderUserID, Message, DateSent) VALUES (@RecipientUserID, @SenderUserID, @Message, @DateSent)";
			cmd.Parameters.AddWithValue("@RecipientUserID", strRecipientUserGUID);
			cmd.Parameters.AddWithValue("@SenderUserID", strSenderUserGUID);
			// EOT
			cmd.Parameters.AddWithValue("@Message", "~::::=[(HANDSHAKE)]=::::~[EOT]");
			cmd.Parameters.AddWithValue("@DateSent", DateTime.Now);

			cmd.ExecuteNonQuery();
			blnSucess = true;
			cmd.Dispose();
			conn.Close();
		}
		<big>return blnSucess;</big>
	}
	[WebMethod()]
	public bool GetEot(string strRecipientUserID, string strSenderUserID)
	{
		<big>bool blnSucess = false;</big>
		string strMessage = null;
		DateTime dDateSent = DateTime.MinValue;

		using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
		{
			conn.Open();

			SqlCommand cmd = null;

			MembershipUser MemUser = null;
			string strRecipientUserGUID = null;
			MemUser = Membership.GetUser(HttpUtility.UrlDecode(strRecipientUserID));
			strRecipientUserGUID = MemUser.ProviderUserKey.ToString();
			string strSenderUserGUID = null;
			MemUser = Membership.GetUser(HttpUtility.UrlDecode(strSenderUserID));
			strSenderUserGUID = MemUser.ProviderUserKey.ToString();

			cmd = new SqlCommand("SELECT TOP(1) Message, DateSent FROM [IMChats] WHERE ([SenderUserID] = @SenderUserID AND [RecipientUserID] = @RecipientUserID) ORDER BY DateSent DESC", conn);
			cmd.Parameters.AddWithValue("@SenderUserID", strSenderUserGUID);
			cmd.Parameters.AddWithValue("@RecipientUserID", strRecipientUserGUID);
			SqlDataReader reader = cmd.ExecuteReader();
			while (reader.Read())
			{
				dDateSent = (DateTime)reader["DateSent"];
				//If dDateSent > DateAdd(DateInterval.Minute, -5, DateTime.Now) Then
				strMessage = (string)reader["Message"];
				// EOT
				if (strMessage == "~::::=[(HANDSHAKE)]=::::~[EOT]")
				{
					blnSucess = true;
					//End If
				}
			}
			reader.Close();
			cmd.Dispose();

			if (blnSucess)
			{
				cmd = conn.CreateCommand();
				cmd.CommandText = "DELETE FROM [IMChats] WHERE ([SenderUserID] = @SenderUserID AND [RecipientUserID] = @RecipientUserID)";
				cmd.Parameters.AddWithValue("@SenderUserID", strSenderUserGUID);
				cmd.Parameters.AddWithValue("@RecipientUserID", strRecipientUserGUID);
				cmd.ExecuteNonQuery();
				cmd.Dispose();
			}
			conn.Close();

		}
		<big>return blnSucess;</big>
	}

}

[edit]OP answer added to question text. Code block added, title changed to reflect question. - OriginalGriff[/edit]

Posted 12-Oct-10 21:19pm

Zia Ullah Khan

Updated 12-Oct-10 21:47pm

OriginalGriff

v2

Add a Solution

Comments

Hiren solanki 13-Oct-10 3:23am

where is error, I cannot see any bold :)

OriginalGriff 13-Oct-10 3:29am

Nobody is goingt o wade through that looking for your problem - edit the question and show only the relevant lines (in < pre > tags using teh "code block" widget to preserve formatting).
Oh, and test us what the error message is?

Johnny J. 13-Oct-10 4:08am

REPOST

Toli Cuturicu 13-Oct-10 10:47am

Repost; Huge code dump.

1 solution

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)

OriginalGriff · Accepted Answer · 2010-10-12T21:55:00

If you look at your errors list, it will tell you which file and which line it is complaining about.
Double click the error, and it will take you to the faulty code.
In this case, I will bet it is the SendMessage method.
What is it's return type?
What type is blnSucess?
Why do you think it is saying

"I can't convert a bool variable to a string unless you tell me I really must, because I think you intended to either have your method return a bool, or to return a string instead of a bool when you got to the end of your method".

Only that message is way too long to read every time you c**k up, so they went with the pithier version.