|
Do I need to create Trigger in DB?
But what If want to get previous deleted record
Actually yesterday I deleted one company record from database and now I need to get back.
Thanks
Pathan
---------------------------------------------------
|
|
|
|
|
Just go through the following code for trigger
it is only works on For DELETE or After,Insted,Before
Create TRIGGER TR_Delete_Package ON Package
for DELETE
AS
Begin
if((select Count(*) from deleted) > 0)
Begin -- if BEGIN
/* --------------- Declaration of variable ------*/
End -- Trigger
Deepak
Smile a Lots,Its Costs Nothing
|
|
|
|
|
i was checking for triggers in the sql server 2000.
i diid not find any options there for the triggers to create a new one.
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
dcjoshi2 wrote: select * from deleted
is "deleted" mean your table name?
if u use that query..SQL will recognize deleted as a table, if u dont have a table name deleted in your database it will output an error message
Kind Regards,
Tomi
|
|
|
|
|
Imran Khan Pathan wrote: I want to get back all deleted record of database
You can't
Imran Khan Pathan wrote: How do i preform this task?
Currently deleted records you can't revert back, but you can solve this problem for future by adding IsDeleted(it's a column name, can be changed to any name) column to the table. When user asks for deletion, don't delete from table, just change this IsDeleted column value. When fetching the data you need fetch only rows which are having IsDeleted value 'no'.
|
|
|
|
|
My dear Navaneeth
I have just read many articles and blogs and it is possible.
Just wait..............................
Best regard
Pathan
---------------------------------------------------
|
|
|
|
|
|
using System.Configuration;
using System.Web;
using System.Net;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Text.RegularExpressions;
using System.Web.Services.Protocols;
using System.Text;
protected void Button1_Click(object sender, EventArgs e)
{
string abc = "http://www.mywebsite.com";
WebClient webClient = new WebClient();
string strUrl = abc;
byte[] reqHTML;
reqHTML = webClient.DownloadData(strUrl);
UTF8Encoding objUTF8 = new UTF8Encoding();
TextBox1.Text = objUTF8.GetString(reqHTML);
}
lets try this above code......
and get this value and save as it into clients computer through Flie Stream..
Deepak
Smile a Lots,Its Costs Nothing
|
|
|
|
|
this code is giving me Error
"The remote server returned an error: (401) Unauthorized."
at "reqHTML = webClient.DownloadData(strUrl);"
Amit Metkar
3i-infotech, Thane.
|
|
|
|
|
u can go for this link
http://www.codersource.net[^]
for the breif detail of HtmlScreenScraping
read this particular article in asp.net tutorial
Deepak
Smile a Lots,Its Costs Nothing
|
|
|
|
|
Hi Deepak,
the code is working fine with the virtual directory.
but in case i have to go out to some external site other then my project site.
then i am getting one error
Could not find file 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\www.codeproject.com
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
i wrote ur folowing code.
during debuging , i am getting the data in the str1 variable.
but not writhing to the page
WebClient webclient = new WebClient();
Byte[] str;
str = webclient.DownloadData(Server.MapPath("default.aspx"));
UTF8Encoding encode = new UTF8Encoding();
string str1 = null;
str1=encode.GetString(str);
Response.Write(str1);
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
U can write tht STR1 through File Stream
strFileName = "abc.html";
strFilePath = "UR Static Path" + "\\" + strFileName;
FileStream fs = File.Create(strFilePath);
StreamWriter sw = new StreamWriter(fs);
sw.WriteLine(STR1 );
sw.Close();
Deepak
Smile a Lots,Its Costs Nothing
|
|
|
|
|
Thanks Deepak
I got the Exact what i want ?
Amit Metkar
3i-infotech, Thane.
|
|
|
|
|
Welcome Dear
Deepak
Smile a Lots,Its Costs Nothing
|
|
|
|
|
If I have an absolute path to a file, e.g.: C:\website.com\assets\images\lumpydog.jpg
How can I translate the address to it's absolute web form? e.g.: http://localhost/website.com/assets/images/lumpydog.jpg
Can asp.net somehow resolve this path for me?
/\ |_ E X E GG
|
|
|
|
|
Request.Path + "/assets/images/lumpydog.jpg"
Parwej Ahamad
g.parwez@gmail.com
|
|
|
|
|
Thank you for reading this..
Today i got a task to enable submit button form. But the problems is
computer = oracle
|
|
|
|
|
Why not just write a page, which takes the email details, does a normal postback, and sends the email using the .NET email classes ?
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
the class you mention about...
I not really clear about that.
Furthermore, is sharepoint contribute to the error.
When i click submit button i can get the "confirmation" page
but i did receive the email
How to write better feedback form handler can give example
computer = oracle
|
|
|
|
|
hi friends
i have one crystal report on aspx
page
but the width and height of that report is small
i tried to increase height and width and setting differet printers
how can i solve this
thanking you
manisha
|
|
|
|
|
Hi,
I'm using Drop down list. List of Quesitons stored in a database. I'm collecting the questions and load it to the drop down list in Page load event.
When I select the Drop down list, the selected question and answer will display in the text boxes name txtquestion, txtanswer.
But I got this error when I select the Drop Down list
"A potentially dangerous Request.Form value was detected from the client"
The Questions and Answer having HTML tags. will it cause the Error? If so How can I Split the tags and load the Questions alone in the drop down list?
Thanks in Advance
|
|
|
|
|
Muthunagai.A wrote: will it cause the Error?
Yes. You can turn it off with ValidateRequest="false" in your page definition.
Muthunagai.A wrote: If so How can I Split the tags and load the Questions alone in the drop down list?
You can just use the HTMLEncode method ( not sure from memory what object it's on ), to change the text to not be HTML.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hi,
I set the ValidateRequest as false. Include the System.Web.HttpUtility also. But Still having the same error
|
|
|
|
|
U'r question is already in dropdwonlist so you can get question on your question textbox and in the event of dropdwonlist_selectindexchanged you get your answer from database and assign it to answer textbox
event dropdwonlist_selectindexchanged
txtquest.text=dropdwonlist.selecteditem
Nand
Nand
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
