How to insert the list View data to database SQL using C# windows form?

Asked by Last Modified  

Follow 2
Answer

Please enter your answer

IT Business Owner and Trainer with 15 plus years of coding experience

Loop through each item and insert one at a time if you need separate rows for each item. Else, concatenate as a string into a single column in the database table. Also, it depends on how you want to store data.
Comments

Trainer

Your SQL should look like: SqlCommand cmd = new SqlCommand("insert into AMICIZIA (IdUtente1) values('" + l.Text; + "')", myconn);
Comments

Trainer

Your SQL should look like: SqlCommand cmd = new SqlCommand("insert into AMICIZIA (IdUtente1) values('" + l.Text; + "')", myconn);
Comments

View 1 more Answers

Related Questions

I want to do Project in MVC 6 with using WebAPI, Entity Framework and LINQ.
. I am working as a senior developer and I deliver same knowledge in my classes with project.I can help you in this.
Profile Photo
Ashish
which .net is good .net silver light or share point?
SharePoint, wpf, asp.net, Silverlight, winforms they all use the .net library that are commononly referenced. Since SharePoint is built on ASP.NET, the argument can be made that anything you can do with...
Profile Photo
Rupali
When do you use Html.Action over Html.Partial ?
Html.Action() will call action method. e.g. Html.Action("Test") Html.Partial() just renders partial view. e.g Html.Partial("PartialName");
Profile Photo
JK IT Training
How to create custom attribute in mvc?
By implementing Attribute class.
Profile Photo
JK IT Training

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

Format Date to “MM/dd/yyyy” in Webgrid ASP.Net MVC Razor View
Replace above line with below to apply ("DD/mm/yyyy") formatting to date field in WebGrid AllTicket.Column(columnName: "DueDate", header: "Due Date") grid.Column("Date",format:@<text> @item.Date.ToString("MM/dd/yyyy")</text>)
M

Mohammad Shafi

0 0
View Comments0

Inversion of Control
Problem You have classes that have dependencies on services or components whose concrete type is specified at design time. In this example, ClassA has dependencies on ServiceA and ServiceB. Figure 1 illustrates...
Profile Photo

Trends in .Net Platform
.NET Framework is a software framework developed by Microsoft. It includes a large class library named Framework Class Library (FCL) and provides language interoperability (each language can use code written...
Profile Photo

Garbage collector [ GC ] in .NET framework
Garbage collector is responsible for the "automatic memory management - AMM" in .NET framework. Garbage collector is one of the properties of .NET framework components CLR . Why there is a need of "Memory...
D

Deleted U.

1 0
View Comments0

Benefits of AsP.net webapi over traditional asp.net 2 and 3.5
Tradional asp.net had slower server side response feedback to the server with the MVC concept on webapi there were faster responses from the server side for client requests. Optimization of code was main...
Profile Photo

Looking for .NET MVC ?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you