• C# (Microsoft .NET)
• JAVA
• Dynamic HTML
• PHP & MySQL
• ASP.NET - C# & VB.NET
• Perl & CGI
• C | C++
• Vector Markup Language
• SMIL
• Assembler
• Databases
• Wap Development
• Web site promotion
• Web Marketing
|

|
How to get all the processes in Microsoft SQL Server and store them in DataSet?
(C# free example written by Anton Zamov.) |
How to get all the processes in Microsoft SQL Server and store them in DataSet?
The method listed below returns a dataset which contains information for all the processes in Microsoft SQL Server database, the name of the SQL server is passed by a parameter.<br>
public DataSet GetAllProcesses(string serverName,string user, string password)
{
/*
This method is created by Anton Zamov.
web site: http://zamov.online.fr
Feel free to use and redistribute this method
in condition that you keep this message intact.
*/
DataSet ds = new DataSet();
try
{
SqlConnection cn = new SqlConnection("Server="+serverName+"; Database=master; UId="+user+"; Pwd="+password+"");
SqlDataAdapter cmd = new SqlDataAdapter("select spid,loginame,hostname,cpu,memusage,cmd,status from sysprocesses order by memusage desc",cn);
cmd.Fill(ds,"nc");
}
catch(Exception exc)
{
System.Windows.Forms.MessageBox.Show("SQL Server is not running or access is denied!");
}
return ds;
}
|
Still have questions?
Ask your question on TechOnlineHelp.com
or find more examples on www.netartmedia.net/examples
If this example was useful for you, please support my company and click Like on the button below.
Thank you very much!
|

|
Jobs Portal, poweful jobs board software
PHP Mall, multi vendors mall website software
Car Portal, php script for auto classifieds websites
NetArt Media, software products and services
Real Estate Portal, web software for real estate portals
Blog System, multi user blog hosting script
PHP Store, powerful e-commerce system written in PHP
Pharmacy System, software for running online pharmacies
|