Saving Datagridview - C# Discussion Boards

That did it. Thanks!

If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
Ya can't fix stupid.

I've got this chuck of code. It looks for different phrases in a line of text being read from a file, then extracts the data at the end and stores it to various properties. The data will be either an IN RANGE or OUT OF RANGE message:

"Denature 1 RTD in range. Reading: 9.64241027832031"

or

"Detection 2 RTD out of range. Reading: 510"

I have 5 different properties that need to be set from the data. I would like to make this into a method call but how would you pass in the property?

The first word of the line determines which property to be set.

var index = line.IndexOf("Denature 1 RTD in range. Reading:");
if (index > -1)
{
    var data = line.Substring(index + 33);
    ((RTDTestModel)model).Denature1ActualValue = Convert.ToDouble(data);
}

index = line.IndexOf("Denature 1 RTD out of range. Reading:");
if (index > -1)
{
    var data = line.Substring(index + 37);
    ((RTDTestModel)model).Denature1ActualValue = Convert.ToDouble(data);
}
index = line.IndexOf("Extension 2 RTD in range. Reading:");
if (index > -1)
{
    var data = line.Substring(index + 34);
    ((RTDTestModel)model).Extension2ActualValue = Convert.ToDouble(data);
}
index = line.IndexOf("Extension 2 RTD out range. Reading:");
if (index > -1)
{
    var data = line.Substring(index + 38);
    ((RTDTestModel)model).Extension2ActualValue = Convert.ToDouble(data);
}

Thanks

If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
Ya can't fix stupid.

Something like this:

C#

private List<string> terms = new List<string>();

// In the constructor (or wherever)
terms.Add("Extension 2 RTD out range. Reading:");
terms.Add("Denature 1 RTD in range. Reading:");
terms.Add("Denature 1 RTD out of range. Reading:");
// and so on...

// In the method that we want to check
foreach (string term in terms)
{
  if (Parse(term))
  {
    break;
  }
}

private bool Parse(string text)
{
  int index = line.IndexOf(text);
  if (index > -1)
  {
    string data = line.Subsctring(index + text.Length);
    double value;
    if (double.TryParse(data, out value))
    {
      ((RTDTestModel)model).Extension2ActualValue = value;
    }
  }
}

This space for rent

Ya, but the problem is that there is a different property to set for each term

For example, for "Extension" there are two properties, Extension1, and Extension2. Same for Denature, Sample, Anneal, Detection, etc...

The structure of the file is the same for each setting. There are just different settings whose values need to be captured to various properties on the model.

A generic property reference would be nice. Something like:

void MyMethod(string term, T TheProperty)
{
.
.
.
}

where the property is passed as in

MyMethod("Anneal1", model.Anneal1);
MyMethod("Anneal2", model.Anneal2);

If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
Ya can't fix stupid.

C#

model.GetType().GetProperty( name ).SetValue( model, value );

Perfect.. Thanks

If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
Ya can't fix stupid.

You're welcome!

hello,

i really need help, i have created a dynamic datagridview, which the number of rows i write it in a xml file. When i save it for first time, in the xml file write the correct number of rows but when i save it again the "new" xml file write zero rows! i can understand why. i try to use datatable and dataset but nothing the problem is that datagridview hasnt rows.

Please some idies?

Thank you

public Form1(int cntC, int cntL)
{
InitializeComponent();
Create_dGV(cntC, cntL);
}

private void Create_dGV(int cnt, int cnt2)
{
for (int i = 0; i < cnt; i++)
{
CmbBx();

}

for (int i = dGV.RowCount; i < cnt2; i++)
{
dGV.Rows.Add();
}

for (int i = 0; i < dGV.Rows.Count; i++)
{

dGV.DefaultCellStyle.NullValue = " ";
dGV.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;

}
dGV.AllowUserToAddRows = false;

}

private void CmbBx()
{
DataGridViewComboBoxColumn CmbBx = new DataGridViewComboBoxColumn();
List<string> data = new List<string>();
data.Add("0");
data.Add("3");
data.Add("5");
data.Add("9");
CmbBx.DataSource = data;
CmbBx.Width = 120;
CmbBx.FlatStyle = FlatStyle.Flat;
dGV.Columns.Add(CmbBx);

}

private void SaveBttn_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();

{
for (int j = 0; j < dGV.ColumnCount; j++)
{
dt.Columns.Add((j).ToString(), typeof(String));
}

for (int i = 0; i < dGV.RowCount; i++)
{
DataRow d = new DataRow();
d = dt.NewRow();

for (int j = 0; j < dGV.ColumnCount; j++)
{

d[j] = dGV.Rows[i].Cells[j].Value;
}
dt.Rows.Add(d);
}
}

XmlWriterSettings settings = new XmlWriterSettings();
settings.Indent = true;
settings.OmitXmlDeclaration = true;
settings.NewLineOnAttributes = true;
using (XmlWriter writer = XmlWriter.Create(name, settings))
{
writer.WriteStartDocument();
writer.WriteStartElement("dGV");
{
writer.WriteElementString("ColumnsCount", dt.Columns.Count.ToString());
writer.WriteElementString("RowsCount", dt.Rows.Count.ToString());
for (int i = 0; i < dt.Columns.Count; i++)
{
//string lttr= "a"+ i.ToString();
//writer.WriteStartElement(lttr);
//{
// for (int j = 0; j < dt.Rows.Count; j++)
// {
// lttr= "a"+ i.ToString()+ j.ToString();
// writer.WriteElementString(lttr, dt.Rows[j][i].ToString());

// }
//}
//writer.WriteEndElement();

}
}

writer.WriteEndElement();
writer.WriteEndDocument();
}
}
// other form
private void OpenBttn_Click(object sender, EventArgs e)
{
XmlDocument xDoc = new XmlDocument();

xDoc.Load(name);
int C, R;
string hlps, hlps2;

hlps = xDoc.SelectSingleNode("dGV / ColumnsCount").InnerText;
C = Int32.Parse(hlps);
hlps = xDoc.SelectSingleNode("dGV / RowssCount").InnerText;
R = Int32.Parse(hlps);
Form1 f = new Form1(C, R);

}
}
}

modified 18-Nov-16 4:54am.

Yeah, there is no way anyone is going to be able to answer this because we can't see your code. Modify your question and post the relevant code that saves your data to the XML file.

Member 12856910 wrote:
i try to use datatable and dataset but nothing the problem is that datagridview hasnt rows.

This last sentence didn't make any sense at all.

A guide to posting questions on CodeProject

Click this: Asking questions is a skill.
Seriously, do it.

Dave Kreskowiak

Hi,
I'm mostly asp.net/services soa/ server code .. I'm have done Win Form apps but installations is not something I have much XP with ..

Question : I have a config file and an encrypted file that I need to write during installation. The directory I was going to use is commonappdata(ProgramData) directory. I was just wondering if this is typical or has everyone found something better for reasons unknown to me .. Win7+

Thanks
Jon

I'd use the special folders: Where should I store my data?[^] - combining the standard "writable" folders with a GUID based app id for your installed app makes it easy for you, but harder for the user to find. Which is probably a good idea if you are writing an encrypted file as some kind of licence.

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

hello sir I m Ramesh .net fresher I want to develop a desktop software in accounting software using c# . how to do this task please help me sir

You start by researching the requirements of the accounting software. Once you know the requirements you can start the actual design: inputs, outputs, data storage etc., etc. As a beginner I would suggest you would probably be better working on some smaller projects first.

Downvote countered.

This space for rent

As Richard said, you would start off by researching the requirements for accounting software. Long before you type your first line of code, you should understand what it is that you are trying to develop. Do you have an accountancy background? If so, that will help you. If not, you are going to have to talk to accountants to get an understanding of what they require. To give you an example of why this is necessary - consider the case of Value Added Tax (VAT). Will your system be able to cope with VAT added at source? What about VAT that gets applied at destination. Can you cope with different VAT rates? What about the ability to have VAT discounts (where VAT is applied at one rate for part of the year, then another rate for the rest)?

This space for rent

What be this VAT thing you talk about.

And that is the point, is it going to be an international package or just for his home country.

Never underestimate the power of human stupidity
RAH

And gawd help his "customers" ... Sigh | :sigh:

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

Or, for domestic customers who also trade internationally?

This space for rent

Member 11580781 wrote:
how to do this task

Building accounting software is not a task but a project full of thousands of tasks. Define your tasks and then build it.

There are only 10 types of people in the world, those who understand binary and those who don't.

What everyone is trying to say is that it sounds like you're in way over your head.

Writing an accounting software is not an easy project and would take several developers months to get a base version and years to get a mature market competitive version. It would require in dept knowledge of different domains like database, accounting, juridical laws, development, IT hardware, ... etc...

try finding some information on existing software and check out what they can do. That will give you an idea why not doing this...

V.

(MQOTD rules and previous solutions)

C#

public class Account {
   public string AccountNumber { get; set; }
   public string AccountType { get; set; }
   public string AccountName { get; set; }
   public decimal TotalDebits { get; set; }
   public decimal TotalCredits { get; set; }
}

Hello I need sample code to show dual screen display using usercontrol.xaml in wpf c#
I need to display a part of screen from primary monitor to another screen

And?
What have you tried?
Where are you stuck?
What help do you need?

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

System.Windows.Forms.Screen s1 = System.Windows.Forms.Screen.AllScreens[0];
ticket.Visibility = Visibility.Visible;
System.Drawing.Rectangle r1 = s1.WorkingArea;
ticket.Height = 50;
ticket.Width = 150;

its not showing in another screen part of usercontrol.xaml name is ticket