HTTP EndPoint in Microsoft SQL-Server 2005 –Implemented in Visaul Studio 2008
You must have heard the terms “Web Service”. This is not something new. People used to read and write many things about this term from year of 2000 for Microsoft Technology. It was inbuilt tool in .NET Framework but it is bit new concept in SQL-Server as it has been implemented from Microsoft SQL-Server 2005. “Web Service” is known as “HTTP ENDpoint” in SQL-Server. It has opened the door for cross platform compatibility.
Let us see how we can define HTTP Endpoint and can use it in Windows application in C#.NET.
This is very simple stored procedure one can ever make. J Now it is time to implement this stored procedure in ENDpoint.
AUTHORIZATION sa –this is something absolutely optional authoraization for db owner STATE = STARTED — State could be STARTED, STOPPED and DISABLE
BATCHES = DISABLED –you could enable BATCHES but it becomes security thread
Here are the steps to implement HTTP Endpoint in your Windows application in Visual Studio 2008.
—Draw One button and dataGridView in your webform.
— Add reference of HTTP Endpoint in your application. Right click on your project name in Solution Explorer and click on “Add Service reference”, you will see on dialog box and you will have to click on “Advance” button at left bottom corner and you will see another dialog box like below.
Once you final add the reference, you will have to code following snippet under the click event of your button.
private void button1_Click(object sender, EventArgs e)
localhost.Test_END_Point tEnd = new ForHTTPendPoint.localhost.Test_END_Point();
tEnd.Credentials = System.Net.CredentialCache.DefaultCredentials;
dataGridView1.DataSource = tEnd.getVal().Tables;
Hey, you just finished your first HTTP Endpoint. What are you waiting for? Runt it now!!!!
Reference: Ritesh Shah