Re: re-create a local database - C# Discussion Boards

re-create a local database

17-Dec-21 2:40

You can use

DateTime today = DateTime.Now;
int lastDay = DateTime.DaysInMonth(today.Year, today.Month);

That particular example would return 31 for December 17 2021 (today's date).

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

steven_noppe15-Dec-21 20:04

steven_noppe

15-Dec-21 20:04

I have a Visual C# .net application hosted on a git.
When I recently moved to a new laptop and re-installed visual studio, I cloned the repository succesfully, but i can not publish / run the application anymore because it's complaining about a lost "database.mdf" file.

error MSB3113: Could not find file 'AppData\Database.mdf'
error MSB3113: Could not find file 'AppData\Database_log.ldf

On my old laptop the location of the database was in the "AppData" directory. Offcourse it's not there anymore.

But my thought was that the project would re-create the database and make a whole new one.

Is this still possible and how do I do this?

Re: re-create a local database

OriginalGriff15-Dec-21 20:54

OriginalGriff

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.

Re: re-create a local database

#realJSOP16-Dec-21 2:39

Re: re-create a local database

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).

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

Advanced TypeScript Programming Projects

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.

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.

#realJSOP15-Dec-21 0:35

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.

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.

#realJSOP15-Dec-21 6:54

c# Search in root/subtree active directory users

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.

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

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.

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.

Dave Dec20216-Dec-21 13:09

6-Dec-21 13:09

So how do I process that collection of strings?

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...

Dave Dec20216-Dec-21 21:24

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 | :)

Dave Dec20217-Dec-21 17:02