how to get cell value of spread in desgin time added record in c#.net window Application

Posted by: sanjay18 on 8 September 2017, 2:21 pm EST

  • Posted 8 September 2017, 2:21 pm EST

    Hi,


    I have Added record in spread design timeIn spread i added stored procedure name in spread .i want to get that storedprocedure from spread and i want get that procedure code from database after that storedprocedure convert into textfile in button click event in C#.net window Application.


    simply I want get stored procedure from database and convert that procedure in textFile in Button Ckick event in C#.net window Application.


     


    Please reply me,


    Regards,


    Sanjay Chaudhari,


    Mumbai,


    India.

  • Replied 8 September 2017, 2:21 pm EST

    Sanjay,

    If I have understood your requirements correctly, then you are looking to retrieve the script inside the Stored Procedure (in the form of string) and thereafter set a particular cell text to this string.

    If this is the case then unfortunately I am not aware of how the Stored Procedure script could be retrieved. I would suggest you to please search on MSDN regarding the same.

    Once the string has been retrieved then you can use it to set Cell's text as:

    fpSpread1.ActiveSheet.Cells[Row, Col].Text=strStoredProcedure;

    Thanks.

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels