Re: Parse from string - C# Discussion Boards

OriginalGriff15-Dec-21 20:54

15-Dec-21 20:54

No, it's not. If it's not part of the git repository, it isn't included - just "accessing it from your code" doesn't make it part of the repository any more than a git-based project to write letters would automatically push each letter to the Git server.
Git is about source code, not data - it is not a backup system!

A database is data which in your case resides on your laptop: that isn't part of your Git project, so it isn't added to the repository. You will have to copy it manually to your new device.

"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!

Re: re-create a local database

#realJSOP16-Dec-21 2:39

#realJSOP

16-Dec-21 2:39

If the database wasn't part of your project checkin, then you're going to have to recreate it manually.

This is precisely why I don't use MDF files. Instead I use SQL Server instance on a different box, rather than my dev box. That way, when I move to a different system, the database is always there (assuming the server box itself hasn't gone tits up).

".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

Re: re-create a local database

jschell23-Dec-21 5:50

jschell

23-Dec-21 5:50

Err...and of course presumably back ups of the db are being taken.

How do i gate the previous values in Crystal repor

remiki14-Dec-21 7:37

remiki

14-Dec-21 7:37

Hello, i have trie this code and i get only the values of the date selectionned, but i need to show if the currect date does not exist, to show the previews values in crystal repor, how can i use previous () fonction?

for example

if ({myadate.datelqd}={?date}) then{mydate.restrlqd}={mydate.restrlqd}
else if mydate does not exists then show previews value

here is what i have tried

if ({?date}={mydate.datelqd}) then {mydate.restrlqd}={mydate.restrlqd}

but I want that when the requested date is not in the database, that I display the last recording for example
on 10/12/2021 i have qty = 55
on 13/12/2021 i qty = 85
on 14/12/2021 I have qty = 55

when I enter 12/12/2021 for example, let it display the data for 10/12/2021 where the qty = 55

modified 14-Dec-21 14:52pm.

Re: How do i gate the previous values in Crystal repor

remiki16-Dec-21 0:56

remiki

16-Dec-21 0:56

urgent, please

Parse from string

Member 1546737514-Dec-21 4:00

Member 15467375

14-Dec-21 4:00

Let's write our own Point class

using System;
namespace PointNamespace
{
    public class Point
    {
        public int X{get;set;}
        public int Y{get;set;}
        public Point(int x = 0,int y=0)
        {
           X = x;
           Y = y;
        }
        public bool TryParse(string s,out Point p)
        {
            // Here is code for your function
        }
        public override string ToString()
        {
           return string.Format("({0},{1})",X,Y);
        }
    }
}

How can I write TryParse method
I would like to use methods like
string.Trim() ,
int.TryParse(string s, out int d),
string.IndexOf(); // Here is few overloads and which should I choose
string.Substring(int startIndex,int length);
Format of parsed string is shown in ToString method

Suppose we want also version for double coordinates
how method TryParse should look like then
In my native language comma and dot are switched in meaning when displaying
numbers and C# includes that

Re: Parse from string

Pete O'Hanlon14-Dec-21 5:21

Pete O'Hanlon

14-Dec-21 5:21

Think about what you are trying to achieve here. Your point class is constrained to using integers so you can put in a constraint that you only accept integers in your string so you can remove any "requirement" that is decimal based. You also have to decide what format you are going to accept your string in, and set rules on it. Personally speaking, I would use Point.Parse[^] as an example.

Advanced TypeScript Programming Projects

Re: Parse from string

jsc4214-Dec-21 6:55

jsc42

14-Dec-21 6:55

Point.Parse does not seem to cater for the fact that the OP has 'swapped' commas and periods in his/her locale. Nor is it clear if the '(' and ')' are mandatory / banned / optional. The best that I have come up with is ...

public static bool TryParse(string s, out Point p)
{
    int x = 0;  // Temp values to hold x and y coordinates of the parsed Point
    int y = 0;

    // String can optionally be surrounded by '(' and ')' and values can be separated by ',' or '.' e.g.
    //  (x,y)
    //  x,y
    //  (x.y)
    //  x.y
    string unparenthesisedValue =
        s.StartsWith("(") && s.EndsWith(")")
        ? s.Substring(1, s.Length - 2)  // Strip off '(' and ')'
        : s;    // No parentheses

    string[] parts = unparenthesisedValue.Split(',');   // Look for x,y
    if (parts.Length != 2)  // Not x,y
        parts = unparenthesisedValue.Split('.');    // Look for x.y

    //Console.Write($"s = {s}, Len = {parts.Length}, Parts = [{ String.Join(", ", parts)}]");

    bool validPoint =
        parts.Length == 2   // Two numbers
        && int.TryParse(parts[0], out x)    // First number looks OK
        && int.TryParse(parts[1], out y);   // Second number looks OK

    p = new Point(x, y);
    return validPoint;
}

