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

More Search Options

RSS Available

• Sv: Re: Transfer from SQL Server to MySQL saving connection code to database

  I have been using code like this below: --------------------- public static DataSet GetChildrenForCategory(int categoryId) { string queryString = "SELECT * " + "FROM Category INNER JOIN Translation ON Category.NameId = Translation.NameId " + "WHERE (Category.ParentId = @categoryId)" + "ORDER BY Translation.Value"; string connectionString = ConfigurationManager.ConnectionStrings[db_connectionstring].ConnectionString; System.Data.IDbConnection dbConnection = new System.Data.SqlClient.SqlConnection

  Posted to MySQL (Forum) by fischer on 12/15/2005

• Transfer from SQL Server to MySQL saving connection code to database

  I found lots of info about this topic but much was outdated and some of it just didnt make any sence. I have a produced lots of code to connect to my SQL server used in Visual studio 2005. Now I decided MySQL will be better suited since I will deploy this later on and the cost will be reduced. Is there any way for me to be able to keep the code I have written to cennect to the SQL Server 2005 but changing database and connectionstring to MySQL? just changing the provider or something? (don't know

  Posted to MySQL (Forum) by fischer on 12/15/2005

• Running static object on server

  Hi. Sittuation: I have constructed a web page which is expected to get high number of visitors. The prefered language can be choosen by the user. It is both the language on the page as well as my dynamic lists stored in the database. My solution: Right now I have a table in my databse which holds keys and values for all the words and its trnaslations for each language. Everytime a page is loaded I will do around 20 calls to the database getting each translation. (I, as admin, will control each time

  Posted to State Management (Forum) by fischer on 12/9/2005

• Re: Setting enter key default button when login control and search button on same page!!!

  This works pretty good. Although I have one scenario when this doesn't work. I write wrong imput to the login and the validation control tells me I did wrong. I then type the right (or wrong) info and press enter again. This time the defaultbutton somehow was lost and the serchbutton (in my case an imagebutton) in master page is pressed instead. I have tryed many scenarios to find the error.. thought maybe had anything to do with client validation or something...

  Posted to Security (Forum) by fischer on 10/27/2005