Search:
Type: Posts; User: Nitesh
Search:
Search took 0.23 seconds.
-
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...
-
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...
-
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....
-
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 = "'" +...
-
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...
-
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...
-
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?
-
-
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 =...
-
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....
-
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.
-
nope. the issue started only when I deleted and recreated the Dataset.
-
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...
-
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...
-
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...
-
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...
-
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...
-
Thanks. I get this error:
on this line of code:
-
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:
-
Thanks again kebo,
I've got it working;) Appreciate your help.
-
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...
-
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",...
-
thanks guys. it works as expected
-
sorry I should have specified I need it converted to vb.
-
Hi Guys,
Please convert these two blocks of code for me. I need to use a datatable on the highlighted line:
List<DataRowView> selectResult =...
-
Thanks JM. perfect as always.
-
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,...
-
Thanks again FunkyDexter. You are spot on. I'm going for option 2 as they prefer a save on each click.
-
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...
-
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...
-
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...
-
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...
-
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...
-
hi Guys,
I have this code:
Dim table As DataTable = New DataTable()
table = BL.GetPeople(1)
If (table.Rows.Count > 0) Then
-
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...
-
Thanks. Will go with your suggestion
-
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...
-
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.
-
no worries. I found the problem. I removed the table.acceptchanges call.
-
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)...
|
Click Here to Expand Forum to Full Width
|