Save Local Html Page code to sqlite database

I have created a windows application. I have some html files created locally, I am able to read the entire file in textbox, but not able to save the html code in database

For eg:- below is the html code I want to save in sqlite database. I tried to save using string array also but no success..

Thanks in Advance. .....!!!

Generic Functions
"UTF-8">
name="viewport" content="width=device-width, initial-scale=1">
"https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js">
General Page
"btn1">Button 1
"btn2">Button 2
"btn3">Button 3

"site">

"text" id="mytxt1">

"text" id="mytxt2">

"text" id="mytxt4">

okk, got your issue

then simply replace all apostrophe with double apostrophe and then insert

string htmlString = OldHtmlString.Replace("'","''");

I tried to replace one single quotes to two single quotes and it worked; but for reading the file I used READALLTEXT method and then replaced the string as you said. Previously the changes were not reflecting, but now its working fine...Thanks a Lot for helping...

@Ankush Sql server automatically converts the double '' to single ' so you should get correct output, have you tried inserting after replacing single quote with double??

Sachin you gave gave the solution of replacing but when it is inserted in database it looks in this way for eg: industry' 's but it should look in this way: industry's. this is the problem.

The following is the p tag inside my html file which contains apostrophe symbol, this creates an error during inserting in database. I have highlighted some of the apostrophe symbols in yellow background.

What is Lorem Ipsum? Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type
specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently
with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum. Why do we use it? It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using
Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using 'Content here, content here', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default
model text, and a search for 'lorem ipsum' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like). Where does it come from? Contrary
to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of
the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of "de Finibus Bonorum et
Malorum" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, "Lorem ipsum dolor sit amet..", comes from a line in section
1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from "de Finibus Bonorum et Malorum" by Cicero are also reproduced in their exact original form, accompanied by
English versions from the 1914 translation by H. Rackham.

$('#btn1').click(function()

Apostrophe sign is creating an error. I changed it to double quotes it worked, but in html body there is a p tag in my file which contains apostrophe sign in some words in its text. that is giving an error.

Sorry, I was wrong....the error is actually inside the script tag. the line below exists in the code attached wit question. While inserting in database it gives an error saying :- SQLlogic error near "btn1" : syntax error.

$('#btn1').click(function()

please share your insert query and corresponding error

As I mentioned in the question, I am able to read entire html file in a textbox but at the time of insrting in database it throws an error.

there should not be any issue if you have already read the html as string in textbox, now simply insert it into database and your html tag should not be lost.

command.CommandText = "INSERT INTO table(field1, field2) VALUES(@param1, @param2)";
command.CommandType = CommandType.Text;
command.Parameters.Add(new SQLiteParameter("@param1", Textbox.Text));
command.Parameters.Add(new SQLiteParameter("@param2", textbox2.Text));
...
command.ExecuteNonQuery();

10 Replies

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

Sachin Singh5y ago
Accepted answer
okk, got your issue
then simply replace all apostrophe with double apostrophe and then insert
string htmlString = OldHtmlString.Replace("'","''");
Ankush5y ago
I tried to replace one single quotes to two single quotes and it worked; but for reading the file I used READALLTEXT method and then replaced the string as you said. Previously the changes were not reflecting, but now its working fine...Thanks a Lot for helping...
Sachin Singh5y ago
@Ankush Sql server automatically converts the double '' to single ' so you should get correct output, have you tried inserting after replacing single quote with double??
Ankush5y ago
Sachin you gave gave the solution of replacing but when it is inserted in database it looks in this way for eg: industry' 's but it should look in this way: industry's. this is the problem.
Ankush5y ago
The following is the p tag inside my html file which contains apostrophe symbol, this creates an error during inserting in database. I have highlighted some of the apostrophe symbols in yellow background.
    What is Lorem Ipsum? Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type
    specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently
    with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum. Why do we use it? It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using
    Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using 'Content here, content here', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default
    model text, and a search for 'lorem ipsum' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like). Where does it come from? Contrary
    to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of
    the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of "de Finibus Bonorum et
    Malorum" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, "Lorem ipsum dolor sit amet..", comes from a line in section
    1.10.32. The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from "de Finibus Bonorum et Malorum" by Cicero are also reproduced in their exact original form, accompanied by
    English versions from the 1914 translation by H. Rackham.
Ankush5y ago
$('#btn1').click(function()
Apostrophe sign is creating an error. I changed it to double quotes it worked, but in html body there is a p tag in my file which contains apostrophe sign in some words in its text. that is giving an error.
Ankush5y ago
Sorry, I was wrong....the error is actually inside the script tag. the line below exists in the code attached wit question. While inserting in database it gives an error saying :- SQLlogic error near "btn1" : syntax error.
$('#btn1').click(function()
Sachin Singh5y ago
please share your insert query and corresponding error
Ankush5y ago
As I mentioned in the question, I am able to read entire html file in a textbox but at the time of insrting in database it throws an error.
Sachin Singh5y ago
there should not be any issue if you have already read the html as string in textbox, now simply insert it into database and your html tag should not be lost.
command.CommandText = "INSERT INTO table(field1, field2) VALUES(@param1, @param2)";
command.CommandType = CommandType.Text;
command.Parameters.Add(new SQLiteParameter("@param1", Textbox.Text));
command.Parameters.Add(new SQLiteParameter("@param2", textbox2.Text));
...
command.ExecuteNonQuery();

Save Local Html Page code to sqlite database

General Page