Search:

Type: Posts; User: Nitesh

Page 1 of 13 1 2 3 4

Search: Search took 0.23 seconds.

  1. VS 2012 Re: Dynamic SQL how to cater for IN syntax

    Thanks guys,

    very useful info. JM I used your extensions and this is what I have so far



    else if (value.IsEnumerable() || value.IsEnumerableT())
    {
    var typeStr...
  2. VS 2012 Re: Dynamic SQL how to cater for IN syntax

    not sure if this is the best solution. It works for list<int>, list<object> so far. The final result is a string like (1,2,3,4,5). How can I cater for strings, say for example the final query must...
  3. VS 2012 Re: Dynamic SQL how to cater for IN syntax

    Thanks JM,

    Using .Net 3.5 unfortunately. I've found a few extension methods that convert any IEnumerable to a comma seperated string. How can I check if the type of object is typeof IEnumerable....
  4. VS 2012 [RESOLVED] Dynamic SQL how to cater for IN syntax

    Hi Guys,

    Here is a small part of the framework I am writing. This code is to build a where clause:



    if (value.GetType() == typeof(string))
    {
    newValue = "'" +...
  5. Replies
    6
    Views
    3,268

    VS 2012 Re: How to export dataview to excel

    Thanks kevininstructor,

    that works. However I have another problem. two in fact. I am adding each columns value to a list of object. Then I append each value to a string.



    For Each col As...
  6. Replies
    6
    Views
    3,268

    VS 2012 Re: How to export dataview to excel

    thanks kevininstructor,

    Sorry for the delay. it's been a while since i've had a chance to sit with this. I've done the following so far. I get the parent rows and append the data to a string. Then...
  7. Replies
    6
    Views
    3,268

    VS 2012 How to export dataview to excel

    Hi Guys,

    How do I export a dataview to excel. I have a datagridview bound to a bindingsource. Also, I need to only display the columns that are visible in the datagridview. Is it possible?
  8. VS 2012 Re: Export Parent/Child Datagridviews to Excel

    Thanks guys. Perfect:)
  9. VS 2012 Re: Export Parent/Child Datagridviews to Excel

    Thanks kevininstructor,

    Your code is brilliant. The only change I made was below as I am using a typed dataset. Looks very promising so far

    Dim MastTable As DataTable =...
  10. VS 2012 [RESOLVED] Export Parent/Child Datagridviews to Excel

    Hi Guys,

    I have two tables in a Dataset that are linked by a foreign key relationship. I need to export the data to excel. However, for each parent row I must output the corresponding child rows....
  11. VS 2012 Re: TableAdapterManager not saving changes

    fixed at last. I was going insane. Turns out I had to set the default value of a boolean column to true in the dataset.
  12. VS 2012 Re: TableAdapterManager not saving changes

    nope. the issue started only when I deleted and recreated the Dataset.
  13. VS 2012 Re: TableAdapterManager not saving changes

    No luck. I was going to scrap the tableadaptermanager and manually the parent and child adapters but now I have another issue. The dataset.haschanges is returning false when I am trying to add new...
  14. VS 2012 Re: TableAdapterManager not saving changes

    Thanks. That works when I call the tableadapter update methods one after the other. Parent first then child:



    However calling Tablemanager.UpdateAll still throws the foreign key constraint...
  15. VS 2012 Re: TableAdapterManager not saving changes

    Thanks guys. JM I have the update of the parent table working now. Here is a snippet of my code on my save button click event:


    Dim saved As Boolean = False


    Dim TestForChanges As...
  16. VS 2012 [RESOLVED] TableAdapterManager not saving changes

    Hi Guys,

    I have an old project I worked on 3 years back using typed datasets. I have a tableadaptermanager on the form. Most of the stuff works fine when I upgraded to Visual Studio 2012. I have...
  17. Replies
    70
    Views
    64,394

    Re: export DGV to word ~ excel

    hey .paul.

    another question. I have a datagridview combobox column. When I export to Excel the Integer value of the combo is printed. How do I go about getting the text value for combobox columns...
  18. Replies
    70
    Views
    64,394

    Re: export DGV to word ~ excel

    Thanks. I get this error:



    on this line of code:
  19. Replies
    70
    Views
    64,394

    Re: export DGV to word ~ excel

    Hey .paul.,

    I've just come across your code and it work's great. I am trying this using late binding. Please let me know how I would do the following using late binding:
  20. VS 2012 Re: How to add combobox to all my BindingNavigators

    Thanks again kebo,

    I've got it working;) Appreciate your help.
  21. VS 2012 Re: How to add combobox to all my BindingNavigators

    Thanks a lot kebo. I have managed to get this working but it is still early days. On my current form I've added a save button to the existing bindingnavigator like this:



    Private Sub...
  22. VS 2012 [RESOLVED] How to add combobox to all my BindingNavigators

    hi Guys,

    I have a bunch of forms with bindingnavigators hooked up to different datagridviews. I need to add a common combobox
    to all of them. The options in the combobox neeed to be "Word",...
  23. VS 2012 Re: Please convert this to use a Datatable

    thanks guys. it works as expected
  24. VS 2012 Re: Please convert this to use a Datatable

    sorry I should have specified I need it converted to vb.
  25. VS 2012 [RESOLVED] Please convert this to use a Datatable

    Hi Guys,

    Please convert these two blocks of code for me. I need to use a datatable on the highlighted line:


    List<DataRowView> selectResult =...
  26. Replies
    2
    Views
    631

    VS 2012 Re: Help with LINQ on datatables

    Thanks JM. perfect as always.
  27. Replies
    2
    Views
    631

    VS 2012 [RESOLVED] Help with LINQ on datatables

    Hi Guys,

    I'm trying to get a resultset from 2 different datatables using LINQ. This is my resultset 1


    UserID, FriendID, Date
    2, 1, '2012-03-12 13:39:55'
    2, 70, '2012-08-30 14:50:47'
    5,...
  28. Re: Need Ideas. Transactions/Temporary Tables? I have no idea

    Thanks again FunkyDexter. You are spot on. I'm going for option 2 as they prefer a save on each click.
  29. Re: Need Ideas. Transactions/Temporary Tables? I have no idea

    Hi FunkyDexter,

    I understand what you mean. however, say for example I have Student A and Student B. If I load the grid with the default state of unchecked for both students for today they are not...
  30. Please convert from Access to MySQL equivalant

    Hi Guys,

    I've inherited an access db that has a view that has the following where clause:


    WHERE (((DateDiff("yyyy",[members].[BirthDate],Now()))>=[service].[min_age] And...
  31. Re: Need Ideas. Transactions/Temporary Tables? I have no idea

    Hi. Thanks for the suggestion. They want all students marked absent for the day automatically. As they tick each record the student is marked as present. I'm wondering how to implement this. At which...
  32. [RESOLVED] Need Ideas. Transactions/Temporary Tables? I have no idea

    Hi Guys,

    I have a school database with an attendance register. At the moment, the teacher selects his class and I load a grid with the students names in column 1 and each day of the current week...
  33. Replies
    3
    Views
    774

    VS 2012 Re: How to add more code in between inline xml

    no worries. I figured out a way. Please can someone verify this is good practice.

    I wrote a function


    Private Function GetSubjects(ByVal peopleID As Integer) As...
  34. Replies
    3
    Views
    774

    VS 2012 How to add more code in between inline xml

    hi Guys,

    I have this code:


    Dim table As DataTable = New DataTable()
    table = BL.GetPeople(1)

    If (table.Rows.Count > 0) Then
  35. VS 2012 Easy way to freeze Gridview Header and first 2 columns

    Hi Guys,

    I need to freeze my gridview header and the first two columns. I found a great jquery plugin called tinytbl which does the job but it messes up the inline javascript on my page which...
  36. VS 2012 Re: Is it possible to add controls to the print dialog

    Thanks. Will go with your suggestion
  37. VS 2012 Is it possible to add controls to the print dialog

    Hi Guys,

    I want to add a textbox to a printdialog control. basically when a user prints, they must enter their name into a textbox on the Printdialog Control. I will then log the name to a...
  38. VS 2010 How to encrypt xml elements using RSA encryption

    Hi Guys,

    Can someone please show me how to encrypt multiple elements in an xml file given the path of the file using RSA encryption.
  39. VS 2010 Re: Set datarow rowstate after table.ImportRow()

    no worries. I found the problem. I removed the table.acceptchanges call.
  40. VS 2010 [RESOLVED] Set datarow rowstate after table.ImportRow()

    Hi Guys,

    I drag and drop datarows from a grid to a treeview. Then I try to change the rowstate of the dropped rows.


    Private Sub gclevels_DragDrop(sender As Object, e As DragEventArgs)...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width