Nigel Harper's Q&A profile

• Windows Forms changing values that are in a record ??

  In my application, I have collect the informations on a form and send to the SQL database tableAdapter.Update(mydatabase.Urunler). Until here there is no problem but If the user want to change this values What do i have to use in form I have used same Update method but it gives an exception. Where can the problem come from pls help.... I didn't get what you meant by exception but in case of updating a record (which is a datarow in your dataset) you can directly assign new values to the right records in your datarow then call DataAdapter.Update for storing them in your real database. Please check the following code, i have a Visitors table in my database and here im replacing new values with old ones ...Show All

• SQL Server using Output clause and return timestamp and return value

  I am trying to bring my stored proc's into the 21st century with try catch and the output clause. In the past I have returned info like the new timestamp, the new identity (if an insert sproc), username with output params and a return value as well. I have checked if error is a concurrency violation(I check if @@rowcount is 0 and if so my return value is a special number.) I have used the old goto method for trapping errors committing or rolling back the transaction. Now I want to use the try,catch with transactions. This is easy enough but how do I do what I had done before I get an error returning the new timestamp in the Output clause (tstamp is my timestamp field -- so I am using inserted.tstamp). Plus how do I check for co ...Show All

• .NET Development Website

  Can Any body help me how can i create a web site that ather than localhost,i want it to have an address like juandelacross.com in my own computer my os is server2003 standard,please i'm an amature. 1. From start menu right click on MyComputer Computer Management dialog comes up 2. In the right pane select and expand |-> Services and Applications |-> Internet Information Services (IIS) Manager |-> Web Sites 3. Select and right click on the "Default Web Site" node, select New --> WebSite or Virtual Directory You will be guided through a series of dialogs asking the name of the site/directory, physi ...Show All

• SQL Server my update index script broke...

  I have tables now use name that is funkie liked dbo.Address For example, use AdventureWorks select * from Person.Address works fine. But, if I wanted to update all table statistics with this script select 'update statistics ' , name from sysobjects where type = 'U'; won't give the correct tablename as Person.Address. tablename shows only Address. What is needed so the script will provide the correct 2 part names Thanks. you can leverage maintenance plans if your not using Express to update stats. But if you still need to use tsql for it this works against a 2005 instance... select 'update statistics ' + S . [name] + '.' + O . [name] As GenedSQL ...Show All

• Visual Studio Express Editions Database search

  This has probably been asked and answered before but here goes. I have set up a login for my application and need to serach my database for username/password combination. Neither of which is the primary key. This is the code I have come upi with so far but it doesn't work! I have used username/passwords that are in the database so it should work. Please can anyone help me Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim user As String = Me .UserName.Text Dim password As String = Me .Password.Text If user = "Admin" Then ElseIf password = "pass" Then Dim myAdminMainForm As New MainForm ...Show All

• SQL Server How to configure SQL XML support in IIS in SQL Server 2005?

  How to configure SQL XML support in IIS in SQL Server 2005 Any help is appreciated. To configure SQL Server 2005 for XML support You need to download SQLXML 3.0 from microsoft site and install it. And then u can configure the XML support from the Configure IIS Support option after u installed. Hope it'll help. -Julia ...Show All

• Visual C++ is this the correct/best way to set file size?

  Hello everyone, I have verified that the following approach works to set the size of a file (newly created file) to be 100 bytes, but I am not sure whether it is the correct/best way to have a maximum portability (I need to write code on both Windows and Linux). Could anyone give me any comments [CODE] #include <fcntl.h> #include <sys/types.h> #include <sys/stat.h> #include <io.h> #include <stdio.h> int main() { FILE* file = fopen ("foo123", "w+"); fseek (file, 99, SEEK_SET); fprintf (file, "x"); fclose (file); return 0; } [/CODE] thanks in advance, George Thank you Sam, Sam Hobbs wrote: UNIX and Linux are ...Show All

• Smart Device Development Connecting to a Pocket PC database (ie: contacts in pocket outlook)

  How can I connect to a database file on the Pocket PC I am trying to extract contact data from the native application on my Pocket PC, which I believe is called "Pocket Outlook." I've searched for information on this, and everything either points me to using some other database (like SQL Server CE), or to using ActiveSync to sync the Pocket PC with Outlook on a desktop. Is there any way to connect directly to the native database on a handheld device from a desktop application I'd like to do it through C#. Any help (even a simple connection string) would be greatly appreciated. POOM is the way to go. It's not exactly a database though so no connection strings. WM 5.0 has Microsoft ...Show All

