Search:

it is c# becaus i thought the expression might be same however i tried your code but a few things are underlined.

i think first i need to trim the Value since it has the time also, which we dont want and then we need to compare it with DateTime.Today

bestellungenBindingSource.Filter = String.Format("Zubereitungszeitpunkt not like DateTime.Now.ToString('dd/MM/yyyy')");

But when i do: MessageBox.Show(DateTime.Now.ToString("dd/MM/yyyy")); it has exatcly the same format as my stored values (just without the time).

Dear friends:
the column is of type String and is holding values like 27.04.2018 21:44 and i want to filter the column so that all the records are filtered out that dont have the date of today.
I...

Thanks, i was a little bit confused. i just used == 0 it works too.

((DataRowView)kundenBindingSource.Current).Row.Field<double>(11)


with this i can get the value of the 11. column but what if i wanted to check wheter the value is empty, how would i do that?
...

Thank you! this helped me alot.

Ok i found another soloution to receive the informatiosn in xml format.
now comes my question i want to use xml.linq to read this xml document. until the element "location" and receive the value of...

https://developers.google.com/maps/documentation/geocoding/intro?hl=en

it is json they say.

and in the browser it says json

Screenshot:...

dear friends,
i am trying to get the longitude and latitude of a city via zip code (postcode)

the json output looks like this (it is automaticly shown in a new broser tab)




results
0

I want to create for each row in my datatable a autocompletestringcollection. i have to use a loop and loop through the rows and create a autocompleteestringcollection for each row. i tried


...

Thank you very much! It works.

Dear friends,

i tried to find a soloution for this but i just dont know what the best way is.
I have a form (form2) with a datagridview and bindingsrouce containing all customers.

Now in one...

Thanks you very much! Helped me.

Hello dear friends,

i was wondering what this command would look like if i do it in linq instead bindingsource.filter:


kundenBindingSource.Filter = String.Format("CONVERT([Id],System.String)...

You guys are right, the tableadapter ist not made for difficult sql querys, also the declaration works, there are alot of bugs and visual studio gives me errors. So i am doing the query without...

I am putting this into the tableadapter > add new query > update method

Using it without variables it works..

Can u tell me what is wrong with this? VS Error: The Sql Construct "Declare" is not suported



DECLARE @Bestellvar INT
SELECT @Bestellvar = Bestellungen + 1 FROM Kunden

UPDATE Kunden
SET...

Hello,

i have a simple problem which i can not solve on my own.

in my sql query i have got:

DECLARE @myvar int = columnname + 1
which doesn´t work.

this works:

Hello, i dont recomend this method and i also don´t recommend the method you are receiving the source code and the innertext of an element. Unforteanatly the google source page gives back an empty...

The problem is that you dont get any result from google there is just a empty string in the source code.
<span id=result_box class="short_text"></span>

And you have to put the word you are...

Selecting a record form parent table displays all records from child table this is ok, i want it to happen. But as i said putting something in the textbox should filter the whole table not only the...

Hello dear friend,

I have a textbox where i want to filter the WHOLE child table and not only the records that are shown in the child table when making a selection in the parent table. Because...

They way you are trying to receive the sourcecode is totaly wrong. Also use the html agility pack for parsing source code.
here is a example of one of my projects, maybe it helps you.



Try
'...

Hello dear friends,

i have 2 tables and they are related to each. When selecting a record of the parent table of course all the record of the child table are shown in the datagridview. Now I want...

Dear forum,

i want to insert a new record into my table adapter. this table contains a foreingkey and i want his foreingkey to be added automaticly. do i have to use :



Dim row =...

Works perfect! And i also put the displaymember top of datasource as u said. Thanks you very much.

Hello dear friends i fill my listbox with this code:




ListBox1.DataSource = ZutatenTableAdapter.innerjoinGetdata(myInteger)
ListBox1.DisplayMember = "bezeichnung"


This works...

This is exactly what i was searching for. Thanks!

no errors. it is this line of code:
deserial.Deserialize(swread)

because when i do outside of the class:
mycl = CType(deseria.Deserialize(swread), Class1)
it works

but inside the...

Dear friends,

why does the deserialization not work? All Strings are empty. This sub is in my class1.



Public Sub deserial()

Dim deserial As New XmlSerializer(GetType(Class1))
...

ParentTable:
Dim row = DirectCast(BestellungenBindingSource.AddNew(), DataRowView)
row(1) = Kunde
row(2) = Datumnow
BestellungenBindingSource.EndEdit()...

Dear friends,

i have 2 Datatables and they are related to each with relationship in dataset.
Now when i add a new row to the bindingsource, the id of the parent table is of course -1.
And the...

Thank your very much! This thread helped me a lot.

Sorry i guess i found it out:

Dim row = DirectCast(bindingsource.AddNew(), DataRowView)

row(0)= value
row(1)=value
row(2)=value
Bindingsource.EndEdit

So to add a "temporay" row you recommend me to add the record to the bindingscource instead of adding the row to datatable right?

Also how can i pass my values into the addnew method? When i try...

Hello dear friends what is the best way to add a row to a datatable and display it in the datagridview? i need to add row temporarley without calling update method of tableadapter.If user cancel...

Thank you very much!

Dear friends,

i am trying to pass an integer to form2 i tried:



form1//

Private Sub Button1_Click_1(sender As Object, e As EventArgs) Handles Button1.Click
Dim frmArtikel As New...