You searched for the word(s): userid:697314

More Search Options

RSS Available

• Re: reduce quantity from database

  You need to learn SQL. That's what you use to amend values in the database. UPDATE Products Set quantity = quantity-1 http://www.w3schools.com/sql/

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Mikesdotnetting on 11/23/2009

• Re: C# detailsview is not accepting one or other querystring

  If you are only passing one querystring value, the other will be null. By default the SqlDataSource control's CancelSelectOnNullParameter property is set to true, so the Select operation is cancelled when a parameter is null. Set it to false.

  Posted to Data Presentation Controls (Forum) by Mikesdotnetting on 11/23/2009

• Re: reduce quantity from database

  Update products set quantity = quantity - @quantity WHERE ProductName = 'hydrochloric acid'

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Mikesdotnetting on 11/23/2009

• Re: SQL Query Help

  I would definitely recommend using JOINS in your SQL. Here's a guide to how to do that using Sql Seerver Management Studio, although the Access Query Designer is very similar: http://www.mikesdotnetting.com/Article/72/Sql-JOINS-and-the-Sql-Server-Management-Studio-Query-Designer As far as your existing query is concerned, I suspect that it doesn't like the fact that you have used an alias in your WHERE clause. You need to reference the actual field name: SELECT Product.ProductID, Model.Model_Name

  Posted to Access Databases and AccessDataSource Control (Forum) by Mikesdotnetting on 11/23/2009

• Re: click button on another site

  [quote user="aspquestion"] user enters search keyword on the remote site and presses this button. when button is clicked a search list page appears. How can I pass the keyword? [/quote] You need to establish whether the search form makes a POST or GET request. A GET request means that values are passed in the querystring. You can see this with Google. All you need to do is formulate your own querystring to include the search word and make an HttpWebRequest using that. If it is a POST request

  Posted to Web Forms (Forum) by Mikesdotnetting on 11/23/2009

• Re: SQL Query Help

  SELECT tbl_product.product_id, tbl_model.model_name as model, tbl_frame.frame_name as frame, tbl_lens.lens_name as lens, tbl_model.gender as gender, tbl_model.extras as extras FROM tbl_lens INNER JOIN (tbl_frame INNER JOIN (tbl_product INNER JOIN tbl_model ON tbl_product.model = tbl_model.model_id) ON tbl_frame.frame_id = tbl_product.frame) ON tbl_lens.lens_id = tbl_product.lens WHERE tbl_model.gender="Female";

  Posted to Access Databases and AccessDataSource Control (Forum) by Mikesdotnetting on 11/23/2009

• Re: Database Design - Tag Clouds

  [quote user="Meltdown"]Aren't tag clouds inherently bad design; they break one of the most basic rules of normalization, repeating data…over and over![/quote] Not really. It's a normal one to many relationship. [quote user="Meltdown"] Tags are essentially allowing users to filter data by single criteria, but what if I need more than one criteria? Example: We have stories tagged as "yellow", but is that a "yellow rose", "yellow dress" or yellow

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Mikesdotnetting on 11/23/2009

• Re: SQL Query Help

  I would always use JOINS. As to the difference between them, I'm not sure. A colleague of mine thought your initial effort might be prone to error in certain circumstances (he said if more than one row was returned in a sub-select) but I can't say I have ever experienced this, mainly because I have never used that approach. Maybe someone else has some insight to offer?

  Posted to Access Databases and AccessDataSource Control (Forum) by Mikesdotnetting on 11/23/2009

• Re: JavaScript and Print

  You will need to regenerate the table, as the pages of data that are not displayed do not exist, as far as the browser (or javascript) is concerned.

  Posted to Client Side Web Development (Forum) by Mikesdotnetting on 11/23/2009

• Re: SQL Query Help

  [quote user="Zamma"]I think I just need to get my head around JOINS a bit better[/quote] Use the tools that are available to you (the Access Query Designer) to create your SQL. Study the results and learn from them.

  Posted to Access Databases and AccessDataSource Control (Forum) by Mikesdotnetting on 11/23/2009