Posts by hericles

And be particular about which part you are having trouble with. Is it the data extraction or the document printing that you need help with? The better you define your problem (and tell us what you have already done) the more likely we are to help.

Check out how to load a file using LOAD LOCAL INFILE command for MySql or for MSSQL the bulk insert method e.g.

BULK INSERT OrdersBulk 
    FROM 'c:\file.csv' 
    WITH 
    ( 
        FIELDTERMINATOR = ',', 
        ROWTERMINATOR = '\n' 
    )

Which database are you using and, more importantly, what error are you getting?

Download wordpress ;)
Or, if you want to do this yourself, what areas of web design are you familiar with? Are you asking for help with site design, databases or the actual coding?
Simply put you will have one page that allows you to enter your blogs (unless you intend to upload them some other way) and the page that shows the blog titles and dates and then extracts and displays the selected one.
If you need help with particular areas we can help more.

If you are reloading the same page the values entered into the form are saved in the page postback. You just need to clear them out in the page load section

textbox1.Text = "";

It looks like you are missing an operator (AND or OR) in your statement.

sql = "Select * From Skills Where StampNo = " & Stamno & " Cell = " & cell & " And Op-Number = '" & op & "' "

This translates to SELECT * FROM skills WHERE StampNo = someValue Cell = cellValue AND Op-Number = opValue.
So you can see you're missing an operator between somevalue and Cell.

The solution is to store the fact that the process ran (or is running) somewhere (database, text file, in memory) and then runReport() checks that value after it determines the time is right but before it starts actual processing.

The isNumeric function is probably the easiest solution. It returns a boolean value indicating whether the input can be parsed to a number.

The HTML code for placing an image on the page is
<img src="location_of_image/image_name.jpg" alt="alternate text" />

I would suggest getting used to the W3Cschools website if you are very new to HTML/CSS. It is a great learning tool

Try this version. It looks like you have got your WHERE condition syntax incorrect

INSERT INTO jobs (priority, date, deadline, material, status) VALUES (?, ?,?,?,? ) WHERE customerID = (SELECT customerID from Customer where CustomerID =?)

I hate to steer you to the competition but check out this article on Stack Overflow:
http://stackoverflow.com/questions/2206988/paging-with-an-asp-net-repeater

You can code up the logic yourself (i've got the code somewhere but I can't find it) but otherwise the above link should help.

what error are you getting when you run this code? Or have you not figured out how to get the file name to delete? If not, you would have to query the database before doing the deletion so you have the name of the file to delete then run the delete query and the file.delete method.

Are you having trouble with the SQL query to check if the name is already used?
just do a SELECT COUNT() on the user name or email. There should be zero results if the name is unique and 1 if it is already registered. You can then proceed to save the user's details or inform them that the name is taken.

You can iterate through a repeater using the foreach loop and the findControl() method to search for the control you want to change, disable, etc. You will probably need to run through the repeater to find the row you want to alter (based on whatever makes that row the target) and then find the particular control in that row that you want to edit. I don't have a good example to hand but if that isn't enough to go on I can post one later for you.

Most browsers can be opened with a URL as a parameter using the Process.start() method e.g. Process.start('firefox.exe', 'someURL'). As you will be opening them as their own processes when you do this you won't be able to control where they open (I don't think).

Thats strange, your session checking code should work as long as the session has been abandoned or cleared. The javascript version won't help, it is designed to simply break the back button (bad idea). debug your page and see what the value of the string is after logging out and returning to the page.

it should be href not ref in your anchor tag.

Hi,
Don't disable the back button. Instead you should have code in each of your pages (in the page_load) that checks if the session is current and if not redirects to the log in page (or whatever is relevant). There once a user logs out and the session is cleared, if they hit the back button they just get redirected.

