Dim stringsList As List(Of String).
Dim newString As String = String.Join(“,”, stringsList)
Dim stringsList As List(Of String).
Dim newString As String = String.Join(“,”, stringsList)
I have a sql query that I return into a DataTable:
SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, DATA_LENGTH
FROM USER_TAB_COLUMNS
WHERE TABLE_NAME IN (SELECT DBTABLE FROM MY_APP_SETTINGS)
With this, I want to create a Dictionary<string, List<ColumnInfo>>
, where the key is TABLE_NAME and ColumnInfo is a custom class with properties to match the other three fields returned in the query. Continue reading
If the DataTable is like below…
COL1 | COL2 |
Name | BABU |
Name | RAO |
Town | Nandyal |
State | A.P. |
I you want to create a Dictionary(Of String, List(Of String)) like below from DataTable using LINQ…
Key | Value |
Name | BABU and RAO |
Town | Nandyal |
State | A.P. |
The query is… Continue reading
Introduction
This article describes the differences between the Web API and Windows Communication Foundation (WCF). And also describes how to choose between WCF and Web API.
What is the ASP. NET Web API
The ASP. NET Web API is a framework that uses the HTTP services and makes it easy to provide the response to the client request. The response depends on the request of the clients. The Web API builds the HTTP services, and handles the request using the HTTP protocols. The request may be GET, POST, DELETE, PUT. We can also say that the ASP. NET Web API:
There are couple of different options available to create proxy class for a WCF service in .Net. First one is to use “Add Service Reference” option available in visual studio and the second option is to use svcutil.exe utility. Although “Add Service Reference” option also invoke this utility implicitly but you can also go to visual studio command prompt and use this utility to generate proxy code that you can use in your client application. Continue reading
Read full article HERE
-- Create Table
CREATE TABLE TestTable (Col1 INT, Col2 VARCHAR(100))
GO
-- Insert Data
INSERT INTO TestTable (Col1, Col2)
VALUES (33, 'Pinal');
INSERT INTO TestTable (Col1, Col2)
VALUES (22, 'Nupur');
INSERT INTO TestTable (Col1, Col2)
VALUES (11, 'Shaivi');
GO Continue reading
Microsoft offers two categories of exams; Those that are technical based (such as 70-487) and those that are Job-Role based (such as 70-583).
A technical based exam focuses on “How” to do stuff with a technology whereas a job-rolebased exam focuses on “Why, when and where” to do stuff with technology.
e.g. A technical based exam might ask “How to implement (code) IDisposable interface in a class?” whereas a job-role based exam might ask “Why and when you should implement the IDisposable interface”.
Whether you should do exam 70-583 or 70-487 really depends on whether you want to be a developer or a designer. If you’ve 3yrs experience as a developer, you should probably do 70-487 (and then maybe do 70-583 as I don’t believe you can be a developer without knowing how to design – IMOA).