hericles

A trigger to do what? Its hard to give a code example when its not clear what you want. The basic trigger statement looks like this: [CODE] CREATE TRIGGER schema.trigger_name BEFORE or AFTER or INSTEAD OF DELETE OR INSERT OR UPDATE ON schema.table_name ... [/CODE] if you intend you use …

I take it you are referring to two database tables, True_False and True_False_Details? If they share a common column (like seqNo) just structure an SQL statement that merges the results from the 2 tables. [CODE] SELECT tf.question, tf.level, tfd.answer FROM True_False as tf JOIN True_False_Details as tfd ON tf.seqNo = …

Does the other site have an API you need to interact with or are you hoping to send the data to the login page of the second website? If the other site doesn't have the required functionality built into it you may not be able to log in except at …

Hey, Can you post up all of the code? I think there is something wrong beyond what you posted here.

Hi, I can see some issues with your lowest and highest functions. Your loop structure is wrong. [CODE] Function GetLowest(ByVal entries() As Integer, ByVal SIZE As Integer) As Integer Dim index As Integer Dim lowest As Integer = 0 lowest = entries(0) For index = 0 To entries(SIZE) If entries(index) …

Hi, Insert commands generally look like INSERT INTO table VALUES(value1, value2, value3, etc) WHERE so criteriais true So, in your case, you would have something like this: [CODE] Dim cmd As New OleDbCommand cmd.Connection = connection cmd.CommandText = "INSERT INTO tableName VALUES(?,?, ?)" Dim para1 As New OleDbParameter Dim para2 …

Hi, On the New button set causes validation to False. That will turn stop that button performing any validation when clicked.

Hi, I'm a little confused but do you need to send an actual aspx page (with code behind) via email to users of your website and then expect the dowloaded page to work when the user saves it and opens it? How can you be sure the user can run …

What Mitja means is that you can easily select the connection string you want to use (and therefore what database you connect to). A drop down box would work for example. All you need is a way to alter which connection string you are referencing at run time.

Hi, Create a loop that runs through the dropdownlist items. Like so: [CODE] for(int i = 0; i < dropdownlist.items.count; i++) { // access each item and do something with it via // dropdownlist.items[i].ToString() or whatever suits } [/CODE] Hope that helps,

Hi, SELECT * FROM purchases WHERE client = 'George' and date >= some_date and date < some_other_date; Obviously change your table columns to suit but that should work for you.

Hi, This line Year = Int32.Parse(input); is crashing because you are trying to parse letters (non-numeric characters) into an integer. This isn't going to work. A string would have to contain only the digits 0-9 (any number of them) to be parsed to a integer. Your simplest solution is to …

Exactly the same? With custom errors on you would see a basic message telling you that the details are hidden because custom errors is off etc. With custom errors off you should see a lot more information, specifically in red at the top of the page a detailed error message. …

Hi, C# is one of the languages you can program in using ASP.Net, the other is VB.Net. They both achieve the same thing as they compile the same. Your other main options include Java (JSP's) and PHP, especially if you want to use linux. The real question is what are …

Is this a website you have developed? I don't get an error in FF but in IE I get an error saying ASP.Net AJAX client side framework failed to load and then 2 more saying 'Sys' is undefined. Some code around the error would help.

Hi, You will want to have a look at the ScriptManager.RegisterStartupScript() function. You can assign your javascript code via this method to the updatepanel and then it should fire everytime insteadof just on a full page load. Hope that helps,

Hi, I'm guessing it wouldn't really work but I've never tried it myself. I think you would need to break up the datagridview too much for it to still work. Up and down arrows aren't an option? That probably isn't as user friendly as you had in mind though. Hope …

The general SQL formual is: SELECT SUM(expression ) FROM tables WHERE predicates ORDER BY predicates; So, in your case, you might want: SELECT transaction_id, SUM(amount) FROM mytable ORDER BY tranaction_id You may or may not want the transaction_id as a SELECT column. You can just take it out if you …

You could always change your code to be: [CODE] Catch ex As Exception MsgBox(ex.Message) Finally [/CODE] to actually see what exception is being caught.

We will need more information than that. What exactly are you stuck on? Have you got any code done that maybe causing a problem? If you are after general help about payment portals (such as PayPal, NoChex or something similar) I would suggest reading their documentation first.

You could consider using a linkbutton. Then you can pass the gallery id via the command argument of the link button. [CODE] <li class="gallery"> <a style="text-decoration:none;" href="galleryData.aspx?gallery_id=<%#Eval("gallery_id") %>"> <img alt="<%#Eval("gallery_name") %>" style="border:0px;" src="photo_load.aspx?gallery_id=<%#Eval("gallery_id") %>&thumbnail=1" /> <span class="below-image"><%#Eval("gallery_name") %></span> </a> <asp:LinkButton ID="LinkButton1" runat="server" CommandArgument="<%#Eval("gallery_id") %>" onclick="LinkButton1_Click">LinkButton</asp:LinkButton> </li> [/CODE] And then in …

hi, This SQL query will help you [CODE=sql]SELECT count(*) TABLES, table_schema FROM information_schema.TABLES WHERE table_schema= 'YOUR DATABASE NAME' GROUP BY table_schema[/CODE] It gives the number of tables in the database you specify. Worked for me:)