Are you trying to store an image in the database and long blob isn't big enough?? Thats a big image.
Can't you store it elsewhere and refer to its location from the database?
Or, if you must store it, turn it into bytes and cut it up as much as is required and place it in several long blobs (I'm sure how efficlient that would be).
I've never had to tackle a file that large in a database before so others may have better real world solutions that work.

AJAX the delete button press then there is no page reload

Specify what is involved for each project in writing in consultation with the client and get it signed off by the client. Base your price on that and don't deviate. Additions to the project then come at an increased cost. Scope creep will kill you otherwise.
Set a realistic deadline and stick to it.
Get major milestones in the project signed off as complete by the client (in writing) before moving on.
Basically make sure both you and the client know what is going to be done for how much and make sure they are happy with every phase of the project. Rework due to miscommunication or growing requirements will wipe out your profit on the job.

is checking for the date modified or created of the file an option? At least using those dates the format is set and you're not relying on user input to determine if you want to operate on that file.

I normally use pwd in place of password but I don't know for sure if using password causes MySql to throw an error. But that is the only thing I can see wrong with your connection string - unless your database name is wrong.

This link will show you one way of doing it using the overloaded fill method of the dataAdapter.
http://csharp.net-informations.com/datagridview/csharp-datagridview-paging.htm

You will need to check that you are accessing the correct database, you are logging in as the right user or that the user you are logging in as has the correct permissions to interact with the database or table. You could also be missing the prefix name when it is required (normally DBO).

Basically, yes. Drag two tetxboxes and a button onto your form and double click the button to open the button_click event in the code window. Add your code into that method and replace the two lines where you read in the user's input to instead access the text in the textboxes.

string username = textBox1.text; // if you haven't renamed it
string password = textBox2.text;

All other console lines can be removed or altered to output text to a label.

The simplest way to do that is to add the google search box to your page - is that what you want? Search 'add google search to webpage' and you'll find links to the HTML code you need to add.
Hereis one link that quickly shows how to do it: http://www.askdavetaylor.com/how_can_i_add_a_google_search_box_to_my_web_site.html

If it is for a web form you would normally use <asp:Image>. In the button click code you would set the imageURL to display the correct image.

It looks like you just need to change the float of the menu as it is currently set to float: right;
I'd follow the advice at the top of the CSS file and add a new CSS file after this one that has the new CSS rules in it. That way it will overwrite the rules you need to but leave your original CSS untouched. By doing it this way you can also play around with the style as much as you like without doing any real damage.

If in doubt about any connection string head to www.connectionstrings.com. You'll find how to connect to any database.

I would change the database table to have the employee ID the date time stamp and a status showing whether they entered or exited (1 or 0 basically). Then you just insert into the table the employee ID, the time stamp and the status (based on whether the sign in or sign out button was clicked).
Otherwise, as you have it, when they sign out you need to locate the last row used by the employee (having a sign in time but no sign out) and update the sign out time. This is pretty awkward and inefficient.

in your code for the button you need the database connection and command execution code. If you don't know how to do this there are plenty of tutorials online that eplain it in better detail than you can get here.

HTML 4 or 5 on an iPhone/iPad/Android shouldn't be a problem for this. Most problems with websites on mobile occur with using CSS attributes like HOVER or absolute positioning. Design the page well and you won't have any issues.
The first part is pretty standard. The user enters the text and clicks the button and then server side code (or javascript if you aren't doing any server side processing) takes the entered text and adds it to the URL.
What you are looking for for the second part is called screen scraping. You can load the desired page using the .Net HTTP classes and then scan through using regular expressions to find the H1 tags.
Here is a very simple tutorial but there are plenty of more advanced ones.

I'm assuming you have the status of order kept in a database. When the order is entered into the text box, take that value and use it to query the database to retrieve the order status. Once you have that use a switch statement or something similar to match the returned result against a status type (renovated, completed, validated or cancelled) and check the correct control.

You need to use the text property of the text box if you want to access the text the text box contains. You are including the textbox itself in the list, not what it contains.

lstNewValues.Add("OfferID", txtOfferID.text);

You are seeing that error because a text box control cannot be converted into an integer.

It seems to me you have your logic round the wrong way. If the data reader can't read then there are no rows so the user name isn't entered. If the reader has rows then the name is taken and you inform the user of that.
You need to swap your code around in the if...else statements.

It looks to me like your SQL statement is wrong. Where you use a join the ON clause is meant to specify which columns match but you haven't done that. You have 'ON PateintTbl.SLP_ID = Session(logAccount)'

This should be: ON PateintTble.SLP_ID = SLP.someMatchingColumn WHERE SLP_ID = ' + Session(logAccount) + ';''

Including Session(logAccount) directly in the string is also incorrect as that would be taken exactly as is, and not evaluated to the value Session(logAccount) holds.

First off, debug your code and see what value is being put into temp. If the user name was in your database twice then temp would be more than 1, if it isn't there at all then temp won't be 1 either.

Use writeLine instead of write. That will add a line terminator to each line.

Have you actually debugged and checked the output of the reader? It is correctly pulling the information from the database?If it it and UserType then contains either A, S or P you should get redirected...

Just checking, you have one column called AccountNUM and the other Accountname.
Can you put the contents of that cell of the gridview into a string variable?

You have a typo, thats all:

comm.Parameters.Add("@AssignedTo", System.Data.SqlDbType.Char)
comm.Parameters("@txtAssignedTo").Value = AssignedTo.ToString

The first line should be txtAssignedTo.

Now I'm confused. If the user type in the data base is stored as a number why are you testing to see if it equal to A, S or P? What is the data type of the userType column in the database? If the reader is holding numbers and you are checking for letters your MsgBox should fire everytime because cases A, S and P will never work. Is that was is happening?

You don't need that to do the SQL query. For each other column you want to include in the query add another OR WHERE column = ?parameter

Is AccountNUM the correct name for the row?

Yep, just add more parameters, one for each column you want to include in the search.

Yes, any variables you store in session state are available to all pages called during that session. Say you had a log in section that showed the log in boxes initially but user data if they had logged in. Each page that had that section could check the session to see what the logged in status was and dispay the appropriate stuff.

come on man, don't put up your euler solutions. Other people that can't solve it are just going to copy your answer which just weakens the site. You can see other people's solutions on the site once you've solved a particular problem anyway.
I've noticed the Python solutions on the site are always blisteringly fast.

Can you locate the image using the physical path? i.e. create a image link on your page where the src points to the image? If you can't then you may need to verify the image location and name.

Try using the server.mapPath() method to point to the file location if this is a web project.
This will look for the folder and file in relation to its physical location to the root folder

Have you got your folder structure the same on your host as on your local machine?

You have already stored the UserType from the first read of the dataReader so the second attempt is unnecessary. Simply use a switch statement to check the value held in UserType and redirect as need be.

switch(UserType) {
    case "S":
        redirect...
    case "A":
        redirect...
    case "P":
        redirect...
}