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

More Search Options

RSS Available

• Re: Call stored procedure with parameters problem

  Yes, I've tried that code before, but it doesn't work for me. Normally the MySqlHelper.ExecuteReader() should execute that kind of code, so just have to give up connectionstring, stored procedure name and parameters. I can write something like this: MySqlHelper.ExecuteReader(_connStr, "call SL_GetAllByCatId(" + parameterValues[0] + ")", parameterValues); That will work, but just looks stupid :) And how do I know if it is a string, integer, ... I probably want to add more

  Posted to MySQL (Forum) by Dema on 10/16/2008

• Re: Call stored procedure with parameters problem

  Anyone who has a solution for this? I just want to call a stored procedure with parameters. There must be someone who knows how to do this?

  Posted to MySQL (Forum) by Dema on 10/14/2008

• Call stored procedure with parameters problem

  I have this stored procedure in my MySQL database: 1 DELIMITER $$ 2 3 DROP PROCEDURE IF EXISTS `loc`.`SL_GetAllByCatId` $$ 4 CREATE DEFINER=`admin`@`localhost` PROCEDURE `SL_GetAllByCatId`( in catid int ) 5 BEGIN 6 7 SELECT 8 * 9 FROM 10 localization 11 WHERE 12 catid = catid; 13 14 END $$ 15 16 DELIMITER ; Now I want to get a MySqlDataReader, so i call the stored the procedure and give up the parameter 1 MySqlDataReader dr = DataProviderHelper.GetReader( 2 "SL_GetAllByCatId" , 3 new MySqlParameter

  Posted to MySQL (Forum) by Dema on 10/8/2008

• MatchCollection duplicates

  How can i delete duplicate matches out of a MatchCollection? My code: Regex regexLinks = new Regex(@"http://([\w-]+\.)+[\w-]+(/[\w- ./?%&=]*)?"); MatchCollection urls = regexLinks.Matches(_text); So after this is done, i want to check if there are duplicates in the collection. If so, delete the duplicates.

  Posted to Web Forms (Forum) by Dema on 8/13/2008

• Re: Microsoft Excel object library COM component

  Thanx for the help.

  Posted to Enterprise Services Integration (Forum) by Dema on 2/21/2007

• Re: Microsoft Excel object library COM component

  I don't have excel installed so that is probably the reason why i don't find it? So i think i will do it this way: string strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Server.MapPath(".\\offertes\\" + strFileName) + ";" + "Extended Properties=Excel 8.0;"; OleDbConnection oleConn = new OleDbConnection(strConnString); oleConn.Open(); OleDbCommand oleCmd = new OleDbCommand("SELECT * FROM [Sheet1$]", oleConn); OleDbDataAdapter oleDta = new OleDbDataAdapter(); oleDta.SelectCommand

  Posted to Enterprise Services Integration (Forum) by Dema on 2/21/2007

• Microsoft Excel object library COM component

  I'm a beginner with asp.net, i program in c# I want read data from an excel sheet into a database, so i think i need the Microsoft Excel object library COM component, but i can't find it. I right click in the solution explorer on my project (c:\dotnet\...) en choose add reference, tab COM. But i don't see the component in the list. What i want to do is to read out the data line by line, cell by cell. Because depending on what data he finds, he has to do a certain action. So i think it will be the

  Posted to Enterprise Services Integration (Forum) by Dema on 2/21/2007

• Betreft: Re: Bug: <authentication mode="Forms"> ???

  Thanx, it works

  Posted to Cassini Sample Web Server (Forum) by Dema on 1/22/2006

• Re: Bug: <authentication mode="Forms"> ???

  i have a similar error as reinaut. My teacher has given us some solutions of asp.net excersises, but i can't watch them in internet explorer at home. this is the error: if you want a translation look at reinaut's post. Serverfout in toepassing /. Configuratiefout Beschrijving: Er is een fout opgetreden tijdens het verwerken van een configuratiebestand dat vereist is om aan deze aanvraag te voldoen. Raadpleeg de hieronder weergegeven details van deze fout en pas uw configuratiebestand overeenkomstig

  Posted to Cassini Sample Web Server (Forum) by Dema on 1/6/2006