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

More Search Options

RSS Available

• Re: Problem with .dbml files

  Like David and the article points out, it is probably a bad idea. Saying that, I ran into the same problem. I had 2 datacontext that were separate but shared one table. To keep them separate I renamed the table in the second datacontext. for example table user became table adminuser in the second DBML and that worked.

  Posted to Data Access and ObjectDataSource Control (Forum) by grbourque on 8/16/2009

• dragging SP onto DBML design sapce

  Using LINQtoSQL and I had 3 stored procedures that I wanted to add to the datacontext. One went first time, second went after a couple tries. The thrid I can not get it to show up for the life of me. I have ran the sprocedure in SQL server management studio and it ran fine. I have double checked to make sure the data types are correct. once in awhile it gives me a timeout error, but mst time the hour glass just goes away and nothing shows up. I have rebooted, refreshed and reset internet connection

  Posted to Data Access and ObjectDataSource Control (Forum) by grbourque on 8/16/2009
  Filed under: linqtosql spoc

• Re: dragging SP onto DBML design sapce

  Yes I have. I have even deleted the dbml and started from scratch. Built the solution, no erros, no warnings. Still won't let me add this stored procedure. ALTER Procedure [dbo].[KD_VendorAdd] ( @VendorName nvarchar(50), @Address1 nvarchar(50), @Address2 nvarchar(50), @City nvarchar(50), @State nvarchar(50), @Country nvarchar(50), @Phone nvarchar(50), @Website nvarchar(128), @notes ntext, @VendorAvail int output ) AS IF EXISTS(SELECT 'True' FROM KD_Vendor WHERE VendorName = @VendorName

  Posted to Data Access and ObjectDataSource Control (Forum) by grbourque on 8/16/2009

• Re: dragging SP onto DBML design sapce

  Yes I ran the SP in SQL management studio 3 times. The first 2 times it added the vendor and the third time I ran it I put the same vendor name in and it returned a -1 like it is suppose to.

  Posted to Data Access and ObjectDataSource Control (Forum) by grbourque on 8/16/2009

• Re: dragging SP onto DBML design sapce

  I can not write the code yet, because I can not get this to be a part of the datacontext, so there is nothing to reference. I have another that is basically the same and i can put that one into the dbml. The structure is the same, only the table referenced is different and the parameters. I will play with it a bit more then I will find a work around for it, like making 2 calls to the database which I don't want to do, first call to check to see if it exist and if not then insert, and not use

  Posted to Data Access and ObjectDataSource Control (Forum) by grbourque on 8/16/2009

• Re: Stringformate to LINQ

  I have never used linq to MySql either. What version of MySql are you using? If it is 5.0 or higher I think that supports stored procedures. I use MSSql but I have a couple queries along the lines you are looking for. What I did was setup a stored procedure that would look at all the variables on my form. For example on the date part I had something like the following. WHERE (Date >= @var1) AND (Date <= @var2) AND (City LIKE @var3) Now if they choose a city it comes back with only that city

  Posted to ASP.NET MVC (Forum) by grbourque on 5/29/2009

• Re: Change current culture

  Glad to help. What you will find is that if they enter the site in french as set by browser, they hit the english link, it will carry that english through to all the pages they view because in the new method of each control it checks the session lang setting. So all the pages are in english until they exit and then return, or hit the french link again. Someone talked about setting cookies, I guess it could be done the same with cookies until you run into a person that has cookies turned off. might

  Posted to ASP.NET MVC (Forum) by grbourque on 5/27/2009

• Re: Change current culture

  [quote user="MeByMySelf"] Hi grbourqu, Can you please post your controller action that sets the language and redirect back to the same page? [/quote] This is located in the home controller. Remember that I use _ES.Lang is a property that points to session("Lang"). Sub Lang( ByVal id As String ) _ES.Lang = id Dim returnurl As String = Request.UrlReferrer.ToString Response.Redirect(returnurl) End Sub

  Posted to ASP.NET MVC (Forum) by grbourque on 5/27/2009

• Re: Change current culture

  [quote user="MeByMySelf"] I am using <globalization culture="auto" uiCulture="auto"/> in web.config and it working just fine without any HttpModule, action filter or overriden method on a base controller. But I ma still having troubles creating the links. They should not redirect user to any other page just set the selected language and refresh the CURRENT page. There is tons of web sites in the Net that do that. I cannot believe that this should be so difficult

  Posted to ASP.NET MVC (Forum) by grbourque on 5/26/2009

• Re: Change current culture

  I ran into the same problem. I could get it to work automatically off the browser settings or by the click of a link. I had trouble getting the 2 to play good together. Here is how I solved that problem and it might not be the best but it works. First the downside to my solution. It looks at browser setting at session start. So if you go in and change you setting and hit refresh, it will not update the language on the page because it only looks at browser settings at session start. Second I do not

  Posted to ASP.NET MVC (Forum) by grbourque on 5/25/2009