Posts by hericles

Are you saying that after entering the data (employee ID) that it should be saved to the database and then the next time the app is started dropDownList2 is populated with the employee IDs? If so, then the dropDownList2 will need to draw the info out of the database and have the data added to it, presumably on page_load.
Are you having trouble with the data insertion or getting it back out?

The standard select statement has the form of

SELECT col_name1, col_name2, etc FROM table_name WHERE some_col = some_value;

So you will want to store the selected option from the combobox and then add it to the SQL statement. You haven't given us much to go on, do you know how to create a database connection with a connection string, put your SQL statement into a command object and execute the command? If not, type ".net database tutorial" into google and follow along.
Of course, if you have specific problems and questions post them back here and we'll help out.

The wikipedia article shoud be enough to explain it but, to really brief, n-tier relates to the breaking up of the project or application into seperate layers for easy design, developement and extension.
A three tier web app could be considered to be the user interface, the code (business logic) and the database.

Hey, a new thread might have been better but never mind.
An update statement requires a WHERE clause otherwise it will update all of the selected column.

UPDATE table1 SET col1 = 'Some value';`

will update all of the columns col1 so the rows read 'some value'. The WHERE clause explains which columns to update and is a very important part of the SQL statement.
In you posted code you have the WHERE clause before the SET clause which is probably the cause of the problem.

Can't help you there I'm afraid, my knowledge of the robots.txt file only handles how to hide files and folders. I would have to assume they know what they are doing though.

I'm not sure how the website is loading the images but as it shows the image with the incorrect name now (rather than not showing anything because the URL is incorrect) I'm guessing that as soon as everything is renamed the images will display correctly sans the repeated .jpg.
Have a look at this post: http://bytes.com/topic/c-sharp/answers/440212-renaming-files-directory
You want to do almost the same thing but instead of moving files like he is, you need to get the file part of the name of each file in the FileInfo array and check if it contains .jpg. If yes, strip it out.

You've only given a very brief description of what you need to do but it sounds like the 'timers' you want would just be more labels and when you click the first label code does what it needs to do and the timer label is updated.

I've found the related article, while it maybe sometimes relevant (but not always), is hardly ever very timely. Often they are articles from months or sometimes years ago. This maybe relevant to the poster, to find other articles related to their question, but as I am in the process of reading and replying to the thread I happen to be on I find the related article distracting, a little pointless and a waste of space.

OK, then query your database and retrieve that column. Then simply check it with an if statment.

string result = // place your retrieved column here
if(result == "Spot Purchase) {
   RadionButtonList.Items[0].Selected = true;
} elseif(result == "Tendor Purchase") {
   RadioButtonList.Items[1].Selected = true;
}

Iwould suggest you check the SQL error logs. They will hopefully tell you what is going wrong with the server starting. If you post the error up here we can probably help fix it for you.

The easiest way to make content center is to apply margin-left: auto; margin-right:auto;
to the content you want to center. But for this to work the containing div (or whatever) must have a width specified.
So, any content you want centered inside #content must have those rules added to them.
inline and in-block are ways to make content that is normally block level (divs, ul,h1..h6 - that is, designed to appear as if on a new row) to appear inline (or beside other content). E.g. adding display: inline-block to <li> elements make them appear horizontally across the page.
So, for your img and form (which maybe better off as another div) just need a width specified for each and the inline-block added.

Ah, I see, I thought it was just a border mis-alignment going on there.
Try adding the z-index:100 value to the menu. That should layer it above the following content.

Sorry, where is the overlap? Everything looked OK in Firefox.

The most obvious answer is that the user name is the student ID. If you don't want to do that and instead have a different login name then you will need another column in your student table that stores their user name.
Then you use the user name in the where clause of your SQL statement rather than their ID.
Your SQL statement is incorrect by the way. When joining tables you need to use the ON clause, this can't be done with the WHERE.

SELECT s.student_id,s.studentname,s.studentcourse, t.faculityname, t.course,result.marks from student as s,teacher as t,result ON s.studentid=result.student.ic and s.course= t.course WHERE --student ID or username --

I used the AS statement to give the tables aliases, its a bit easier to read. I also see there is a reference to linking to the faculity table but that is a typo and should be t (or teacher) I'm assuming.

If you have added them with the doubled extension and there really are hundreds of them, write a script to get all images in the folder and rename each one in turn (taking the file name part, ignoring the extension, and checking if it contains .jpg. If it does do a string.replace to remove it.
Be a lot faster than renaming them all by hand.

The current date in MySQL can be used with the curdate function. In MS SQL use GETDATE (returns date and time). so thelast part of your SQL statement should be

Trans_Date >= CURDATE()) or
Trans_Date >= GETDATE())

You can find out plenty more options on either the MySQL reference site or MSDN for whichever database you are using.

If you want to check a radio button based on some value you would use

RadioButtonList1.Items[index].Selected = true

The Text method would not whether it was checked or not. It alters the text assigned to the item.

Simply drag two dateTimePickers onto your form, one for the from date and the other for the to date. You can then access the DataTimePicker.Text method to retrieve the value of either one. E.g. some simple code to get the days between two dates

Dim date1 As New Date
Dim date2 As New Date
date1 = DateTimePicker1.Text
date2 = DateTimePicker2.Text
Label1.Text = (date2 - date1).ToString

How does the information relate to the other fields and the gridView? You will need to construct a database with at least one table (maybe more depending on your answer to my first question) to hold the info. You haven't mentioned whether you have done that yet.
After that the actual saving is just a matter of declaring the usual database objects (a connection with the database info, a command object and the SQL statement specifying what to save and where) and performing the data insertion.
We could help more if we knew what step you were up to-
Designing a database or performing the information saving.

It sounds like your class definition is incorrect. You would have forgotten a { or } somewhere and so your class or methods don't properly close. A sample class would look like this:

namespace SampleNamespace
{
    class SampleClass
    {
        public void SampleMethod()
        {
            System.Console.WriteLine(
              "SampleMethod inside SampleNamespace");
        }
    }
}

One or more of the curly braces being missed would cause the errors you are seeing. Check everything is where it should be. Basically your namespace holds a class with {}, and a class holds your fields and methods inside a pair as well.

Maybe you should post up some code so we can see what you've done.
Although in your previous post you have

Dim frm As New frm2()

That should probably be

Dim frm As New Form()

I assumed that was a mistake but maybe it isn't.

Then use height: auto. the div will always be the size of the content plus any padding you have added.

It looks like your containing div (with the pink background has a set height to it. The text you added pushed the content beyond that height limit.
You can change the height of the div to something like height:auto (so it is always just as big as it needs to be) or use min-height: some value if it requires a set minimum.

You shouldn't need to create your own Show method. The correct method is Show() - uppercase but the IDE should have corrected that for you. Delete the show() method you created, change the code in form1 to Show() and it should work.

You are missing some syntax somewhere in the class, most likely a method that has no End Sub.

I'm with Momerath here. Just out of curiosity what use could 16.7 million rows be to anyone?
If you need to proceed what you need to do can be done with nested for statements, three of them, each one holding one of the sets of 0 to 255. Then just loop through slowly building up your ascending, really, really long list

It sounds like you aren't creating an HTML email. A plain text email will of course display the HTML code as it doesn't know what to do with it.

Obviously the connection string you are using will have to change and hopefully the dev team knew enough to store it in one place only (web.config). You can find the connection string syntax for MySQL at connectionstrings.com.
Also, in certain places you may need to alter the actual SQL commands used, particularly if you have used parameters as MS SQL uses @ to preceed the variable while MySql uses ?.
But, change the connection string and run it in debug mode and watch as the IDE shows you all of the changes you need to fix:)

Can't you pass in the points as one data set rather than call it 16 times? You'd need to change your plotting function of course. How fast are new plot points generated (can you slow down the function call to match the incoming data)?
If it becomes unresponsive when use threading you most likely will be causing dealocks or race conditions. Without sample code we can't help you there.

Debug your code and step through it. That will help you find the exact section that is causing problems. And this was really hard to read. You should get in the habit of using either pascal case (PascalCase - capitalise every first letter) or camel case (camelCase - capitalise every first letter after the first word). Variables and methods become a lot easier to read. txtnameofingrediant.Clear() becomes txtNameOfIngrediant.Text for example, much easier for someone else to come along and read (and that includes yourself). Just a tip:)

The best way (if it is a compiled, dynamic site, rather than static HTML) is host it somewhere and give them the URL. You can't expect to send them the files and have them install IIS and a database just to view it.

You can simply redirect to the MyAccount page and then it uses the session value to load the appropriate data. If you are going to another page in your own site passing a session variable as a parameter in the URL is really not needed.

You aren't using the dataSource method to match your dataset to the chart for a start. Have a look at the chart doc on MSDN, that will help you a lot.

Are you referring to the connection string for your database or something else? You're question isn't very clear.

I just read these two books on C#4.0 and found them to be very good. They might be a little advanced for a complete novice but they go into depth on a range of topics:
Programming C# 4.0 Ian Griffiths, Matthew Adams, published by O'reilly
Fluent C# Rebecca M. Riordan, published by Sams

You are calling your cmd.execute twice, once to execute it and again to ensure it worked and clear out the textboxes. That is where the duplication is coming from. Remove the first instance and the second will run and provide you with your check that it succeded at the same time.

You can call Process.Start() to start an executable. E.g. Process.Start('notepad.exe') will fire up notepad.
Your text is only appearing the top textbox because that is all you are telling it to do.
If you open a file and want the text to appear in more than one textbox, first store the text file in a string variable

string fileContents = tr.ReadToEnd();

and then set the textbox.Text to the string variable for every textbox you want it to appear in.

You could put your address image inside a div and your table inside another, set the widths of both to what ever width they should be on the page and then add the CCS rule

display: inline-block;

to both. That will remove the need for the float and place them side by side.

You would need some way of knowing when a user has liked a page, so the like button doesn't show again and the unlike option is there. I'm assuming you will be saving this in a database so when the page loads the code checks if this user has liked or disliked this page and, knowing that, can figure out what button to show and what text to display.

In the page load method add your code that calculates the number of likes (from a database most likely) and figure out what text is displayed on the buttons.

If you need it to repeat in one direction only use:

background-repeat: repeat-y (or repeat-x)

If you want it to not repeat at all use

background-repeat: no-repeat;

This should be placed in the CSS file rather than entered as in-line style. Add it inside the body {} section.

Are intending to use Crystal Reports for it or do you want a simply, ad hoc solution (coding yourself)?

LinkButton.Text = "Like";

You will want the code to check the current text of the button so it knows what to change to I guess. An if statement will do that easily enough:

if(LinkButton1.Text == "Like") {
    LinkButton1.Text = "Unlike";
    // plus whatever other codes runs when something is liked
} else {
    LinkButton1.Text = "Like";
}

Initially you will want to show two buttons (like and dislike) but once a selection is made you would be better to hide one of the buttons as only one is needed now - to reverse the decision. For example, if I like the page there is no point changing the like button to unlike because there will now be unlike and dislike which is pretty confusing to the user. Better to change its visibility instead and leave the dislike button unchanged.

We would need an actual explanation of the problem first. Does it fail completely or just not look right? And IE6, really? W3C school stats show IE6 is down to around 1% usage now and it was a terrible browser with plenty of bugs to begin with. Later browsers adhere to the HTML and CSS specs far better than IE6 ever did and will most certainly present differently. I would suggest testing and designing for a far more modern browser.

Are you wanting to convert a hex color into an image of the same color, a block of that color only?
You can use the system.drawing to create an image, brush it with that color (basically filling it with one color and then save it as a file.
The images can then be used as the display in a webpage.

For HTML emails the images always need to be used with an absolute path. src="image1.jpg" means nothing when the code is away from your development environment. You will need to host the images on a server and point to them with a full address.
This link will help you: http://kb.mailchimp.com/article/top-html-email-coding-mistakes

Check your mySql log files to see what is happening. You should have a mysqld directory with the relevant logs in it.

On the page reload could the code that populates your listbox be running again, doubling up the number of files listed? Debug your code and see how many items are being added to the hfc collection, it may be more than you think.
Also, as an optimisation, you don't (shouldn't) use a try/catch for each step of your database interaction, particularly when all you are doing is outputting the error. Try/catch blocks are expensive to run so you should minimise their use.

The checked method returns a boolean, true if checked false if otherwise. So you can use

if (!checkBoxAddSub.Checked && !checkBoxMultDiv.Checked)

OK, are you saying that when you refresh the page or it reloads after a postback that the user name and password still appear in the textboxes? Or is something else going on? Some example code would help.