Posts by Ramy Mahrous - Page 27

Did you post that in Microsoft forums?!

In such cases, it better to search over internet or googlize that take a look on http://www.codeproject.com/KB/aspnet/DataTableAdapter.aspx

If you didn't understand that, feel free to reply back.

Yes, if I were you, I'd make it UserControl
1- You have constant control (be used in this App and others)
2- You need this control to give you "a matrix" more than textboxs values, some how you isolate logic from UI and UI controls from UI processing elements.

- List or ArrayList can be used for better reasons. and It contains .Contains method which to be used in your case.
- Use Random class to generate numbers but check if the generated number is has been generated before or not.

Look I feel you can do it on your own just try
First tell me you can get the ListView columns?!
- listView1.Columns
Then you can treat with XML file as we discussed in the previous post.

Try using System.XML you'll find classes help you to do anything with XML files.

http://www.google.com.eg/search?hl=en&safe=off&q=united+states+database&btnG=Search&meta=

Please ask in ASP.NET forum

I think it's the time to close this thread! really I feel shame when I look to the question then find these huge number of replies!

There's some sites have desired data! but you've to pay! fits you?

Did you try googlize that?

Very nice, and I'll subscribe there to know how to be handled in ASP.NET :)

Look what makes difference is that you get SQLCommand.CommandType = ? "Text" or "StoredProcedure"
If you get CommandType value you'll solve your problem I didn't work before with Microsoft.Cci library!

Lizr and Danny don't answer people with code especially who don't show their effort in solving easy problem, they're right, aren't they?!

The system would do a daily task which is to check which questionnaire has not been attempted.

You can use ASP.NET cache to make it every 24 hours check the database and if there's just 5 days, send reminder, it's not hard but need you to know some idea about ASP.NET caching so I highly prefer to you send this question in ASP.NET forum, believe me your thread will be solved immediately.

Yes there's, search you'll find more than way :)

Ok, please give me sample Data and your desired output

So the output should be
2008-03-09 13:15:12.513
2008-03-09 13:16:53.700
2008-03-26 13:30:20.077
2008-03-26 13:30:51.810

right?

Take a look http://blog.crowe.co.nz/archive/2006/06/01/644.aspx

hmmm, Yes Danny, but I think he has a problem in undertanding what virtual directory is!! What you are doing Mkn is going to shared folder on network not virtual directory!!
I'll search in this topic and reply you soon, but better go to ASP.NET forum and discuss that there http://www.daniweb.com/forums/forum18.html

Break the many-to-many relationship into one-to-many and many-to-one
Which means?
create a bridge table Employee_Company (EmployeeID int #, CompanyID int #, Salary float, .....)
Bridge table properties: has composed primary keys (in your case Employee and Company)
- has shared properties which illogical to included in the entities it ties with (in your case salary, work_period, title, etc...)

declare simply array from object datatype then call AddRange for all combo boxes and pass this array!

It may help http://fci-h.blogspot.com/2007/08/webservices-in-orcas.html

I think going on replying this post is just wasting time! really.
Please read in basic C# programming, It's definitely impossible to ask someone has no idea about math and ask him to solve an equation.
I can't try with you again else you show readiness to start on your own.

loool I can't believe 23 replies!!! Lizr code self-explained!!

Very simple in C#
http://www.computorcompanion.com/LPMArticle.asp?ID=194

Read in generics
http://msdn.microsoft.com/en-us/library/512aeb7t.aspx

?! I've did for you almost all functions your program should do. Just try to make use of them and have a deep look inside the code to learn how things done.

Thank you Danny so much, but he may don't have .NET framework 3.5
I hope he replies he could solve the problem.

Here's some codes...

List<Human> Humans = new List<Human>();

        void Add(Int16 humanID, string humanName, Int16 humanAge, float humanSalary)
        {
            Humans.Add(new Human(humanID, humanName, humanAge, humanSalary));
        }

        float GetMaxSalary()
        {
            float maxSalary = 0;
            foreach (Human aHuman in Humans.ToArray())
            {
                if (aHuman.SALARY > maxSalary)
                    maxSalary = aHuman.SALARY;
            }
            return maxSalary;
        }

        float GetMinSalary()
        {
            float minSalary = GetMaxSalary();
            foreach (Human aHuman in Humans.ToArray())
            {
                if (aHuman.SALARY < minSalary)
                    minSalary = aHuman.SALARY;
            }
            return minSalary;
        }

        float GetAverage()
        {
            float totalSalary = 0;
            foreach (Human aHuman in Humans.ToArray())
            {
                totalSalary += aHuman.SALARY;
            }

            return totalSalary/Humans.Count;
        }
    }

    struct Human
    {
        public Int16 ID;
        public string NAME;
        public Int16 AGE;
        public float SALARY;

        public Human(Int16 humanID, string humanName, Int16 humanAge, float humanSalary)
        {
            ID = humanID;
            NAME = humanName;
            AGE = humanAge;
            SALARY = humanSalary;
        }
    }

well, seems you don't need to try we've absolved responsibility regards this, I'll try it after some minutes and come back with C# code.

What's this??
You need to read in Structures as well.
Let us start.
1- I need you do initialize an array of 5 elements from human datatype

You can also use DirectX SDK

Give us hint you tried, if you declare instance from ArrayList class and pressed '.' you'll find someone much greater than us with all respect to my friend Ddanbe. it's intellisense and documentation.

You can read either in LINQ or ArrayList, in your case I prefer to read in ArrayList.

mmmm, can't you extend its name to hold the date?

Look I don't feel it'd be good to send email from SQL Server, + I don't know if Express edition has this feature or not. but try to send on ASP.NET forum http://www.daniweb.com/forums/forum18.html how to solve this task.

That's correct give me real sample data to all these tables + output you need not table just in english text what you need to extract from these tables.

[User] table still the same
[Rating] table has (Voter_Member int #, Voted_Member int #, Rating int)
- Composed primary keys (to maintain user can't de\vote user two times)
- Rating int (if you need some higher rating 1 2 3 4 or -1 -2 -3 -4)

752

As I said, you've lack in your design, I am sorry but your database design is wrong. It need some normalization

PL\SQL just for Oracle and T-SQL for SQL Server, you can't run PL\SQL in SQL Server! except ANSI-SQL runs on both (all) RDBMSs

users can 'approve' or 'disapprove' another member

User is Member?! or each another entity!!

What's machine1 and machine2 ?? and what '0' in the first row in output?

Welcome, Phillip please mark it as solved if it be.

You're welcome, if this thread answered, please mark it as solved.

Marke this thread as solved! please.

if (openFileDialog1.ShowDialog() == DialogResult.OK)
            {
                System.Diagnostics.Process.Start(openFileDialog1.FileName);
            }

Please if your problem solved, mark this thread as solved :)

Stored procedure name as well SQL Statement may be in SqlCommand class, can you fetch some properties of SqlCommand class using Microsoft.Cci??