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

More Search Options

RSS Available

• Re: Is there an XMLRoleProvider and XMLMembershipProvider out there?

  Very nice velio.ivanov, very nice. Thank you!

  Posted to Security (Forum) by Simon Deshaies on 4/10/2009

• Re: How To: Connect to SQL using C# and SELECT INSERT UPDATE ?

  clownshoes2009, Do you load your data on the page_load. If so when you post back it load the page_load before it gets to your call. Using ASP.NET control is always complex since they behave unexpectedly. Regards, Simon

  Posted to Tips & Tricks (Forum) by Simon Deshaies on 4/6/2009

• Re: How To: Connect to SQL using C# and SELECT INSERT UPDATE ?

  [quote user="clownshoes2009"]System.Data.SqlClient.SqlException: The data types text and nvarchar are incompatible in the equal to operator.[/quote] It means that somewhere in your code you try to assign a text to nvarchar SQL types. This is either when you assign the parameter in the SQL command or it's at the SQL server, you try to assign a typed nvarchar value to a text column. This is what I can think of, you need to run in debug step into and try to execute your query directly

  Posted to Tips & Tricks (Forum) by Simon Deshaies on 3/30/2009

• Re: How To: Connect to SQL using C# and SELECT INSERT UPDATE ?

  Hi clownshoes2009, What is your exception? You code seems good... Regards, Simon

  Posted to Tips & Tricks (Forum) by Simon Deshaies on 3/28/2009

• Re: How To: Connect to SQL using C# and SELECT INSERT UPDATE ?

  Hi phoebe_ph, The VB you posted is not valid... can you give us the whole method/function/sub ? Thanks, Simon

  Posted to Tips & Tricks (Forum) by Simon Deshaies on 3/26/2009

• Re: How To: Connect to SQL using C# and SELECT INSERT UPDATE ?

  Hi Ranganayaki, What I would do is create a object that represent yout product. Query the database and create a generic list of this object. Then when you want to add a new product you call the Save method and in Save you check if product exist in database. Here is the example: 1 public partial class _Default : System.Web.UI.Page 2 { 3 protected void Page_Load( object sender, EventArgs e) 4 { 5 // get products 6 List<Product> list = ProductHelper.GetAllProducts(); 7 8 // cahnge first product

  Posted to Tips & Tricks (Forum) by Simon Deshaies on 2/13/2009

• Re: Can you access/store ViewState data in a Class Library referenced in a Web App?

  Thank you, indeed Session is the trick. HttpContext.Current.Session["SomeKey"] = "This String"; String SomeKey = HttpContext.Current.Session["SomeKey"].ToString(); It's a hash table of objects. Have fun!

  Posted to State Management (Forum) by Simon Deshaies on 1/18/2009

• Re: How To: Connect to SQL using C# and SELECT INSERT UPDATE ?

  I rewrote this class into one that implement the singleton pattern and it now closes itself. Read: http://weblog.simondeshaies.net/post/2008/11/How-To-Connect-to-SQL-Server-with-C-and-Optimize-Reusability.aspx

  Posted to Tips & Tricks (Forum) by Simon Deshaies on 11/16/2008

• Re: Error in stored procedure

  I tryed to reprodure your error. But it works for me. I created the table: USE [Test] GO /****** Object: Table [dbo].[flatsearch] Script Date: 10/04/2008 12:39:07 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo] . [sellproperty] ( [ptype] [varchar] ( 100 )NULL, [rate] [varchar] ( 100 )NULL, [location] [varchar] ( 100 )NULL, [region] [varchar] ( 100 )NULL, [area] [varchar] ( 100 )NULL, [areaunit] [varchar] ( 100 )NULL, [bedroom] [varchar] ( 100 )NULL, [features] [varchar

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Simon Deshaies on 10/4/2008

• Re: Server Error in '/Forum' Application

  ASP.NET makes sure the call comes from a form that was generated by the server. It's a security feature. You can disable it by setting enableEventValidation to false in the page declaration. But you will open a door to hackers. Or you can use the ClientScriptManager.RegisterForEventValidation method in order to register the postback or callback data for validation like the error message suggest.

  Posted to Web Forms (Forum) by Simon Deshaies on 10/4/2008