Yes thank you, i found a solution! It is more a SQL problem! than something with web-development! Only it is not that easy anymore to change our collation of SQL-server because DB is standing in Correct collation mode... But hey, we will find something! thanks!

Hi, I have a website with some inputboxes! (the site is multi-language! French-Dutch-English) Now i want to add an address in my site wich is stored in SQL-server but the address is in Slovakia ... poisťovňa when pressing insert it gives me --> poisovòa on my listview when i try to remake this on my test site it is all correct! The special characters in SQL are stored like AsCII code and in my listview on my website it is displayed perfect! --> So when i insert manually the perfect ascii code in SQL it is displayed also perfect on my production site! - Is it some problems with code page? on the webserver (W2003) - has it something to do with sql? - Regional settings on webserver - ASP.NET settings? - IIS settings? - other problem? I do not know where to look anymore! I cannot see a difference between settings on code page, IIS settings, SQL between test and production! Or i must over look something! Kind Regards, A.

thank you all, it has something to do with Parameter Sniffing! It explains a lot! Is this the best practice? to disable parameter sniffing? Thank you

I can run it a 1000 times! the difference is: the first one with local variables: I get a result in 5 seconds. the second one without local variables: I get a result in 20 minutes!!!! Thank you

CREATE PROCEDURE sp_Get_Borderel_4d_data @MaatschappijID numeric, @VervalDatum datetime, @LanguageID char(1) AS DECLARE @MaatschappijIDLoc numeric DECLARE @VervalDatumLoc datetime DECLARE @LanguageIDLoc char(1) SET @MaatschappijIDLoc = @MaatschappijID SET @VervalDatumLoc = @VervalDatum SET @LanguageIDLoc = @LanguageID SELECT Agent.AgentID, Agent.Naam AS AgentNaam, ProRataDetail.InternPolisNummer, (sum(ProRataNettoPremie) - sum(ProRataCommissie)) AS Techpremie, sum(ProRataNettoPremie) As ProRataNettoPremie, sum(ProRataTaksen) As ProRataTaksen, sum(ProRataBrutoPremie) As ProRataBrutoPremie, sum(ProRataCommissie) As ProRataCommissie, sum(ProRataBeheerskosten) As ProRataBeheerskosten FROM fn_Get_ProRataDetail(0, '{00000000-0000-0000-0000-000000000000}', 0, 0, @MaatschappijIDLoc, @VervalDatumLoc, @LanguageIDLoc) as ProRataDetail LEFT JOIN Polis ON Polis.PolisID = ProRataDetail.PolisID LEFT JOIN Klant ON Klant.KlantID = Polis.KlantID LEFT JOIN Agent ON Agent.AgentID = Polis.AgentID WHERE Polis.Demo <> 1 GROUP BY Agent.AgentID, Agent.Naam, ProRataDetail.InternPolisNummer ORDER BY Agent.Naam, ProRataDetail.InternPolisNummer GO ---------------------------------------------------------- CREATE PROCEDURE sp_Get_Borderel_4d_data @MaatschappijID numeric, @VervalDatum datetime, @LanguageID char(1) AS SELECT Agent.AgentID, Agent.Naam AS AgentNaam, ProRataDetail.InternPolisNummer, (sum(ProRataNettoPremie) - sum(ProRataCommissie)) AS Techpremie, sum(ProRataNettoPremie) As ProRataNettoPremie, sum(ProRataTaksen) As ProRataTaksen, sum(ProRataBrutoPremie) As ProRataBrutoPremie, sum(ProRataCommissie) As ProRataCommissie, sum(ProRataBeheerskosten) As ProRataBeheerskosten FROM fn_Get_ProRataDetail(0, '{00000000-0000-0000-0000-000000000000}', 0, 0, @MaatschappijID, @VervalDatum, @LanguageID) as ProRataDetail LEFT JOIN Polis ON Polis.PolisID = ProRataDetail.PolisID LEFT JOIN Klant ON Klant.KlantID = Polis.KlantID LEFT JOIN Agent ON Agent.AgentID = Polis.AgentID WHERE Polis.Demo <> 1 GROUP BY Agent.AgentID, Agent.Naam, ProRataDetail.InternPolisNummer ORDER BY Agent.Naam, ProRataDetail.InternPolisNummer GO -------------------------------------------------------------------------- Why is the first procedure, faster than the second? The ony difference are the extra local variables! thanks, A.

