1
Answer

Displaying Data in excel sheet

Sweety

Sweety

11y
904
1

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.

Answers (1)
0
naura pax
NA 1.9k 64.8k 15y

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.
Accepted
0
Master  Billa
NA 2.7k 0 15y
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


0
Pankaj Singh
NA 69 0 15y
Thanks
0
Pankaj Singh
NA 69 0 15y
Thanks
0
Kirtan Patel
NA 35k 2.8m 15y
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"






0
jinge
NA 2.4k 23.5k 15y