How can i export data to SQL Database tables

Aspose.Cells Product Family
1

Hi,


I have a couple of questions.

1. How can i export spread sheet data directly SQL database tables??? Is there any export method to export data from spread sheet data to SQL database table??

2. How can i implement security features like encoding the data,(checking for sql injection & other security related …) across spread sheet data???


Thanks,
Thulasi.
2

Hi,


1) Well, you may try to export worksheet data to fill a data table (using Cells.ExportDataTable() method) and then use your own .NET code to save / update in your Source SQL Server database tables accordingly.
See a topic for reference:

2) Well, to encode data, set your desired encoding type e.g Unicode, UTF or others, see a sample code:
Workbook workbook = new Workbook(“e:\test\test.xls”);
workbook.Settings.Encoding = Encoding.Unicode;
MemoryStream stream = new MemoryStream();
workbook.Save(stream, SaveFormat.TabDelimited);
byte[] byteArray = stream.ToArray();
stream.Flush();
stream.Close();
Encoding encoding = Encoding.Unicode;
string s = encoding.GetString(byteArray);

MessageBox.Show(s);