hericles

I think books are much better than online tutorials. If you afford the cash look on ebay or amazon for some of the MCP or MACD exam books for .Net. They are used to study for the MCP exams obviously and they are very good are getting you beyond the …

Greek people must like exclamation marks!!!! Just kidding :) Are you asking for help because you are having trouble with part of it or do you not know how to begin?

What trouble are you having? From what I did see you don't really understand database connections and dataAapters. You set the connection string at the start of your class and then, for some reason, after opening the connection decide to set the connection object again. Which is doubly pointless because …

I'd check the values you are getting out of the data set (name, telephone, email) and confirm they aren't empty strings.

By isn't karth saying that values are getting stored twice? His problem, as I read it, isn't getting double values returned but getting repeat values inserted.

Hi, Use a switch statement to move to the correct option based on the user input (1-5) [code] switch (input) { case 1: // add address break; case 2: // remove address break; case 3: etc... } [/code]

OK, you'll have a database of course that contains the user name and passwords. You'll need to connect to that. On your page you have the textboxes for user name and password and the login button. The code for the button takes the user name and password and constructs an …

I'm not sure about this, and could easily be wrong, but I thought Google could read and crawl a javascript link but no weight was given to the link as it wasn't permanenton the page. As far as google's algorithm goes a javascript link doesn't provide a real indication of …

You have the basic elements in place. Are you getting any error messages?

Is the next page static (the url is always the same)? If yes, then wrap the image in an anchor tag. Other use an imageButton.

Is this of any help to you? [url]http://msdn.microsoft.com/en-us/library/bb483096.aspx[/url]

Try this code: DATE_FORMAT(date,format) So your code would look like DATE_FORMAT(date, '%d-%m-%Y') You can read more here: [url]http://www.w3schools.com/sql/func_date_format.asp[/url] Hope that helps,

How many active connections have you got specified. I would think increasing the size of the connection pool would help. Also, checking that the open connections are used as efficiently as possible; you want them returned to the pool the instant they are free.

With something like this: [code] DataRow newRow = dataSet1.Tables["Customers"].NewRow(); newRow["CustomerID"] = "ALFKI"; newRow["CompanyName"] = "Alfreds Futterkiste"; dataSet1.Tables["Customers"].Rows.Add(newRow); [/code] You add a dataRow to the existing dataTable and then specify what data you want to put in the columns. If you don't have columns specified like the example above you need …

In the onTextChanged event of the first text box (or all of them if you want to be really user friendly) split the string into 4 substrings, each 4 characters long. Then just paste each substring into the right text box. I wouldn't use the return key as a 'move …

Yes, you do use javascript - assuming the thefpl.co.uk URL in your image is your site. You have what looks like Google Analytics code but you have it in the header. It normally goes at the bottom of the page, right before the <?html>. I'm not sure if incorrect placement …

You are calling an insert operation on the data in the texbox - thats inserting into one row of the database (creating a new row as it is an insert, not an update) and then later you are calling the update on your data adapter. The updater is only updating …

Ask Google and you shall receive: [url]http://www.dotnetperls.com/treeview[/url] - simple tutorial which explains what you need

How accurate do you need it to be? You could break both strings into their separate elements and then match each one but that may not be very useful. If the user puts in an extra space but everything after that is OK, the match would report everything after the …

If you only return one row (and will only ever return one row) why don't you just use an image and label? That's about as simple as it can get.

Store the first input in a variable when the button is clicked and then disable the button. In the onTtextChanged function of the textbox check all new input and if it matches the saved variable do nothing, else re-enable (or make visible - enable is better) the button.

For a start you are using INSERT when you say you want to UPDATE. Insert puts a new row in the database table whereas UPDATE finds the current value and replaces it. And you don't seem to be calling the command on the database at all either. Yo haven't posted …

so you don't use AJAX at all? No analytics included? I don't actually see an attachment here... I just checked trade4traget.com, is that your site? Because there is javascript used on that page, including analytics. Table based layout too... haven't seen that for a while:)

I'd go for WPF too. My knowledge is pretty basic at this stage, I haven't devoted the time to learn it but the ability to really make the UI look how you want is a big plus. Winforms are pretty basic in comparsion.

Is the error coming from the ConnectDatabase() method? I wonder that because you don't pass the method the connection object and it isn't declared in the method. The method maybe in the same class as the connection object though, I can't tell. You can always debug your code and find …

How good is your regular expressions? Because that level of parsing is going to require some decent skills

try this: Process.Start("C:\Windows\Explorer.exe", "your image location")

Don't disable the back button unless you have a really good reason. Seeing as you seem to be doing it on the logout page, you can achieve the same effect through session state. If session state says user is logged out (you update it when they do log out) when …

I'd use a dataAdapter to pull out the information and a dataTable to hold it. Must easier to work with and insert to the email. Probably faster execution than a data reader too.

You are using HTML email for this? Because if yes, the formatting is reasonably easy. Use a table and some CSS in-line styling.

In your code you have this line: [code] if (cn.State == ConnectionState.Closed) [/code] but I can't see a section where you continue if the cn.State is open. Depending on whether you handled any other opening/closing of that connection you may have a problem (the two functions here look OK but …

Have a look at this post: http://dotnetref.blogspot.com/2008/05/keeping-vbnet-form-always-on-top.html The user there said they found a solution among what other people had posted. Apparently they used a timer to keep resetting the form's topMost property to true. Might work for you

You will need to be careful where you use the findControl though. If you are using it in Page_Load expect difficulties as the control may not have been created yet. I had this problem once and I had to force the control to load before using findControl. Just FYI.

Really? Store the current total as a variable. Add the value of the textbox to it and then output the new total to the textbox. If you're having trouble keeping the current total persisting (you don't mention if this is a webpage or not) use session state or a hidden …

