Posts by ChrisHunter

Java is an actualy programming language to make fully functional programs isnt it and JavaScript is a scripting language used to style webpages and not functionality.

I could well be wrong

If you create a connection sting for your database in app.Config, create a method called something like DBConnect() and then call that in you SQL command then you won't need to data your database name in you SQL statement. The issue i'm guessing is with:

(1,@data) ; "

Make sure the datatype of the data you're trying to store is compatable with the datatypes of the columns in your DB

Can you just attach the image ? was the joker "there are 10 types of people, those who understad binary and those who don't" ?

Post this in the Linux and Unix form, you might get a quicker response

Have a look at these's threads. Reading and writing to Xml has been discussed in the past so they might help you with your problem. If not just ask.

http://www.daniweb.com/software-development/csharp/threads/420976/easiest-way-to-read-and-write-xml-files#post1796401

http://www.daniweb.com/software-development/csharp/threads/406137/dealing-with-xml#post1734164

Best of luck

Doing a system restore might also work, it has for me in the past,

you could possibly update the Players and Managers table in the same update. The Draft table may need to be kept in it's own update because it has the year in it's where clause.

Try something like:

DECLARE @old_team_id AS int;
DECLARE @new_team_id AS int;

UPDATE Players 
SET Players.team_id = @ new_team_id, Managers.team_id = @ new_team_id WHERE team_id = @old_team_id;
UPDATE draft 
SET owner_id = @newteam_id WHERE owner_id = @old_team_id AND year > year(getdate());