Hi, i have a question about DataGridView in VS2005! So i bound my DatagridView with Data through a Stored Procedure in SQL the last column of my grid is a checkbox! The user scrolls through the gridview and checks everything he needs... at the end of my form i have a button, when i click this button i need the checked rows from the datagridview in my further program! So i do not need to update my Database or tableAdapter, i only need the rows, which are checked! Can anybody help me, don't know where to start and don't do much of programming... Thanks A.

Ok, thank you but i want to put this in a stored Procedure... So i can call it from out of a program! A.

Helo, Can anybody help me! I have 3 tables first 1 have a header table with one row the second table are all the data records and the third is a trailer table! So now i want to create 1 file with all the fields of the header table separated through ; then new line, the data table with the fields separated through ; and finally the trailer table with fields separated through ; i think i can do this with Bcp utility or something like this, but i don't know how! Please help! Thank you

Thank You, I was looking way to far, for a solution...

Hi, I have 2 Tables with each his own columns but they have both 1 identical column I want to make a 3th table with the identical columns in but not twice the same! For example: Table 1: ID1,Title,pages Table 2: ID2,Title,Author Table 3: ID3,Title (but when my title is the same in table1 and table2 i only want to insert it once) So i thought, I insert whole table1 in table3 then with a cursor, run through table2 and if i don't find the value in table3 insert Title from table2 in Table3 Is there another work around? Thanks, A.

Hi, I would like to use MS Word in my application. I 've designed in WORD a Dot File, which uses a merge function, is fill some fields in this document from SQl-server! I want to use this document in my application, so the user pushes a button that call's the document and fills it with the correct data out of sql-server! Something like a merge you do in Word but then from out of my application just call the letter and data and merge them! So i have a list of maybe 100 of the same pages but only different data on it from Sql-server! How do i do this?

The 'Old' DataGrid ?

No other Solution? I don't want the third party grid! But thanks anyway A.

It is all with dataset but i have tableAdapters so how do i fill my dataset with correct data throug TableAdapters? The relationship is already created between my tableAdapters! i can use My tableAdapter as well to fill a datagrid, why change to a Dataset? A.

Hi there, could anyone help me start with this: don't know where to look or start I have 3 tables which i want to show in a datagrid --> Parent First row = Customer name + child first row totalsum of orders for this customer + ChildChild First row = Detailed orders for this customer With a + or - button to click open or not I also work wit *.xsd scheme tableAdapters,... already have a relation between those tables But then i'm stuck Please get me back on track... If i read everywhere it's all in ASP.net with dataset and thinks like that... But i don't know how thhat helps me... thanks A.

I would like to have something like this! but how should i begin, can anyone put me in the right direction...

Hi, In my Webapp. i want the user to type in some fields (textboxes) press the add button. Then directly is has to be seen in gridview, datalist,... At the same time the textboxes are made empty and i can type in new things in those textboxes, press the add button again --> clear textbox, add new line at grid... How do i have to start,... Is there maybe a better way to display something like this,... Thanks A

Hi, I want to make a simple document system. But i don't know what to do store my files in SQL or store a little XML in the table 1. Store the whole file in the DB (like a BLOB or something like this) including other columns (title, little explanation, author, date,...) 2 Store a little XML file in the DB with a filepath to the file but in XML all the metatags like the columns in point 1. I don't know which is the best choise!!! Ok, i shall restrict the files to a max of 10Mb. for versioning - The XML solution is maybe better? Searching goes faster in ...? performance...? size of DB I think it will grow rapidly? Security easiest in which solution? Can anyone put me in the right direction!!! Please what do you think

Never mind I solved it myself! When i put off the Acceptbutton property of the form it was OK! Thanks Anyway A.

Hi, I used this: Private Sub TextBox1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TextBox1.KeyPress If e.KeyChar = Chr(13) Then 'event End If End Sub --> but it didn't work in my application is there some property of the textbox that must be true or false to use this? I can hit any other key and it works fine but when i hit enter he does not go to this procedure I use VS2005 what could i do, please help? Thanks Alwin