Are you using the XML to hold data and need to put that data into your page? If yes, data tables can respond to XML just as easily as they use databases so you can use the XML as the data source for a repeater or grid view. Or do …

The easiest way to display the image would be to have a complete set of images that are each an increment of the previous one. e.g. head, then head and body, then head, body and one arm, etc. Then you just need to display one image or another to show …

get practice with string manipulation and regular expressions, you're going to need them a lot. You will need to open the css file as a stream, locate the id or class you want to edit or delete and make the changes to the stream or locate the place where you …

Um, yes. That is what the .Net part of the name means. Do you know .Net at all, played with a copy of Visual Studio? Open up google and type in asp.net tutorial. You'll find all the help you need.

Create a connection object with a valid connection string, and command object. Link the two and set your sql statement. open the connection, execute the query on the command object and close the connection. Like this: [CODE] Dim conn As New MysqlConnection('valid connection string') Dim cmd As New MySqlCommand() cmd.connection …

How can you update date that isn't in the database? Insert then update is probably better, assuming you aren't updating the information you just inserted because that doesn't make much sense (you'd just insert correctly the first time right??). In the posted code you have a mistake on line 4, …

You will need to add roles (unless that is what the type column already does) to your user database, admin, user, guest, etc. Then when a user logs in you check the role and apply the appropriate permissions to the menus.

wow, big question. Do you really expect one of us to hand you everything you need to do that? What have you done so far and do you need help with the database, the printing, the interface, etc?

What exactly do you mean by unique ID? Seeing you mention creating a record are you referring to when you insert the data in a database? As these are sub classes and inherit methods from the super class, any code that guarantees uniqueness should be handled in the super class.

A SQL connection string normally looks like this: Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword; I'm guessing you're failing at the point of opening the connection because the connection string is incorrect. You could always handle the exception to see what is really going on.

You might want to edit the post to remove your email and password...

Are you getting an error at the point of executing the query? Setting the SQL statement by the radio buttons is easy enough, I can't see what you're doing wrong there. You're not closing your connection when you're done either by the way:)

I don't really understand the question but if there are fields you need the user to complete use required field validators to make sure they are filled out. You can also use range validators and regular expression validators to check for the format of the input. Is that what you …

You need to call dataBind() on the GridView to actually make it display the data. All you have done is tell what its data source is. Also, you don't need to specifically open and close a connection for a dataAdapter, it takes care of that itself so you're using two …

Do you have a ThumbnailCallback function on your page? Going by the error message I'm assuming you don't. This MSDN post might help you [url]http://msdn.microsoft.com/en-us/library/system.drawing.image.getthumbnailimage.aspx[/url]

An older version of MySQL would work fine, the issue isn't what database you use but how you make the remote application update, unless I've missed the point of the exercise. I wouldn't think database speed would be issue, both MS SQL and MySQL are used as production servers for …