This will parse with '(' and ')' as optional (both or neither; but not just one of the pair; either ',' or '.' as separator; any spaces either side of the numbers. If you have more than one '.' or ',' it gets rejected as there are either too many components of you have floating point nos.

Re: Parse from string

#realJSOP15-Dec-21 0:35

#realJSOP

15-Dec-21 0:35

You don't have to check for parens before deleting them. This will work:

// remove parens, remove all spaces, and trim the ends. You should end up with a 
// pure string for parsing.
s = s.Replace("(", "").Replace(")", "").Replace(" ", "").Trim();

I would also make the parser work more generally:

List<string> parts = new List<string>();
// restrict the number of parts to 2
parts.AddRange(s.Split(new char[]{',' }, 2));
// fill in missing "parts" to compensate for 1 or no values
// (string would be "1" or empty)
while (parts.Count < 2)
{
    parts.Add("0");
}
// make a valid value for parts that are present but not specified
// string would be "1,", or ",2"
for(int i = 0; i < parts.Count; i++)
{
    int value;
    if (Int32.TryParse(parts[i], out value))
    {
        parts[i] = value.ToString();
    }
    else
    {
        parts[i] = "0";
    }
}

At this point you now have a reasonably valid list of values, and you can use the .net Int32.TryParse() method.

int x;
if (!Int32.TryParse(parts[0], out x))
{
    x = 0;
}
int y; 

if (!Int32.TryParse(parts[0], out y))
{
    y = 0;
}

// by the time you get here, x and y are valid integer values
Point myPoint = new Point(x,y);

EDIT ====================
Fixed some code typos

modified 15-Dec-21 13:03pm.

Re: Parse from string

jsc4215-Dec-21 0:49

jsc42

15-Dec-21 0:49

All good points (no pun on Point() intended). But it depends on what Point.TryParse() is meant to be parsing. A text like )(, could be parsed as meaning (0, 0) which (I think) your modifications allow, or it could be treated as being syntactically invalid. We don't have a specification of what the OP had intended to be valid and what was intended to be invalid.

Re: Parse from string

#realJSOP15-Dec-21 6:54

#realJSOP

15-Dec-21 6:54

In the absence of a well-defined specification, make it up as you go. My assumptions are valid, and will provide a valid "point" object regardless of the supplied data. I would prefer to return unintended data rather than stop the app with an exception.

modified 15-Dec-21 13:05pm.

c# Search in root/subtree active directory users

jwradhe9-Dec-21 2:10

jwradhe

9-Dec-21 2:10

Hi!
Im having some problem in my function to search on all users in my active directory, root and subtree.

my ad is like this:

ad.company
-> se.ad.company
-> fin.ad.company
-> no.ad.company

I can search , but only get some results from ad.company, not the other subtree directorys.
What have i done wrong?

And this is my code:

private void AutoCompleteTextBox_ReferenceUser()
        {

            try
            {
                var attributeName = "sn";
                string OU = "DC=ad,DC=company";
                var searchString = textBox_manager.Text;
                var ent = new DirectoryEntry("GC://" + OU);
                var mySearcher = new DirectorySearcher(ent);
                mySearcher.Filter = string.Format("(&(anr={0})(objectCategory=user)(objectClass=user))", attributeName, searchString);

                SearchResultCollection result = mySearcher.FindAll();

                List<string> names = new List<string>();

                foreach(SearchResult sr in result)
                    {
                        var n = sr.Properties["cn"][0].ToString();
                        if (!names.Contains(n))
                        {
                            stringCollection.Add(n);
                        }
                    }

                textBox_referenceuser.AutoCompleteMode = AutoCompleteMode.Suggest;
                textBox_referenceuser.AutoCompleteSource = AutoCompleteSource.CustomSource;
                textBox_referenceuser.AutoCompleteCustomSource = stringCollection;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

Re: c# Search in root/subtree active directory users

Richard Andrew x6411-Dec-21 9:16

Richard Andrew x64

11-Dec-21 9:16

jwradhe wrote:
I can search , but only get some results from ad.company, not the other subtree directorys.

This statement doesn't make sense to me, because all of the subtrees you've listed contain "ad.company" as part of their names.

The difficult we do right away...
...the impossible takes slightly longer.

Access Exif Metadata

Dave Dec20216-Dec-21 10:05

Dave Dec2021

6-Dec-21 10:05

I am trying to access the Authors fields from a picture.

I am using System.Windows.Media.Imaging;

My code:
BitmapSource img = BitmapFrame.Create(fs);
        BitmapMetadata md = (BitmapMetadata)img.Metadata;
        lblTitle.Text = md.Title;
        lblSubject.Text = md.Subject;
        lblAuthors.Text = md.Author;  // <======
        lblComments.Text = md.Comment;
        lblDateTaken.Text = md.DateTaken;

It doesn't like highlighted line:
	Cannot implicitely convert type "System.Collections.ObjectModel.ReadOnlyCollection<string> to <string>.

Evidently, I don't have a good enough grasp of C#. Can anyone help?
Thanks in advance.

Re: Access Exif Metadata

OriginalGriff6-Dec-21 10:19

OriginalGriff

6-Dec-21 10:19

The Author property does not return a string: BitmapMetadata.Author Property (System.Windows.Media.Imaging) | Microsoft Docs[^]
It returns a collection of strings, one for each author - since there can be multiple author credits, a single string would not work well.

That's what the error is saying: you can't convert a ReadOnlyCollection of strings to a string - you need to either retriev the first, or work out what to do when you do get multiple authors.

Re: Access Exif Metadata

Dave Dec20216-Dec-21 13:09

Dave Dec2021

6-Dec-21 13:09

So how do I process that collection of strings?

Re: Access Exif Metadata

Luc Pattyn6-Dec-21 16:39

Luc Pattyn

6-Dec-21 16:39

Depends on what you want to do with the author(s)...

BitmapMetadata.Author is a collection of strings, and it implements IEnumerable. So one of the things you could do is

string authors=string.Join(", ", md.Author);

Or turn them into an array like so:

string[] authors=bmd.Author.ToArray();

Or submit them to some LINQ magic...

Smile | :)

Luc Pattyn [My Articles]
If you can't find it on YouTube try TikTok...

Re: Access Exif Metadata

Dave Dec20216-Dec-21 21:24

Dave Dec2021

6-Dec-21 21:24

Luc, you are on my Christmas list. Thank you! Your first reply worked perfectly, and gave me exactly the results I needed! Smile | :)

Re: Access Exif Metadata

Dave Dec20217-Dec-21 17:02

Dave Dec2021

7-Dec-21 17:02

How do you check to see if the string collection is null first? Now my program is crashing because of that.

Re: Access Exif Metadata

Luc Pattyn7-Dec-21 17:20

Luc Pattyn

7-Dec-21 17:20

Don't call join when the array parameter is null; either use an explicit if construct, or use the null-coalescing-operator ?? - C# reference | Microsoft Docs[^] e.g. like so:

string authors = string.Join(", ", md.Author??new string[] {"<NN>"});

Luc Pattyn [My Articles]
If you can't find it on YouTube try TikTok...

Re: Access Exif Metadata

Dave Dec20217-Dec-21 20:51

Dave Dec2021

7-Dec-21 20:51

string authors = string.Join(", ", md.Author ?? new string[] { "<nn>" });
That didn't work.
Operator '??" cannot be applied to operands of type 'ReadOnlyCollection<string>; and 'string[]'
Thank you.

Re: Access Exif Metadata

Richard MacCutchan7-Dec-21 22:13

Richard MacCutchan

7-Dec-21 22:13

Use simple statements:

if (md.Author != null)
{
    string[] authors = md.Author;
    // process the author details
} 
else
{
    // n author details
}

Re: Access Exif Metadata

Richard Deeming7-Dec-21 22:17

Richard Deeming

7-Dec-21 22:17

Try:

string authors = string.Join(", ", md.Author.AsEnumerable() ?? Array.Empty<string>());

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

Created Access DB, now how to load a list into a single column in the newly created DB.

Richard A Knox4-Dec-21 6:18

Richard A Knox

4-Dec-21 6:18

Good afternoon,

I am adding a spot to create the initial Access DB for my program and I am able to get the tables & columns created just fine.

I have one column that has program specific information, (ex: paydays (weekly, 2x month, bi monthly, monthly, etc.)

Where can I find information as to how to load that specific information from a list or something into that one specific column? There are 5 or 6 items.

Richard
Disable Vet
Grandfather
Pain in the @ss

Re: Created Access DB, now how to load a list into a single column in the newly created DB.

OriginalGriff4-Dec-21 6:48

OriginalGriff

4-Dec-21 6:48

The best idea is not to: create a second table that contains each of the various options and has two columns: an ID (can be integer) and a description.

Then your main table contains ID values which are a foreign key to the new table.

That way, you can only hold valid values, and people don't add new ones by mistake by mistyping, or adding punctuation, or the wrong case.

Access is a relational database, and relations between tables are one of the things it is good at: See SQL JOINs for more info: SQL Joins[^]

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.