|
 , obviously hasnt read any of the posts on this page about using google for questions
|
|
|
|
|
In his previous post itself it was mentioned that these questions can be answered easily on google.
Apurva Kaushal
|
|
|
|
|
nithydurai wrote: how to use the date concept
Please be more clear. I observe that variants of this question is scattered across the forum aplenty. Posting the same query multiple times actually dissuades focussed experts in helping out rendering your request futile.
Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson
|
|
|
|
|
i am using date concept.i get system date.but i host the project in website.it will be run.i am using the query select * from tablename where date='"+systemdate+"'.i have one dought i donot open website,how it's run.it will run or not.if you know the answer replay to me..
|
|
|
|
|
Can you write your question in somewhat better manner. It is not at all clear what you want to ask.
Apurva Kaushal
|
|
|
|
|
i am using --->
string month, yearr, datee, systemdate;
month = DateTime.Now.Month.ToString();
yearr = DateTime.Now.Year.ToString();
datee = DateTime.Now.Day.ToString();
systemdate = Convert.ToString(month.ToString()) + "/" + Convert.ToString(datee.ToString()) + "/" + Convert.ToString(yearr.ToString());
SqlConnection con = new SqlConnection("server=.;initial catalog=master;user id=sa;password=sa;");
con.Open();
SqlCommand cmd = new SqlCommand("delete from no where date='" + systemdate + "'", con);
cmd.ExecuteNonQuery();
con.Close();
this is my code. systemdate reach the date it will be delete.but i host the project in web.how it is work?
replay to me...
|
|
|
|
|
sugunavathysubramanian wrote: string month, yearr, datee, systemdate;
month = DateTime.Now.Month.ToString();
yearr = DateTime.Now.Year.ToString();
datee = DateTime.Now.Day.ToString();
systemdate = Convert.ToString(month.ToString()) + "/" + Convert.ToString(datee.ToString()) + "/" + Convert.ToString(yearr.ToString());
SqlConnection con = new SqlConnection("server=.;initial catalog=master;user id=sa;password=sa;");
con.Open();
SqlCommand cmd = new SqlCommand("delete from no where date='" + systemdate + "'", con);
cmd.ExecuteNonQuery();
con.Close();
 Buy a basic programming book, there are so much chaff in the above that it is impossible to guide you.
eg.
Convert.ToString(yearr.ToString()); <-- anything strike you as redundant in this snippet?
|
|
|
|
|
sugunavathysubramanian wrote: new SqlConnection("server=.;initial catalog=master;user id=sa;password=sa;");
Your database administrator should really be kicked with a wet towel till he understands the folly he has created:
1) Allowing others to tamper the master database
2) Having a weak password for sa account.
Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson
|
|
|
|
|
Completely agree. Please, the English language has tools for letting people understand each other.
Anyhow, maybe you should consider changing the query and use the DB server date, something like SELECT * FROM tablename WHERE date = GETDATE() [if on SQL Server].
Kazz
"Users are there to click on things, not think. Let the archs do the damn thinking."
|
|
|
|
|
we are not opening the website.ok how to get system date ..do u get my point.
|
|
|
|
|
sugunavathysubramanian wrote: we are not opening the website.ok how to get system date ..do u get my point.
How do you expect the code to be executed if the website isn't running?
You do understand how websites, the internet and the HTTP protocol works, don't you?
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
No idea about what you really mean with 'not opening the website'  , but anyhow, in the code you posted before...
string month, yearr, datee, systemdate;
month = DateTime.Now.Month.ToString();
yearr = DateTime.Now.Year.ToString();
datee = DateTime.Now.Day.ToString();
systemdate = Convert.ToString(month.ToString()) + "/" + Convert.ToString(datee.ToString()) + "/" + Convert.ToString(yearr.ToString());
SqlConnection con = new SqlConnection("server=.;initial catalog=master;user id=sa;password=sa;");
con.Open();
SqlCommand cmd = new SqlCommand("delete from no where date='" + systemdate + "'", con);
cmd.ExecuteNonQuery();
con.Close()
What about...
SqlCommand cmd = new SqlCommand("delete from no where date= GETDATE()", con)
That's what I originally meant.
Kazz
"Users are there to click on things, not think. Let the archs do the damn thinking."
|
|
|
|
|
I would suggest you two things:
1) Prefer stored procedures instead of such queries.
2) Use Google first. These are little queries that Google can help you in a jiffy without having to wait for some one to respond and assist you through.
Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson
|
|
|
|
|
Dear All,
I have requirement like creating a word document with some data. Once it is created , that word document should me saved on the client system.
Please help me solve this.
|
|
|
|
|
Search the web for 'Word automation' and you'll find plenty of information on controlling Word programmatically.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Thanks for your replay,
I am able to create word document by Application Class. What i required is once the document is created
it should prompt to user to save or open the document in other window.
|
|
|
|
|
Then you can temporally save the file on the server, then redirect the user to the file, and browser should automatically prompt the user to save or open the file. I believe...
Kazz
"Users are there to click on things, not think. Let the archs do the damn thinking."
|
|
|
|
|
how to use window service in .net with c#?
tel me something about window service
|
|
|
|
|
You can get lot of information regarding these topic if search this with google.
Apurva Kaushal
|
|
|
|
|
nithydurai wrote: tel me something about window service
It's a service. It runs in Windows.
Any more information, I suggest you search the web or buy a book. Oh, and in future, read the forum rules before you post, particularly numbers 2 & 3.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
or ask rajkumar.3 he seems to have a soft spot for useless programmers
|
|
|
|
|
.netman wrote: or ask rajkumar.3 he seems to have a soft spot for useless programmers
Who is he?
Apurva Kaushal
|
|
|
|
|
he is a user, look down a couple of topics and you will see his post
|
|
|
|
|
Ohh. 
And all this soft spots he got in one day(he joined here only one day before).
Apurva Kaushal
|
|
|
|
|
There is a website called Google and it is located at this URL http://www.google.com/[^]. If you type your query there, it would guide you to appropriate tutorials instantly. Wonder what it is? It is 'Internet Magic'.
Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
