C#

Luc Pattyn wrote:

Yes, I forgot: Invoke without parameters provides some defaults, and since you don't really use the parameters inside DisplayText, there is no problem. However, I wouldn't do it like that.

Luc Pattyn wrote:

OK, if you are not really interested in the string, why not use a class member "double Rx;" instead of "string RxString;". Have DataReceived read the string, convert it to double, and store the value in Rx; then have DisplayText and any other interested method just read the Rx variable.

mprice214 wrote:

any other suggestions?

mprice214 wrote:

this.Invoke(new EventHandler(DisplayText));

this.Invoke(new MethodInvoker(delegate{DisplayText(null, null);}));

ActiveWorkbook.SaveAs Filename:= _
       "C:\Users\dan.mos\Desktop\New Microsoft Office Excel Worksheet (2).xls", _
       FileFormat:=xlExcel8, Password:="", WriteResPassword:="", _
       ReadOnlyRecommended:=False, CreateBackup:=False

<br />
if (chkSelection.Checked == true)    {       <br />
 TextBox contact = (TextBox)item.FindControl("phone_num");<br />
 errors0.Text += contact.ToString();        <br />
errors0.Visible = true;        //string contact = contacts.SelectedItem.Cells[4].Text;   <br />
  }<br />

...Select("Login like '"+s1+"' and MotPasse like '"+s2+"'");

...Select("Login = '"+s1+"' and MotPasse = '"+s2+"'");

foundRows = dat.Tables["Connexion"].Select("Login like  '%" + s1 + "%' and MotPasse like '%" + s2 +"%'");

username: a
password: a

string s1 = textBox1.Text.ToString();
string s2 = textBox2.Text.ToString();

string s1 = textBox1.Text;
string s2 = textBox2.Text;

SqlCeConnection cnx = new SqlCeConnection("..."); // Replace ... by the right connexion string
string req = "SELECT * FROM Connexion WHERE Login = @login AND MotPasse = @pass";
SqlCeCommand cmd = new SqlCeCommand(req, cnx);
SqlCeParameter login = new SqlCeParameter("login", s1);
cmd.Parameters.Add(login);
SqlCeParameter pass = new SqlCeParameter("pass", s2);
cmd.Parameters.Add(pass);
...

O.Phil wrote:

textBox1.Text.ToString()

private void button1_Click(object sender, EventArgs e)
{
/*string req = "select Login, MotPasse from Connexion";
DataTable tab = new DataTable();
SqlCeCommand com = new SqlCeCommand(req, sqlceconn);
SqlCeDataAdapter ada = new SqlCeDataAdapter(com);
ada.Fill(tab);*/
string s1 = textBox1.Text;
string s2 = textBox2.Text;
SqlCeConnection cnx = new SqlCeConnection();
string wCS = String.Format("DATA SOURCE = '{0}';", Program.gFichierBase);
cnx.ConnectionString = wCS;
string req = "SELECT * FROM Connexion WHERE Login = @login AND MotPasse = @pass";
SqlCeCommand cmd = new SqlCeCommand(req, cnx);
SqlCeParameter login = new SqlCeParameter("login", s1);
cmd.Parameters.Add(login);
SqlCeParameter pass = new SqlCeParameter("pass", s2);
cmd.Parameters.Add(pass);
BaseGmaoLocaleDataSet2 dat = new BaseGmaoLocaleDataSet2();
DataRow[] foundRows;
foundRows = dat.Tables["Connexion"].Select("Login like  '%" + s1 + "%' and MotPasse like '%" + s2 + "%'");
if (foundRows != null)
{
MessageBox.Show("Authentification réussie");
MenuP m = new MenuP();
m.Show();
}
else
{
MessageBox.Show("Login ou mot de passe incorrect veuillez réessayer");
}
}

{...}
cmd.Parameters.Add(pass);
int count = cmd.ExecuteScalar();
if (count == 1)
{
   MessageBox.Show("Authentification réussie");
   MenuP m = new MenuP();
   m.Show();
}
else
   MessageBox.Show("Login ou mot de passe incorrect veuillez réessayer");