inside your checkbox_CheckChanged method do this: [CODE] if(checkBox.checked) { button1.enable = true; or button1.visible = true; } else { button1.enable = false; or button1.visible = false; } [/CODE] Thats c# code anyway. You get the idea

What on earth is this? A table of contents? You can benefit from our help better if you actually phrase a question...

Hi, I'm with adam_k; why isn't a new table per user being used instead of an entire new database per user - that seems excessive. If you do need different tables you will need to figure out a naming strategy that will create unique names (but still following some set …

Hi, You'll want to look into using a hash function against the entered password and then saving the hashed version in the database. Then, on logging in, hash the supplied password and check it against the hash in the database. Check out tutorials for MD5 and SHA1 online

First question is - are you sure the reader is holding more than 1 row? If not, that would explain the single loop.

I think correct indenting is easier to understand than the numbers beside them and is a habit you should get into. Other coders will expect to see it.

Reply to what? All you did was post up some code without a question...

Hi, With no code to go on I'm speculating but have you got the code to upload the file in the Page_Load method? if so, and you don't want the action repeated, you need to put the code inside of if(!Page.IsPostBack) { // your code } This means your code …

Basically you are holding two versions that are the same in the GAC and windows is confused as to which one to use. Look here for a solution: [url]http://dotnetfish.blogspot.com/2007/09/type-xxx-exists-in-both.html[/url] Did you try google before posting this? Took me 20 secs.

Definitely is possible but its a javascript thing not an asp.net thing. Look into jQuery, I think that was the library I used when I put it into a project. You would probably need to call the javascript from .net if you are using AJAX for page refreshes. I found …

Are you asking for the SQL command text that extracts the price and image url using some filter as parameters? If yes, and assuming you use the stock code to find the product you would do this: I'm using MySql as you didn't specify the database you are using. [CODE] …

Everytime I have had this error (usually moving my project to a production server just like you did) it is always because I haven't updated the connection string in the web.config to point to the new database. Or it could be the database hasn't been created on the production server.

This isn't recursion at all. Recursion is the act of a function repeatedly calling itself until its task is done. In your example, if you wanted to fill an array of length 10 with the letter X then you would have a function: [CODE] fillArray(string x, int i) { a[i] …

Hi, Clear out your listbox before you start adding the files to it [CODE] ListBox1.Items.Clear() For Each file In ftpFiles ListBox1.Items.Add(file) Next [/CODE] This empties the list of the previous inputs so when you reload on the page refresh the previous items aren't doubled up. ListBox1 holds its contents through …

Hi, I wouldn't make hitting the enter key tab the focus to the submit button because all the user is going to do is hit the enter key again (being unaware that the use of it is not allowed in the textbox) thereby submitting the unfinished textbox. You could look …

Hi, I would avoid making the database connection global to your application. One way to achieve what you are after is to create a database that creates the connection for you. Then when you need to access the database, instantiate the database class and use the connection it provides. I …

Hi, What browser are you seeing this in? I just copied this code and tried it in IE, FF and Chrome and it looked OK in all of them.

Hi, It appears you are missing the UpdatePanel and ContentTemplate required to show which parts of the page are updated by the AJAX request. Change your code to this and it should help: [CODE] <asp:Panel ID="bt" runat="server"> <asp:ScriptManager ID="ScriptManager1" runat="server"> </asp:ScriptManager> <asp:UpdatePanel runat="server" id="updatePanel1"> <ContentTemplate> <asp:Timer ID="Timer1" runat="server" OnTick="tick" Interval="50"> …

The developer APIs for Facebook and Twitter can do a lot of things. They'd be a good place to start. 30 secs on Google told me it is possible to update Facebook status via their API.

Hi, I'd use an image, unless you intend for there to be text on the lines that is following the curve. Twiss's comments above won't help you as he ignored the changing line ends give the curve you have in your code.

Hi, The only place you're using an integer that cause the out of range exception is when you refer to field(1) or field(2). So I would check that your field, when split on the comma character actually has 3 resulting splits e.g. 2 commas are in the initial line. Otherwise, …

Hi, To check something has been entered in the new and confirm textboxes use a required field validator on both and a compare validator on one (to make sure the text entered in it matches the text entered into the other). These validators will validate when the button is clicked …

Hey, I've been working on a product display page that lists product info and images via a repeater control. That all works fine. What I'm doing now is adding some new functionality that uses a link button to send the product code clicked on to the server (via AJAX, to …

Hi, I've just downloaded GNUstep onto my Vista machine, installing the GNUstep MSYS System, GNUstep Core and GNUstep Devel components mentioned on theGNUstep website ([url]http://www.gnustep.org/experience/Windows.html[/url]). I installed into the standard folders but when I try to open the shell for GNUstep the window flashes up and disappears again. I've checked …

Hi, I'm having trouble getting the Ajax Toolkit autocomplete extender to work. I have the web service set up as its own file in the same project and calling that alone works - the correct list of results is output as xml. But when entering text into the textbox nothing …

I take it you want the text to be over the image and larger. You can add the text to the image and still use roll overs if you want. Or you can use the background0image property of the div to have your text in a div and the image …

you seem to have a 50 element array and your loop is running from 0 to 49 (50 elements) but you're only selecting the top 49 in your SQL statement. Is the last iteration of the loop the problem? What point does it break at if you debug it?

Hi, It sounds like you need to use a Windows service. These run behind the scenes and have no windows or forms to display (usually). They can run at start up if needed. Is that what you are after?