Comments by ontheline89 (Top 68 by date)

ok thank you. I will check now.

Thank you for your quick reply, I have 4 columns in my Grid.

Still i am getting same error.

thanks .... it was saying, Unused Variable !

Thank you so much for your answers.

Thank you for your reply.

Actually i am trying to convert Windows app to console app to make a Window service

yes i need datagrid to show me specific results for SensorValue < 20

Datagridview is showing the records in a Database, but i need other datagridview to show the records when the button is pressed for Select Statement.

Thank you so much for your answer.

Thanks for your reply.
I need to use these line in my C# Code ?

Yes i am inserting new rows when i get a value of X variable from COM port.
I need to save X to a new row only when its value change from the previous row value.

i am trying to save values coming from COM Port to a database. when i store these value (X) then many time its value do not change and give same values but after some time its values are changed. I just want to insert the different values in a database.

oh ok thank you !

Jibesh is it the right way to update the data grid view ?

Thank you so much Jibesh.

Thanks for your reply.
You are so helpful thanks again.

Sisir Patro, is there any other way to refresh Datagrid automatically ?

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace WindowsFormsApplication2
{
public partial class Form2 : Form
{
public Form2()
{
InitializeComponent();
}

private void Form2_Load(object sender, EventArgs e)
{


}


private Form1 myForm1;
public Form2(Form1 form1)
{
myForm1 = form1;

myForm1.Refreshdatagridview1();

}


}
}

My form 2 is not opening.
The idea which i get from you that, making form 2 and placing a button there, when a user press button it will update datagrid in form 1.

ok thank you so much.
I am trying it now.

Data grid is displaying data from database but how can i automatically update a datagrid as new data goes to database.

Thank you so much.

thank you , i will try to make changes in your web form code.

i need to fetch data and display it in winforms. But i am getting how to display it. Display need to be updated automatically.

i am so sorry i have taken so much time of yours.
Yes i have put these lines in my code in Visual Studio, actually these lines were not copied here.
Thank you so v much for your time and guidance.

what i need to change in it now ?

seriously i didnt get your point.

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.IO.Ports;
using System.Media;
using System.Data.SqlClient;




