using VWDExpress2010, is there a way to print the table definition for an SQL table that has been created within the designer? I would like to begin using SQL databases for more of my projects but find the difficulty in working with the tables (compared to other options) to be such a pain that I usually choose some of the other formats. Typical problems are simply documenting the structure, moving data in and out with some form of command line feature, etc.
I have an ASP.Net website as one of the projects in a Visual Studio 2010 solution. I have several files in my ASP.Net website project which are named correctly according to the expected pattern of *.aspx and *.aspx.cs, however, when I view them within the ASP.Net website project, they are not displayed hierarchically and are instead displayed in a flat file view adjacent to each other. How do I get the files to display hierarchically within Visual Studio as they are normally when I add a brand new .aspx page to the website project? I have been looking all over for a corresponding Visual Studio MSBuild or settings file that might be storing these hierarchical display settings but have found nothing as of yet.
I am planning to develop an application with asp.net mvc 2. In my project it is very large project.How to plan the solution structure in visual studio 2008. My requirement is module wise solution structure in visual studio 2008 using asp.net mvc2.
I'm not sure if I'm asking this correctly, but I'm having a problem with a web service. The company hosting a web service wants to see what I'm submitting to the API. Is there something in the debugger I can use to "print" or somehow get the request object and all of it's properties with values in Visual Studio? I'm guessing there's some way to get the XML request?
I have a folder with a web site I'm developing which is connected to a database.Every time I move the folder to a different computer it's a pain when I have to move the database and change the connection string. I've thought to use for the first time a database in the app_data folder and move all the database inside it. Nevertheless, when I try to recreate all the tables in the new database for the first time with the query "create table ..." I get and error saying that "SQL CREATE TABLE" is not supported. Is there a way to manage this situation?
When i drag my table into any asp page inside the Visual Web Developer aspx page, Nothing happen, Even there is no datasource or gridView it just the blank page i created.
I tried to create new web forms and all same results i got.
I use vs2010 to study the asp.net mvc and I have a strange fool quiz . I can create tables successfully, but when i wanna change something ( just like the name of a field , the "Allow Nulls" checkbok ) and save it, the software will give me a tips :
How can i figure up the problem? and by the way , now I have a table call "categories" and i want to change the name to "Categories"
my question is that i actually want to make a table in a database and update delete the recordsin that table The thing is that i dont want to make the database table in the sql server but i want to make it in the visual web developer (the editor i am using) can any body gimme any idea abt how i can do this orany link regarding to this
I have a profile of member to be displayed. I am using a dataset with all the data table adapter to retrieve the information from database.
I have a memContact method which has NRIC and Number as a composition primary key. Thus, automatically, the table adapter has created a method called FindByICNum () for me. However, when I do the search to display the contents, i will only need to search by memberic instead.
Is there anyway to change the table adapter query?
i need to prepare a report as a table. but my table needs to contain data from two schemas. so my doubt is, is it possible to set two dataset names for a table in its property?
I am followint the insructions of this walkthrough of VS2003
[URL]
and in a part say this 8 Find the authors node and expand it to show the fields in the authors table. 9 Using CTRL+Click, select the au_id, au_lname, au_fname, and city fields. 10 Drag these fields from Server Explorer onto the design surface Now i am using VS2008
When i try to drag and drop i can not made it is maybe because of the differences between 2003 and 2008 versions
I added a DateTime column to a table in my database through the Server Explorer. Because the team lead for this project wasn't savvy on nullable types, one of the requirements was that there be no null values in the database. This requires me to program all sorts of useless code into the system, but that's another story. My problem arises when assigning a default value to this column. I typed the following into the cell for the "Default Value or Binding":
1/1/1753 12:00:00 AM
When I went to inspect the content of the table, I found that all of the dates had been populated with:
I 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?
I work with Visual studio 2005 and Sql server data base. I extract 1 million rows from a database and I put the rows in a Sql table. With a simple direct extraction, in a few minutes I complete the operation:
Dim cmd As New SqlCommand(query, cnSql) cmd.ExecuteNonQuery() cmd.Dispose().
But, if I must select and modify some fields between extraction and introduction, it takes a lot of time! I work in this way. I extract rows from Dbase, Table1, and I put all into a Collection using dataReader:
Dim cmd As New SqlCommand(query, cnSql) Dim coll As New Collection coll.Clear() Dim dr As SqlDataReader = cmd.ExecuteReader() I replace some fields with the string "YES". Dim toRepl As String = "" If dr.HasRows Then Do While dr.Read toRepl = dr(5).ToString If Len(toRepl) <= 3 Then ToRepl = "YES" collPrel.Add(dr(0).ToString) collPrel.Add(dr(1).ToString) .................. .............. collPrel.Add(toRepl) collCount = collCount + 1 Loop End If dr.Close() cmd.Dispose() Now, I insert all into a SQL Table2: Dim a As String = "", b As String = "", c As String = "" etc. For i = 1 To collPrel.Count Step 6 a = collPrel.Item(i).ToString b = collPrel.Item(i + 1).ToString .............. ............... f = collPrel.Item(i + 5).ToString queryIns = "INSERT INTO Tab (name, adress, etc) VALUES ('" & a & "', '" & b & "', '" & c & "', etc. ) Dim cmdIns As New SqlCommand(queryIns, cnSql) cmdIns.CommandTimeout = 600 cmdIns.ExecuteNonQuery() cmdIns.Dispose() Next
This way to work goes right but it is necessary a lot of time for completing the operation.
I 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.