Question: Hi everyone, I need a help in C# and SQL server. i want to create a list or array in c# to save a distinct

Hi everyone, I need a help in C# and SQL server.

i want to create a list or array in c# to save a distinct data column from data base and save data to list or array.

this is my sql qurey which is work fine

select distinct BatchId from _ImportAPCWageIndex

but i need a help to save these data from sql server in to the list or array.

is anybody can help, me please?

best regards.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Hello! Im a little confused as to what I should do in regards to this assignment could you help. Objectives: The major advantage of using structs is to make the C++ code simpler, easier to read and...

Q:

Students will review examples and evaluate them. Review these documents and evaluate them (click on the link): https://1drv.ms/w/s!AoYu6G3CLyuakjVCGipkRkNSBVUB?e=jrPXX6...

Q:

Question 40 of 40 2.5 Points Which selection below represents an entry that would be seen in the active box? A. =sum(A1:A3) B. 15 C. (A1:A4) D. E11 Question 40 of 40 2.5 Points Which selection below...

Q:

Question 40 of 40 2.5 Points Which selection below represents an entry that would be seen in the active box? A. =sum(A1:A3) B. 15 C. (A1:A4) D. E11 Question 40 of 40 2.5 Points Which selection below...

Q:

Question 40 of 40 2.5 Points Which selection below represents an entry that would be seen in the active box? A. =sum(A1:A3) B. 15 C. (A1:A4) D. E11 Question 40 of 40 2.5 Points Which selection below...

Q:

Mates Rates Rent-A-Car ( just do the part a) using visual studio code (C#) Criteria sheet - Par A Example supplementary files (readme.pdf) Example supplementary files (class-diagram.pdf) Assignment...

Q:

I have to create a program in C and I can't figure it out. The program has to read a source file. Please help. /******************************************************************** PROJECT: Glossary...

Q:

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Q:

This uses microsoft SQL management Studio I. OBJECTIVES At the end of this activity, the students will be able to: 1. Create, Alter, and Drop SQL VIEWs. 2. Understand the use of WITH SCHEMABINDING....

Q:

In this assignment, we will create an application which runs on the sample database from the Forta textbook. We will code it in the spirit of three-tier architecture. You will set up the data tier...

Q:

Kimly Limited and RE&S Holdings Limited are public companies limited by shares. Kimly Limited Kimly Limited is one of the largest traditional coffee shop operators in Singapore. The Group operates...

Q:

5) [10 pts.] Find the volume of the solid generated by revolving the region between the curves y = Vx and y = x about the x-axis.

Q:

5 Internal Rate of Return A company's management decides to make a capital budgeting decision using information from a modified internal rate of return. Which of the following statements make this...

Q:

8:37 * N. 80% i ... OBJECTIVES: Create relationships Create a Pivot Table from Related Tables Create a PivotChart Modify the PivotChart The major section in this chapter :ontinuation is: Data...