I want to add many items after scan them one by one from database into datatable
publicvoid CheckItem( string itemcode)
string constring = @"Data Source=.;Initial Catalog=pos;User id = sa;password=123";
SqlCommand objCmd = new SqlCommand();
using (SqlConnection objCnn = new SqlConnection(constring))
using (objCmd = objCnn.CreateCommand())
objCmd.CommandType = CommandType.Text;
objCmd.CommandText = "SELECT * FROM Items where Item_Code=@Item_Code";
objCmd.Parameters.Add(new SqlParameter("@Item_Code", itemcode));
SqlDataReader myreader = objCmd.ExecuteReader();
DataTable dt = new DataTable();
if (dt.Rows.Count <= 0)
// here i want to add new item into datatable , after that bind the new item with items that i added before
dt = objDT.NewRow();
dataGridView1.DataSource = dt;
Pen yellowPen = new Pen(Color.Yellow, 2);
Pen bluePen = new Pen(Color.Blue, 2);
Pen redPen = new Pen(Color.Red, 2);
int hOffset = heatmapWidth / 2;
int vOffset = heatmapHeight / 2;
using (Font title_font = new Font("Times New Roman", 20))
using (StringFormat string_format = new StringFormat())
string_format.Alignment = StringAlignment.Center;
string_format.LineAlignment = StringAlignment.Center;
Point title_center = new Point(this.heatmapWidth / 2, 20);
Point titleleft = new Point(this.heatmapHeight / 4, heatmapWidth/10);
Font leftfornt = new Font("Times New Roman", 10);
Font totalfont = new Font("Times New Roman", 10);
Font rightfont = new Font("Times New Roman", 10);
I need to get 'Form1' to retain its black back-ground color while the 3 labels with a white BackColor displaying famous quotes are not visible (Form1 totally black) until a mouse pointer hovers over a label and reveals the famous quote(s) during the execution of runtime.
I followed the instructions that tells me to put three labels to the form each displaying a famous quote. When the program starts, the BackColor of the form and each of the 3 labels should be black. Now, as the user passes or hovers the mouse pointer over a label it should change the label's BackColor white thus revealing the quote. The results I get is not the same. That is, when the program starts the BackColor of the form is black, but the 3 labels do not have a black back ground at all. Instead, all the labels on the form are visible (showing quotes) with a white BackColor. Now, as I hover my mouse pointer over each label the back ground color of the form turns white and as I release the pointer from the label(s) the back ground color of the form returns to black.// The control settings in the properties window are: On Form1; BackColor = ControlText(black) & ForeColor = ControlText(black)// On Label1,Label2,Label3; BackColor = White & ForeColor = ControlText(black). In the Events window settings are:On Form1; Load = Form1_Load & MouseHover = Form1_Load// On Label1,Label2,Label3; MouseHover = Label1,2,3_MouseHover
Questions here need to have more detail than what you've written. At the least, share the ideas you have for this project: what is required to sense the mouse moving over a Control which is not visible ?
Hint: examine the Rectangle.Contains method.
«While I complain of being able to see only a shadow of the past, I may be insensitive to reality as it is now, since I'm not at a stage of development where I'm capable of seeing it. A few hundred years later another traveler despairing as myself, may mourn the disappearance of what I may have seen, but failed to see.» Claude Levi-Strauss (Tristes Tropiques, 1955)</
“What was that?" Belgarath asked, coming back around the corner.
"Brill," Silk replied blandly, pulling his Murgo robe back on.
"Again?" Belgarath demanded with exasperation. "What was he doing this time?"
"Trying to fly, last time I saw him." Silk smirked.
The old man looked puzzled.
"He wasn't doing it very well," Silk added.
Belgarath shrugged. "Maybe it'll come to him in time."
"He doesn't really have all that much time." Silk glanced out over the edge.
From far below - terribly far below - there came a faint, muffled crash; then, after several seconds, another. "Does bouncing count?" Silk asked.
Belgarath made a wry face. "Not really."
"Then I'd say he didn't learn in time." Silk said blithely.”
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
Please explain! I noticed as I set the BackColor of the Labels white, and Form1 having a black BackColor; in runtime when I hover over a label, the whole back ground color of Form1 turns white. Now this is the problem, because the form is always suppose to stay black when the labels should be darkened (black) until the user hovers a mouse pointer over it to lighten it up - revealing the quotes. So, I changed the BackColor setting of the labels to black; now the whole form is Black, but as I Run the program and hover my mouse over a label nothing happens,i.e, the labels stays black as well as the form. How can I tweak this program to get the results required in runtime?