Moti Mashiah
asked on
Checkbox with C#
Hi all ,
I have some table that look like ( see screenshot) also I attached the application.
I would like to display in my app just the rows with the false result in column "Closed".
Here is my combobox code:
data.JPG
I have some table that look like ( see screenshot) also I attached the application.
I would like to display in my app just the rows with the false result in column "Closed".
Here is my combobox code:
//combobox lastname display in the textboxs
private void comboLname_SelectedIndexChanged(object sender, EventArgs e)
{
string conn = "Data Source=srv-db-02;Initial Catalog=RMSCRM;Persist Security Info=True;User ID=test;Password=masterB4";
string Query = "select * from RMSCRM.dbo.sales where LastName= '" + comboLname.Text + "' ;";
SqlConnection Myconn = new SqlConnection(conn);
SqlCommand cmdDataBase = new SqlCommand(Query, Myconn);
SqlDataReader Reader;
try
{
Myconn.Open();
Reader = cmdDataBase.ExecuteReader();
if (Reader.Read())
{
string ID = Reader.GetInt32(Reader.GetOrdinal("ID")).ToString();
string AccountNuber = Reader.GetString(Reader.GetOrdinal("AccountNumber")).ToString();
string Time = Reader.GetDateTime(Reader.GetOrdinal("Time")).ToString();
string Deposit = Reader.GetDecimal(Reader.GetOrdinal("Deposit")).ToString();
string slastname = Reader.GetString(Reader.GetOrdinal("lastname"));
string sname = Reader.GetString(Reader.GetOrdinal("name"));
string semail = Reader.GetString(Reader.GetOrdinal("emailaddress"));
bool scheck = Reader.GetBoolean(Reader.GetOrdinal("closed"));
int statusIndex = Reader.GetOrdinal("status");
string sstatus = Reader.IsDBNull(statusIndex) ? null : Reader.GetString(statusIndex);
int noteIndex = Reader.GetOrdinal("Note");
string snote = Reader.IsDBNull(noteIndex) ? null : Reader.GetString(noteIndex);
//int historyIndex = Reader.GetOrdinal("history");
//string slbox = Reader.IsDBNull(historyIndex) ? null : Reader.GetString(historyIndex);
txtid.Text = ID;
txtacnum.Text = AccountNuber;
txttime.Text = Time;
txtdeposit.Text = Deposit;
txtlname.Text = slastname;
txtStatus.Text = sstatus;
txtNote.Text = snote;
txtName.Text = sname;
txtEmail.Text = semail;
checkBox1.Checked = scheck;
//close reader ready for our next query
Reader.Close();
cmdDataBase.CommandText = "SELECT * FROM History WHERE SalesID=@SalesID";
//add parameter to salesID
cmdDataBase.Parameters.Clear();
cmdDataBase.Parameters.AddWithValue("@SalesID", ID);
Reader = cmdDataBase.ExecuteReader();
//cleare and repopulate listbox
listBox1.Items.Clear();
while (Reader.Read())
{
listBox1.Items.Add(Reader.GetString(Reader.GetOrdinal("History")));
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
Myconn.Close();
}
}
Capture.JPGdata.JPG
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great as always
ASKER
I hope that one day I will be able to figure all these things by myself LOL...