namespace WindowsFormsApplication2
{
public partial class Form1 : Form

{
public Form1()
{

InitializeComponent();
serialPort1.Open();
}
public void playSimpleSound()
{
SoundPlayer simpleSound = new SoundPlayer(@"c:\smokealarm.wav");
simpleSound.Play();
}








private void Form1_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'latestsensordataDataSet1.Table_1' table. You can move, or remove it, as needed.
this.table_1TableAdapter1.Fill(this.latestsensordataDataSet1.Table_1);
// TODO: This line of code loads data into the 'latestsensordataDataSet.Table_1' table. You can move, or remove it, as needed.
this.table_1TableAdapter.Fill(this.latestsensordataDataSet.Table_1);
//configuring the serial port
serialPort1.PortName = "COM14";
serialPort1.BaudRate = 115200;
serialPort1.DataBits = 8;
serialPort1.Parity = Parity.None;
serialPort1.StopBits = StopBits.One;
serialPort1.DataReceived += new SerialDataReceivedEventHandler(serialPort1_DataReceived);


}

public enum MessageType { Incoming, Outgoing, Normal, Warning, Error };







private byte[] HexToByte(string msg)
{
//remove any spaces from the string
msg = msg.Replace(" ", "");
//create a byte array the length of the
//divided by 2 (Hex is 2 characters in length)
byte[] comBuffer = new byte[msg.Length / 2];
//loop through the length of the provided string
for (int i = 0; i < msg.Length; i += 2)
//convert each set of 2 characters to a byte
//and add to the array
comBuffer[i / 2] = (byte)Convert.ToByte(msg.Substring(i, 2), 16);
//return the array
byte[] newbuffer = comBuffer;
return comBuffer;
}




private string ByteToHex(byte[] comByte)
{
//create a new StringBuilder object
StringBuilder builder = new StringBuilder(comByte.Length * 3);
//loop through each byte in the array
foreach (byte data in comByte)
//convert the byte to a string and add to the stringbuilder
builder.Append(Convert.ToString(data, 16).PadLeft(2, '0').PadRight(3, ' '));
//return the converted value
return builder.ToString().ToUpper();
}


#region DisplayData

private void DisplayData(MessageType type, string msg)
{
richTextBox1.Invoke(new EventHandler(delegate
{



string substring = string.Empty;
if (msg.Length > 57)
substring = msg.Substring(54, 2);



int x;

bool f = Int32.TryParse(substring, System.Globalization.NumberStyles.HexNumber, null, out x);
if (f)
{

string hexValue = x.ToString();
richTextBox1.AppendText(hexValue);


try
{

SqlConnection sqlconn = new SqlConnection("Data Source=ARSALAN-PC;Initial Catalog=latestsensordata;Integrated Security=True");
SqlDataAdapter sa = new SqlDataAdapter();


string query = "insert into Table_1(SensorValue,Time) values(@SV, @TM)";
sa.InsertCommand = new SqlCommand(query, sqlconn);

you are absolutely right, i dont have expertise in databases and c# thats why i am confused why i am not getting time with values.

#region DisplayData

private void DisplayData(MessageType type, string msg)
{
richTextBox1.Invoke(new EventHandler(delegate
{



string substring = string.Empty;
if (msg.Length > 57)
substring = msg.Substring(54, 2);



int x;

bool f = Int32.TryParse(substring, System.Globalization.NumberStyles.HexNumber, null, out x);
if (f)
{

string hexValue = x.ToString();
richTextBox1.AppendText(hexValue);


try
{

SqlConnection sqlconn = new SqlConnection("Data Source=ARSALAN-PC;Initial Catalog=latestsensordata;Integrated Security=True");
SqlDataAdapter sa = new SqlDataAdapter();


string query = "insert into Table_1(SensorValue) values(" +hexValue+")";





sa.InsertCommand = new SqlCommand(query, sqlconn);


sqlconn.Open();
try
{
sa.InsertCommand.ExecuteNonQuery();
}
catch (FormatException ex) { MessageBox.Show(ex.Message); }
MessageBox.Show("Record Inserted");
sqlconn.Close();
}
catch (SqlException ea) { MessageBox.Show(ea.Message); }
























}

If i use
string query = "insert into Table_1(SensorValue) values(" +hexValue+")";

Then sensor value is stored in database.

I have two columns in SQL Server
SensorValue ( int )
Time (nchar)

but it still giving the same error.
Must declare the Scalar Variable at @SV.

I am still getting error
Must declare the Scalar Variable at @SV

I am getting error,
Invalid column name CurrntTime.

I am getting error in above your statement.
Invalid Expresstion ","

I am getting some values which are in not in correct format. But how to avoid them ?

yes the format of values changer after some time, you can say some garbage values. Is there any way that it just convert only strings which are in format and discard other without getting any errors.

i am getting correct values, but after 4 to 5 values, i get error that
Input Sting was not in a correct format.

I cant avoid values like 1A OR 1B.
These are HEXADECIMAL values and i need to convert them to integers.
I am still getting errors.

Thank you so much !

Thank you so much Sisri Patro.
It worked.

Thank you for your reply but i am still getting error.

Must Declare the Scalar Variable "@SensorValue"

Thank you for your reply,

Hello Jibesh,
If i need to store these substring to a SQL Server Database with TimeStamp then what should i do? Thanks

I have just seen your reply. Thank you so much !

Jibesh can you please tell one thing more, i am trying to play a .wav file when sub string value is 1B , but i am getting Int to string conversion errors .....private void DisplayData(MessageType type, string msg)
{
richTextBox1.Invoke(new EventHandler(delegate
{



string substring = string.Empty;
if (msg.Length > 57)
substring = msg.Substring(54, 3);
if (substring = 1B)
playSimpleSound();




richTextBox1.AppendText(substring) ;



richTextBox1.SelectedText = string.Empty;

richTextBox1.ScrollToCaret();


}));
}
#endregion


public void playSimpleSound()
{
SoundPlayer simpleSound = new SoundPlayer(@"c:\smokealarm.wav");
simpleSound.Play();
}

i tried it ,
int decValue = Convert.ToInt32(hexValue, 16);
not working

thanks .... Jibesh you helped me a lot ,
one more thing i need to ask from you.
I am getting values which are in Hexadecimal , i need to convert Sub Sting in Decimal. what should i do ?

Thanks you Jibesh its working now correctly. I did this as you said.
if (msg.Length > 57)
substring = msg.Substring(54, 3);

Jibesh i did this. But it still gives error after displaying some values correctly.
Index and length must refer to a location within the string. ERROR

The length of a string is varying.
It gives error " Index and length must refer to a location within the string. "

i have checked it, string length is changing.
Most of time it gives about 57 value long string, but after some time, its length reduces.

7E 45 00 FF FF 00 01 0A 00 93 00 00 01 00 00 01 00 13 18 75 51 9D 7E
This is a string.
But number of values in strings are changing with time.
How can i set indexes of a string when its indexes are changing with time.

Jibesh just one thing more,
Why you have used values 54 and 4 in your solution ?

thanks
good day to you too.

ok thank you so much for your solution.
I am trying your solution now.
Thanks once again.

I just need to display values at Index 19 and 20. Whatever the values are at index 19 and 20.

I dont need that combination. i just need to display elements at index 19 and 20 as values are changing in every minute at serial port.

yes i want to display values at given indexes 19 and 20.
I dont know, where i need to change my code for it.

Right now i am getting this large output
7E 45 00 FF FF 00 01 0A 00 93 00 00 01 00 00 01 00 02 17 B5 70 20 7E

I just need to extract 17 and B5 from above output.

I dont know, what need to be change in above code to display that specific elements.