.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Execute a DLL function

Posted By:      Posted Date: October 12, 2010    Points: 0   Category :Sql Server

Good Day

i m trying to configure my SQL DB to call a COM+ DLL written in VB.
First i tested this using visual studio and this is the source code used in VB.net to execute this Funtion.

I add a reference to the COM+ dll and my code is as follows
Dim objBR As New FIBR.Director
Dim abcdef As String = "<?xml version=""1.0""?>"

View Complete Post

More Related Resource Links

Execute a function for specific time (not at specific time)


I have a function that does large amount of processing.

I just want that if it executes in specific time (say 10 min) then it should return "execution successful".

But if now then i want to stop the execution of that function and return "unsuccessful" and rollback my transactions.

Returning and rollback is fine.

But i dont know how to stop the execution of a function at specific time.

I am using asp.net with C#.

Any ideas would be really appreciated.


execute a javascript function in code page

I use js function in source page and call that js function as below in Source page<a href="javascript:;" onclick="openwin('Sample.aspx?DID=<%#Eval("UID") %>', '', '700','300','yes'); return false ">I need to call this function from vb.net code page.....how to solve this ........???????????Give ur ideas...............

How to use Store Procedure to execute the Function Of COM DLL (the DLL is Coded By C#)

Hi All, I find a question. How to use Store Procedure to execute the function of Dll? I tried as the steps: 1. Code a dll 2. Register the dll by "regasm XXX.dll /codebase" 3. Use the dll in SP But when I do it in step 3, I face some error, which is "Invalid class string" and the error ID is "0x800401F3" Could you help me solve this problem? Thank you very much.

Error For Execute User Define Function in remote host.

Hi there.I wanna to call a user defined function in stored proc.it's ok in local test but in the host it rises error: Cannot find either column "dbo" or the user-defined function or aggregate "dbo.MinCount", or the name is ambiguous.What should i do?

How to execute javascript function from datagrid row

 Hi I need to execute  a javascript function when a row of a datagrid is clicked. I am not sure how to do this. I have tried adding a template column with a button <asp:TemplateColumn>  <ItemTemplate>    <asp:Button ID="myButton" Text="Insert collection" OnClientClick="putData();" runat="server" />  </ItemTemplate></asp:TemplateColumn> And then attaching the javascript to it: myButton.Attributes.Add("onclick", "putData()") But it produces an error. Sorry this is a basic question, but what am I doing wrong?

RegisterStartupScript and UpdatePanel - Execute JS Function after postback




Is there a way for me to call a js function that I have registered the first time after a post back of an update panel?


In the first initial request to the page I register a script block and it works fine.

BUt it doesnt not fire or execute when the updatepanel does a post back.


I did a simple test and just did and page.ClientScript.reg...('alert("test"))

the code works so dont worry about my example syntax. I t just does an alert. The alert is executed once when the page was first requested. but not after a post back.  any ideas?




Execute jquery function after updatepanel.update


I want to execute following function after I have called updatepanel.update:

Public Sub StartScroller()
        Me.Page.ClientScript.RegisterClientScriptBlock(Me.[GetType](), "startscroll", "$(document).ready(function () {$('.scrollable').scrollable();});", True)
    End Sub

It doesnt work. I also tried RegisterStartupScript. I would expect the scrollable() method to be executed. But it doesnt.

    <asp:UpdatePanel ID="upnlCompareLocations" runat="server">
<a class="prev browse left"></a>
<div class="scrollable">   
   <!-- root element for the items -->
   <div class="items">

        <asp:ListView ID="repLocationsToCompare" ItemPlaceholderID="itemsGoHere" DataSourceID="XMLDSCompare" GroupItemCount="4" runat="server">
                <asp:PlaceHolder runat="server" ID="itemsGoHere"></asp:PlaceHolder>
                    <%# XPath("title&

Execute a JavaScript function from code behind


Hi All,

I have implemented the following progress bar;


It works very well apart from i have a link on the Gridview which opens a ModalPopUp.  On the popup i have a close button which runs ModalPop.hide();  However the Progress Bar stays on the screen and I can't get rid of it??  This only happens when i have opened the Modal Popup - if i do a gridview sort the progress bar opens and hides as it should.

I have tried to execute the Java "OnUpdated" command like such but it dosent work either:


ClientScriptManager script = Page.ClientScript;

        if (!script.IsClientScriptBlockRegistered(this.GetType(), "Popup"))

            script.RegisterClientScriptBlock(this.GetType(), "Popup", "<script type=text/javascript>onUpdated();</script>");



 Thanks all

Using EXECUTE on dynamic SQL string containing scalar valued function with parameters


I would like to use EXECUTE for calling a scalar valued function as dynamic SQL and for assigning the return value to a variable. This is working fine as long as the scalar valued function does not have parameters. E.g.:



@Result bit, @Function nvarchar(MAX)

HttpContext.Items and Server.Transfer/Execute

The problem was basically that when a Server.Transfer call was applied the script container (and also various ClientScriptProxy script embedding routines) would potentially fail to load up the specified scripts.

want to execute url without showing that page or url to client.


hello friends,

I need ur help,what i want to do is to execute a url ("To send a text message to client") on client registration but without showing that url page, in short executing url without displaying any page or url to the client.

please help and thanks in advance.

Content page control passes as argument to javascript function


Here is the content page:


<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="JavaDynamicCopyValue.aspx.cs" Inherits="JavaDynamicCopyValue" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
 <script type="text/javascript" >
 function copyValue(input, output )
   ouput.value = input.value;
   return true;
 <asp:TextBox ID="txt1" runat="server" onchange="copyValue(this,document.getElementById('<%=txt2.ClientID%>'))"></asp:TextBox>
    <br />
    <br />
    <asp:TextBox ID="txt2" runat="server"></asp:TextBox>


I got a javascript run time error says output is undefined. if I view source of the page, the txt1 markup became:

<input name="ctl00$ContentPlaceHol

connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly.


I dont have the SQL EXPRESS installed instead I have SQL Standard Edition.

 I have two SQL Server instances installed.

 1- UserLT (this is sql 2000)
2- UserLT\SQL2005 (this is SQL 2005 named instance)

But when i try to add a database to my VS website project I get the following error:

Connection to SQL Server files (*.mdf) require SQL server express 2005 to function properly. please verify the installation of the component or download from the URL: go.microsoft.com/fwlink/?linkId=4925

I went in Tools>Opetions>DataBase tools>Data Connection>Sql Server Instance Name (blank for default)

and changed the "SQLEXPRESS" to "USERLT\SQL2005".

But I still get the same error message. Any ideas how i can resolve this issue?

Public Shared function doubt????

I am using VB.net/ASP.NET and SQL Server 2000 for a web application.

For populating the dropdowns, I wrote a Public Shared function LoadDDL(), in which I pass the dataset and dropdown name to set.

I have my doubts that this function will produce unexpected results for concurrent users. And will mix the results among sessions because it is a Shared function.

I am confused here. Is it the right way to go?

Please advice. Thanks in advance.


Trim function in C Sharp

How do i use "trim" function in C Sharp? I have a string and i want to strip off spaces from the end of the string. Any idea how do i do it??


UI on the Fly: Use the .NET Framework to Generate and Execute Custom Controls at Run Time


Creating UI controls on the fly can be accomplished via run-time code generation. And there are lots of reasons to do so. Generating these controls once and then reusing them as needed is more efficient than generating the controls each time. Read on.

Morgan Skinner

MSDN Magazine December 2005

Pure C++: Invoking Generic or Function Templates


As I promised last time, in this month's column I'll walk through the process of defining and invoking a generic or template function under C++\CLI. A function template or a generic function begins with the template or generic keyword followed by its parameter list.

Stanley B. Lippman

MSDN Magazine October 2005

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend