Re: How to add row headers to DataGridView? - C# Discussion Boards

9-Jun-21 19:16

Hi,
I tried this code:

<pre lang="C#"> if (DGVName.Rows.Count >= 1)
            {
                foreach (DataGridViewRow row in DGVName.Rows)
                {
                    row.HeaderCell.Value = (row.Index + 1).ToString();
                }
            }

But it gives the following runtime error: WTF | :WTF:

System.ArgumentOutOfRangeException: 'Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index'

OriginalGriff9-Jun-21 20:13

9-Jun-21 20:13

None of the code you show uses an index: those are referenced via square brackets.
So that is the wrong code, and you need to use the debugger to find out exactly where in your code the exception is happening.

"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!

Alex Dunlop9-Jun-21 21:53

9-Jun-21 21:53

I tried this code which is the same as DataGridViewRow.HeaderCell Property (System.Windows.Forms) | Microsoft Docs[^]Microsoft Reference

int rownum = 1;
            foreach (DataGridViewRow row in DGVName.Rows)
            {
                if (row.IsNewRow) continue;
                {
                    row.HeaderCell.Value = "Row " + rownum;
                    rownum = rownum + 1;
                }
            }

The same error occurs. Please help me.

modified 10-Jun-21 4:03am.

OriginalGriff9-Jun-21 22:07

9-Jun-21 22:07

And I tried your code in my DGV and it works without problem:

private void FrmMain_Shown(object sender, EventArgs epp)
    {
    string strConnect = SMDBSupport.SMInstanceStorage.GetInstanceConnectionString("Testing");
    using (SqlConnection con = new SqlConnection(strConnect))
        {
        try
            {
            con.Open();
            using (SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM myTable", con))
                {
                DataTable dt = new DataTable();
                da.Fill(dt);
                myDataGridView.DataSource = dt;
                }
            }
        catch (Exception ex)
            {
            Debug.WriteLine(ex.ToString());
            }
        }
    }

private void MyButton_Click(object sender, EventArgs e)
    {
    foreach (DataGridViewRow row in myDataGridView.Rows)
        {
        row.HeaderCell.Value = (row.Index + 1).ToString();
        }
    }

You need to use the debugger to find out exactly which line of code is throwing the exception - because I don't think it's in the code you think it is!

Alex Dunlop9-Jun-21 22:10

9-Jun-21 22:10

This part

row.HeaderCell.Value = (row.Index + 1).ToString();

throws an exception.
I use generalized form in my code so I can use it as a dll file in every project.

OriginalGriff9-Jun-21 22:25

9-Jun-21 22:25

Strange.
It definitely doesn't for me, so it's got to be something to do with your data and / or the DGV itself.
I'd start by breaking it down: put each "dot point" in a separate variable and see which "bit" gives a problem:

int i = row.Index;
i++;
string s = i.Tostring();   // Can't see this failing! :laugh:
var hc = row.HeaderCell;
hc.Value = s;

I'm guessing it's something to do with the HeaderCell reference, but it's worth using the debugger to see how many times it goes round that loop before it fails as well ...

Alex Dunlop9-Jun-21 22:39

9-Jun-21 22:39

I checked it. The error occurs in the first loop. Of course, I'm using advanced DataGridView (because of its filter capability). Maybe, I should use native DGV instead.

OriginalGriff9-Jun-21 22:41

9-Jun-21 22:41

That would explain the difference between your code and mine ...

You can filter standard DGVs using a binding source - didn't we tell you that a week ago or so?

Alex Dunlop9-Jun-21 23:08

9-Jun-21 23:08

I'm going to change them with standard DGV.

Alex Dunlop10-Jun-21 0:02

10-Jun-21 0:02

There was an update to advanced DataGridView. I updated it and the issue solved. The filter function also has very rapid response like Excel.

OriginalGriff10-Jun-21 0:24

How can i read a xml file with Linq? c#

10-Jun-21 0:24

bart10008-Jun-21 9:07

bart1000

8-Jun-21 9:07

i'll try to read a cwe xml file. The problem is i have not good solution read it in a good way out

That is a xml file
CWE - Downloads[]

I'll find for example ID "1004" and will read all Items behind.
When i will read value from <background_detail> i find not a way to read this out

XElement xelement = XElement.Load(@".\cwec_v4.4.xml");

var value = from cwe in xelement.Elements().Elements()
                where (string)cwe.Attribute("ID") == "1004"
                select cwe;

foreach (XElement xEle in value)
{
    Console.WriteLine(xEle.Value);
}

var result = xelement.Elements().Elements()
             .Where(x => x.Attribute("ID").Value == "1004")
             .Elements().Where(x => x.Name == "Background_Details")
             .Elements().Where(x => x.Name == "Background_Detail")
             .Select(x => x.Value);

Have somebody experience and can help me

modified 8-Jun-21 16:20pm.

Re: How can i read a xml file with Linq? c#

Gerry Schmitz8-Jun-21 19:43

Gerry Schmitz

8-Jun-21 19:43

Create a class from the xml, and use that to access the xml.

.net - Generate C# class from XML - Stack Overflow

How to deserialize an object using XmlSerializer | Microsoft Docs

It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food

Re: How can i read a xml file with Linq? c#

Richard Deeming8-Jun-21 21:29

Richard Deeming

8-Jun-21 21:29

The XML document has a default namespace. You need to use that to select elements by name:

var document = XDocument.Load(@".\cwec_v4.4.xml");
var ns = document.Root.Name.Namespace;
int idToFind = 1004;

string detail = doc.Descendants(ns + "Weakness")
    .Where(el => (int)el.Attribute("ID") == idToFind)
    .Elements(ns + "Background_Details")
    .Elements(ns + "Background_Detail")
    .Select(el => el.Value)
    .FirstOrDefault();

If you want to read multiple values from a single weakness, you'll want to cache the Weakness element:

XElement weakness = document.Descendants(ns + "Weakness")
    .FirstOrDefault(el => (int)el.Attribute("ID") == idToFind);

if (weakness != null)
{
    string description = (string)weakness.Elements(ns + "Description");
    string detail = (string)weakness.Element(ns + "Background_Details").Element(ns + "Background_Detail");
    ...
}

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Re: How can i read a xml file with Linq? c#

bart10009-Jun-21 4:12

bart1000

9-Jun-21 4:12

Thanks a lot, it works wonderfully Smile | :)

