Is it possible to disable Visual Studio (2010) query renaming feature? For example, when I "SELECT * FROM table_name" VS will rename my query to SELECT id, name, type, inspectedBy, inspectedDate FROM table_name"
View 1 Replies
I am trying to write a script in Visual Studio 2008 (using a VB project) that will, upon the clicking of a button:
- An file object will be created.
-Said file object will read in a number of files from a specified file path.
-A dataset will be created and populated with fields from two columns within a database table; app_id and company_name.
-The script will read through the file names and fields recorded in the dataset, renaming the file to the app_id if the original file name contained the company_name.
The code I have so far to do this:
[Code]....
The problem is that currently this code will only rename the file if the file name and company_name match exactly, ideally I'd need to include a clause to make it rename if the file name is "LIKE" or "contains" the company_name. To be honest I'm not even sure if what I want is possible, or if what I have is even on the right track. So far my own research into the issue has been less than conclusive.
I have recently upgraded to SQL Management Studio 2008. The first thing I noticed is it wouldn't allow me to save changes to my table structure at all. I fixed this by disabling "Prevent Saving Changes that requre table re-creation" under Tools..Options...Designers...Table and Database Designers. Now it lets me save. However, if I rename a column in a table that has data in it, I get a warning telling me my data will be lost since the old column will be gone and the new column has no data in it. Since when does renaming a column require a table to be recreated? Is this some sort of setting in SQL Management Studio? If I can't don things like rename clolumns (even change column data types) without losing all my data, then what is the point of using SQL management studio?
View 2 Replieseverytime i debug the application i get the disassembly tab window i tried tools/option & unchecked show disaasembly if not is not avaliable & sourec file to exce;ty open the original file
but still i get after making the chnages i restarted my system but still i get it
how do i disable teh disassembly tab
How do i disable the creation of .bak files in visual studio 2008 for my asp.net application?
View 2 RepliesI just want to disable "return" word. is it possible??
View 2 Replies In both VS 2008 and VS 2010 when we open websites using FILE > OPEN WEBSITE we get a prompt asking us if we want to convert the website to .Net 3.5 or .Net 4.0.
I know once you answer it wont ask again for that site, but it gets annoying when we have alot of websites. We cannot convert the sites because the servers they run on are too old.
Is there a way to disable this prompt permanently?
TMVC 2.6.13
VS2010
MVC 1.0
Target .Net 3.5
How can I disable warning message?
I have been developing my web site for a while, everything was ok. The hard drive of Visual Studio 2010 installation was damaged, after re-install VS 2010, every time I start debugger for my asp.net web site, VS pops up a diaglog to ask for user name/password.How to disable that popup? Is is just debugging, security is not an issue at all.
View 3 RepliesI am having problems disabling the autoinsertion of quotes for the 'style' and 'class' attributes on VS2008 SP1 on 64-bit Windows 7.
When I type:
<div class="
I end up with
<div class="""
In Tools->Options->Text Editor->HTML->Format, I set "Insert attribute value quotes when typing" off (and "...when formatting" is also deselected) but it still seems to insert the quotes.
why automatic quotes might be disabled for everything but style and class attributes?
I'm creating a website in Visual Studio 2010. I would like to use Visual Studio for C# debugging, but it also uses Visual Studio as JavaScript debugger. Is there a way to disable script debugging for Asp.Net website projects? I run my projects by hitting F5 in my Visual Studio. (I've noticed that when I attach the debugger manually, I can specify the type of stuff I would like to debug.) Note: I would like to debug, but not with Visual Studio. The developer toolbar is enough.
View 3 RepliesI have a query that, when run in SQL Server Mgmt Studio query analyzer window, completes in about 5 seconds. However, when I attach this query to a table adapter in visual studio and try to preview the data, I get an error that says:"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."Please note, the dataset was successfully configured using the TableAdapter Configuration Wizard, so there didn't appear to be any syntax errors with my query. Also note that I have other datasets connecting to the same database that are working as expected, so it doesn't appear that it would be an issue with the server not responding. Does anyone have thoughts on what kinds of things, other than a query taking too long to run, that could cause this specific error?
View 1 Repliesis it possible to convert whole visual studio 2008 web site project to visual studio 2010 web site project
my current project references
i have a very annoying iis problem
iis server stops working until app pool is recycled
i am hoping that new visual studio (net framework 4.0) may solve this very annoying unsolveable problem
I'm having a hard time really grasping this concept. I've done a lot of development with Microsoft Access, so I'm very familiar with the structure of tables, queries, and all that sort of thing. And maybe that's really hindering me with understanding what to do with ASP.NET/VB.NET development.
I have an ASP.NET web application, and I want to pull a UserName and the date that this user was created and last logged on. UserName is in the ASPNETDB's aspnet_Users table, and date created and last logged on is in the membership table. So in database explorer in Visual Web Developer, I opted to create a "New Query". It brought up the UI and I selected these two tables. Linked them with the primary key of UserID. Then I selected the three necessary fields (UserName, date created, and last logon date). Looks good, viewed the data. But there is no way to save this query to programatically reference it. I want to see what user is logged on, and then look through this query to get the other two pieces of data. But there is no way to save/reference this query.
This has bother me for a long time but I cannot believe there is no such a simple function. I start a new query through the "Server Explorer". The query builder is brilliant and I can easity build and test my queries. The only problem is: there is no way to save it!
If I want to use this query as a stored procedure, I need to create a new stored procedure through "Server Explorer" and than copy the query into it. And I also need to define all the parameters(filters) to finish that strored procedure. This is a boring and frastrated job as I belive the query builder has all the information to as this query into the stored procedure.
sql_select = "SELECT auid FROM tbl_auAccount WHERE username='" & IarUN & "'"
'Step Three is Creating Connection Object and opening the database
'Add Error Trapping Later
con = Server.CreateObject("ADODB.Connection")
con.Open(data_source)
'Step 4 is to Execute the SQL Command
con.Execute(sql_select)
'Step 5 Done. Close the connection
con.Close()
con = Nothing
This works fine, but I want the returned id (which I will right code to make sure it is not null and that it is only one returned) to show up as a label (or the text of a label)
lblShowNEWUserauID.Text = ?
When i create a sql script in the Query Builder (going through the wizard in a DataSet) the Query Builder window is to small for me. Is there a way to maximize this window by default?PS, I have previously posted this in the forum "Visual Studio 2008.
View 2 RepliesAnyone know if I can maintain a VS 2008 (.net 3.5) project by using the VS 2010 IDE ?
View 1 RepliesI'm using Visual Studio 2008 Query Builder and am trying to pass a value to a parameter that uses the IN OPERATOR.Here is my sql from qb:
SELECT COURSE_TITLE, INSTR_NAME, ADMIN_UNIT
FROM vwHRIC_EC_ContractSummary
WHERE (ADMIN_UNIT IN (@ADMIN_UNIT))
The trouble I am having is that if the parameter @ADMIN_UNIT contains more than one value such as (8X, CV) that the query doesn't return any data. If I run the same query with only one value such as (8X) it works fine.I have tried different formats like (8X, CV), ('8X', 'CV'), (8X; CV) but none have worked.I ran this same query in SQL Server Management Studio and and it returns data no problem but can't get it to work in Query Builder for my aspx application.Does anyone have any experience with this problem and how did you correct it?
where to find/download visual source safe plug in or visual source safe client for visual studio 2005 IDE?
I do not want to install visual source safe 2005 server.
Is it possible to migrate the application which is in visual studio 2003 to visual studio 2010. provide me details about how to migrate.
View 2 RepliesI have a site in production developed in 2005 and i am planning to migrate to Visual studio 2010. Is there an easy way to do it?
View 1 RepliesI want to use a source control in VS2010, I know my best bet is TFS, but at the moment TFS(can't afford ). As i understand TFS is the new VSS_2005(can afford)Can VSS 2005 be use as a source control for VS 2010 solutions/projects?
View 2 RepliesI just recently upgrade my asp.net web project from visual studio 2005 to visual studio 2010. The upgrade was successful with no problems however im missing some features with this project. The One Click Publish feature(which is greyed out) in the header area of Visual Studio 2010 and the Add Config Transforms feature which is no where to be seen when you right click on web.config. When i create a new web project straight from visual studio 2010, these options work fine.
View 1 RepliesVisual Studio 2010 Beta 2 locked up, and when I tried to restart it, it wouldn't load, so I did a devenv.exe /resetuserdata to get it going again. It reset everyhing in my options of the web app/ etc, and now some AJAX conrols don't work such as dragpanel. I assume that it is because something got reset that I haven't enabled again, but can't figure it out.
View 2 Replies
