-
Replied To a Post in Object reference not set to instance and I got mad
I suggest a compromise for anyone wanting to use a lambda that is not intuitively obvious. Use the lambda but add a comment explaining what the statement does. Have pity … -
Replied To a Post in Message Paradox
When you receive a message it would have to be from your "past self" rather than your "future self". -
Replied To a Post in Object reference not set to instance and I got mad
The difference is that it is immediately obvious what the longer version does at a glance. In a [recent survey](http://engineering.intenthq.com/2015/03/what-is-good-code-a-scientific-definition/), professional developers were asked "what makes good code?" The top … -
Replied To a Post in hi everyone i have an error
I'll assume that ConnNewClient = FncDBConnect(DbPath) sets the connection string, although I have no reason to do so. Before you access the database you must open the connection like ConnNewClient.Open() … -
Replied To a Post in Object reference not set to instance and I got mad
Sorry. I should have quoted. I was referring to dt.AsEnumerable().Where(Function(r) r.Field(Of Integer)("qty") =0).ToList().ForEach(sub(x) x.Delete()) -
Replied To a Post in hi everyone i have an error
You didn't open the connection. -
Replied To a Post in Object reference not set to instance and I got mad
That line of code may be correct (I'm not going to parse it) but it is so unclear I would be appalled if I saw it in production code. In … -
Replied To a Post in Things I hate about TV shows
How do you determine if a chess position is "wrong"? -
Replied To a Post in There is an elephant on the loo!
In the US, bottled water is regulated by the FDA and is not bound by EPA standards (which are more stringent). Tap water **is** regulated by the EPA and must … -
Replied To a Post in Thank God It's Friday!!
I'm retired. Every day is my day off (or no day, depending on your perspective). -
Edited link button with form
Hi, I build a login form and want when user click on submit button then other form show. I also add new form by file->add->new project I use the name … -
Marked Solved Status for Syntax Error
im a complete newbie in visual basic and im currently working on my first project which is the book borrowing system. the project is almost done except with this error. … -
Marked Solved Status for Data Environment
SELECT BANK ACCOUNT.*FROM BANK ACCOUNT ORDER BY ACCOUNT NAME What is the missing operator here? In sql statement, pls I need help -
-
Replied To a Post in QA Session
Q: What do you call a cow with no legs? A: Ground beef -
Replied To a Post in Data Environment
Try SELECT * FROM [BANK ACCOUNT] ORDER BY [ACCOUNT NAME] but if possible you should rename the columns by replacing the spaces with underscores. -
Replied To a Post in QA Session
Q: How many NRA spokesmen does it take to screw in a light bulb? A: More guns. -
Marked Solved Status for VB 6.0 Search
Dim searchvar As String Dim sbookmark As String searchvar = Text1 searchvar = Trim$(searchvar) If searchvar <> " " Then With Data1.Recordset sbookmark = .Bookmark .FindFirst "ACCOUNT NO like'" + … -
Edited VB 6.0 Search
Dim searchvar As String Dim sbookmark As String searchvar = Text1 searchvar = Trim$(searchvar) If searchvar <> " " Then With Data1.Recordset sbookmark = .Bookmark .FindFirst "ACCOUNT NO like'" + … -
Edited VB 6.0 Search
Dim searchvar As String Dim sbookmark As String searchvar = Text1 searchvar = Trim$(searchvar) If searchvar <> " " Then With Data1.Recordset sbookmark = .Bookmark .FindFirst "ACCOUNT NO like'" + … -
Replied To a Post in Syntax Error
This is a query SELECT * FROM tblbooks WHERE author LIKE 'Smi%' This is not a query adobooksearch.Refresh If you want help debugging the query then post your query. -
Edited Object reference not set to instance and I got mad
I just want to delete if column qty contains value 0 then delete that row but i get error after delte six records it says object refrence not set to … -
Edited Object reference not set to instance and I got mad
I just want to delete if column qty contains value 0 then delete that row but i get error after delte six records it says object refrence not set to … -
Edited Object reference not set to instance and I got mad
I just want to delete if column qty contains value 0 then delete that row but i get error after delte six records it says object refrence not set to … -
Replied To a Post in Syntax Error
What you posted was the code that generates the query. What I want to see is the query that is causing the error. -
Replied To a Post in Syntax Error
Please post the entire query. -
Replied To a Post in the remote procedure call failed in windows 7
Check [this procedure](http://answers.microsoft.com/en-us/windows/forum/windows_7-windows_update/the-remote-procedure-call-failed-and-did-not/445c3192-466e-476f-a552-535da05f086c) from Microsoft. -
Replied To a Post in There is an elephant on the loo!
In the United States (and probably also in Canada and Great Britain), when a corporation is forced to pay punitive damages, those damages can be claimed as a cost of … -
Replied To a Post in Why does Windows XP refuse to die?
>after having a virus that caused explorer.exe to majorly multiply in my RAM and eat 4GB in a matter of seconds, I'm not a big fan of explorer anymore And … -
Replied To a Post in Automatically update new value in DataGridView and create chart
Try Table1DataGridView.Rows(e.RowIndex).Cells(e.ColumnIndex + 1).Value = Math.Round(Val(Table1DataGridView.Rows(e.RowIndex).Cells(e.ColumnIndex).Value) * x, 6) -
Replied To a Post in Automatically update new value in DataGridView and create chart
Unless x is a function, it is being interpreted as an array and you cannot use an array in an arithmetic operation unless you index to a specific element. -
Replied To a Post in Why I sometimes hate ads
I am not a prude. I occasionally use "colourful metaphors" and several of the words so eloquently enumerated by the late, great George Carlin. I wasn't offended when my local … -
Replied To a Post in Memorable Quotations
"What we don't see is that freedom is not a concept in which people can do anything they want, be anything they can be. Freedom is about authority. Freedom is … -
Edited First fetch top unique record out of duplicate and then fetch rest randomly
Hi All, I have a requirement first to fetch top unique company_names out of duplicate values based on the product name search and then fetch rest of the record randomly.Below … -
Replied To a Post in Copy missing column values from table1 to table2
Try this version UPDATE tb2 SET tb2.data = tb1.data FROM tb1 INNER JOIN tb2 ON tb1.id = tb2.id AND tb2.data IS NULL -
Replied To a Post in booting windows
>what is the proceedure for booting windows 1. Remove all other bootable media (USB, CD, etc) 1. Power on the computer This assumes you have Windows installed on your computer. -
Replied To a Post in How Can We Check Is our site has virus or not
You could download [Trend Micro Housecall](http://housecall.trendmicro.com/) and burn a bootable CD. Boot from the CD and do a scan of your system. -
Replied To a Post in Copy missing column values from table1 to table2
You can try UPDATE tb2 SET tb2.data = tb1.data FROM tb1,tb2 WHERE tb1.id = tb2.id AND tb2.data IS NULL This will update only records for which data is NULL. -
Replied To a Post in subscript not in range
It occurred to me while trying a test that you may be accessing the data incorrectly. You want to access the values of the columns in a particular row. Perhaps … -
Replied To a Post in Silencing Users
>Just ignore his posts. It's like driving by a car accident and trying not to look. You know it will be bad, but you really want to see *how* bad. … -
Replied To a Post in subscript not in range
I notice you have one line ENG5Text = DataGrid1.Columns(8).Text that should probably be ENG5.Text = DataGrid1.Columns(8).Text You have SCI4.Text = DataGrid1.Columns(26).Text SCI5.Text = DataGrid1.Columns(26).Text where you use column 26 twice. … -
Edited subscript not in range
Hi to all! I am having a 69 fields in datagrid, i can add data into it but as i have selected certain row, not all data displays on the … -
Replied To a Post in DuckDuck Go, New Search Engine
I like the bang feature. -
Replied To a Post in DuckDuck Go, New Search Engine
Only if you are logged in to Google. If you don't log in then they can't associate your search terms with a particular user. -
Replied To a Post in Cutting virtual cloth
Very cutting edge. -
Gave Reputation to vegaseat in So. Does anyone have any good programming/computing jokes?
Programmers not only byte, the also nibble a bit. (nipple was wishful thinking, corrected, thanks RJ) -
Replied To a Post in So. Does anyone have any good programming/computing jokes?
I suppose I should have said all but one ;-P. Because I don't browse the C/C++ threads I can honestly say I've never seen your code (although I am sure … -
Replied To a Post in How to Read a .txt file Line by Line in DataGridView
You can add rows just by For r = 0 To lines.GetUpperBound(0) DataGridView1.Rows.Add(lines(r)) Next Just add a test at the top of the loop to select/ignore specific rows. To clear … -
Created Happy Holi
To all of our friends in the great sub-continent. -
Edited Joins/Pivot tables
SELECT * FROM basketball_market where (name LIKE '%- Total Points' OR name LIKE '%- Money Line' OR name LIKE '%- Spread') AND type_id like '266' basketball_market table: http://my.jetscreenshot.com/5886/20150305-us2v-35kb SELECT * …
The End.