|
hello
how to set query dynamically
thank you
vijaya
|
|
|
|
|
Hi all,
I want to implement the running text in my website's home page. Either in a text box or list box. Can anyone of you help me out to solve this problem.
Thanks and Regards,
Hariharan C
|
|
|
|
|
You mean scrolling text ? Inside an edit control ? I'm not sure that you can.
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,
What i meant is? If you go to any website there will be a text running in the home page. For eg.. log on to anna university website, you can see the latest news running. When you move the mouse cursor to that news it will stop. Then you can click and view the news. Like that I want to implement something in my home page.
Regards,
Hariharan C
|
|
|
|
|
Hari_1010 wrote: log on to anna university website, you can see the latest news running.
It's a small script. You can goto viewsource of that page and take that script. Alternatively you can use HTML marquee for this.
|
|
|
|
|
Yes, there are scripts for that. But, not in a listbox or editbox.
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 )
|
|
|
|
|
Hello All,
There is such a requirement that we have to convert the uploaded word document to pdf. This feature should be implemented in our application, found few third part tools but unable to select one and finnding difficutly in implementing the functionality in our code.
Trying to use Adobe SDK and in the examples provide we have some distiller dll to be added where can i get this?
gauthee
|
|
|
|
|
Hi friends
I have a bit problem here
I want to get back all deleted record of database
How do i preform this task?
If it is possibel then plz help me out.
Thanks
Pathan
---------------------------------------------------
|
|
|
|
|
You can Create a Trigger into DB with following select query
select * from deleted
deleted is a logical table which store data temprirory into it.
but it is only for while whn next delete or other statements will fire.
and also mind it is not select Image,ntext or other data type which store a large amount of data.
hope tht will help you......
Deepak
Smile a Lots,Its Costs Nothing
|
|
|
|
|
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....
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
