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


Post New Web Links

call c# class from sqlserver

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
 
Hi,How I can call a c# class from sqlserver


View Complete Post


More Related Resource Links

Class with recursive call to that calss.

  
Dear all,I have a class with a property who is a recursive call to the same type of Class. Is this a correct way of working ?The code :public class DataObject { public string Name { get; set; } public string DataType { get; set; } public int IntValue { get; set; } public string StrValue { get; set; } public DataObject DataValue { get; set; } public DataObject() { Name = string.Empty; DataType = string.Empty; IntValue = 0; StrValue = string.Empty; DataValue = new DataObject(); } } I got an abort exception while creating an object from this class.

How to call to class by clicking button?

  
Hi. I add new class  to my project via "add --new item--class" now i wont to call added class by clicking button. how i do that? for example there is button click   private void button5_Click(object sender, RoutedEventArgs e) {   }

how to jquery call a other call function other class is not static

  
how to jquery call a other call function other class is not static[WebMethod]    public static bool Verify(string username, string password)    {        //Do your logic with username, password  here        //I am just checking with admin/admin credentials            Console.WriteLine("Ritu");        string s="SELECT p.RETMSG FROM P_DOCSHARE(1001,1453,'1002,1012,1011','Add') P";                 CCUtility c;                c=new CCUtility();             c.JavascriptMessage(c.Insert_P(s));        return (username == "admin" && password == "admin");    }

Call each class in folder

  

Hi all,

I'm developing an application that needs to be very easily maintained. Currently, the program calls a boolean function, which determines if a given set of criteria are met, and then if true... increments a counter.  Afterwards, it moves on to the next function, until all 9 funcitons have been called and the counter now set anywhere between 0-8.

I would like to put each function in a class file, within a subfolder.  IE:  Main Application -> Service1.asmx -> DataCriteria (folder) -> OverLimit, UnitExpired, AddressUnavailable, etc. etc. etc.

Then, have a method (using reflection or whatever means possible) that will loop through each .vb (class) file in the DataCriteria folder, and run its Main function to get the boolean.  This would mean that the calling application does not care how many classes exist in that folder, it checks each class.  And if new criteria needs to be added, i just create a new class and plop it into that folder, without having to edit any code files.

Of course, each class within the DataCriteria folder would need to implement an interface, to verify that they each have the same method type...

any ideas / suggestions?

Thanks,


How can i call custom class in my sharepoint page

  
Hi,

   I created a class file inheride with Page class. I wrote load event in that class file how can i call that in my Newform.aspx in my sharepoint list.

Derived class and try call private/protected base member

  

Hi, i often write a class derived from built in .NET class.

Unfortunately, there are many methods/properties/fields that marked private/internal (i decompile using net reflector),
so i call the members using reflection (get method/field/property, invoke method).

The reflection is damn slow!

Anyone knows how to solve my problem? Or have alternate method instead of using reflection?

 

*** the sealed, internal, and private keywords is enemy for me, it prevents the developer for derivering a class/type.


call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side.

Using jQuery to directly call ASP.NET AJAX page methods

  
Here I am looking to explain how to call page methods using jQuery. Using jQuery to directly call ASP.NET AJAX page methods

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side

Class Diagrams

  
Class diagrams show the static structure of the systems. Classes define the properties of the objects which belong to them. These include:

Attributes - (second container) the data properties of the classes including type, default value and constraints.

Creating a Simple Class in C#

  
The second article in the C# Object-Oriented Programming tutorial describes how classes are created in C# and how behaviour, in the form of publicly visible and private, hidden methods can be added. This demonstrates some of the uses of encapsulation

Static Class for Beginners

  
In general, the members of a class can be accessed by instance of that class when they are in public, but there comes a situation to access or call members of a class without an instance and this can be achieved by declaring them as static

How to Encrypt and Decrypt a Password using SQLSERVER 2005?(Video)

  
Encypt and Decrypt a Password using SQLSERVER 2005(Video)

Date and Time Functions in SQLSERVER

  
Date and time functions allow you to manipulate columns and variables with DATETIME and SMALLDATETIME data types.

1 DATEPART Function
2 DATENAME Function
3 DAY, MONTH, and YEAR Functions
4 GETDATE and GETUTCDATE Functions
5 DATEADD Functions
6 DATEDIFF Function
7 More SQL Server Functions

Data Types - Date and Time in SqlServer

  
Date and time values can be stored with either the DATETIME or SMALLDATETIME data type. The difference between the two is that SMALLDATETIME supports a smaller range of dates and does not give the same level of precision when accounting for time. The DATETIME data type can hold values from January 1st of 1753 to December 31st of 9999. The time is stored to the 1 three hundredths of a second and each value takes up 8 bytes of storage. The SMALLDATETIME data type can hold values between January 1st 1900 and June 6th of 2079. The time is tracked to the minute and each value takes up 4 bytes of storage. The majority of business applications can live happily with SMALLDATETIME, however, if you are in an environment where each second matters or you need to make estimates to the distant future (or past) then you have to resort to DATETIME. If you fail to specify the time when inserting a value into a DATETIME or SMALLDATETIME column, a default of midnight is used. If you fail to specify the date portion the default of January 1, 1900 is used.

How to call an .exe file in .net

  
Sometimes a developer has to call an EXE from another EXE. While calling EXE there can be a requirement to pass parameter.

abstract away the source of the connection string using a class with a static property.

  
ASP.NET provides a configuration system we can use to keep our applications flexible at runtime. In this article we will examine some tips and best practices for using the configuration system for the best results.

The element of a web.config file is a place to store connection strings, server names, file paths, and other miscellaneous settings needed by an application to perform work. The items inside appSettings are items that need to be configurable depending upon the environment, for instance, any database connection strings will change as you move your application from a testing and staging server into production.

Encapsulation
Let's abstract away the source of the connection string using a class with a static property.
Categories: 
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