For those new to message boards please try to follow a few simple rules when posting your question.
Choose the correct forum for your message. Posting a VB.NET question in the C++ forum will end in tears.
Be specific! Don't ask "can someone send me the code to create an application that does 'X'. Pinpoint exactly what it is you need help with.
Keep the subject line brief, but descriptive. eg "File Serialization problem"
Keep the question as brief as possible. If you have to include code, include the smallest snippet of code you can.
Be careful when including code that you haven't made a typo. Typing mistakes can become the focal point instead of the actual question you asked.
Do not remove or empty a message if others have replied. Keep the thread intact and available for others to search and read. If your problem was answered then edit your message and add "[Solved]" to the subject line of the original post, and cast an approval vote to the one or several answers that really helped you.
If you are posting source code with your question, place it inside <pre></pre> tags. We advise you also check the "Encode "<" (and other HTML) characters when pasting" checkbox before pasting anything inside the PRE block, and make sure "Use HTML in this post" check box is checked.
Be courteous and DON'T SHOUT. Everyone here helps because they enjoy helping others, not because it's their job.
Please do not post links to your question into an unrelated forum such as the lounge. It will be deleted. Likewise, do not post the same question in more than one forum.
Do not be abusive, offensive, inappropriate or harass anyone on the boards. Doing so will get you kicked off and banned. Play nice.
If you have a school or university assignment, assume that your teacher or lecturer is also reading these forums.
No advertising or soliciting.
We reserve the right to move your posts to a more appropriate forum or to delete anything deemed inappropriate or illegal.
Guru's I need your help. I've been trying to figure out how to write the following SQL code in VB.NET LINQ but haven't had any luck. Any suggestions would be appreciated:
FROM ARN_1 t
WHERE RECORD_TYPE = '1'
AND NOT EXISTS(SELECT INVOICE_NUMBER
FROM ARN t1
WHERE t1.INVOICE_NUMBER = t.INVOICE_NUMBER AND t1.RECORD_TYPE = '7')
AND NOT EXISTS (SELECT INVOICE_NUMBER
FROM ARN_1 t2
WHERE t2.INVOICE_NUMBER = t.INVOICE_NUMBER AND t2.RECORD_TYPE = '5')
AND t.DUE_DATE < '2017-11-13'
First - select the data in a variable type var.
Below two example of the selectusing lingQ
Unique table, read all fields
var query = from vep in dataset.Tables["name_my_table"].AsEnumerable()
where (Int16)vep["field1"] == Convert.ToInt16(search_parameter_1)
&& (string)vep["field2"] == search_parameter_2
two tables with join, read some fields and field ordinate
var query = from lan in dataset.Tables["name_my_table1"].AsEnumerable()
join noc in dataset.Tables["name_my_table2"].AsEnumerable()
on (string)lan["id"] equals (string)pap["id"]
where (int)noc["id"] >0orderby noc["date"]
data = ((DateTime)noc["date"]).ToString("dd/MM/yyyy")
num = noc["field1"].ToString()
qtd = lan["field1"].ToString()
val = ((decimal)lan["value"]).ToString("0,0.00")
Second - Create a datatable with the selected data
datatable dt = new datatable();
Example 1foreach (var item in query)
dr = dt.NewRow();
dr["data"] = item.vep["field1"].toString();
dr["num"] = item.vep["field2"].toString();
dr["qtd"] = item.vep["field3"].toString();
dr["val_unitario"] = item.vep["field4"].toString();
Example 2foreach (var item in query)
dr = dt.NewRow();
dr["data"] = item.data;
dr["num"] = item.num;
dr["qtd"] = item.qtd;
dr["val_unitario"] = item.val;
Third - Display in grid
my_grid.DataSource = dt;
I hope has been helping.
GreaterThan() and LessThan() methods won't work on strings. Why? It's simple. String is not numeric value!
To be able to compare lowValueString and highValueString with the set of numbers, you need to convert string values into proper data type. Convertion should be made before you data into Between method.
I got the following error "The connection was not closed. The connection's current state is connecting entity framework" while implementing Async/Await functionality in single transaction scope. Please provide the suggestions to resolve the issue.
The problem is the entity framework automatically opens and closes a connection with each call to the database, thus when using a transaction, you are attempting to spread a transaction out over multiple connections which elevates to MSDTC.
Open the connection manually and close it when you are done. Then the framework will use only one connection for all your calls.
I have a 20 records in a database table. Each record has and ID. I want to read a field in each record fieldA. I only want to read the records that have an ID '1'. For each record that has an ID '1' and fieldA Is Not Null I want to return a count of those records.
So if 10 records have data in fieldA and have ID '1' then my count for fieldA will be 10.