fix c# app- add string of parameters to sp and display results in datagridview
$10-30 USD
Törölve
Kiadva ekkor: majdnem 6 évvel ezelőtt
$10-30 USD
Teljesítéskor fizetve
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";
Security Info = True; User ID = Test; Password = Test";
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;
Hi Dear,
I am having an expert level knowledge in C# DotNet and SQLSERVER.I would love to work in this project to help you get the details of your need. Awaiting your positive response.
Regards,
Mayuri Patel.