Is there any SQL Server on the cloud for free?

Alex Dunlop8-Jun-21 8:15

Re: Is there any SQL Server on the cloud for free?

8-Jun-21 8:15

Hi,
I want to make a managerial app using Xamarin. Is there any free SQL Server on the cloud which I can use in Visual Studio during app development (and as a database source for my app)?
I just only need to have a small amount of storage. My clients will be less than 100.

OriginalGriff8-Jun-21 10:45

Re: Is there any SQL Server on the cloud for free?

8-Jun-21 10:45

There are some - normally associated with free websites - but ... would I use one? Not on your Nellie!

They are free for a reason: very limited storage, very poor or non-existent / expensive tech support, availability and speed can be very low. You really do get what you pay for!
"100 clients" doesn't necessarily mean "low storage volume", it depends on the number of clients and the space each will use. Add to that, that space is not the same as bandwidth / processing time: responses need to be timely as well as small!

And these apply to the website and the DB - so unless you really don't care for security, uptime, or space, I'd pay for it. There are good one available cheap, but use Google to find one i your country if possible - it makes support much easier and (hopefully) quicker.

Alex Dunlop9-Jun-21 4:16

Re: Is there any SQL Server on the cloud for free?

9-Jun-21 4:16

Azure SQL Service has a trial period for use. Is it possible to put an SQLite database file in the cloud and use the cloud IP address for reading/writing database on clients' devices?

OriginalGriff9-Jun-21 4:26

How to dynamically escape a character?

9-Jun-21 4:26

That is a spectacularly bad idea, and most installations of SQL Server will not allow it - to do that you have to expose the whole DB server to the internet along with all the DBs it handles, with all the security problems that opens up!

Joseline Riker7-Jun-21 13:25

Joseline Riker

7-Jun-21 13:25

I recently ran into a problem where I'm running a C# program on the Windows command line and the % character is breaking things. So it's like runthisprogram.exe -variables -outputname "I am a filename 100%.mkv".

The % in the above path when passed to the application errors. They say I have to escape the % to get it to work and they are correct, but if

I am a filename 100%.mkv

is in a variable, how do I dynamically search the contents and if there is a % replace it with %%

Thanks.

Re: How to dynamically escape a character?

Dave Kreskowiak7-Jun-21 15:06

Dave Kreskowiak

7-Jun-21 15:06

How about

myString = myString.Replace("%", "%%");

Asking questions is a skill
CodeProject Forum Guidelines
Google: C# How to debug code
Seriously, go read these articles.

Dave Kreskowiak

Re: How to dynamically escape a character?

OriginalGriff7-Jun-21 19:50