Is your problem that in the time between loading your form (which will populate your comboBox automatically because it's databound) and selecting a comboBox item the data in the database may have changed and you would like your comboBox to update if the data in the database is changed ?

make sure you have instantiated, assigned all you instances correctly and have all the correct DLL's at the top of your .cs files (example below).

Using UIHelper; 

hope this helps

use a lable instead of a textbox or just set the ReadOnly property of the textbox to true that will stop the user from being able to type in the 2nd textbox

To strengthen and honor "one.soul", "one.body" of water was born, "and one.mind" had to...

why do you put a full stop (period) in random places? are you posting in some sort of code we (prossibly just me) don't know about?

I did a quick google and found quite a lot of info on running background processes, Have a look at the two links below and see if they help at all (i typed "running background processes in C#" into google)

http://msdn.microsoft.com/en-us/library/hybbz6ke.aspx
http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/26396b5e-6ebf-426a-86ae-a767719db9b9/

Hope this helps

I don't need to be p.ssed off all day for no God dam.n reason, worthless sh.t anyways.

bad day ?

You should have all patients in a single table with a unique ID for each patient and then seperate tables (in-patient and out-patient) that reference the patient's record from the main patient table.

Unfortunatly other than the below query (which will return all rows from both tables and show which will show both matched and unmatched patient records) i don't know the query to fix the issue correctly.

SELECT OP.PatientID IP.PatientID OP.PatientFName, OP.PatientLName, OP.Gender
FROM OutpatientDetails AS OP
FULL OUTER JOIN InpaitentDetails AS IP
ON OP.PatientFName = IP.PatientFName 
AND OP.PatientLName = IP.PatientLName 
AND OP.Gender = IP.Gender;

Hope this helps, let me know how it goes . . .

This should do i i think, let me know if it works or not.

SELECT INP1.PatientID, PatientFName, PatientName, Gender
FROM INP1 LEFT JOIN OTP1
ON
INP1.PatientID = OTP1.PatientID;

Theres also XHTML which is a mix of Xml and HTML and i think it's used like CSS to style the website rather than for adding functionallity to a webpage.

Try making the plans for it, think of what data your system will be handeling and what you want the system to do with the data (what functions your system will carry out). once you know what data needs to be input and what functions you will implement you can design your interface.

What experience have you had with design and development ? you seem to be asking someone to give you a system rather than just a bit of help.

If you're using Windows you can just go to Start->Search and then start to enter the name of your program. to get the .exe you need to publish your program and save the published version to your desktop.

Hope this helps . . .

If you don't know anyone who can do it for you i would suggest you take it to your local computer shop and get it fixed or buy a new computer depending on which one would be more worth while

The three test you should do are:

• Try a different cable to check if the cable is the issue.
• Try a different computer to see if the computer is the issue.
• Try a different monitor to see if the monitor is the issue.

once you've isolated the which one is the problem you can diagnose the issue further.

if the pins have broken off the blue cable try another cable to see if that fixes the issue

convert the int value to string thn it will work effectively

This would mean that charactors can be entered into the textbox which would cause errors. Best thing to do would be restrict/ validate what the user can enter.

Yeah sorry there is a link towards the bottom of the link i posted which is about deadlock in mobile development but i cannot access due to banns in work for some reason

It's suggesting that you use threading to avoid your application from hanging while a process is waiting for resources. For example if you have a mobile IM application for a mobile if you don't use threading and one device trys to send a message but has to wait for resources before it can successfully send the message, no other devices can send a message untill that first device finishes sending it's message. However with threading each device can create it's own session and send the symotaniously.

Have a look at the 'How do i' link on THIS LINK, the subject of the application might not be relevant to your app but it may explain dead lock a bit better.

Hope this helps.

Restrict your test box to only except ints so that the user can't enter charactors into the textbox.

Code will be alot more organised if it's OOP developed and have more generic object and variable names than none OOP programs. Best thing to do might be to create an OOP program in something like Visual Studios to see how the code to create object is organised when you add a new object to your OOP program in comparison to non-OOP programs.

Thats my best guess . . . hope it helps

Yeah I was addicted to Angry Birds untill my phone broke and i had to start again. I don't know if it's already available but Pokemon on smart-phones would be excellent! i spent weeks of my life on that game when i was younger.

You should try SAD: Zombie Assault 3. it's addictive and you can play it online in public games or in private matches with friends. i stole my girlfriends iPhone while she watched her soaps and needless to say she wasn't best pleased when i run her battery down.

I think I would ditch the auto and ride a bike. That's terrible price for petro.

I'm thinking of investing in a motorbike, more expencive than a bicycle but cheaper than a car (which is £2000 for insurance per year).

Don't get me started of petrol prices in the UK ! I'm spending £60-£70 on the stuff in an average week at the moment.

The tanker drivers are planning on going on strike in a weeks time too so it's going to be like something out of a Mad Max film at the pumps this time next week !

Glad i . . . kind of helped.

Is COTDetails a column in a table ? if so do the following for where clause:

WHERE COTDetails NOT BETWEEN '32' AND '63';

This works for me when selecting customers using their ID column.

Also don't forget to put " " on each end of your SQL statement.

As NormR1 said you don't appear to call the getNumDots() method. Also why are you returning value in getNumDots() when you haven't done anything with value in that method. Other than that your methods look ok you just need to call them at some point.

Have a look at this Click Here.

Also do WANT to select COTDetails that are NULL or that are NOT NULL ?

To get a good idea of database concepts in general a book called Database principles and design.

Once you have an idea of the different concepts and designs the books would depend on what you use to create your databases as there are different database management systems which may use different variations of SQL. Judging by the image above your making your's in Visual studeos which is MicroSoft SQL i think so i would suggest you look at mcts self-paced training kit (exam 70-433) microsoft sql server 2008 - database development but only after you understand the types of databases available as it focuses more on functionality such as creating and deleting tables and other functions to manipulate your database using Microsoft SQL code.

Good luck and if you have anymore problems just ask.

Sorry if this sounds rude but have you had much experience with databases ? it might be a good idea to have a read of a few articles about relational databases as record IDs should be automaticalle incremented and shouldn't be changed once created so that you don't have the issue that you're currently facing.

is it a foreign key in another table or referenced it is still the same case i think. you would have to include the columns from the 2nd and 3rd tables in the update

Something like:

UPDATE table1.CarID, table2.CarID, table3.CarID VALUES (4,4,4) WHERE CarID = 4;

so you are updating CarID in the first table as well as the 2nd and 3rd table. The WHERE clause will define which row to update (so update the record WHERE the CarID is 4).

You should really use primary and foreign keys to avoid repatition and maintain consistancy throught the tables.

If you carID column is a primary key field and it's a foreign key in another table i don't think you're allowed to update them because the foriegn key basically means it references the record in another table. For example if there is an ID of 1 and and it is changed to 3, anything that has a foreign key of the ID 1 can no longer find that ID and so you'll get that error i think.

So to sum up you can't/ shouldn't change primary key fields for consistancy and reliabilitry purposes.

Have a read through these articles about reading and writing to Xml. They are different ways of doing it but should be useful and i did it the way shown in the stack overflow link (the first one, i suggested it in my earlier reply in this thread).

http://stackoverflow.com/questions/1464557/reading-and-writing-an-existing-xml-file-c-sharp-3-0-net3-5

http://www.c-sharpcorner.com/uploadfile/SamTomato/xmlserializer-class-for-reading-and-writing-xml/

http://forum.codecall.net/topic/58239-c-tutorial-reading-and-writing-xml-files/

Also if you want help bumping with comments like the last few probably won't help. It might be a good idea to do a search on DaniWeb for reading and writing Xml because i have seen a few in the past too.

Hope this helps, let me know if you get stuck (c looks like it is a string containing the contact info).

put .ExecuteScalar instead of .executeScalar (use a capital E)

Why are you doing:

convert.ToInt16(cmd.executeScalar().toString());

take off the .toString() (plus its To.String()), convert it straight to string and put a capital C on convert.

Hope this helps

What is the problem you're facing, does the application not run? or are you just not seeing the correct answers being shown at the end of the test ?

I noticed the arrary below is never used after it is declared, are you supposed to use it to check the user's answers are correct ?

int[] Correct_Answer = new int[] { 2, 1, 3, 4 };

I hope this helps but if it doesn't could you possiby try to explain the problem you're facing a little more please.

Thanks

Really? How could you say such a thing without any thought? I haven’t seen or read any news about food (or money) given to Greece for free… (If you have any such news –not loans- please share them). Don’t carry away, the problem certainly are not peoples.

You really think that amount will be paid back in our lifetime ? They can just about stay afloat at the moment as it is, torisum will return one day, but not while there is protest and unrest.

I don't know about the localization or configuration bit but i did the code below to import data from an Xml file. I used an OpenFileDialogBox (fileOK method belongs to OpenFileDialogBox) and created a class called ObjectTypeState containing get/ set properties to store the imported data which was then displayed in a propertyGrid.

using System.Xml;

ObjectTypeState objtyp = new ObjectTypeState();
ObjectTypeState objtype1 = new ObjectTypeState();

        private void openFileDialog1_FileOk(object sender, CancelEventArgs e)
        {
            try
            {
                string path = openFileDialog1.FileName.ToString();
        }
            catch (Exception ex)
            {
                throw (new Exception("Could not import state " + ex));
            }
        }

    public ObjectTypeState importState(string path)
        {
            try
            {
                //Initialises instance of XmlDocument class called config
                XmlDocument config = new XmlDocument();

                //Loads existing Xml document, located at directory this is stored in path and stores it into config
                config.Load(path);

                //Creates instance of all node within loaded Xml docuemnt and retrieves element by tag name
                XmlNodeList ObjectTypeID = config.GetElementsByTagName("ObjectID");

                //Loops through foreach for each element specified by GetElementByTagName("")
                foreach (XmlNode n in ObjectTypeID)
                {
                    //Converts XmlNode to XmlElement
                    XmlElement _ObjectTypeID = (XmlElement)n;

                    //Converts and stroes value of specified attribute in property of ObjectTypeState class
                    objtyp.ObjectTypeID = Convert.ToInt32(_ObjectTypeID.GetAttribute("ID"));
                }

                XmlNodeList StateType = config.GetElementsByTagName("StateType");

                foreach (XmlNode n in StateType)
                {
                    XmlElement _statetype = (XmlElement)n;
                    objtyp.StateType = Convert.ToInt32(_statetype.GetAttribute("ID"));
                }   

            }
            catch (Exception e)
            {
                MessageBox.Show("Could not import file contents. Exception: " + e);
            }
            //Returns instance of ObjectTypeState class
            return objtyp;
        }

Hope this helps. (the code that goes on two lines are comments.

expecting output which should be made in XSLT

Good for you thanks for telling us i'll sleep better tonight now i know that!

What problem are you facing ? you haven't stated that you're having a problem getting this output, or what you're doing in an attempt to gett his output you're just saying you're expecting this output. Are you getting errors or exceptions or are you just looking for someone to do your homework for you ?

If you ask a spacific question someone might be able to help you.

Edit: XSLT is used to ad a style to a document (font size, format, colour, spacing etc) in the same way CSS does. To get the out your require you beed to know what you want the output to look like. have a look at this Link, it's not the best but a quick search of something like "XSLT turoials" might give you some better tutorials.

To answer your first question: No they are assigned different IP addresses. 192.168.0.1 is usually the default IP and is usually reserved for a router, the first computer connected to the router will have an IP of 192.168.0.1, the second 192.168.0.2 and i think you can guess the 3rd.

to question 2: i think you can set the IP of the web server but if you're renting one you will be given the IP i think.

to answer question 3: if external users (people not connected to your network) use the website they will access your website by typing in the website URL which references the DNS to get the IP of your webserver where the data for website is stored.

Hope this helps . . .

My answer may not be 100% correct, check other replys to confirm

string SearchText = "7,true,NA,false:67,false,NA,false:5,false,NA,false:5,false,NA,false";
string Regex = @"\btrue\b";
int NumberOfTrues = Regex.Match(SearchText, Regex).Count;

stirng doesn't contain a Match() extention method so you can't do Regex.Match().

take a look at this Link it might help you

Download Chrome or IE and see if the same thing happens.

I don't know much Java but by the looks of the error you're getting it looks like the ClassicRoom.Occupy field should never be null but is null at the point the error is thrown.

Instead of using:

invalue = textBox1.Text;

guessedNumber = int.Parse(invalue);

use:

guessedNumber = Convert.ToInt32(textBox1.text);

Hope this helps

edit: if you enter any charactors into the textbox you will get an error because charactors cannot be converted into a numerice value the way you wish, you may have to do a check when anything is entered into the textbox to check it is only numeric.

Next to "Logged in as" click your name and in the community contributions box click total posts. this will list all of your posts, it's a little confusing at first but they are all there