.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

How to Call SQL function from ASP.net application?

Posted By:      Posted Date: October 13, 2010    Points: 0   Category :ASP.Net

I have SQL functions and I want to be able to call it from my asp.net application.

How can I call it from my asp.net application?

Also I am using microsoft enterprise application block to call dataabse. 

thank you


View Complete Post

More Related Resource Links

databind from a custom function call


in datalist templatefield, i want to bind an imagebutton's visible property. the scenario is .. it is a picture comments page like one in facebook. if its your own comment, the delete button is shown, otherwise not.  the problem is .. for the imagebutton i want to set visible = false, if the user logged in is the same user as the one who commented. how can i do that ? please help

currently im using this code on datalist databind event. but the label is returned as null

public bool set_visibility()
        Label lb = DataList3.FindControl("Label7") as Label;

        if (lb.Text == Session["user_id"].ToString())
            return true;
            return false;

findcontrol dosent return the control.

how to call thickbox function in codebehind



i want to call thickbox.js function in codebehind , below the code in jquery

i want to call below code in codebehind

function tb_remove() {
    if (typeof document.body.style.maxHeight == "undefined") {//if IE 6
        $("body","html").css({height: "auto", width: "auto"});
    document.onkeydown = "";
    document.onkeyup = "";
    return false;

Call function Vb in ASP

Does anyone know if is possible fill one column using a function in VB ? I thought in something like this but I don't know what i put in one part. Thanks.   <Columns> <asp:TemplateField HeaderText = "A" > <HeaderTemplate> <table> <tr> <td>Teste</td> </tr> </table> </HeaderTemplate> <ItemTemplate> <asp:Label ID="lblTeste" runat="server" Text='<%# ???????? %>' /> </ItemTemplate> </asp:TemplateField>  

asp.net web application and SAP integration - Call BAPI

Hi, I want to create customer in SAP using asp.net web application or web service. I am using BizTalk Adapter Pack and SAP RFCSDK library.Using "Add Adapter Service Reference" I am able to connect and fetch customer records also using RFC_CUSTOMER_GET successfully. I am trying to call BAPI "BAPI_CUSTOMER_GETLIST". I could not understand the parameters and return values of BAPI. This is my code:   RfcClient rfcClient = new RfcClient("SAPBinding_Rfc");                 rfcClient.ClientCredentials.UserName.UserName = "DEEPAK";                 rfcClient.ClientCredentials.UserName.Password = "*****";                 // Open client                 rfcClient.Open();                     microsoft.lobservices.sap._2007._03.Types.Rfc.BAPICUSTOMER_ADDRESSDATA[] custDataAdd = new microsoft.lobservices.sap._2007._03.Types.Rfc.BAPICUSTOMER_ADDRESSDATA[0];                 microsoft.lobservices.sap._2007._03.

Can you call a javascript function from code behind?

Call you cal a javascript function from the code behind? If so how??? 

Can you call Javascript function from the codebehind?

 Can you call Javascript function from the codebehind?  How???

how call silverlight application page in asp.net application

Hello, I want to show silverlight page in asp.net application .That is I want to show some design using silverlight in asp.net application   Thank you.

Call to "ChooseFont" API function fails

Hi all, I'm trying to call ChooseFont function in order to load standard system font dialog instead of .NET FontDialog (which does not support not TrueType fonts and fails with error if I try to choose such font). In C program there no problem to call to this function, but in C# the call fails with CDERR_STRUCTSIZE code (returned by call to CommDlgExtendedError). All structures sizes are equal to those in C declarations. Here is a code (maybe I miss something). Thank you in advance. private const int CF_SCREENFONTS = 0x00000001; private const int CF_EFFECTS = 0x00000100; private const int CF_INITTOLOGFONTSTRUCT = 0x00000040; [StructLayout(LayoutKind.Sequential, CharSet = CharSet.Auto)] private struct LOGFONT { public int lfHeight; public int lfWidth; public int lfEscapement; public int lfOrientation; public int lfWeight; public byte lfItalic; public byte lfUnderline; public byte lfStrikeOut; public byte lfCharSet; public byte lfOutPrecision; public byte lfClipPrecision; public byte lfQuality; public byte lfPitchAndFamily; [MarshalAs(UnmanagedType.ByValTStr, SizeConst = LF_FACESIZE)] public string lfFaceName; } //structure size in C is equal to 60, so I use int instead of IntPtr [StructLayout(LayoutKind.Sequential, CharSet = CharSet.Auto)] private struct CHOOSEFONT { public int lStructSize; public int hwndOwne

call SSRS report in asp.net application

hi all I am using following code to call a report in a ap.net application but its output is " The request failed with HTTP status 401: Access Denied"........ kindly resolve..... ##############C O D E ################### Partial Class Report1     Inherits System.Web.UI.Page       Public Class ReportViewerCredentials1         Implements IReportServerCredentials         Private _userName As String         Private _password As String         Private _server As String         Public Sub New(ByVal userName As String, ByVal password As String, ByVal server As String)             _userName = userName             _password = password             _server = Server         End Sub         Public ReadOnly Property ImpersonationUser() As System.Security.Principal.WindowsIdentity Implements Microsoft.Reporting.WebForms.IReportServerCredentials.ImpersonationUser             Get   &n

Cannot call Table Valued Function from Dynamic stored procedure statement

Hello,  I have a table-valued function that splits string into a table column. I can easily call this function from a stored procedure within a regular SELECT statement: SELECT * FROM Table1 WHERE Code1 = '1' AND Code2 IN(SELECT * FROM [dbo].[fnSplitValues](@Code2String))   However when I try to use the same logic for a dynamic SELECT statement: ‘SELECT * FROM Table1 WHERE Code1 = '1' AND Code2 IN(SELECT * FROM ' + [dbo].[fnSplitValues](@Code2String) + ')’ I get an error ‘Cannot find either column "dbo" or the user-defined function or aggregate "dbo.fnSplitValues", or the name is ambiguous.’ Any idea what is wrong with my dynamic SQL?   Please help, Lana

java script to call serverside function

hi i want java script by which i can call my asp.net (vb) function which i have written in aspx.vbi just using the vb function to change and check value of hiddenfild and other controln dont want to use ajax control toolkit , i wat to perform some action after spefic time interval

how to call a function or event using jquery Ajex

<asp:Button id="Bu_DocShareSave" runat="server" Text="Save Share" OnClick="Bu_DocShareSave_Click"/>protected void Bu_DocShareSave_Click (object sender, System.EventArgs e){            string S_DocShareID=CCUtility.ToSQL(Utility.GetParam("txt_DownloadFileID"),FieldTypes.Number);            string S_DocStorage=CCUtility.ToSQL(Utility.GetParam("dbo_Storage"),FieldTypes.Text);            string S_DocShareToEmp=Utility.GetParam("dbo_Emp");            string[] SA_DocShareToEmpSplit = S_DocShareToEmp.Split(',');                        int a=0;                         foreach (string Empid in SA_DocShareToEmpSplit){                        if(!Empid.Equals(""))                   {                      

How to call javascript function in master page

helloi have javascript file 'script.js' where i have writt en a function for print. but this function is working fine if i am not using master page in my report page but the question is i want to use master page for my report page where i am calling javascript function but it is not working . Do help me regarding MasterPage and Javascript function.

How to call two stored procedures from asp.net application simultaniously?

I have a asp.net web page.Inside i am calling 2 stored procedures.. which causes huge performance hit on the page I need to call the both the procedures simultaniously using threading Both procedures return data which will displayed on the page how this can be done??   Thanks and Regards, Maverick

asp:Button inside a SharePoint Dataview's Rows with onclick event does not call C# function. Pull i

asp:Button inside SharePoint Dataview Rows with onclick event does not call C# function. Pull it out of Dataview and works fine. I have a ASP.NET Button I've placed inside a SharePoint  DataView's rows with an onclick event pointing to C# function block inside my page. The page refreshes when I click on them, but it's not hitting that code block. If I move the button to outside the dataview and make the ID fixed, the code works beautifully. what's up with that? the button in the Dataview: td class="ms-vb" style="width: 70px"><asp:Button runat="server" Text="Delete" id="Delete{@ID}" CommandArgument="{@FileRef}" OnClick="DeleteDoc"/> </td> my C# onclick handler (inline C# on the page) void DeleteDoc(object sender, EventArgs e) { Button b = sender as Button; .. more code The buttons are rendered and they look like this: input type="submit" name="ctl00$PlaceHolderMain$g_08acadfd_957b_4112_a426_cc7c81991c1e$Delete1" value="Delete" id="ctl00_PlaceHolderMain_g_08acadfd_957b_4112_a426_cc7c81991c1e_Delete1" Thie code block in inline and I'm working from SharePoint Designer. Not sure how I can troubleshoot this.  Am I missing something here, maybe I need to add an Itemtemplate or something like we need to in the ASP.N

WCF function call in page load not working asynchronously

Hi all, I am trying to implement the WCF async function call in my page load event but, it not working asynchronously. Which means page content is displayed only after the asynchronous event is completed. This is my code         protected void Page_Load(object sender, EventArgs e)         {             if (!IsPostBack)             {                 ServiceReference1.Service1Client srv = new WebApplication1.ServiceReference1.Service1Client();                 srv.GetListCompleted += new EventHandler<WebApplication1.ServiceReference1.GetListCompletedEventArgs>(srv_GetListCompleted);                 srv.GetListAsync();             }         }           void srv_GetListCompleted(object sender, WebApplication1.ServiceReference1.GetListCompletedEventArgs e)         {         

The expression contains undefined function call MyUserFunction() error :Telerik Reports

  Hello All, I am getting the error."An error has occured while processing textbox:The expression contains undefined function call FormType()". I have a report..where in i used a user function called "FormType". My datasource  for teh report is sharepoint list. I am passing a parameter to the user function in the code.My user functions retrieves three values(one each time based on the conditions)But when i select the user function..in the edit expression dialog box.. i am not writing any parameter inside the user function as i am not sure what to write there. I have gone through http://www.telerik.com/support/kb/reporting/designing-reports/the-expression-contains-undefined-function-call-myuserfunction-error.aspx and thought i might fall in 2nd cateogry..but unable to find a solution for that Please help me. Here is the code. InitializeComponent();             string strType;             SPSite oSite = new SPSite("spsiteurl");             SPWeb oWeb = oSite.OpenWeb();             string[] parameters = { "10", "100", "1000" };             T
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