executing the IISWeb.vbs commands from the c# code which I am trying to use for starting and stopping the websites on remote IIS servers (IIS 6.0).
I have tried other options like using DirectorServises with SyytemManagement or with WMI but in all cases code works fine for the local IIS server but displays error for the remote servers. I get 'Access denied' error for remote servers
I have got the all the servers in the same domian and network area and trying with a user account with administrative priviledge but nothing works for remote machine so giving it a try using IISWeb.vbs.
note that from my dev machine I am able to stop and start the websites on remote machines using this IISWeb.vbs commands without any problem when I run it from command prompt. So definitely there is no permission issues.
Code I am using:
Process p = new Process();
p.StartInfo.FileName = "cscript.exe";
p.StartInfo.Arguments = "iisweb.vbs /stop w3svc/87257621 test /s servername /u userid /p password";
p.StartInfo.UseShellExecute = false;
p.Start();
p.WaitForExit();
int i= p.ExitCode;
Surprisingly I am not getting any error and i get return code '0' but nothing but website is not getting stopped.
I am creating a web site through command line. I am able to create a web site with single host address. But i want multiple host address for a website. this is the command I am using iisweb /create D:Test Test.com /d [URL]
How do I build a web application project from command line using Web Developer Express 2010?
I am using the same command format that I would use with devenv.exe (Visual Studio), so I can evaluate us moving forward to VS2010. However, I am having real trouble building our code. Our solution consists of 4-5 projects, consisting of assemblies. The last assembly is the web site code. The root .sln file is the one which when opening in the IDE can click Rebuild All, and the DLL's of each project are generated and then brought into the website project.
However, when I run vwdexpress.exe from the command line nothing happens and no Dlls are generated. This is not giving me any confidence to run with VS2010.
The in folders of each respective project are empty, but it takes 3-4 seconds for the command to finish, which gives me the impression it did something.
I'm new in working with Shell commands by C#.I want to go to specific directory(c:Program Files) by command prompt by c# and run a java application from there.I have a code but its only can open a application from C: directory,I appreciate if anyone can help me regarding it
I want to issue an INSERT command for an SQL Server table using DataAdapter without first issuing a SELECT command. Could anybody send me lines of code to handle this? Also how do i manage INSERT into selective table columns (I have 10 columns but i only want to update 2 of them)?
I am working with odbcCommand class, in one case I got error that QueryTimeout Expired. Even though this SP is taking only 3-4 secs in DB to execute these specific values, When I set the CommandTimeout=0, then it worked fine.
1)Is it necessary to always use this property while working with Command Class.
2)If it is not suggested to use, but still if I use it then how it will impact the performance.
Below is my code sample.
OdbcConnection conObj; OdbcCommand cmdObj; OdbcDataAdapter daObj = new OdbcDataAdapter(); public DataTable GetIFAContractNoteData(string RecipientIDIFACN, DateTime BatchDateIFACN, int TransmittalReportIDIFACN) { conObj = new OdbcConnection(GlobalVariables.strDsnName + ";" + GlobalVariables.strDsnDataBase + ";" + GlobalVariables.strDsnUserID + ";" + GlobalVariables.strDsnPassword);
I've recently started working in ASP.NET and RDBMS.I'm making a test form where I can do basic add,update,delete operations.I'm using OracleDataClient to do the DB operations.I was able to populate a listbox using OracleDataAdapter.
Now after clicking on update button,I intend to Update in DB.I've Dataadapter with it's update property.But the update query is not happening.The examples I saw over net all have Select command before Update.Is it actually like that or am I missing some point.
How does Oracle DataClient work with Insert,Update,Delete Commands.
i'm trying to issue a select command in my app soi could execute the command and retrive the data into a string variable.the problem is that this command is overloaded with DataSourceSelectArgument and i can't figure out what it is.i'm using sql server express and when issue a n insert command for example sq.Insert(); i have no problems.this the command that's holding me:
SqlDataSource sq = new SqlDataSource(); sq.ConnectionString = ConfigurationManager.ConnectionStrings["CustomerDatabaseConnectionString1"].ToString(); sq.SelectCommandType = SqlDataSourceCommandType.Text; sq.SelectCommand = "SELECT * FROM CustomerTable where customerID = 1"; string result = sq.Select(some overload that's stopping me);
how would i do my Gridview delete command like a update command?
im using a datasource... and my delete command is like my update command... so i can change the status into "INACTIVE"...
DeleteCommand="UPDATE ACCOUNT_MAINTENANCE SET am_status = 'INACTIVE' WHERE (accmain_no = @accmain_no)"
UpdateCommand="UPDATE [ACCOUNT_MAINTENANCE] SET [account_type] = UPPER(@account_type), [min_deposit] = @min_deposit, [min_capital] = @min_capital WHERE [accmain_no] = @accmain_no"
when i press my delete command at gridview... the status changed into "INACTIVE" but when i refresh or press f5... it automatically update the status into "INACTIVE" also...
ave never used ajax.... I'm currently putting together a little web app that basically calls a program on the server itself (a command line tool) and displays the output to the web page.When the command line tool is run from the command line, it outputs status messages as it does it's thing... as it is now, my page just displays all the output when it's done. What I would like to do is show each line of output on the web page as they happen, just like when run from the command line. I'm guessing ajax is what I need... can anyone point me in the right direction for this specific scenario (user clicks button, output streams to web page as it happens without full page post backs)... a good example would be how ping.exe displays it's output on the command line
My program is doing good when I suddenly bumped into this problem. I dont know how to do the next functionality that I need to accomplish. I am done with inserting values, showing the gridview etc and it works great. Now my problem is the update command.
I have 2 tables table: tblDest Fields: destLastName destFname destEmail Table:tblSource Fields: Sourcelastname SourceFname SourceEmai
Now, when I run my update command in sql server, it works great! I just right click the database, click new query and i run this command:
Code:
update tblDest set DestEmail =(Select SourceEmail from tblSource where tblSource.SourceFname = tblDest.DestFname and tblSource.SourceLastname = tblDest.DestLastname) what the query does, is it updates the table tbldest email where lastname and firstname exists in both tables that are equal, the question is, I want to automate this, I am done with inserting values, the problem is, I dont know how to run the update command, I tried doing this:
Code:
Dim sqlds As New SqlDataSource sqlds.ConnectionString = ConfigurationManager.ConnectionStrings("sqlconnect").ConnectionString sqlds.ProviderName = ConfigurationManager.ConnectionStrings("sqlconnect").ProviderName sqlds.UpdateCommand = "update tblDest set DestEmail =(Select SourceEmail from tblSource where tblSource.SourceFname = tblDest.DestFname and tblSource.SourceLastname = tblDest.DestLastname)" DestGrid.DataSource = sqlds DestGrid.DataBind()
I've been trying to use the same SqlConnection and SqlCommand objects to execute to different commands.
the first one checks for duplicate and the second one inserts the data if the data the user entered is not a duplicate.
Here's a sample of my code:
using (SqlConnection conn = new SqlConnection(ConnStr)) { string Command = "SELECT CountryName FROM [Countries] WHERE CountryName = @Name"; using (SqlCommand comm = new SqlCommand(Command, conn)) { comm.Parameters.Add("@Name", System.Data.SqlDbType.NVarChar, 20); comm.Parameters["@Name"].Value = Name; comm.Parameters.Add("@IsVisible", System.Data.SqlDbType.Bit); comm.Parameters["@IsVisible"].Value = IsVisible; conn.Open(); if (comm.ExecuteScalar() == null) { Command = "INSERT INTO [Countries] (CountryName, IsVisible) VALUES (@Name, @IsVisible);"; comm.ExecuteNonQuery(); } }
I was trying to save a trip to the database by using one connection.
The Problem is:
The first command runs okay but the second command which inserts into the database won't work (it doesn't add any records to the db) and when I tried to display the rows affected it gave me -1 !!
The Question is:
Is this is the ideal way to check for a duplicate records to constraint a unique country ? and why the second command is not executing ?
I'm trying to send an HTTP command using VB.NET and I'm not quite sure how to do it. I don't want to actually navigate to the page, just execute the command.http://xbmc.local/xbmcCmds/xbmcHttp?command=ExecBuiltIn¶meter=XBMC.updatelibrary%28video%29hat I'm doing is building an integrated interface for my XBMC home theater, and my home automation.
