C#

Create Procedure prclogin_check
(
@User_name varchar(20),
@U_Password varchar(23),
@Results int Output
)
IF EXISTS (Select * from User_Table
where User_name =@User_name and U_Password = @U_Password)
Set @Results =1

using System.Data.SqlClient;

String strcon = "User id = sa;Password= topman;Server=myServer;Database=MyDB";
            SqlConnection con = new SqlConnection(strcon);
            SqlCommand cmdselect = new SqlCommand();
            cmdselect.CommandTimeout = 0;
            cmdselect.CommandType = CommandType.StoredProcedure;
            cmdselect.Connection = con;
            cmdselect.CommandText = "prclogin_check";
            cmdselect.Parameters.Add("@Results",SqlDbType.Int,4);
            cmdselect.Parameters["@Results"].Direction = ParameterDirection.Output;
            int Res;

            try
            {
                con.Open();

                cmdselect.ExecuteNonQuery();
                Res = (int)cmdselect.Parameters["@Results"].Value;
                con.Close();

            }
            catch (SqlException e)
            {
                MessageBox.Show(e.Message);
            }using System.Data.SqlClient;

String strcon = "User id = sa;Password= topman;Server=myServer;Database=MyDB";
            SqlConnection con = new SqlConnection(strcon);
            SqlCommand cmdselect = new SqlCommand();
            cmdselect.CommandTimeout = 0;
            cmdselect.CommandType = CommandType.StoredProcedure;
            cmdselect.Connection = con;
            cmdselect.CommandText = "prclogin_check";
            cmdselect.Parameters.Add("@Results",SqlDbType.Int,4);
            cmdselect.Parameters["@Results"].Direction = ParameterDirection.Output;
            int Res;

            try
            {
                con.Open();

                cmdselect.ExecuteNonQuery();
                Res = (int)cmdselect.Parameters["@Results"].Value;
                con.Close();

            }
            catch (SqlException e)
            {
                MessageBox.Show(e.Message);
            }

private void hsc_Scroll(object sender, ScrollEventArgs e) {
    // Occurs when the scroll box has been moved by either a mouse or keyboard action.
}

private void hsc_ValueChanged(object sender, EventArgs e)
{
    // Occurs when the System.Windows.Forms.ScrollBar.Value property is changed,
    // either by a System.Windows.Forms.ScrollBar.Scroll event or programmatically.
}

frommi wrote:

Why the jitdebugger ask me where is the .cs file?

Text = Convert.ToInt32(obj);

Kwagga wrote:

just copying the .exe from the bin directory to another computer? This will not work.

frommi wrote:

Why the jitdebugger ask me where is the .cs file?

frommi wrote:

If i open module page (ctrl+alt+u) i see my file .exe with symbols loaded, but i can see the c# code.

strife19 wrote:

and also, is it possible to insert images using the paint event??

Image Hair;
Image Face;
Image Body;
//etc...

Hair = ImageListHair.Images[2];
//etc...
PanelMain.Invalidate();//cause panel to paint itself

void PanelMainPaint(object sender, PaintEventArgs e)
{
   //draw items from back to front
   //draw body
   e.Graphics.DrawImage(Body, xPos, yPos, width, height);//
   //draw other items...
}