|
ok i have find Sql Server Agent but next what should i do?can you give me sove reference site from where i can get any solution.suppose i have to run a update query after checking the system date.what will be the process to do this?
Sujit
|
|
|
|
|
|
ok ....i have got yours point but i didn't understand where i have write the sql query...suppose i have a table test1 every day i will change its data by update query..for this i have already added a Scheduler..but i am not able to write sql query for update the table test1.
Sujit
|
|
|
|
|
In the Job properties (right click "Jobs", select "New Job", there is a list of items on the left hand side. One of those is "Steps". Clicking on that will allow you to enter a list of steps that you want your job to run. Any of those steps can be a T-SQL update query.
|
|
|
|
|
Hello ALL,
I have to populate some data in a treeview. My question is, till what level a tree can be expanded.
ex:
root
parent1
leaf1
leaf1.1
leaf1.1.1
like this i want 5 levels for a single parent node. Is that possible??
thanks in advance.
Bharath.S Ron
|
|
|
|
|
Why don't you give it a try and let us know what you find out?
|
|
|
|
|
Hello,
I tried it and i am able to go upto the fifth level, i am not sure about the maximum dept for a node.
Thanks
Bharath.S Ron
|
|
|
|
|
we have modules in vb.net windows application where we can declare our variable globally and use in N no.of forms.how in web application ?
Thanks in advance.
|
|
|
|
|
Please clear your specifications or requirements what you want to do.
Parwej Ahamad
g.parwez@gmail.com
|
|
|
|
|
I want global variables to be declared ..where should I do it ???
|
|
|
|
|
If you want to hold globaly any object (value) in web application then you can use Application variable in web application.
Parwej Ahamad
g.parwez@gmail.com
|
|
|
|
|
I want variables not objects
|
|
|
|
|
You can store any thing in Application variable. I think you don't have much information about Application in web application.
For getting more information about Application find in google.
Parwej Ahamad
g.parwez@gmail.com
|
|
|
|
|
i under stand ur problem ,
the best way to use the variable u need on all most all the forms is:
make static varible in on class and use where ever u need to want to use it value or set its value as uer requirement.
Note define that as public in class.
Hello Forum
Always be in touch to help about the topic ASP.NET
|
|
|
|
|
|
public static class MyGlobalVariables
{
public static int someVariable;
}
NOTE: This can be an indication of poor design - You should not be thinking in terms of global variables.
What you need to do is to think of what the purpose of the variable is and find out which class it should belong to. Put it there and have the class control access to it via a property.
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
"I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless."
My website
|
|
|
|
|
thanks ..Im taking your sugesstion given in note
|
|
|
|
|
Great.
Colin Angus Mackay wrote: have the class control access to it via a property.
I heard writing properties inside class as a bad habit ? What do you say ?
|
|
|
|
|
Who told you that? Properties are not a bad habit at all - they allow you to hide the implementation of setting and retrieving values.
To a certain extent, properties are just syntactic sugar hiding the fact that these are internally functions called set_... and get_....
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Thanks, But I read some where like exposing class variables through properties is a bad habit.. Any way I always used to do that, just seen Colin's code and got doubt again...
|
|
|
|
|
N a v a n e e t h wrote: But I read some where like exposing class variables through properties is a bad habit
Actually, it is a very good habit. You may, presently, wish to allow direct access to the variables because the class doesn't care what outside entities set on the variable. But if you do that and then realise that in fact you need to fire off an event, or check the validity of the value then you can't do anything about it.
Properties are methods in reality. A property called Address will actually compile to get_Address() and set_Address(string value). So, by using properties now, even although you may not strictly need them now, saves problems later when you make the field private. You can easily add code to the method (that backs the property) because the public interface has not changed. It isn't so easy moving from public field to public property because they are not the same thing. (Even although in C# the look like the same thing)
Two blog entries of mine that might be of interest:
* Why make fields in a class private, why not just make them public?[^]
* The public fields debate again[^]
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
"I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless."
My website
|
|
|
|
|
Thanks that was excellent
|
|
|
|
|
N a v a n e e t h wrote: I heard writing properties inside class as a bad habit ? What do you say ?
Good grief no. public fields (aka member variables) are a bad habit.
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
"I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless."
My website
|
|
|
|
|
Variables can be declared as Global in the configuration file.
|
|
|
|
|
help me with coding
Mohan
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
