Concluído

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;

Habilidades: .NET, Programação C#, Programação C++

Veja mais: 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

Acerca do Empregador:
( 7 comentários ) Westboro, United States

ID do Projeto: #16640525

Concedido a:

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 Mais

$15 USD em 1 dia
(7 Comentários)
3.7

12 freelancers estão ofertando em média $22 para esse trabalho

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 dias
(1271 Comentários)
7.5
$25 USD em 1 dia
(42 Comentários)
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 em 1 dia
(9 Comentários)
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 em 1 dia
(16 Comentários)
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 Mais

$10 USD em 1 dia
(12 Comentários)
3.2
jprmdev

A proposal has not yet been provided

$15 USD em 1 dia
(1 Comentário)
0.4
Indiandevelop462

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

$25 USD em 1 dia
(0 Comentários)
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 Mais

$25 USD em 1 dia
(0 Comentários)
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 em 1 dia
(0 Comentários)
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 Mais

$25 USD em 1 dia
(0 Comentários)
0.0
$25 USD em 1 dia
(0 Comentários)
0.0