sql injection all tables, How to Prevent?

Question

Dear Sir,

Sql injection happen in our website and i used store procedure. but happen this problem and that inject all database table of varchar and nvarchar columns.

</title><style>.a9zs{position:

absolute;clip:rect(473px,auto,auto,473px);}</style><div class=a9zs>States have been around <a href=http://paydayloansforsure.com >24 hour payday loan</a> even thousands of people.</div>

Please help and suggest me what i do?

Answer 1

Thanks.

 

But I don't have fixed Max & min date.

So, I write a code in Textchanged event & in that I'm checking the Textbox date with Max & min date.

If textbox date is between the range of min & max date then its ok else gives Errormessage.

Answer 2

Hi Just try below mentioned code.

 

<asp:TextBox ID="txtDate" runat="server" ReadOnly = "true"></asp:TextBox>

<br />

<asp:RangeValidator runat="server" ID="RangeValidator1" Type="Date" ControlToValidate="txtDate" MaximumValue='09/20/2011' MinimumValue="09/01/2011"

ErrorMessage="Date should be between 09/01/2011 and 09/20/2011" Display="Dynamic" />