Search results for query: *

  • Users: chime
  • Order by date
  1. C

    SQL Server does not exist or access denied

    Hi prav_roy Thanks for your reply but ManicCW solved the problem Thanks chime
  2. C

    Error while using sharepoint dll's

    Hi I hope there is someone out there who can help me this error on my project. This is the first time I am trying to integerate sharepoint and vb. I am trying to use the following sharepoint dll's in my project. Microsoft.SharePoint.Security.dll Microsoft.SharePoint.Dsp.dll...
  3. C

    Check a datagrid checkbox column is checked not working

    Would I need to add an event handler http://www.codeproject.com/aspnet/DataGridCCEvents.asp I found this but it is in C#
  4. C

    Check a datagrid checkbox column is checked not working

    Hi I have a datagrid with a template checkbox column. Which I create programatically using the following code 'insert checkbox and load with data Private Sub DataGridFinanceInvoiceHistory_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs)...
  5. C

    Deploy on a virtual server

    Hi Is there a way to deploy a web project on a specified virtual server. Ideally I would like to add something to the installation process so that we can specify which virtual server to install it on. However if this is not possible then maybe specifying it during the deployment process...
  6. C

    Merge/combine similar rows so that extra columns are added

    Hi I have a complex view that pulls data down into this format ClientID, ClientName, FundID, ProductID Each Client can have more than one fund Each fund can have more than one Product Client1, MyClient1, Fund1, 101 Client1, MyClient1, Fund2, 101 Client1, MyClient1, Fund2, 301 Client2...
  7. C

    Sql Insert error for auto incrimental field

    Hi TechGnome, I have only being using sql server for 5 days and vb for a few months so I just wanted to do the insert statement Is there a quick fix for this problem or why can't I do this insert. I have a working insert with mysql which hasn't caused me these problems. Thanks
  8. C

    Sql Insert error for auto incrimental field

    Hi TechGnome When I remove the invoiceID parameter SqlInsertCommandChangeInvoice.CommandText = "INSERT INTO Invoices (EntityID, FundID, LOBSID, InvoicePeriod, InvoiceDate, PaymentDate, CurrencyISO, Amount, CreatedBy, CreateDate, LastEditedBy, LastEditDate, SubmittedFinanceIndicator...
  9. C

    Sql Insert error for auto incrimental field

    Hi TechGnome Do I need to remove it from the sql in the dataadapter as well Thanks
  10. C

    Sql Insert error for auto incrimental field

    Hi I am trying to insert a row into a sql Server Database The InvoiceID field is an auto incremental field which in increased by 1 each time When I try to run this code I get the following error "Input string was not in a correct format." The code works when the field InvoiceID is...
  11. C

    Datagrid not taking up dataview as a data source

    Datagrid not taking up dataview as a data source - solved Hi In my code I have a dataview which I want to bind to a datagrid I want to use it to sort column on the datagrid itself Public Sub BindGrid(ByVal SortField As Object) Dim strSortOrder As String = Session("SortOrder").ToString...
  12. C

    SQL Server does not exist or access denied

    Hi MainicCW Thanks for the reply, I am access this on another computer in another office across the network There is no firewall to cross The thing that confuses me is how come I can connect using the dataadapter and preview the data but it won't run in the code Thanks
  13. C

    SQL Server does not exist or access denied

    I have just started to use SQL SERVER for the first time today. I can set up a dataadapter and connection string in vb .net and pull down data But when I try to do it in code it doesn't work and I get the following error "SQL Server does not exist or access denied" I am sure this is...
  14. C

    Error when configuring a dataadapter

    Hi It seems to be working again after I restarted the pc. The connections were correct as I was able to see the tables in server explorer I have attached the error message (I mustent have uploaded the file previously) Thanks
  15. C

    Error when configuring a dataadapter

    This is the error when I try using the wizard (yep its visual studio on windows xp)
  16. C

    Error when configuring a dataadapter

    Hi I get the following error when I try to configure my dataadapter I have tested the connections in the server explorer and they work "DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=myDatabase;USER=myUsername;PASSWORD=myPassword;OPTION=3;" I am new at this so its probably...
  17. C

    DataAdapter set up for delete/update error

    MySQL Database I am using ODBC data Adapters which is the comany default I am using the wizard which is why I don't undertand why I am getting these problems. This is where I have found about the primary key issue http://www.informit.com/articles/article.asp?p=26956&rl=1
  18. C

    DataAdapter set up for delete/update error

    I have Tried selecting each field individually and have unchecked 'Use Optimistic Concurrency' ('Refresh Dataset' is greyed out) the error is the same I have attached the error section I am configuring the dataadapter by right ckicking on it and going through the steps Its just the last step...
  19. C

    DataAdapter set up for delete/update error

    ...and INSERT sections. But it gives an error for the UPDATE and DELETE sections. I have tried it on different tables of the MySQL Database all of which have a primary key. I am also using the simplest SELECT statement - SELECT * FROM tablename Would anyone have an idea what the problem is...
  20. C

    dataset into listbox - one works but the other doesn't

    Resolved This </SELECT><SELECTid="ListBoxPublicHolidaysSelecte"style="TABLE-LAYOUT: fixed; Z-INDEX: 108; LEFT: 440px; OVERFLOW: auto; WIDTH: 304px; CURSOR: hand; POSITION: absolute; TOP: 104px; BORDER-COLLAPSE: separate; HEIGHT: 312px" Should be...
Back
Top