the link is http://www.sqlcommands.net/sql+join/ i would like to know if it would work if it were SELECT Weather.City FROM Weather WHERE Weather.City = State.City meaning select all those cities "from weather" which belong in the state table will the above work if not then why? ...
Visual Studio ( VSTS 2008 ) design mode work good for long time and from about 2 weeks ago it's suddenly stop view any thing in design mode i tried a lot with trying in another projects even in a simple web page but no way it's doesn't view any thing in design mode ... I think to reinstall VS 2008 again but I don't know if is there any o...
one websevers one website one page, three users clients two dbservers different databases on each using sql server 2005 server express when any of the client accessing the page from his computer clicks on button A ---- connect to 'table1' of db 'first' on dbserver1 button B ---- connect to 'table1' of db 'second' on dbsever2 questi...
Hello everyone, I am using ASP.Net + .Net 3.5 + VSTS 2008 + IIS 7.0 + C# to develop a web application. I find when debugging in VSTS 2008, if I call Response.Close() method in page_load (please refer to code below), there will be error (from IE when accessing the page) like can not connect to server. My question is, Normally when sho...
using :- sql servr 05 and vs08 c# website asp.net Okay, I have always used SQL Server 2005 Express and its Management Studio as a host and a design interface to create tables from design view only. All the queries, transaction, retrieval and anything needed during run time of the website is done using Visual Studio 2008 sql "connection ...
Hello everyone, I am using ASP.Net + .Net 3.5 + VSTS 2008 + IIS 7.0 + C# to develop a web application. I am using WebPartManager, and I find when personlization feature is enabled to true, the web application will connect to SQL Server Express version database automatically. BTW: I find this by when stop SQL Server Express version serv...
Hello everyone, I am using ASP.Net + .Net 3.5 + VSTS 2008 + IIS 7.0 + C# to develop a web application. I am creating a very simple web application, and I just modified page_load, Session_Start and Session_End. Here are my code, my question is I find session ends message is written to file immediately after session start message. My test...
Hi, I am working on an excel2007 plugin in VSTO and am using VB for coding it. One of the item in the plugin is the button, pressing which should give a call to a python program which will add some data to the current worksheet. I would like to know 1 How can i call the python function from the VBA code 2 pass the active workbook to thi...
After installing some plug-ins for Visual Studio, they have added their own context menu options to the context menu of VS IDE. so now when I right click on the IDE, there is a huge list of menu items in its context menu. Is there a way we can add/remove the items that are showing in this pop-up menu of the IDE? ...
Hello everyone, I am using SQL Server 2008 Enterprise + VSTS 2008 + C# + .Net 3.5 + ASP.Net + IIS 7.0 to develop a simple web application. In my database table, I have a XML type column. The content is like below, I want to get AdditionalInfoList of all rows in the table if Title contains "software engineer" or Info contains "Software ...
I need code example please.i tried selectedindexchange but it doesnot register any index change what to use? its c# vs08 asp.net sql server the code files are .cs file using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient...
how to set the insert button as the default default for formview? i did this for input focus, but how to default insert button, i tried panel but it say type needs to be ibutton.!! ...
well the question is simple, javascript is used where one want to do something on the client side purely or wants to send something to the server in a manner that postback does not occur but in vs08 controls asp.net c# i have seen that when the page is displayed in browser the controls namely gridview, formview, LINKBUTTON!!! all sh...
"I DONOT WANT TO use the default error page tachnique, because i donot want the webpage to redirect!" yes there is the try and catch yes there are way to add exception handling mathods overwrite for controls but what i need is, it may just be a simple sql command,it may be a control such as formview, it may be a control such as datag...
Hello everyone, I am using ASP.Net + .Net 3.5 + VSTS 2008 + IIS 7.0 + C# to develop a web application. I want to count how many users are online. This is my current implementation, when Session_Start is called, I will increase # of users online by 1; when Session_End is called, I will descrease # of users online by 1. Two quesitons,...
Hello everyone, I am using ASP.Net + .Net 3.5 + VSTS 2008 + IIS 7.0 + C# to develop a web application. I want to use Fiddler to debug (i.e. monitor request and response Http traffic) local traffic -- i.e. when I test web application inside VSTS 2008's built-in test ASP.Net web server. Is that feasible? If yes, how to monitor such traffi...
Hello everyone, I am using C# + VSTS 2008 + .Net + ASP.Net + IIS 7.0 + ADO.Net + SQL Server 2008. I have a ADO.Net datatable object, and I want to filter out duplicate/similar records (in my specific rule to judge whether records are duplicate/similar -- if record/row has the same value for a string column, I will treat them as duplicat...
Hi, I have created a addin for excel, where there is a ribbon and a button on it. I have handled the event of button click with the following code Private Sub test_button_Click(ByVal sender As System.Object, ByVal e As Microsoft.Office.Tools.Ribbon.RibbonControlEventArgs) Handles test_button.Click Dim activeWorksheet As Excel.Work...
When I run the Release build of my (VS 2008 .NET) unit tests, I get the following exception: System.IO.FileLoadException: Could not load file or assembly 'arcVegaORM, Version=1.0.3856.24327, Culture=neutral, PublicKeyToken=0dd85ae1d99ddbee' or one of its dependencies. The located assembly's manifest definition does not match the assemb...
Hello everyone, I am using C# + VSTS 2008 + .Net 3.5 + ASP.Net + IIS 7.0 + ADO.Net + SQL Server 2008. I want to develop an ASP.Net aspx page which has the following function, 1 It could accept 3 Url parameters param1, param2 and param3, and the request looks like this, http://mysite.com/foo.aspx?parame1=abc&param2=def&param3=g...