AleMonteiro

The problem is making a loot of separeted querys, that's not good. Always go for the least number of database connections possible. Try like this: SqlCommand sc = con.CreateCommand(); sc.CommandType = CommandType.Text; int i = 0; string sql = string.empty; foreach (DataRow row in dt_blah.Rows) { // Use ´i´ to …

There is no static guide for DB options, it all depends on your utilization of the engine. I found [this PDF](http://www.google.com.br/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&ved=0CCsQFjAA&url=http%3A%2F%2Fbradmcgehee.com%2Fwp-content%2Fuploads%2Fpresentations%2FBest_Practices_Every_SQL_Server_DBA_Must_Know_Pensacola.pdf&ei=2CVAUY-LM5KM9ASV2YCIBw&usg=AFQjCNEQLBQDyvlt67AufQFpxx9e7whyLA&bvm=bv.43287494,d.eWU) very usefull. You should also check this microsoft page: http://technet.microsoft.com/en-us/sqlserver/bb671430.aspx

I don't know how this is implemented inside the site, because I don't know Wordpress. But the functionality itself is just some images exactly positioned and in each step that you choose something the image source is changed. The JS implementation is very simple, the hard work is creating the …

Hi JorgeM, nice job, very small code. I took the liberty to change a few things, hope you don't mind. This is a version with just a small code ajustment: http://jsfiddle.net/grFQp/5/ And this is a version with a closed scope, so it could be easy of use, without worring about …

To check if a database exists, use this select (from [here](http://forums.mysql.com/read.php?101,213455,213496)): SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'DBName' If it doesn't exists, execute the creation script.

I'm not sure, but try like this (it may have syntax issues): SELECT SUM( ct.num_prod ), mc.catagory_name FROM ( SELECT COUNT(`product_id`) as num_prod, sub.category_id as cat_id FROM `product_table_1` as p INNER JOIN fm_product_sub_category as sub ON ( p.sub_cat_id = sub.sc_id ) GROUP BY sub.category_id UNION ALL SELECT COUNT(`product_id`) as num_prod, …

If the page use jQuery Ajax you could set up an global event handler and run your function after the events: http://api.jquery.com/category/ajax/global-ajax-event-handlers/ Another option is to set a timer(setInterval) to run your function periodically.

If you just want to display the data the same way you got it, I suggest you use the WebBrowser component to display this exatcly HTML. If you really want to extract the data from the HTML, manipulate it and display it on your own component, then I suggest you …

I know MySQL Browser, but you have to write the querys your self.

You can use XmlDocument to parse your xml string and use it to go throw it. See this example: http://www.csharp-examples.net/xml-nodes-by-name/

You didn't say what the problem is.

Post your `addResizeFunctionality();` function

It's not possible, but you could do it from code. This is not an working code, just the logic idea: string strConn = @"Data Source=$(MyDocumentsFolder)\My App\MyAppDatabase.sdf"; string strFlag = "$(MyDocumentsFolder)"; if ( strConn.IndexOf(strFlag) > 0 ) { strConn = strConn.Replace(strFlag, Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData)); }

I sincerely don't know the cause for your problem, but when the problem occurs you can try somethings: -> Stop and Start the MySQL Service (run -> net stop mysql; net start mysql) -> Force kill MySQL ( run -> taskkill /IM mysql.exe /T /F) -> Restart IIS ( run …

What you got so far?

The first thing that I'd look into would be startup programs. Run -> msconfig -> Startup tab

I did this exatcly same thing, but not for a blog, it was to an commercial building security system. So they can register anyone who enters the building. I used Android 2.0 and C# 3.5 on the server side. It's not that difficult and I could share the code if …

Using AsyncTask you can only update the UI(the ListView in this case) on the `onPostExecute` method. And inside `onPostExecute` you can call `getApplicationContext()` to get the context.

I think this should work: SELECT relfirstname, rellastname, relrel, count(*) AS kamote FROM RelativeTable WHERE effectivedate = '" & frmNew.DTPicker2.Value.ToString() & "' AND empnumber = '" & frmNew.empnotxt.Text & "' GROUP BY relfirstname, rellastname, relrel

I think that one of the most rewarding badges would be Post Quality Score.

Just use `(assets.Quantity * stock_names.value) as Total`

I'd say that the first on consume less resources, but the second is more reliable. And I will suggest a third: - Delete only the records that will no longer exists - Update the records that already exists but need to be updated - Insert the new records The implementation …

Please, post your AJAX request so we can analyse it.

You should debug and see if the line `Response.Redirect("admin/default.aspx");` is being executed. If it is being executed, I'd guess that something on admin/default.aspx is redirecting back to the login.aspx.

I've used HightCharts with .NET with great success and I recommend it. To obtain sofisticated user experience I suggest requesting data with AJAX in JSON format. The JS parser will be easy and fast. This way it's possible to achieve drill down funcionality that is really something else =)

Please post a picture from your database diagram, so we can know how your database is structured. For what I deduced, your select will return for each post 3 records, one for each tag. So, if you have 10 posts and 3 tags, it will return 30 records.

Big and complicateds softwares are nothing more than small pieces of code put toggether. In my opnion, being a programmer is one thing, being a software developer is something more. You need to have the vision of what group of small pieces of code put toggether will achieve the funcionality …

DateDiff returns an Int not an BigInt, that's why you get the error. One work arround is to get the minutes and then multiple by 60, to get the seconds, like this: `ABS(CONVERT(BigInt, (DateDiff(minute, grn_date, getDate()))) * 60)` I found the answer in this forum: http://www.sqlservercentral.com/Forums/Topic964359-392-1.aspx And here it's a …

Hello guys, I'm in need of some thinking help. I want to build an auto-complete text input to find cars, but I want it to search for Car Models and Car Manufactor too. In example, if the user type 'For', the suggestions would be 'Ford - Car 1' 'Ford - …

In your gridview itemtemplate button, you should add the commandArgument, like this: `<asp:button .... CommandArgument='<%#Eval("UserId") %>' />` Then, in the BackEnd, on your RowCommand event, you can get the userId like this: `int UserId = int.Parse(e.CommandArgument.ToString())`

Check this sample, I got it from Google Maps Docs and just modify it a little bit: <!DOCTYPE html> <html> <head> <meta name="viewport" content="initial-scale=1.0, user-scalable=no" /> <meta http-equiv="content-type" content="text/html; charset=UTF-8"/> <title>Google Maps JavaScript API v3 Example: Info Window Simple</title> <link href="http://code.google.com/apis/maps/documentation/javascript/examples/default.css" rel="stylesheet" type="text/css" /> <script type="text/javascript" src="http://maps.google.com/maps/api/js?sensor=false"></script> <script type="text/javascript"> var …

Violet, good night. I openned your link in safari and I confirmed the error. But I didn't find anything that could resolve the issue. And in my opnion, I'd say this is working well enough. I wouldn't lost much of my time trying to solve this, if I were you. …

See the comments: $('.available, .unavailable, .selected').click(function(){ // Save the reference for better performance and cleaner code // Use $ before the name to identify jquery objects var $this = $(this), thisId = $this.attr('id'); // Instead of getting the attr class use the method hasClass() //var ID = $(this).attr('class'); if ($this.hasClass('unavailable')) …

I didn't understand what's your problem/doubt.

In my opnion, you can't let the end user change the database, NEVER EVER. Any and every change in the database should be done by the software, or only, in very specific cases, by the database administrator. In your example, you want to let the user change the description in …

I'd suggest you wrap the input hidden and the button in a <div> or <span>, that has an specific class(in this case I set as `cl_id`). The result should look something like: <div class="cl_id"> <input type="hidden" id="hdn<?php echo $cl_id ?>" name="hdn<?php echo $cl_id ?>" value="<?php echo $cl_id ?>" /> <input …

You forgot to call the `.DataBind()` method of your combobox. Without this it won't show the itens in the select. I made a few changes in your code, try it like this: Imports MySql.Data.MySqlClient Public Class MainForm Private Sub MainForm_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load Try Dim conn …

How are you oppening the popup?

Hi Violet. I'd use more like this: <html> <head> <title>test</title> <style> .theForm{ background-color:#f4f4f4; margin-top:14px; padding:25px 0 40px 25px; font-size: 0.875em;/* 14/16*/ color: #333333; } .theForm #email, .theForm #residence { width:52.33333333333333%; /* 314/600*/ } .theForm #theMonth { width:14.5%; /* 87/600*/ } .theForm #theYear{ width:14.5%; /* 87/600*/ } .theForm a#mandatory{ font-size:0.75em;/*12/16*/ } …

I suggest you do it like this: var Jspeed=200; //Global variables that I want to change var CSpeed=200; function changeSpeed(ClownSpeed, JuggleSpeed) { // This will get the values as string CSpeed = document.getElementById('txtClownSpeed').value; Jspeed = document.getElementById('txtJuggleSpeed').value; // Convert to int: it will throw error if the value is not an …

It's easier than you think... something like this: SELECT City, Count(CustomerId) as CustomerCount FROM ContactInfo GROUP BY City

Yes you can. You can make an entire mail client with C#. Take a look: http://www.codeproject.com/Articles/34495/Building-your-own-Mail-Client-using-C

http://support.microsoft.com/kb/308470 http://en.wikipedia.org/wiki/Comparison_of_C_Sharp_and_Visual_Basic_.NET Please google a little bit before posting basic questions like this. A simple search and you would have found those links. We are here to help and guide, not be your search engine.

You need to post your form and then get the value, something like this: Form: <form action="MyPage.php" method="post"> <select name="mySelect"> <option value="1">My First Option</option> </select> <button type="submit">Submit</button> </form> MyPage.php: $selectedOption = $_POST["mySelect"]; // Do something

Do you mean a database engine called Profile or a database profiler(tool for testing performance)?

This should work for removing one item at a time: `myListBox.Itens.RemoveAt(myListBox.SelectedIndex)`. If you want to enable mutiple selection/deletion you'll need to loop the `SelectedIndices` property.

As JorgeM and naphets said, the second <img> source is an php page, not an image. But just to make it clear, note that the point is that the php page returns HTML content. An url with .php extension could return an jpeg/bitmap content(when reading a image from a database …

Let's go to the points: 1. You need to wait until the DOM is loaded so you can get the reference of an object. // This won't work var movingBox = document.getElementById("moveBox"); var topOfBox = movingBox.style.top.value; // This should work var movingBox, topOfBox; window.onload = function() { movingBox = document.getElementById("moveBox"); …

I really don't have any idea about what a mdi is, but I'll take two huge guesses, maybe it'll help, who knows... 1. Does the mdi child form is transparent as well? 2. Maybe when the panel is moved, some event is fired and triggers an routine that updates the …

What's your problem about it? What doesn't work? Did you write anything yet?