I am working in a project where i have to add employees in a company. I have a form with text fields(for example name,surname,age,...). What i want is to insert this txt values into a database. My project is connected with an sql database. How can i add the values into a data table on button click("submit")?
View 9 RepliesI am using Visual Studio 2010 with ASP.NET, VB, and using SQL Server as my database
I am creating a website using ASP.NET and I have a mailing list database, I have a add to mailing list page that takes in certain fields (Name, e-mail, phone number) that are TextBox and a sumbit button. When the submit button is clicked how to do I take the current values of those text fields and add them to the database.
I have done it using the DetailedView which works at adding to the database but I also want to redirect to a different page after inserting.
how to take the values from the TextBox and insert them into the database, or how to I redirect to a different page after inserting a new row with DetailedView.
Here is my code with for the .aspx file, it has both the TextBox's and the detailed view
<p class=whiteMail>
First Name: <asp:TextBox ID="FirstName" runat="server"></asp:TextBox> <br />
Last Name: <asp:TextBox ID="LastName" runat="server"></asp:TextBox> <br />
[Code].....
I am going to start project in VB.net using MSV.Studio-2008. In that I want to use sql server that is provided with MS visual studio. How can I use it and how can I create database in that server. I dont have any separate sql server installed in my PC except provided my visual studio-2008. Is it possible to use it? how to start with and how to make connection in such case?
View 1 RepliesI am new to SQLSever, Visual Studio and Visual Basic. I have read through Microsoft Visual Basic 2008 by Michael Halvorson and Microsoft Visual Studio 2008 by Lars Powers and Mike Snell. These books mention the ability to use SQLServer as the DB but I am not clear on the process. I am not knew to programming an have had training in OO programming but have never done any OO programing professionally. So, you can assume I am new to OO programing.
I have created an SQL DB using the Server Explorer in VS, and created a Windows form with Labels, TextBoxes, and ComboBoxes for the application's user to add the demographic information about a new employee. I created a new query with the Query builder that is in the Employee table of the DB which contains all the field for the record for inserting. I have a few questions to understand the process for inserting into the DB.
The DB fields are defined as numeric(6, 0), nurmeric(5, 2), and char(30) for some examples.
The maxlength on the form windows are in sync with the maxlength of the DB for the various fields.
1. What is the process to update the DB with the fields from the form?
2. Do I need to declare and set the results from the form first? If so, how do I call the function (query) that I created in the Employee table.
3. The emp_num I would like to be a dynamically incrementing number starting from 1000. How do I make this a dynamic? The emp_num is also the key on the Employee table.
4. I have a decimal field on the Employee table to hold emp_rate (pay rate). Does the user enter the decimal on the Form or is this resolved by SQL to take the 7 numbers and insert the decimal beause of the table's field definition?
I'm looking for a control that allows images to be placed onto it and moved about. Moreover, I need to draw lines between the images. It will sort of be like the query designer in SQL Man Studio. It will be used as a virtual desktop where a variety of objects (and their icon representations) can be freely placed and moved. I'm having a blank and cant remember where I saw this before.
View 2 RepliesI have a database in access and one of the fields is 'Is Quick'. I have a query that filters all of these out. How would I get the data from that query in Visual Studio 2010 (Express). VB code please.
View 1 RepliesIs it possible to import a query from Access 2003 into Visual studio 2010 (language used vb.net).
I created the queries originally for a project, then when I imported the database to visual studio I can only use the tables that i created. I have started looking at the coding to re-do these, but if I can import them would it be quicker?
Will i be able to successfully install 2010 beta 2 side by side 2008? because i want to test 2010 features and some development toolkits such as silverlight while i don't want to uninstall my visual studio 2008 professional.
View 2 Repliesi'm getting an error with the code below
The Error.... SQL Syntax Errors Encountered
Error in Select clause: expression near 'DESC'.
Missing from clause
[code].....
I am new to VB and trying my hand at the below code. I am trying to determine the number of records for each possible combination. Depending on the outcome of the number of records groups may be combined. I am not able to find the record count for each grouping. Can you please look at the code below and suggest what I am doing wrong?
[Code]...
I am trying to run this sample code [URL] I added reference to System.Data.SqlServerCe in project. I get the following error?
SqlCeException was unhandled
There was an error parsing the query. [ Token line number = 1,Token line offset = 8,Token in error = FROMUsers ]
myDA.Fill(myDataSet, "MyTable")
I'm looking for specific and current advice from professional .NET + SQL Server developers on:[code]I'm starting a new position next week in which I will be developing advanced accounting software (LAN software) using Visual Studio 2010, Visual Basic, and SQL Server.I am an experienced programmer (16 years), with a strong background in web development using Python, PostgreSQL, PHP, MySQL. I have also completed a number of smaller projects in Visual C#, so I have a general familiarity with .NET. I have not used Microsoft SQL Server.
View 2 RepliesI have installed VS 2008 Pro for VB.Net and want to know if SQL Server 2005 will work with it or not?
View 1 Repliesfirst of all sorry if this is not the right place to post this question. yesterday i bought Microsoft visual studio 2008, so as to develo web application, then i installed it in my pc. after installing it in my pc, i have seen microsoft Sql Server 2005, in my start menu programs. wow that is nice, but now i want to create database and then connect it with visual studio 2008, so how can do that? this is my frist time to use sql server, so where can i create tables and databases? and how can i connect it with visual studio 2008?
View 2 RepliesI recently got into this article. It makes a chat server and people can connect to it like an AIM. The problem how would I disconnect from the server from the client. Because if I close the client application when its connected to the server it will crash the server as well. Please let me know if anyone has any solutions.
View 1 RepliesI made a simple chat system that connects to a server with a client one on one. I'm not really sure how to get multiple clients with the server so that you can see everyone's messages. Here is the source code. The Server only accepts one client at a time.
View 3 RepliesINSERT INTO [ET_SolutionText]
([SolnTextKey]
,[SolnTextValue]
,[SolnTextTitle])
[code]....
In Above Query, SolnTextValue is XML field. How i can format XML data in Values using insert query in SQL server 2008?
I have Windows Vista Business on my machine and running visual studio 2005 (Version 8.0.50727.867 (vsvista.050727-8600)) as well as "ENU Service Pack 1 (KB926601)" and "Update for Microsoft Visual Studio 2005 Standard Edition - ENU (KB932232) "I'm trying to connect to SQL server 2008 Express via Visual Basic and I've gone through all the forums to try to resolve my issue and it seems that I have to install " Microsoft Visual Studio 2005 Service Pack 1 Update for Microsoft SQL Server 2008 Support" However, when I try to do this I keep on getting the error "The upgrade patch cannot be installed by the Windows Installer service because the programme to be upgraded may be missing, or the upgrade patch may update a different version of the programme.
View 9 Repliesproblem use Visual Studio 2005,2008 with Microsoft SQL Server 2008 R2 , when open vb.net choose : add new data source and choose database and add connection when choose Microsoft SQL Server (SqlClient) show error this version not supported
View 2 Repliesi have this database format in SQL:
ID name add num
1 fel mn 201
2 john kaye 23
3 Kate mani 25
I used databinding to call the values on (SQL) to textboxes in visual studio 2010 and i have this code in NEXT command:
Inter is the name of the databinding
With inter1
If .Position = .Count - 1 Then
[code]....
The code above display the information not on Random. How can i display those information in Random mode? And i need a msgbox when all the data has been already seen by the user. I mean no redundant data will be seen by the user upon random mode has been done.
I hope I got all that in this question title. Let me explain. We are starting on small desktop app that will snowball into a big app with many forms. The database is SQL Server. It will have classic stored procs/functions performing classic CRUD functions. Given a table or stored proc in SQL Server what is the quickest way to create a form with all the hooks to maintain a table.
For e.g. lets assume I have table like this (most code below is pseudo code)
Table Employee
{
Name varchar(30)
DOB Datetime
Address varchar(100)
}
From this as source I want to create my Target which is form with 3 labels and 3 textboxes with add delete modify buttons (or OK button to add if not exists or modify if exists)
[Code]..
The code generation tool or technique that will be used should generate the correct db hooks (create SQL parameters, SqlCommand, execute sql.. basic try catch etc. Is there any open source tool to do this ? Some trick or templated approach via VS 2010 ? Worst case any third party tool ?
I created a new project. I copied files from the original VS 2008 project into the new VS 2010 an used "include" in VS 2010.I get an error saying "Error 108 Maximum number of errors has been exceeded."
It seems that EVERY field in the webformsuser-controlsASCX's has the error message "fieldName' is not a member of".I tried a delete the contents of the ASCX and ASCX.vb for a specific ASCX. Compiled and that page had no errors (although the other pages did). Copied back the contents ASCX and compiled (although the other pages did). That page had no errors. Added back the code-behind in the ASCX.vb and compiled. Same error.'fieldName' is not a member of They fieldName can be anything. Textboxes, hiddens, checkboxes, etc.
what am I doing wrong? I have spent hours on this I am hoping I am just missing something simple.
Have anyone worked on a project on 2 different computers with different version of Visual Studio Express?
In my case, I have made (and still working on..) a project in VSE2008, which I have installet at my job-computer.
At my homepc I have VSE2010 installed. I am a bit afraid to try working on that project from another version of the Visual Studio..
I tried to install Microsoft Silverlight 2 but fail - fatal operation however I managed to install Silverlight 3 for Visual Studio 2008. Do you think I need to install Silverlight 2 as well because it clearly to see that Silverlight 3 is a latest version. Please response. Secondly for Visual Studio 2010 I managed to install very easily with Silverlight 4. There is no problem at all. I think, I more likely in VS 2010 Professional. But I have to keep this together (VS 2008 and VS 2010) because I still need to develop certain program. Can I maintain both of this version together?
Website: GuidedMissileDesign.comWebsite: GuidedMissileDesign.com
im starting ado.net and have some problems i can read from data base but when i wanta to insert some data ,visual studio.net show me some errors my code:
[Code]...
I have a Visual Basic project and when working and modifying code, the compiler will crash and then a message will say something like "Microsoft visual studio encountered a problem and was shut down." I've tried editing code from the solution and the project. Both produce the error. Usually occurs when adding an "IF...Then..." condition. May work for hours but then crash. Solution will compile and build.
View 3 RepliesI have a situation where I want to run a Visual Studio macro that has the user type something in an InputBox, then inserts a snippet and includes that text somewhere in it. Unfortunately, I can't figure out how to insert the snippet from macro code. It seems like it'd be something like
DTE.ExecuteCommand("Edit.InvokeSnippetFromShortcut")
or DTE.ExecuteCommand("Edit.InvokeSnippetFromShortcut", "theSnippetName")
Basically i want to know if the visual studio IDE and/or compiler in 2010 and 2012 was written to make use of a multi core environment (i understand we can target multi core environments in all versions using parallelism, but that is not my question).I am trying to decide on if i should get a higher clock dual core or a lower clock quad core, as i want to try and figure out which processor will give me the absolute best possible experience with Visual Studio 2010 or 2012 (v11) (ide and background compiler).
If they are running the most important section (background compiler and other ide tasks) in one core, then the core will get cut off quicker if running a quad core, especially if background compiler is the heaviest task, i would imagine this would be difficult to separate in more than one process, so even if it uses multi cores you might still be better off with going for a higher clock CPU if the majority of the processing is still bound to occur in one core (i.e. the most significant part of the VS environment).
I have an issue with Visual Studio's support for coloring User Types in VB.NET, I'm an C# developer that have been forced to code in Vb.NET by political rules in my organization, and I really misses the support for coloring user types in Vb.NET, I had hoped that this would be solved in Visual Studio 2010 and well in the beta they have added Vb.NET User Type coloring, but the coloring is the same for all user types I cant't have one color for interfaces and one for classes and so on.
View 3 RepliesI've made a fairly good Windows form application to solve quadratic equations, but I am having a hard time understanding the publication process microsoft uses in Visual Studio. I'd like to distribute my programm as freeware on my blog.
View 5 Replies