dcsimg

Search:

Type: Posts; User: Serigraphie

Page 1 of 2 1 2

Search: Search took 0.05 seconds.

  1. Create Read Update Delete from gridview and save in the database

    Hi Everyone,

    I've been dealing with this issue for four hours now and almost giving up. I just want to ask how create, delete, update and delete can be done with the use of datagrid and update SQL...
  2. Re: Cannot bind to the new value member. Parameter name: value

    I am actually thinking of having two SQL statements

    1. Select field1 from table A - this to populate the dropdownlist
    2. Select field1 from table B where field1 = othercombobox selected value.
    ...
  3. Cannot bind to the new value member. Parameter name: value

    Hello code masters,

    Today I have been banging my head in the wall trying to figure this one out.

    I have a combo box filled with values from table A field A
    no issue on that, I am able to...
  4. VS 2010 Re: Needing your expertise - assign database value to array

    Dim conn As New OleDbConnection("connection string")
    Dim cmd As OleDbCommand

    Dim CorrectAnswer(19) As String
    For x As Integer = 1 To 20
    cmd = New OleDbCommand(String.Format("Select...
  5. VS 2010 Re: Needing your expertise - assign database value to array

    Dim conn As New OleDbConnection("connection string")
    Dim cmd As OleDbCommand

    Dim CorrectAnswer(19) As String
    For x As Integer = 1 To 20
    cmd = New OleDbCommand(String.Format("Select...
  6. VS 2010 Re: Needing your expertise - assign database value to array

    Thank you Paul! Will definitely try it on my next shift at work and will let you know and rate you as well if it works!
  7. VS 2010 [RESOLVED] Needing your expertise - assign database value to array

    Dim conn As New OleDbConnection("connection string")
    Dim cmd As OleDbCommand

    Dim CorrectAnswer(19) As String
    For x As Integer = 1 To 20
    cmd = New OleDbCommand(String.Format("Select...
  8. VS 2010 Re: Help in assigning database value to array value

    124297

    Hi Shaggy,

    Thank you for chiming in. CorrectAnswer is actually the CorrectAnswer value stored in the DB for a particular question so no it cannot be Null. I am storing the correctAnswer...
  9. VS 2010 Re: Help in assigning database value to array value

    Hi Sir,
    so for example I have the following queries:
    Select AnswerValue from tbl_ECM_Questionnaire where QuestionID = 1 and CorrectAnswer = 'Y'"
    Select AnswerValue from tbl_ECM_Questionnaire...
  10. VS 2010 Help in assigning database value to array value

    Hello, Code Masters,

    Here I am again today going to seek help and guidance from you.

    I have here a manually assigned values to arrays 0 - 19
    now my question is, how can I assign values to...
  11. Replies
    1
    Views
    2,224

    VS 2010 For Loop question

    hello Masters,

    How are you all doing? I just have a question.

    I am building this simple quiz application using asp.net/vb.net and sql server for the database. Now what I want to happen is...
  12. Thread: SQL Query

    by Serigraphie
    Replies
    6
    Views
    3,355

    Re: SQL Query

    @FunkyDexter, let me try that. Thank you!
  13. Thread: SQL Query

    by Serigraphie
    Replies
    6
    Views
    3,355

    Re: SQL Query

    Not a problem, thank you for your effort sir.
  14. Thread: SQL Query

    by Serigraphie
    Replies
    6
    Views
    3,355

    Re: SQL Query

    Hello sir,

    Thank you very much for your prompt response. I am using Oracle for the DB and I believe this is PL SQL.

    Here is the complete query:

    SELECT s.BUSINESS_GROUP,
    ...
  15. Thread: SQL Query

    by Serigraphie
    Replies
    6
    Views
    3,355

    SQL Query

    Hi Everyone,

    a good day to all of you. I am a newbie in SQL queries and I would like to ask a question in an existing query I have.



    SELECT
    SUM (SPEND) SPEND1,
    FROM ...
  16. Replies
    2
    Views
    2,101

    [RESOLVED] SQL query

    HI EVERYONE.

    GOOD DAY TO YOU ALL! i WOULD LIKE TO GET SOME OPINION SINCE I AM KINDA STUCK IN THIS QUERY I AM WORKING ON.

    WE HAVE THIS EXISTING QUERY

    SELECT
    f.A_OBJ_ID,
    ...
  17. Replies
    0
    Views
    1,777

    Double data when saving

    Hi Everyone,
    I've been facing this issue since the last three days and I still can't seem to know where the issue is coming from. There are no syntax errors but i think there is something wrong...
  18. Replies
    1
    Views
    362

    Login Error

    Hi Everyone,
    Good evening. Can you help me point out what seems to be the problem with my applciation? I know my problem will be a piece of cake to you guys.

    I have a login page where the user...
  19. Replies
    4
    Views
    1,499

    Re: Database Restore Fails

    TG,
    Thank you very much for your guidance! First of all, you're right when you told me to make sure it finds where the .BAK file is. What confused me is that the file seems to be in the path I...
  20. Replies
    4
    Views
    1,499

    Re: Database Restore Fails

    Hello Tg,
    Thank you for your response. In case I include the move command in the restore command, will it move the ldf and mdf files in a different location? Because if so, the other database...
  21. Replies
    4
    Views
    1,499

    [RESOLVED] Database Restore Fails

    Hi Everyone,
    Good day, I am trying to do a restore of my database and I am using this command :


    RESTORE DATABASE TicketingRestored
    FROM DISK = 'C:\Program Files\Microsoft SQL...
  22. Replies
    3
    Views
    1,325

    Re: Incorrect syntax near 'ProjectOverview'.

    Okay how about I get only the max of date?


    ProjectOverview.[Target Event DATE - DATE] AS [Target Bid DATE]

    I get below error when i try this code:
    Max(ProjectOverview.[Target Event DATE -...
  23. Replies
    3
    Views
    1,325

    Incorrect syntax near 'ProjectOverview'.

    Hello,
    Please help me with my problem, this is the simple select statement I have for target bid date:

    ProjectOverview.[Target Event Date - Date] AS [Target Bid Date]
    now, I want to ask how can...
  24. Re: The isnull function requires 2 argument(s).

    Thank you techgnome and si the geek indeed all of you here are geeks!
  25. Re: The isnull function requires 2 argument(s).

    OMG jggtz that solved the error! thanks a ton!
  26. Re: The isnull function requires 2 argument(s).

    Hi TG ,
    I really appreciate your intelligent reply, I already changed it to:
    SELECT IsNull(EventSummary.[Event Information - Event Status],"ACTIVE") AS [Event Status],
    but it prompted me an...
  27. Re: The isnull function requires 2 argument(s).

    Hi si the geek,
    I am using SQL Management Studio 2005, the code above doesnt seem to work, do you think of any workaround to accomplish the task?
    Thank you very much.
    I am really running out of...
  28. [RESOLVED] The isnull function requires 2 argument(s).

    Hello Everyone,
    I know this is going to be easy to all of you, this is my first time performing an if else statement in SQL,
    after performing this query:

    Collapse | Copy Code...
  29. Replies
    11
    Views
    10,694

    Re: Error in importing data from excel to sql

    Yes, just a select *, by the way I tried copy pasting and it worked :) but the downside of it is that it's making my computer to slow down and it takes 30 mins to paste 5,000 of rows. Should I use...
  30. Replies
    11
    Views
    10,694

    Re: Error in importing data from excel to sql

    Thank you for correcting me, yes I am using express.
  31. Replies
    11
    Views
    10,694

    Re: Error in importing data from excel to sql

    SQL Server 2008 Management Studio, I cant see the SSIS package notice, maybe I have the wrong version of SQL?
    thanks GaryMazzone!
  32. Replies
    11
    Views
    10,694

    Re: Error in importing data from excel to sql

    But can I still import it using import task without the errors? or should I really use the SSIS?
    If so, can you tell me how?
    Is SSIS downloadable or it comes with SQL Management studio?
    Thank...
  33. Replies
    11
    Views
    10,694

    Re: Error in importing data from excel to sql

    Hi GaryMazzone,
    Thanks for your response. I am using Sql Server 2008 management studio, I right click my database and then tasks, then import data.
    Can you tell me how to ignore truncation errors? ...
  34. Replies
    11
    Views
    10,694

    Error in importing data from excel to sql

    To all database genius out there,
    I hope you can help me with this error I encountered when importing excel file to SQL Server 2005.

    This is the error:

    Collapse | Copy Code
    Executing...
  35. Replies
    7
    Views
    1,164

    Re: Cross-thread operation not valid

    Hi Techno,
    I think that is an excellent suggestion.
    Here is the code.


    using System;
    using System.Collections.Generic;
    using System.ComponentModel;
    using System.Data;
    using System.Drawing;
  36. Replies
    7
    Views
    1,164

    Re: Cross-thread operation not valid

    Hi Pradeep1210,
    Thank you for your response, maybe I still have to study it, I am a newbie in C#.
    Again,
    Thanks!
  37. Replies
    7
    Views
    1,164

    Cross-thread operation not valid

    Hello everyone, I have here a standalone application written using C# language.
    Error occured when I hit the button "compute"

    Please see below error:


    Error Description :...
  38. Replies
    2
    Views
    1,386

    unable to install or run the application

    Hi everyone,
    I have this problem, I developed the program in C#(winform) in my computer, when I try to publish it and install in my computer, it works fine. But when other users with different...
  39. Replies
    1
    Views
    1,951

    Export to Excel (Standalone application)

    Hi Everyone,
    Can somebody please help me with this.
    I have this gridview and I have binded it properly,
    now I have a button and I want to export the data inside the datagrid to excel.
    I can do...
  40. Replies
    0
    Views
    2,577

    Scrolling goes back to top

    Hello everyone
    I have this problem with the system passed to me by the previous developer.
    The page is scrollable vertically.
    Now to be able to click the button, you have to scroll down.
    The...
Results 1 to 40 of 58
Page 1 of 2 1 2



Featured


Click Here to Expand Forum to Full Width