• Visual Basic How to upload files

  Hello I got a problem with uploading files. Look at the code: My.Computer.Network.UploadFile ("D:\file.txt", " http://www.onh1986.com/file.txt ", username , password ) And I set permission to "777". And it couldn't to upload the file. What's problem, please Thanks & Regards Then try using ftp:// instead of http:// would be my best suggestion - it's possible that the service provider has set something to prevent a direct upload using http (that's just a guess, since this is usually the cause of the error you are seeing). ...Show All

• SQL Server SQL 2005 Server DDL Trigger Errors

  Greetings! I've been working on a SQL 2005 project, and have really been excited about the new DDL triggers. I managed to implement some database-level DDL triggers successfully. However, I keep getting an error when I try to create a server-level DDL trigger. For several of the event groups, I keep getting the following error: Msg 1082, Level 15, State 1, Procedure tr_Server_Audit_Security, Line 44 "DROP_SERVER_ROLE_MEMBER" does not support synchronous trigger registration. I can't figure this one out for the life of me. Here's a sample of the trigger I'm trying to create (BTW, this code works for database triggers, with some slight mods of course): create trigger tr_Server_Audit_Security on all server  for drop_server_role ...Show All

• Connected Services Framework Routing Messages synchronously to services

  Hi, We are using CSF 3.0 Dev edition. We have been able to create and terminate session synchronously. However we are not clear on how to call services ( as defined manifest) synchrounously. As in case of Create Session, there is a class "CreateSessionResponse",which holds response of Create Session. Which class is used to hold response of TResponse SendSync<TResponse> (message) when we want to route manifest to services through Session Web service. We have been able to send messages to services asynchronously. Would be great if somebody could throw some light Thanks Ruchi Hi Ruchi, There are two approaches in CSF 3.0 programming. 1. SDK approach ( like ...Show All

• Windows Forms DataGridView: Combo box column takes several clicks

  Has anyone noticed that the DataGridViewComboBoxCell seems to require several clicks to get it to drop down Alan The first click puts the cell in edit mode and shows the combobox. The second will make combobox's list drop down. I do like Valentine's solution he posted for this. ...Show All

• SQL Server HelloWorld_CLR not sending messages anymore...........

  Hello, Yesterday I made the HelloWorld_CLR sample work and figured today I would create a simple windows service to immulate its functionality.  When this was not working I tried the sample again and it stopped working.  I have tried several things and nothing has worked.  Has anyone seen this before or have any ideas on how I can get it working again   I even tried removing SQL Server and its samples then reinstalling to give me a clean slate but that did not work.  I did not make any changes to the software nor did I make any changes to the database however the sample did so I need to make sure I can fix this incase it happens in development not to mention I need to continue development. The Client Que ...Show All

• Visual Studio Express Editions Updating Data, take 3...

  I am amazed at how difficult it has been trying to figure out how to update data. Please help me!!!!!!!!!!! Here is my attempt to update a data table with an update command: Dim oCon As New OleDb.OleDbConnection( My .Settings.FantasyConnectionString) Dim oCommand As New OleDb.OleDbCommand Dim oAdpt As New OleDbDataAdapter oCon.Open() If IsBench = False Then strSQL = "UPDATE Table1 SET Field1 = 1 WHERE ID = 1" oCommand = New OleDbCommand(strSQL, oCon) oAdpt = New OleDbDataAdapter(oCommand) oAdpt.UpdateCommand = oCommand oAdpt.Update( Me .DataSet1.Table1) dt = me.DataSet1.Table1 I put a break just after the last line up there to see if my changes were made ...Show All

• Visual Studio Express Editions Syntax error converting the varchar

  ERROR - Syntax error converting the varchar value 'SELECTSERVICE' to a column of data type int. I am having some problems converting a number to an int, this is for doing a SQL statement search. Dim SELECTSERVICE As Integer SELECTSERVICE = VenderBox.SelectedValue Dim theSqlCommand As New SqlCommand( "Select [DE_ID],[DE_DEVICE_NAME],[DE_STATUS],[DE_associated_vender] from [FR-DEVICE-TABLE] WHERE DE_STATUS = 'ACTIVE' AND [DE_associated_vender] = 'SELECTSERVICE'" , New SqlConnection(connectionString)) What should my Dim SELECTSERVICE be to correct this thanks for the help it should be like this: Dim theSqlCommand As New SqlCommand( "Select [DE_ID],[DE_DEVICE_NAME],[DE_STATUS],[DE_asso ...Show All