|
nedusmile wrote: " values (@PatRep_ID, @DateCol, @WrngDataDate, @Data_Field, @Provider) select scope_identity()", con)
Interesting, I never knew you could append a select statement to the tail of a prameterised query. Comes form using stored procs 100% of the time  !
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
i have table for advertisement
i want trans advertise which completed 15 days automatically to another table archive
thank you
|
|
|
|
|
you can write a script and run it from a SQL job that checks your table and move rows that comply with your constraint...
I am assuming you are working with SQL Server
|
|
|
|
|
|
NNR_Noga wrote: i want acually code
We all do:
You need to use the DateDiff function :
DateDiff[^]
Create a Job:
Create a Job[^]
|
|
|
|
|
Read this [^] to understand why Bassams answer was so good.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi,
My company has now decided that we developers now have to bring in a persistence layer in our applications(mostly c#.net,wpf and ASP.net). Previously I wrote my own entity classes and had a common data class handle all my database transactions. This data class used Corelab's Unidirect to generate sql for a vast multitude of DBs and defined the way in which you are to communicate with the database. Now I have to implement Nhibernate. I've never used it before and apparently it makes our job as developers easier. I do not yet know whether this is the case and so far it has only complicated things. Can anybody tell me if Nhibernate is worth the effort as I don not yet know the product well enough to make a conclusion. The learning curve is messing with my productivity.
|
|
|
|
|
It is very hard to answer your question. NHibernate is a very large open source project, it will take everyone much time to make use of it in a good way. Like any framework, simply using it doesnt mean you are using it effeciently. yet once you learn it and there are many articles here in CP, it will bring great value and ease to your team.
Now that being said, there are other Microsoft framework that may be worth digging into like Entity Framework but I am not expert on EF so I cannot recommend it over NHibernate.
|
|
|
|
|
how to create edb in C# and read data from there. 
plzzzzzzzzzzzzz anyone help as soon as possible.
|
|
|
|
|
I am assuming you mean Enterprise Database? The answer is the same as you open a sql or any other kind of database:
using EnterpriseDB.EDBClient;
string strConnectionString = ConfigurationSettings.AppSettings
["DB_CONN_STRING"];
EDBConnection conn = new EDBConnection(strConnectionString);
try {
conn.Open();
Response.Write("Connection opened successfully");
}
catch(EDBException exp) { exp.ToString(); }
finally {
conn.Close();
}
I have not compiled the code so expect errors
|
|
|
|
|
How can I write some text to the Event Viewer from a stored procedure?
|
|
|
|
|
|
Quoted from this[^] website;
xp_logevent {error_number, 'message'} [, 'severity']
I are troll
|
|
|
|
|
I'm fairly new to ADO .NET concepts.
I understand that the framework gives a Data.SqlClient namespace with its collection of classes. I installed SQL Server on my machine, but not the SQL Client. And connected/queried the database from C#, using these provider classes.
I deployed my application on other machines as well to connect/query the 'database on my machine'. I did not install the SQL Client that comes with SQL Server on any of the machines.
My question is - for a production envionment is there a necessity for SQL Client licensing for various users? Is mere installing SQL Server on a network server not sufficient when I'm using ADO .NET?
How does this licensing - sql client installation - server set up work?
I tried to read a number of sites but I could not get a straight answer to my question.
I greatly appreciate response.
Thanks
Ap
|
|
|
|
|
You don't need licenses on the client machines. The server needs to have a license for the appropriate version of SQL Server, unless it's SQL Express.
I are troll
|
|
|
|
|
|
There is Something that you are not Doing Right. You must always remember that SQl is not shipped with your Application.
SQL server must be Installed Separately and it has nothing to do with what you have in your Application. In your Application if you decide to use SQl , then you will use appropriate libraries and use ado.net. When you are done compiling your application , you will install the setup project on the client machine that has .net installed and your application is supposed to work, there is nothing extra that your application needs than SQl Server, so no licenses.
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
how to remove all sql server 2005 componet? After i remove it from Add/Remove Program, why it still appare in Start=> Programs => Sql Managment Studio. how can i remove all of it? 
|
|
|
|
|
uninstall Sql Management Studio from add/remove programs
|
|
|
|
|
Why did you vote me down? It's a separate application which isn't removed when you uninstall MSSQL, it has to be uninstalled separately...
|
|
|
|
|
because i have done as what u said so many many times as i can. even i go into registry delete some KEY in LOCAL_Machine, but i can't run it after i reinstall new SQL server 2005. 
|
|
|
|
|
That is no reason to down vote someone. He gave you the correct answer. It is not his fault that your system is screwed.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
ok...  u and him are good .... course of my fault.... 
|
|
|
|
|
"Unable to access first record" this error occur while generating crystal report. i m generating crystal report using vb.
if anybody has any solution please suggest me.
thank you
|
|
|
|
|
If you really want help, you're going to have to give everyone a bit more information than that.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
