|
my database is ms-access,i tried the query , u provided.it is giving an error message
the microsoft jet engine cannot find the input table or query deleted. Make sure it exist or it's name is spelled correctly.
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
As per as concern about your reply i dont know about the MS-Access.I had to solve it in SQl Server and create a Audit Trail through this particular query.or write # before the deleted.......
Deepak
Smile a Lots,Its Costs Nothing
|
|
|
|
|
in sql server too it is not poviding the result
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
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
|
|
|
|
|
Hi Deepak,
I tried to run the statement you have provided "select * from deleted". But its saying "Invalid object name deleted". I am using SQL Server 2005.
Regards,
Hariharan C
|
|
|
|
|
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
|
|
|
|