Facing the issue generating the data from MSSQL

Maahi

I have uploaded a bulk record from front end in c# ok

Then am loading the record in temp table using table type ok I have used if exisits condition from based on the if exisit condition if the record is valid it will update the master else it will insert into the table unmatched records.

So i need unmatched records of the table and this table am trying to export in excel in c# .

When i execute the procedure its working but export to excel no record found.

If possible plz provide solution for the same.

Export to excel method is working but from sql server the records are getting generate.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nilesh Shah9y ago
can't help you if you dont post code
0
Maahi9y ago
No i want invalid records in excel..
i think multiple select stamtent due to its not able to get the select * from tablename
0
Nilesh Shah9y ago
Let me clarify my understanding: you want to either insert or update records in SQL server, then you want to export newly inserted records in Excel.

If that's what you want then I suggest following approach:

- pass records to an SP
- in the SP, write logic to either insert or update the records
- you will need to create an extra column of Guid in table, create a new Guid (only 1 Guid, same for all records) and while inserting records pass this Guid in the new column
- return this Guid from SP to C# code (or whatever code which is calling SP)
- now the code needs to fetch all records which has that Guid
- write code to fetch records with that Guid and export to excel
0