Completed

2fix c# app- add string of parameters to sp and display results in datagridview

My code is below. My aim is to take list of ordernumbers to the sp to process.

Then have the return data viewed in a datagridview.

string connstr = @" Data Source = GNC7; Initial Catalog = ONYX; Integrated Security = True";

SqlConnection conn = new SqlConnection(connstr);

try

{

[login to view URL]();

}

catch (SqlException ex)

{

[login to view URL]([login to view URL]);

}

SqlCommand command = new SqlCommand();

[login to view URL] = conn;

SqlDataReader dr = null;

[login to view URL]();

List<string> listTemp = new List<string>([login to view URL]([login to view URL], [login to view URL]));

List<string> list = [login to view URL]().ToList();

string trimmedItem;

StringBuilder builder = new StringBuilder();

foreach (var item in list)

{

[login to view URL]("\'" +item + "\',");

}

trimmedItem = [login to view URL]();

trimmedItem = [login to view URL]([login to view URL] - 1);

[login to view URL] = "Usp_GetStains";

[login to view URL] = [login to view URL];

[login to view URL](trimmedItem);

dr = [login to view URL]();

[login to view URL]();

return;

Skills: .NET, C# Programming, C++ Programming

See more: c# datagridview stored procedure parameter, execute stored procedure on button click c#, how to display data in datagridview in c# using stored procedure, vb.net fill datagridview from sql stored procedure, c# fill datagridview from sql stored procedure, how to show data in datagridview in c# from sql database, how to display data in gridview using stored procedure, how to display data using stored procedure in asp net, Get Data Entry Done - 04/06/2017 02:56 EDT, 07/06/2017, 20160928-02:41:06.358 : 8=FIX.4.49=009035=149=HDTEST56=DATEST34=000000000252=20160928-02:41:07.420112=20160928-02:41:07.4, images company logos screen 20shot 202016 03 06 20at 2018.59 52 png, http www search ask com gct hp&o apn10644a&qrsc 2871&l dis&sver 3&apn_ptnrs ag5&dateofinstall 2015 04 07&d 533_257&v 1.1 _675, freelancer bh 07 06, 07.06 severe weather writing assignment, 07.04 16 freelancer, pokerstrategy freelancer freeroll password 06.09 15, poker strategy freelancer freeroll парола на 07.06 2015, poker strategy freelancer freeroll password 06.09 2015, android app force close fix

About the Employer:
( 7 reviews ) Westboro, United States

Project ID: #16640525

Awarded to:

alyelhaddad

Hello Mister; the task seems to be simple; however, I need to know further details about your stored procedure; does it take one comma-separated varchar parameter and parse it inside, or does it take multiple (and fix More

$15 USD in 1 day
(7 Reviews)
3.7

12 freelancers are bidding on average $22 for this job

vano101

Hello Looks like you work with some database and stored procedure. I guess it would be much easier to work through TeamViewer.

$27 USD in 3 days
(1271 Reviews)
7.5
$25 USD in 1 day
(42 Reviews)
6.0
leedaniel1989

Hi, How are you ? I am a senior C# expert. I can complete the task. I am looking forward your reply. Thanks Lee

$35 USD in 1 day
(9 Reviews)
5.4
itoasis1

Hi Thanks for posting such a job. I am an expert in such job. I can finish your project perfectly. Best regards.

$25 USD in 1 day
(16 Reviews)
4.2
Sivamurugan13

Hi Sir, I see your code very carefully,Yes I can do this. There is problem in passing paramater in stored procudure and calling procedure. This Siva new for free lancer. Please give me a chance to prove my str More

$10 USD in 1 day
(12 Reviews)
3.2
jprmdev

A proposal has not yet been provided

$15 USD in 1 day
(1 Review)
0.4
Indiandevelop462

I can start from [login to view URL] share more detail...regards...sunil developer

$25 USD in 1 day
(0 Reviews)
0.0
DnyaneshwerK24

Hi, My name is Namrata. I’ve read your brief and can see that you’d like to build a Website. We have 7 years of experience in website designing on PHP, CI, core PHP, .NET, C#, asp.net, Entity framework, WCF, MVC, UX More

$25 USD in 1 day
(0 Reviews)
0.0
arsalankhanahmed

Just add below line before and after loop [login to view URL](" ' "); And remove "\'" from loop, and your passed the as a string of comma separated order number & + only @ordernumber varchar it's all done

$10 USD in 1 day
(0 Reviews)
0.0
MRaj45

Hello Please visit our website- [login to view URL] As per your post ,I have understood your requirement. We are team of 10 an expertise of Web Developing architecture and Web Designing. We are Microsoft Approved Partne More

$25 USD in 1 day
(0 Reviews)
0.0
$25 USD in 1 day
(0 Reviews)
0.0