Displaying Data in excel sheet

Question

I have an excel sheet with each month data in it and i have two button(one is show button and another one is Add) one is to display data and another button to add data to it.

In the first button i.e Show button

When the user click on the this button i need to display current month data not all the data but some few data(eg 7 rows of data).

In the second button i.e Add button

when the user click on this button the authorized person should be able to add data to this excel sheet for that i need to provide login credential after verifying only the authorized person should be able to add data to it and it should be get saved i should be able to store it under same project.

Can any one help on it.

Answer 1

hi Pankaj,
if you are creating dynamic query then at the time of creating sql string you can do following example :

 wherestring+=txt.Replace("'","''"); 

// single quote is passed string in
//first parameter and single quote is written twice '' for second.

Answer 2

Hi

when you are use the single quite you need add extra two quote to string.or else is make to sql injection.

About this please take look,

http://archives.devshed.com/forums/windows-107/sql-injecttion-401471.html

thank you

Answer 3

Thanks

Answer 4

Thanks

Answer 5

Hi you just need to Replace every Single timeWriten Quote to Double Time

suppose you are inserting

string " pankaj's Name "

then you should write String Like

"Pankaj' 's name "     { Dobule time Single Quotes before 's' )

Thats it :)

Better to Write Function That Will Replace Every Single Time Quote to Write it Double time in String

public string CSQ(string str)
{
 
    return Strings.Replace(str, "'", "''");
}


if i Helps you please check "Do you like this answer"

Answer 6

Please see the following two links:
http://it.toolbox.com/wiki/index.php/How_do_I_escape_single_quotes_in_SQL_queries%3F
http://blog.sqlauthority.com/2008/02/17/sql-server-how-to-escape-single-quotes-fix-error-105-unclosed-quotation-mark-after-the-character-string/