How insert in sql server in c# through WPF

Question

Means how can we insertupdate delete in Sql server using wpf forms

dinesh kumar · Answer

i hope this will help you. public int InsertArticle (Data DataObject ) { //Create the SQL Query for inserting an article string sqlQuery = String . Format ( Insert into DataObject ( DataObject Title DataObject Body  DataObject PublishDate DataObject CategoryID) Values('{0}' '{1}' '{2}' {3} ); + Select @@Identity  DataObject . Title  DataObject . Body  DataObject . PublishDate . ToString ( yyyy-MM-dd )  DataObject . CategoryID ) ; //Create and open a connection to SQL Server SqlConnection connection = new SqlConnection ( DatabaseHelper . ConnectionString ) ; connection . Open ( ) ; //Create a Command object SqlCommand command = new SqlCommand ( sqlQuery  connection ) ; //Execute the command to SQL Server and return the newly created ID int new DataObject = Convert . ToInt32 ( ( decimal ) command . ExecuteScalar ( ) ) ; //Close and dispose command . Dispose ( ) ; connection . Close ( ) ; connection . Dispose ( ) ; // Set return value return new DataObject ; }