Search

Author filtered by: ontheline89 [x]

Datagridview in WindowsForm by ontheline89

Question 12 Mar 2013 license: CPOL

Hello, I want to start Blinking the Label if the Last ROW in the Datagridview has entry Critical. I really dont know, how to check whether that last row contains word Critical or not. Thanks.

C#DataGridView

How to Highlight Datagridview CELL not a ROW. by ontheline89

Question 12 Mar 2013 license: CPOL

Hello, Below code highlight the entire row, but i need to highlight only specific CELL. private void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e) { int colIndex = e.ColumnIndex; int rowIndex =...

General Programming » Uncategorised Quick Answers » General

C#DataGridView

Object reference not set to an instance of an object. by ontheline89

Question 11 Mar 2013 license: CPOL

Hello,I am trying to change the cell color. The code run successfully and the Back color changes but after sometime i get error which is Object reference not set to an instance of an object. at line if (theRow.Cells[colIndex].Value.ToString() == "Normal")private...

General Programming » Uncategorised Quick Answers » General

C#DataGridView

Changing color of a Datagridview cell color based on its value by ontheline89

Question 8 Mar 2013 license: CPOL

Hello, I am trying to Change the Back color of a Cell in a Datagridview if the Column value >39. I am using below code , private void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e) { // If the column is the Artist column, check...

General Programming » Uncategorised Quick Answers » General

C#DataGridViewWindowsForms

Refreshing a Chart in C# by ontheline89

Question 7 Mar 2013 license: CPOL

Hello, I am drawing a Chart on Windows Form using C# and chart is using Database Table. Can anyone please tell me, what is the easiest way to refresh the chart as more data is inserted into a database ?

General Programming » Uncategorised Quick Answers » General

C#Chart

Strings Assignment in C# by ontheline89

Question 27 Feb 2013 license: CPOL

Hello, Can anyone please tell me what is the mistake in it. string Stat; if (fsensorvalue1 >= 05 && fsensorvalue1 = 30...

General Programming » Uncategorised Quick Answers » General

C#strings

Floating datatype of SQL Server by ontheline89

Question 26 Feb 2013 license: CPOL

Hello, I am storing values in SQL Database table as floating point. But i dont need a long floating number, just want to display it in two decimal places. Thanks

General Programming » Uncategorised Quick Answers » General

C#SQL

SQL Query and Displaying by ontheline89

Question 26 Feb 2013 license: CPOL

Hello, I am inserting data in a SQL Database Table with columns SensorID,SensorValue, DateTimeWhere SensorID is constant. I need to display database table in a datagridview in a Sorted form with respect to DateTime. Can anyone please tell me the SQL Query for that. Thankyou !

General Programming » Uncategorised Quick Answers » General

SQLDataGridView

Console Application and windows application by ontheline89

Question 13 Feb 2013 license: CPOL

Hello, I want to use this statement richTextBox1.Invoke(new EventHandler(delegatein Console Application. How can i avoid richTextBox1. Thanks

General Programming » Uncategorised Quick Answers » General

Datagridview Automatically Update by ontheline89

Question 12 Feb 2013 license: CPOL

Hello, I have made a Window Service which is saving data from COM Port to a Database. I have made Windows Form with one Datagridview. My question is, how can i automatically update datagridview when there is any new data goes into a database. Thanks

General Programming » Uncategorised Quick Answers » General

C#SQLDataGridView

SELECT SQL Statement for a datagridview by ontheline89

Question 11 Feb 2013 license: CPOL

Hello, I am inserting Records in a Database. I need my records to be shown in a Datagridview, when a button is pressed. Datagridview should show records only with SensorValue is

General Programming » Uncategorised Quick Answers » General

C#SQL-Serverselection

Comparisons in C# and inserting to database by ontheline89

Question 30 Jan 2013 license: CPOL

Hello, I am trying to insert value (X) to a database, but now i want to compare that, if X last value is not equal to X present value then INSERT to a database table. I really dont know what will be its syntax. Thanks

General Programming » Uncategorised Quick Answers » General

C#SQL-Server

Adding values to a database table with IF condition by ontheline89

Question 25 Jan 2013 license: CPOL

I am adding hexvalue in Table_1 . But if the hexvalue is not AA (or any specified value) then, i need to insert that hexvalue to Table_2. How can i do it ? Thanks try{ SqlConnection sqlconn = new SqlConnection("Data Source=AAN-PC;Initial Catalog=mon26;Integrated Security=True"); ...

General Programming » Uncategorised Quick Answers » General

C#SQL-Server

How to display database table ? by ontheline89

Question 17 Jan 2013 license: CPOL

I have created table, but How can i display database table in Windows Form ?SqlConnection sqlconn = new SqlConnection("Data Source=AAN-PC;Initial Catalog=friday;Integrated Security=True"); SqlDataAdapter sa = new SqlDataAdapter(); string...

General Programming » Uncategorised Quick Answers » General

C#SQL

Error in SQL Line in C# by ontheline89