Insert a data without using insert command

Question

User1997423929 posted
Can I insert a data into my table without using insert command in asp.net project.

Answer 1

User475983607 posted
Unclear, what kind of table? Please post your code?

Answer 2

User409696431 posted

If you are referring to a database table, you use the insert command to put new rows in, and the update command to replace existing data with new data.  So, are you inserting new rows, or updating existing rows?

Answer 3

User1120430333 posted

Can I insert a data into my table without using insert command in asp.net project.

no

Answer 4

User283571144 posted

Hi Adwin Jha,

Can I insert a data into my table without using insert command in asp.net project.

Could you please share more details information about insert a data into my table without using insert command in asp.net project?

Do you mean you don't want to write insert sql command in your asp.net application?

If this is your requirement, I suggest you could consider using store procedure to achieve your requirement.

By using store proceduce, you could just call store proceduce name in the application.

More details about how to use store procedure with ADO.NET, you could refer to below article:

https://www.c-sharpcorner.com/article/using-stored-procedures-with-Asp-Net/ 

Best Regards,

Brando

Answer 5

User1997423929 posted

If you are referring to a database table, you use the insert command to put new rows in, and the update command to replace existing data with new data.  So, are you inserting new rows, or updating existing rows?

I am inserting new rows.

Answer 6

User409696431 posted

If you are inserting new rows, you need an insert command.   Why are you not wanting to use one?

Answer 7

User753101303 posted

Hi,

Unclear. It can be hidden from you if using a DataSet or Entity Framework but ultimately a SQL statement is sent to the server (at least those based on SQL): INSERT for adding new rows, UPDATE for updating existing rows and DELETE for deleting rows.

What is the exact problem you have ?