how to insert data of console in database

Question

I am facing problem to insert data in database the insert query is working and database is also connected but i don't know how to fatch data from async method and give the values of that variable to insert query...I have also tried to run query into the function but it is not working.

Sundar · Answer

From where you are running your async function ?. Means Layer !. Try to use Subquery to fetch and insert into table. Eg: INSERT INTO Table1 (Column1Column2Column3) SELECT Column1Column2Column3 FROM Table2 WHERE Column1=@conditional_parament; Hope this may helps you. Thanks in advance.

Amit Kumar · Answer

Hi First add your connect string in app.config and call it in console like string conString = ConfigurationManager.ConnectionStrings[databaseConnectionStringName].ToString(); SqlConnection cnn = new SqlConnection(conString ); SqlCommand cmnd = new SqlCommand(ProcedureName cnn); cmnd.CommandType = CommandType.StoredProcedure; cmnd.Parameters.AddWithValue(@iiiddd 10); //parameter which you define in procedure for insert the data cnn.Open(); cmnd.ExecuteNonQuery(); cnn.Close(); get data in datatable then SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmnd; cnn.Open(); da.Fill(dt);