C#

using (SqlDataReader reader = cmd.ExecuteReader()) {
    while (reader.Read()) {
        if (txtUsername.Text == (reader["UserName"].ToString()) && txtPassword.Text = reader["Password"].ToString())) {
            // whatever needs to be done on a match
            break;  // optionally shortcircuit the remainder of the loop
        }
    }
} // close the using statement, this automatically calls Dispose()

try
{

	SqlConnection conn = new SqlConnection("");	 
	conn = DataHandler.conn;	 
	String username = txtUsername.Text;
	String password = txtPassword.Text;
	SqlCommand cmd = new SqlCommand("SELECT * FROM [TBLUsers]", conn);
	conn.Open();
	DataTable table = new DataTable();
	SqlDataReader reader = null;
	reader = cmd.ExecuteReader();
	while (reader.Read())
	{
		if (txtUsername.Text == (reader["UserName"].ToString()) && txtPassword.Text = reader["Password"].ToString()))
		{
			table.Load(reader);
			POS2 p = new POS2();
			MainPage page = (MainPage)this.MdiParent;
			p.MdiParent = page;
			p.WindowState = FormWindowState.Maximized;
			p.Show();
			page.WelcomeUser = reader["UserName"].ToString();
			 
			//throw new CustomException("Enter Correct Username and Password");

		}
	}
}
catch
{
	reader.Dispose();
}
finally
{
	conn.close();
}

Invalid attempt to call MetaData when reader is closed.

POST /xmlservice1dot1/service1.asmx/PostMethod HTTP/1.1
Host: ***.***.**.**
Content-Type: application/x-www-form-urlencoded
Content-Length: length

test=string

samir.abda wrote:

I was doing a post to http://localhost/Service1.asmx/HelloWorld and it works fine but I cant get it to work for PostMethod.

<webServices>
  <protocols>
    <add name="HttpGet"/>
  </protocols>
</webServices>

Mark Salsbery
Microsoft MVP - Visual C++

<test>This is a test string</test>

XmlDocument _xml = new XmlDocument();
_xml.Load(filePath);

ServicePointManager.ServerCertificateValidationCallback = AcceptAllCertificatePolicy;
WebRequest _request = WebRequest.Create((WebServiceURL));
_request.Credentials = new NetworkCredential(UserName, Password);
_request.Method = "POST";
_request.ContentType = "text/xml";

XmlTextWriter xw = new XmlTextWriter(_request.GetRequestStream(), Encoding.UTF8);
_xml.WriteTo(xw);
xw.Close();
WebResponse response = _request.GetResponse();
response.Close();

_request.Headers["SOAPAction"] = "[Value of SOAPAction, you can see this by navigating on the web method of the web service, through browser]";