Hi, I am a novice and am very stumped with this one. I recently put my ASP.NET web application on a newly provisioned server and restored back up files of my database in MS SQL Server 2005. Everything works just fine- all data queries, membership creation, etc EXCEPT for anything involving the profile...

Have an OLE DB Source with connected to a table with a column that is varchar(7). This column contains only numbers. I need to get this data to a table with a numeric column type. I am currently using a Derived Column Transformation. In the Derived Column Transformation Editor, I put the column in the...

Hello, I am using VB.NET 2005. I have a form with a datagridview that is being populated by a datatable filled with results from a sql resultset. One of my columns is a DataGridViewButtonColumn. I want the text for each one of the buttons to display the value that is returned from sql. I know how to...

Hi I am using visual studio vb.net 2005/2008 and Mysql as backhand I am in the middle of a programme which requires that i generate unique alpha numeric id for each entry into the system. and the counter must be set to 1 for next change in date for eg. on todays date the entries are made with auto generated...

I need to replace a number of records from database1.table to database2.table , I dont want to copy them from table to table because I dont want duplicates, I want to replace records. The ideas is restore information from a backup database to the current database, what would be the best way to write...

I have two listboxes: listbox1 and listbox2. When the user selects an item in listbox1 and click on Move button, the selected item will be moved to listbox2. I have no problem in moving the selected item from listbox1 to listbox2 as follows: Dim item As Object Dim index As Integer item = listbox1.SelectedItem...

We have a SQL 2005 SP1 server running on a webserver. It runs fine but since a few weeks it stops unexpetedly and at random times. SQL Agent and SQL Server services stop. We need to start them mannually again. Please help us out. For details see attached dumplog. Error is : SQL Server is terminating...

How do you check the current date format of a SQL Server 2005 database?

I am using Visual Basic 2005 and am having a problem. I am sending information to Microsoft Excel. This works fine. However, I want to tell it to set the page orientation to landscape. This doesn't seem to work. I'd guess that I am passing it the wrong statement, but I can't figure out the...

Please see my attached code. I need to sort my array of type structure by the TransDate Field. Help, I need code. Code Snippet: 1: 2: 3: 4: 5: 6: 7: 8: 9: Dim mTransForecast() As sTransLedger Structure sTransLedger Dim AcctID As Integer Dim TranDate As Date Dim TranCategory As eTransCategories Dim TranAmount...