-
C#, Webforms, VS 2005, SQL Hi all, quick hit question. I'm trying to update a table with an employee name and hire date. Session variable of empID, passed from a previous page (successfully) determines which row to plop the update into. It's not working even though i compiles and makes it all...
-
While working with the Gridview control enhancements I decided to see if there was some new features of SQL 2005 I could use... Check out my latest article on Http://tech-review.org which covers how to use SQL optional paramaters, Row_Number(), and how to dynamically control whether or not you bring...
-
My question is this. Do I need to use the line in green or does the Using command dispose of the sqlCMD object as well as the cn object? 'Maleki: Have fun use it but give credit if you do. =:) Private Function WhoIsYourDady(ByVal intID As Integer) As String Dim strReturn As String = ""...
-
It seems nobody wants to help. I am completely stuck and I need help. All I want is to be able to use my tableadapter and its insert method to insert data into my database ORDER table. my problem is using the tableadapter and my insert method to get the values of my textbox fields and dropdownlistbox...
-
I've found 2 possible solutions. 1.) temporarily change your stored procedure to select the columns you would like to see in the data table (what you see when you open the xsd file). Example: SELECT 0 as [CustomerID], 'some text' as [CustomerName] FROM Customer Comment out the SQL that created...
-
First part of .NET Express install went fine. Visual Web Developer 2005 Express work good ... BUT! Attempting to install - SQL Server 2005 Express Edition - Get Error The SQL Server System Configuration Checker cannot be executed due to WMI configuration ERROR: 2147942402 Researched above issue and found...
-
Hey All, I have built a Strongly Typed DAL for a system I am working on and I am trying to add filtered searching to it. Example: Before I put the Strongly Typed dataset in place I had a class file that made all the calls to the database/stored procedures. To accomplish this I simply added to the SQL...
-
After you do an insert you can return the key for the insert like: INSERT INTO [dbo].[table] ( name , phone) VALUES ("Denny", "555-1234") Return @@IDENTITY Also be sure to read on the differences of SCOPE_IDENTITY() and @@IDENTITY - to be sure which one you should use to return the...
-
First post, go easy on me. I have a table with 3 fields I need to filter with, ClientName(text), Status(text), LocationID(int32). I can create a where statement that filters all three, when there is a selection for each one. However, what I need is for the user to be able to pick and choose. Not having...
-
I'm coding something pretty common - using form input to create a dynamic database query and displaying the results. However, some of the form controls are multi-select boxes, so my query winds up containing a lot of loops and looking pretty messy. Any suggestions/example code on the best approach...