2fix c# app- add string of parameters to sp and display results in datagridview
$10-30 USD
Completed
Posted about 6 years ago
$10-30 USD
Paid on delivery
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;
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 fixed number of) varchar parameters?
$15 USD in 1 day
5.0 (23 reviews)
4.8
4.8
8 freelancers are bidding on average $20 USD for this job
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 strength.
Thanks