15,890,282 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View Python questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by sudevsu (Top 200 by date)
sudevsu
3-Mar-20 8:38am
View
app .config can be read in all forms. Or create a class the reads the values from app.config and call the object of the class in your forms anywhere as needed.
sudevsu
3-Mar-20 8:35am
View
As soon as you log in, store the user into a session like ZurdoDev commented above. It holds the value until the session is expired. When does a session expires? You must be already knowing an answer to this so it is pretty simple to show session values in another web form of same application using sessions
sudevsu
3-Mar-20 8:33am
View
You better improve your question with exact error message you are getting. Fatal error could be anything like no connection made/ no column in the table/ anything.
sudevsu
21-Apr-17 12:21pm
View
thank you
sudevsu
21-Apr-17 10:45am
View
Oh No Ajax is being called. Because control is going to my server side and I have my ajax in try catch block so I am sure it is called but request.Form("mystring") is always nothing. Can't figure it out why?
sudevsu
21-Apr-17 9:53am
View
I did try that way too but no luck. result is always showing nothing in server side while debugging.
sudevsu
21-Apr-17 9:22am
View
Deleted
Control is not hitting the Page2.vb Page load method at all. debugging like sick but couldn't find anything wrong.
sudevsu
9-Nov-16 10:02am
View
I don't think you have seen my tags. It is for Db2. If I know for Db2 I can write for MySQL. All the links you have in solution are already referred before posting the question. They don't help for Db2. passing with comma separator is my thought too but query should have something like this in IN clause('A','B','C'). ('A,B,C') doesn't work on IN. It works on FIND_IN_SET function MYSQl
sudevsu
9-Nov-16 9:26am
View
Thanks Maciej ... It helped after working on it for a while. Thanks for the guidance
sudevsu
24-Oct-16 9:40am
View
Thanks Maciej. I did run your three statements before testing them into my query. But I get error like Program column is not found, marks is not found. Meaning create the table and insert statement doesn't have these columns right!? I am talking about these
CASE
WHEN Program Like '%[1]%' THEN 'LVL1'
WHEN Program Like '%[2]%' THEN 'LVL2'
WHEN Program Like '%[3]%' THEN 'LVL3'
END AS Program,
CASE
WHEN Program Like 'YTD%' THEN 'YTD'
WHEN Program Like '%MT' THEN 'MT'
WHEN Program Like '%SP' THEN 'SP'
WHEN Program Like '%SC' THEN 'SC'
END AS Category,
in your select.
sudevsu
16-Aug-16 16:37pm
View
Thanks again @NJammy
sudevsu
16-Aug-16 10:26am
View
I does make sense... I am concerned about security issues. However let me give this a shot
sudevsu
16-Aug-16 10:07am
View
to elaborate this is what I want to do...
Step1: Send a URL to users via email. Also send a Unique Password.
Step2: User when clicked on the link, request for a password sent in email.
Step3: If valid , redirect to another page to upload File.
If Invalid, Request password from same page. Do not redirect until Valid.
Step4: Upload the File.
Now I have already done few things here. But I don't understand how can I make the url valid for only 24 hours.
How to know that this password is for this link/user ?
Basically I have parts of it all programmed but I missing the links between them. I not marrying them all properly. Let me know if you have ay thoughts on this. Thanks njammy
sudevsu
16-Aug-16 9:58am
View
ASP.NET webforms framework 3.5
sudevsu
16-Aug-16 9:50am
View
I don't need a code. I just need an idea like njammy did. Thanks
sudevsu
5-Aug-16 16:17pm
View
I am not aware of that. I was in misconception that setting a culture would change the page automatically. It would help me if you could tell me how to do that? For example my website has 100 content pages 70 user controls and nested master pages, it means I have to create every value in english and its corresponding spanish. Thats a lot of work. Is there any plugin that can do this without setting all the resource files? I tried google translator but I cannot get rid of the google tool bar that says Switch to Original / Translated to Spanish .
sudevsu
30-Jun-16 14:04pm
View
I am aware of that. So I placed all the functions and events from document.ready to a separate function sample(){//Placed all the code here}
And I am calling this SAmple function on document.ready and also later but that didn't help my bind events to work and eventually my selects options are not loaded
sudevsu
30-Jun-16 13:41pm
View
No karthik. It is not update panel. My only concern is I bind "change" events on each of these select option on document.ready() so as soon as page is loaded it works great. Once I do something else on the page(not refresh) and then click on button again all the bind "Change" events are not executed if I try to make them as separate function and call also it didn't help
sudevsu
30-Jun-16 11:32am
View
I have click event that does what ever document.ready has like loading all my select options but it only works once because page is not being refreshed so it doesn't load my select options again when clicked
sudevsu
29-Jun-16 10:10am
View
I got it working by adding this in as a jquery script separate. $('#closeBtn').click(function () {
$('#dialog_test1').dialog('close');
}); But I am still stumped why that doesn't work with closing the title bar
sudevsu
29-Jun-16 9:40am
View
Yeah I know about it. But I am stuck with 1.6 because most of our users are still using the old versions on IE ... Thanks Richard
sudevsu
20-Jun-16 12:57pm
View
Thanks Ryan. I did got that straight in my head. I found out the issue. I have set my user controls to visible false which has button1 when other button9 in ASPX is shown. So that is problem. that fixed my partial issue
sudevsu
20-Jun-16 12:48pm
View
While you are still here, Could we hide the user control and remove its space but it should still load the user control
sudevsu
31-Mar-16 12:02pm
View
Deleted
Never Mind. I am missing the index. I got it
sudevsu
30-Mar-16 9:44am
View
Seriously... I knew it its very simple. Silly me... Thank Griff :)
sudevsu
11-Mar-16 12:34pm
View
Any help is appreciated
sudevsu
11-Mar-16 11:41am
View
I deleted the post
sudevsu
11-Mar-16 11:40am
View
oops sorry I posted it but it didn't show me any so I had to create again. I will delete this. browser has been spinning for 30 mins now and didn't know if question is posted or not
sudevsu
10-Mar-16 16:21pm
View
Thank you
sudevsu
10-Mar-16 16:21pm
View
I have created a layout that looks exactly like my warehouse.
I am stuck having no idea of how to implement the Directory map in mall.
I need help regarding tutorials, links, any advice on how to create a directory map, just like in shopping mall directions map
sudevsu
24-Feb-16 15:19pm
View
Oh yeah ... this worked. I am looking more in SO these days because few experts here aren't helping like you usually do. I regret my decision now. Thank you so much.
sudevsu
24-Feb-16 15:11pm
View
"$(...).clear is not a function" is the error I got when I did as per your suggestion. At this line ".clear().append(frame)". I removed this line and it showed the modal pop up with empty frame. No grid is bound
sudevsu
24-Feb-16 15:05pm
View
I am not sure if you understood the issue here. Each time a button is clicked on Page1.aspx, the text of the button is passed as parameter to DisplayGrid.aspx and it then Binds the Grid. And I want to display this Grid in a Modal pop up.
sudevsu
24-Feb-16 14:56pm
View
Lol. It means analysis.
sudevsu
24-Feb-16 14:54pm
View
Deleted
To bind the Grid, I need the parameter that is passed in Jquery which will then fill the dataset
sudevsu
24-Feb-16 14:52pm
View
I have updated as per your suggestion but my parameter is not getting to a variable to pass to the method in Page load of DisplayGrid.aspx
sudevsu
24-Feb-16 14:44pm
View
Deleted
Should the DisplayGrid.aspx page contain a web method that actually gets the dataset filled with the parameter passed in Jquery?
sudevsu
24-Feb-16 14:39pm
View
Before I saw your solution, I have had few other tries in program and updated the question.
sudevsu
24-Feb-16 11:51am
View
Deleted
BTW, first thing is I have no idea how to show a gridview in modal pop up
sudevsu
24-Feb-16 11:49am
View
I did add server side method. Please look at MyFun() in "What I have tried"
sudevsu
19-Feb-16 14:11pm
View
Thanks Richard.
sudevsu
19-Feb-16 14:03pm
View
Awww.. How did I miss that . You are right.
sudevsu
19-Feb-16 13:57pm
View
now every time the button is clicked first alert shows button text and second alert with empty message. Please see improved questions
sudevsu
19-Feb-16 13:16pm
View
I did as per your solution. But now, as soon as I click on button, it shows the alert and all the dynamic created cells and table are gone. It shows white panel. I have Enableviewestate = True in my ASPX page.
sudevsu
19-Feb-16 9:52am
View
Page Load for javascript??? Can you show me how?
sudevsu
17-Feb-16 15:00pm
View
I have all the error traced in event viewer. But the error message didn't really show where it came from in the message. So I was wondering if that is with some cache issues
sudevsu
16-Feb-16 16:43pm
View
Just awesome. Thanks Dave
sudevsu
10-Feb-16 8:16am
View
Files having read /write permissions to everyone cannot be opened when embed src is changed to the path of server folder's file. Did that make sense ?
sudevsu
9-Feb-16 10:25am
View
I can definitely see that every one has permission to the folder in server.
sudevsu
9-Feb-16 9:56am
View
Its not about downloading the File. I have MEnu item "Manual" On clicking it, it should open the PDF in content page on web application. That's it.
sudevsu
4-Feb-16 16:35pm
View
I mean I did check that if IP address is correct or not.
sudevsu
4-Feb-16 16:01pm
View
I already did that. Did you see the above comment I added 192.1.*.**: ***/Login.aspx which is what I did before posting the question. I wonder why it worked when I first clicked without clearing the browser's history and cache and why it is not working after clearing.
sudevsu
4-Feb-16 15:36pm
View
It just keep spinning and ends up showing "Google Chrome could not load the webpage because 192.1**.*.* took too long to respond. The website may be down, or you may be experiencing issues with your Internet connection."
I just cleared my browser's cache and entered the URL and checked and it wont' work
sudevsu
4-Feb-16 15:34pm
View
I missed that simple thing. Thanks Richard. Just went out of space for few minutes.
sudevsu
4-Feb-16 14:33pm
View
I have connection bcoz it works locally. and also on server. but if I clear the cache and click on url it doesn't show up
sudevsu
29-Jan-16 11:40am
View
I tried to set Canvas top didn't work. Please see updated question's Code
sudevsu
29-Jan-16 11:40am
View
Deleted
this is making sense now.
sudevsu
29-Jan-16 11:20am
View
Did not quite understand
sudevsu
27-Jan-16 11:59am
View
Thanks
sudevsu
27-Jan-16 11:32am
View
Sequential like starting from 123456,123457,123458,123459 like this?
Not quite happy with that. because I have done that earlier. For some reason my VP isn't happy. Because at the End of the day this 6 digit will be a barcode on a sticker.
sudevsu
27-Jan-16 11:30am
View
I understood that part. But I don't understand how it is going to remember the number it generated yesterday and make sure it won't generate it again after few days
sudevsu
27-Jan-16 11:29am
View
Can you give example?
sudevsu
22-Jan-16 15:18pm
View
I don't think u understood the question.
In a windows Form, I have designed a dashboard which is what our company is using since 6 years. that is developed with one panel at center and multiple Grid on the it. Based on the Menu Items its respective grid is displayed.
Like wise I am not knowing the control in WPF.
sudevsu
20-Jan-16 11:57am
View
That is the problem I have here, the website was developed some 15 years back and I am new one to work on this now. I don't think it is good idea to start entirely new website based on the old one as it is time consuming. I am stuck in black hole . Thanks for you help . I had all this in my mind but wanted to make sure if its true to my knowledge.
sudevsu
13-Jan-16 11:20am
View
Ryan, I don't think that is actually a solution, I am going on for Leave for few days so this is kind of temporary fix for the release. So I didn't post it as solution.
sudevsu
13-Jan-16 11:19am
View
Yeah 136 line actually the line you mentioned.
sudevsu
13-Jan-16 8:19am
View
Alright I am not sure why is this line causing the problem ?
As soon as I remove the below line from web.config everything worked.
"mimemap mimetype="application/octet-stream" fileextension=".ttf""
I was doing some work with Barcode and ttf images so I added that line in web.config.
I will have to look at this later next week. For now, the release is good to go.
sudevsu
12-Jan-16 11:48am
View
I have all the unhandled exepctions redirecting me to a page called "Internal error" .
Error message in Event views shows this
Exception information:
Exception type: CryptographicException
Exception message: Bad Data.
Nothing else apart from the stack trace.
It works locally so I am not sure what is wrong
sudevsu
8-Jan-16 12:28pm
View
I saw the scanners in warehouse and you are right about it . They are using wifi scanners with displays and keypad.
So assume that the club car screen system is browser + js capable, then will the Cipher Lab USB scanner work for what I am asking for?
sudevsu
7-Jan-16 10:40am
View
Alright this makes some sense now. I can relate. Let me go to warehouse and get back to you. I have to drive couple of miles from my work place.
sudevsu
7-Jan-16 10:18am
View
hmmmm...ok
sudevsu
7-Jan-16 9:01am
View
Here is the Whole thing again.
When scanned the Barcode on the document (which is generated by my web application) ---> And scan the barcode stickered on the Bin of Rack.
My Claim (Barcode) should update respective field in the Database with the Bin of Rack (where the claimed Items are sitting in warehouse)
I believe there is nothing to show on the scanner actually. Instead warehouse guys have small club cars where there is a screen on each. It should get updated on the Screen. I know it is all grey here. But I have not worked in any warehouse / manufacturing projects earlier. So Its absolutely dark for me to explain properly.
sudevsu
7-Jan-16 8:52am
View
This is what I have CipherLab A1070CBS0U001 Barcode Scanner
sudevsu
7-Jan-16 8:39am
View
Yes Handheld USB Scanner is what I have.
I am not sure about the rest two questions. And that is the whole point of this thread.
sudevsu
6-Jan-16 15:55pm
View
May be the wordings are put incorrectly. But now the other Expert is trying to help me as he/she is getting into this. I would appreciate if you can throw some light in this grey area
sudevsu
6-Jan-16 15:43pm
View
Now you are actually getting into this.
Warehouse has Racks. Each Rack has a Bin stickered with a Barcode.
Now if the guy scans the barcode from the printed document and scans the Barcode on the Bin. It has to save the Bin number (that is where my Claim items are sitting )in my Database which will be reflected on the web app further. But they may not be using both at same time as per your point.
sudevsu
6-Jan-16 14:45pm
View
Deleted
Can you elaborate "receive data from the PC to display (which will be hard because it's a Web App"
Why is it hard if its a web app.
sudevsu
6-Jan-16 14:28pm
View
BTW, the barcode that is generated is in font Code 39
sudevsu
6-Jan-16 14:25pm
View
See, I have created a web application where user enter all the Claim details that is supposed to return/ claim return .
And there is a unique alphanumeric string that is generated by my program and that string is converted to Barcode Image using Keep automation.dll .
Now that image is placed on the top right corner of a paper (printed Claim).
I have people who will work on this project and they will scan the barcode on the printed claim and know where the related products are placed in Rack/Bin in huge warehouse.
I am stuck with last step. I want to know how they can scan and relate that to my Program and get the details on the scanner.
sudevsu
6-Jan-16 13:43pm
View
I am not afraid to use JavaScript. But "how" is what I need.
sudevsu
6-Jan-16 13:39pm
View
nope. But what I need here is to scan the barcode image (that is generated by my web application) on the claim (printed PDF)
sudevsu
6-Jan-16 13:13pm
View
Yeah I am using USB scanner.
But how do I use that scanner to scan the barcode that is generated by my ASP.NEt VB.NEt web application and get the details from Database. I am not quite comfortable with scanner because I haven't worked before. So this is completely New. Please talk in layman terms. To scan a barcode on PDF and get the Rack number that Claim is sitting in is all what I need.
sudevsu
6-Jan-16 9:41am
View
debug and see what it returns???
sudevsu
29-Dec-15 10:10am
View
No problem. Let us know if you get a solution
sudevsu
28-Dec-15 11:02am
View
Ok I saw that. But neither I have access to your code nor I will. But I hope you must have already checked on these things
1) If you have a JavaScript /Client side script running on the Click on Excel, Have a debugger in the debugger tool of browser.
2) Keep a breakpoint on the server side (code behind) page and check to see what is going on behind after clicking the Excel
3) ASP.NEt is all about knowing Postbacks well.
Also Still I don't see the Uploading thing on my End.
I see "waiting for Oder.arrahmanoverseas.com ..." message on the left side bottom on the browser and then the file is downloaded.
I am sorry If any of these are not helpful.
sudevsu
28-Dec-15 10:51am
View
I tested in Chrome and FF , there is no Upload... Only the Excel file is downloaded.
sudevsu
28-Dec-15 10:44am
View
You understood it wrong Ashutosh. Please read the comments given by Dave.
sudevsu
28-Dec-15 10:42am
View
On clicking Excel, there is nothing uploading on the site. Instead clicked Excel is downloaded Tabulated_Report.xlsx. I am not sure where you see the uploading thing happening. Also Is this developed in ASP.Net or MVC?
sudevsu
28-Dec-15 10:33am
View
I don't see a ringing bell actually to try.
I have got to View orders Grid. Is it something there?
sudevsu
28-Dec-15 9:42am
View
This is not a question buddy. This is a homework...
https://msdn.microsoft.com/library/ff184050(v=vs.100).aspx
Go through that link
sudevsu
28-Dec-15 9:17am
View
I think datagridview is from windows application. In that case, you will have fill the grid by each row. If its a web application, most of the time we use Gridview in this case assigning the Datasource to Gridview works.
also Please use parameterized query. DO NOT PASS the value in the Query WITHOUT Parameters. Capitals may annoy you but you will thank me later if you know about it
sudevsu
21-Dec-15 14:06pm
View
No I did develop windows service already. Its running quite good. However, I have read a suggestion that was made by someone that are commented in the question. so I thought lets do a scheduled task
sudevsu
17-Dec-15 10:43am
View
Appreciate that. Thanks
sudevsu
15-Dec-15 15:26pm
View
Also I have tried and I get "the requested document is not available in Firefox's cache." I dont' want this message. Instead I want the entire page to reload again. I believe there is no answer for this
sudevsu
15-Dec-15 12:18pm
View
BTW, this can be only positive to IE. Not FF, Chrome.
sudevsu
15-Dec-15 12:14pm
View
Yes. I have web page which is like information gathering form and on clicking submit, it shows a success message after inserting the data. Now I clicked on Page2.aspx. Now back button on the browser is clicked and I see the success message instead of loading the entire page. This one is being a problem since last 2 weeks. I couldn't solve. just losing hopes
sudevsu
15-Dec-15 8:54am
View
What happens if this is added Tadit. I can still click on back button on the browser and it should "requested document is not available on Firefox cache"
sudevsu
11-Dec-15 16:01pm
View
I tried the first one already and I got this message in the browser
"This document is no longer available.
The requested document is not available in Firefox's cache.
As a security precaution, Firefox does not automatically re-request sensitive documents.
Click Try Again to re-request the document from the website."
sudevsu
30-Oct-15 16:22pm
View
I am not sure why? but for some reason this worked absuoultely fine in VS2013/ VS2010 . It is not working in VS2008. I did add reference System.Core. It shows me an Error "Unable to cast object of type 'WhereSelectEnumerableIterator`2" ... After putting a efforts on this for a week and I was finally there but again a disaster... arghhhhh...
sudevsu
29-Oct-15 11:42am
View
What did you try so far? what was the error you got
sudevsu
28-Oct-15 12:10pm
View
When someone is trying to help you ... You are not supposed to comment like that. OriginalGriff is trying to help you by saying what you should do to improve your question.
sudevsu
27-Oct-15 10:01am
View
Thank you ...
sudevsu
27-Oct-15 10:00am
View
Deleted
I did try your query in MySQL in fiddle and it always throws me error saying oops something went wrong. I have never used fiddle
sudevsu
26-Oct-15 16:34pm
View
This actually didn't work. I have used exactly same thing I get the below error
"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'case when BinUse > 1 then "Yes" else "No" from (select BABLOC, BinUse = count(BA' at line 1"
BTW, I did this in MYSQL instead of DB2 to check .
sudevsu
26-Oct-15 10:59am
View
If PRM_QTY is '' then it should ignore the where clause for this condition alone.
It should just check VINBIN.BAQOH > 0
It PRM_QTY is some value '50' then it should give me results like
VINBIN.BAQOH >0 and VINBIN.BINBAOH < INTEGER(50)
sudevsu
26-Oct-15 10:50am
View
Basically, if I don't pass the value it should ignore that condition
sudevsu
26-Oct-15 10:45am
View
Thanks George. I tried it works only if I pass the value. If I don't pass the value it should ignore this clause in where. but it throws me an error data conversion error
sudevsu
26-Oct-15 10:43am
View
I may or may not pass the value for PRM_QTY . Meaning. If I don't pass the value it should ignore the comparison. But it throws me an error saying "Data conversion error"
sudevsu
21-Oct-15 12:50pm
View
Awesome. thank a ton.
sudevsu
21-Oct-15 11:36am
View
I think Grouping on Item and Bin would solve the Problem. Because we are grouping on BIN, there will be an error as Some Bins can have different Items also. So how to group on Item and BIN? All are string datatypes. Please consider them as String and let me know. We want Items and BINS that are grouped in Group Clause
sudevsu
21-Oct-15 10:33am
View
Can we group by Item and Bin ?
I tried this but it gives me error saying conversion of Long is not possible.
Dim clearedBins = (From d1 In dtNew.AsEnumerable() _
.GroupBy(Function(b) b.Field(Of String)("Bin").ToString().Trim() AndAlso b.Field(Of String)("Item").ToString()) _
.Select(Function(g) New With _
{ _
Key .Bin = g.Key(), _
Key .Comments = String.Join("|", g.Select(Function(c) c.Field(Of String)("Comment").Trim())) _
}) _
.Where(Function(a) a.Comments.Contains("Cleared")) _
Join d2 In dtNew.AsEnumerable() _
.Select(Function(a) a) On d1.Bin.ToString() Equals d2.Field(Of String)("Bin").ToString().Trim()) _
.Select(Function(b) b.d2) _
.Distinct()
This grouping on Two fields should solve the problem. Please help me
sudevsu
21-Oct-15 9:46am
View
I understood that we are grouping by BIN and checking if Cleared belongs to that Group. But In that case, the Query shouldn't return the last two rows which are not having "Cleared" in comments. But It returns them as well instead of First three. Please see the DataTable from Query
sudevsu
21-Oct-15 9:09am
View
I totally agree on doing a class but I first need to get the LINQ query work first as expected. I have couple of other LINQ queries based on the results of the above LINQ results. If this gives me accurate results, I think everything will work perfect. I have been working on this since a week and I learned a bit from your Queries and explanation.
sudevsu
21-Oct-15 9:05am
View
Thank you Maciej.
I am trying to work on this LINQ queries as per my need. First to understand I have been trying your suggestion which you said "If you want to get 2 or 3 rows with Bins which were cleared, try this:" But I don't see right outer join is working with this LINQ . I cannot see null as results if it doesn't exists . instead I get a union of these two tables . Let me show you an example.
I have updted my Question so that formatting will be easy to understand.
Please see above
sudevsu
19-Oct-15 15:46pm
View
I get error saying {"Value cannot be null.
Parameter name: row"}. It doesn't allow me adding a null / default
sudevsu
19-Oct-15 15:35pm
View
I did change that to
Dim JoinResult2 = (From o In dtcleared.AsEnumerable _
Group Join a In dtNew.AsEnumerable _
On o.Field(Of String)("Bin").Substring(0, 6) Equals a.Field(Of String)("Bin") _
And o.Field(Of String)("Item") Equals a.Field(Of String)("Item") Into _Table2 = Group _
From _a In _Table2.DefaultIfEmpty() _
Select New With _
{ _
Key .Item = _a.Field(Of String)("Item"), _
Key .Bin = _a.Field(Of String)("Bin"), _
Key .Size = _a.Field(Of String)("Size"), _
Key .Description = _a.Field(Of String)("Description"), _
Key .MoveQty = _a.Field(Of String)("Move Qty"), _
Key .ToBin = _a.Field(Of String)("To Bin"), _
Key .Comment = _a.Field(Of String)("Comment"), _
Key .Action = o.Field(Of String)("Action")
}).ToList()
But no use
sudevsu
19-Oct-15 15:10pm
View
Nothing funny here but I have just been there to check syntax and all. :) but didn't help though
sudevsu
19-Oct-15 15:01pm
View
Yeah I did try that. Only after trying I will ask here. I am not that person who will leave work on someone's shoulders and sit happily. I am very much interested to learn LINQ.
Dim JoinResult1 = _
(From o In dtcleared.AsEnumerable _
Join a In dtNew.AsEnumerable _
On a.Field(Of String)("Item") Equals o.Field(Of String)("Item") into JoinItem _
From a in JoinItem.DefaultIfEMpty() _
Select New With _
{ _
Key .Item = a.Field(Of String)("Item"), _
Key .Bin = a.Field(Of String)("Bin"), _
Key .Size = a.Field(Of String)("Size"), _
Key .Description = a.Field(Of String)("Description"), _
Key .MoveQty = a.Field(Of String)("Move Qty"), _
Key .ToBin = a.Field(Of String)("To Bin"), _
Key .Comment = a.Field(Of String)("Comment"), _
Key .Action = o.Field(Of String)("Action")
}).ToList()
I get error at into clause
sudevsu
19-Oct-15 14:54pm
View
I want a Right outer Join for
<pre> Dim JoinResult1 = _
(From o In dtcleared.AsEnumerable _
Join a In dtNew.AsEnumerable _
On a.Field(Of String)("Item") Equals o.Field(Of String)("Item") _
Select New With _
{ _
Key .Item = a.Field(Of String)("Item"), _
Key .Bin = a.Field(Of String)("Bin"), _
Key .Size = a.Field(Of String)("Size"), _
Key .Description = a.Field(Of String)("Description"), _
Key .MoveQty = a.Field(Of String)("Move Qty"), _
Key .ToBin = a.Field(Of String)("To Bin"), _
Key .Comment = a.Field(Of String)("Comment"), _
Key .Action = o.Field(Of String)("Action")
}).ToList()
</Pre>
Meaning results something like below
For the columns it should show Empty or ""
<pre>
Item BIN Size Description MoveQty ToBin Comment Action
AD1952234763 AN033 LT24575R16 120/116Q E ADVANTA A/T ROBL 16 AR029 Reduced Bin AN033 Reduced,Reduced,Cleared
AD1952234763 AN033 LT24575R16 120/116Q E ADVANTA A/T ROBL 26 AL031 Reduced Bin AN033 Reduced,Reduced,Cleared
AD1952234763 AN033 LT24575R16 120/116Q E ADVANTA A/T ROBL 13 AL036 Cleared Bin AN033 Reduced,Reduced,Cleared
Reduced,Reduced,Cleared
Reduced,Reduced,Cleared
</Pre>
sudevsu
19-Oct-15 14:50pm
View
Basically I want a Right Outer Join for this
Dim JoinResult1 = _
(From o In dtcleared.AsEnumerable _
Join a In dtNew.AsEnumerable _
On a.Field(Of String)("Item") Equals o.Field(Of String)("Item") _
Select New With _
{ _
Key .Item = a.Field(Of String)("Item"), _
Key .Bin = a.Field(Of String)("Bin"), _
Key .Size = a.Field(Of String)("Size"), _
Key .Description = a.Field(Of String)("Description"), _
Key .MoveQty = a.Field(Of String)("Move Qty"), _
Key .ToBin = a.Field(Of String)("To Bin"), _
Key .Comment = a.Field(Of String)("Comment"), _
Key .Action = o.Field(Of String)("Action")
}).ToList()
sudevsu
19-Oct-15 14:50pm
View
Can you have Right outer Join for this?
sudevsu
19-Oct-15 14:13pm
View
@Maciej Los .
Earlier, The solution you gave me here http://www.codeproject.com/Questions/1039700/LINQ-Query-on-Datatable-in-Vb-net?arn=0
Is kind of for this. But I belive I am doing same thing over and over again.
For this reason, I would like to ask you if you can do that with above datatable1 dt1. How would that be possible? I have been trying to figure it out but no luck like the other one. Can you help me please?
sudevsu
19-Oct-15 14:09pm
View
Thank you all
sudevsu
19-Oct-15 14:03pm
View
Deleted
Can you tell me how to do that to To List() at the end
sudevsu
19-Oct-15 13:56pm
View
Have been there already. :(
sudevsu
19-Oct-15 13:35pm
View
yeah I did, instead of going each line on the datatable, only after I press F11, it comes to next line and if I watch the resultjoin, it was showing me that "Type Expected"
sudevsu
19-Oct-15 13:11pm
View
I did change those two. But in the Joinresult variable I get "Type Expected".
Other than that there is no error or no result.
sudevsu
19-Oct-15 12:56pm
View
Updated
sudevsu
19-Oct-15 12:36pm
View
a.Field(Of String)("Move Qty")
sudevsu
19-Oct-15 9:41am
View
Deleted
I have used same function for my another LINQ query results and it converts it absolutely fine. But this result it doesn't show any errors. Instead it returns all empty rows
sudevsu
19-Oct-15 9:36am
View
Deleted
Yeah I am still working on that. I am trying to convert this result list to a datable by using below function. But that doesn't work. Can you tell me the reason. No errors or nothing.
Public Function ConvertToDataTable(Of T)(ByVal list As IList(Of T)) As DataTable
Dim table As New DataTable()
Dim fields() As FieldInfo = GetType(T).GetFields()
For Each field As FieldInfo In fields
table.Columns.Add(field.Name, field.FieldType)
Next
For Each item As T In list
Dim row As DataRow = table.NewRow()
For Each field As FieldInfo In fields
row(field.Name) = field.GetValue(item)
Next
table.Rows.Add(row)
Next
Return table
End Function
sudevsu
19-Oct-15 8:38am
View
Thank you
sudevsu
15-Oct-15 14:08pm
View
Can you please tell me in vb.net? I want to test this, I tried and it shows errors
Dim clearedBins = dtNew.AsEnumerable().[Select](Function(c) New With { _
Key .Item = c.Field(Of Integer)("Item"), Key .Action = c.Field(Of String)("Comment").Substring(0, c.Field(Of String)("Comment").IndexOf(" ")), _
Key .Bin = c.Field(Of String)("Comment").Substring(c.Field(Of String)("Comment").IndexOf(" "), (c.Field(Of String)("Comment").Length - c.Field(Of String)("Comment").IndexOf(" ")))}).GroupBy(Function(a) New From { a.Bin, a.Item }).Select(Function(g) New With { Key .Bin = g.Key.Bin, Key .Item = g.Key.Item, Key .Action = String.Join(",", g.[Select](Function(x) x.Action)) }).Where(Function(b) b.Action.Contains("Cleared")).ToList()
sudevsu
14-Oct-15 14:35pm
View
Please see the example where I strikes out the lines that shudn't be considered
sudevsu
14-Oct-15 14:34pm
View
Hey Manas,
You misunderstand the question, I want those rows that are associated with same bin if it reduced and cleared. Not just cleared alone. If the next bin is not cleared then I don't want that row.
sudevsu
30-Sep-15 16:48pm
View
This is not what I am looking for. I want the external proc to be called on each row with a parameter passing from select query
sudevsu
30-Sep-15 14:42pm
View
Before that, Can you tell me if my query written above is correct ? Meaning, for each row of the select statement results, it should pass a value from it to external proc and return a result union of both the query and external proc.
I am hanging on the edge and banging my head since last three days for this. Google doesn't help me in finding any solutions in DB2.
sudevsu
30-Sep-15 14:37pm
View
I did try this. But no luck. Can you just tell me or write the same. I am pretty new to DB2
sudevsu
28-Sep-15 14:22pm
View
Got it. Thanks
sudevsu
28-Sep-15 13:42pm
View
I did it like below
ICITEM like '@PRMICITEM%'
Because I want a like clause there
sudevsu
28-Sep-15 13:24pm
View
Yeah but it putting restriction on ICITEM if its empty/null. It doesn't return anything. Instead I want it to return all records
sudevsu
28-Sep-15 13:09pm
View
Well , yeah something like this. But it didn't fulfill the requirement though. When the parameter is empty it should return all results. If Parameter is '3' then it only returns the records where ICITEM='3'. Meaning, it PRMICITEM is not empty, then it should check for this constraint. otherwise it shouldn't
sudevsu
25-Sep-15 11:40am
View
Got it. Thank you. However, I did get a solution.
sudevsu
25-Sep-15 11:05am
View
variable height for Grid? Its not about height. Its about Width. I did try changing width sizes and still it is not showing the entire grid.
sudevsu
25-Sep-15 8:41am
View
May be its true, But thats what I can do... Because the result of above SP should had to have a call to external SP on each row. Only then we get the required output
sudevsu
21-Sep-15 9:22am
View
Thank you
sudevsu
21-Sep-15 9:22am
View
Thank you
sudevsu
21-Sep-15 9:22am
View
This has helped me. Thank you
sudevsu
13-Aug-15 14:54pm
View
Lol, yeah I did. Thank you. I will delete this post now.
sudevsu
13-Aug-15 14:33pm
View
Thank you
sudevsu
10-Aug-15 13:07pm
View
There you go ... You are awesome. Thanks a lot. First time ever, someone from Codeproject constantly giving solutions till it is achieved. I really Appreciate you Richard. Thanks a lot. I did add ClientID mode on dropdown as well.
sudevsu
10-Aug-15 12:53pm
View
It is txtProdcode. Yeah I know that these are case sensitive.
And I do have master page. and I added ClientID Mode on the Textbox Control to Static but didn't help me
sudevsu
10-Aug-15 12:40pm
View
Thanks Richard. But even now, my value is not assigned to asp:Textbox.
I have this txtProdCode in panel(not update panel) Page1.aspx on which the modal popup opens. If that has anything to do with.
sudevsu
10-Aug-15 12:25pm
View
I am doing it this way. But I don't seem that works. I need help on that
Save: function () {
debugger;
var value = $("ddlProductCd").val();
$('#txtProdcode').text(value);
$("#txtProdcode").text = $("#ddlProductCd").val();
$(this).dialog("close");
$(this).find("iframe").attr({ src: "" });
}
sudevsu
10-Aug-15 12:22pm
View
When I click on Save button on Pop up, I want the selected value to assign to the Textbox.
sudevsu
10-Aug-15 12:17pm
View
Deleted
function getfoc() {
debugger;
$("#modal_PrdCddialog iframe").attr({ src: "ProductCode.aspx" });
$("#modal_PrdCddialog").dialog({
title: "Select the Product Code to fill the Tire size",
css: { border: 'Yellow' },
autoOpen: true,
modal: true,
height: 300,
width: 450,
open: function (event, ui) {
$('#modal_PrdCddialog').css('overflow', 'hidden'); //this line does the actual hiding
},
buttons: {
Save: function () {
debugger;
var value = $("ddlProductCd").val();
$('#txtProdcode').text(value);
$("#txtProdcode").text = $("#ddlProductCd").val();
$(this).dialog("close");
$(this).find("iframe").attr({ src: "" });
},
Close: function () {
$(this).dialog("close")
$(this).find("iframe").attr({ src: "" });
}
}
}).prev(".ui-dialog-titlebar").css("background", "blue");
}
sudevsu
10-Aug-15 11:37am
View
I can definitely see that this is working. But my submit on Modal popup is not returning the value selected from dropdown after I added this code. Can you please suggest?
sudevsu
7-Aug-15 13:32pm
View
Can you please see my updated question and help me with that
sudevsu
6-Aug-15 14:31pm
View
Yeah That's the help I am looking for
An open source solution that does the work.
I didnt find any reliable open source. So I am asking for help here about the sample code for writing our won Barcode renderer.
I always check with google first and then come here for help.
sudevsu
6-Aug-15 13:52pm
View
So consider my string is "MFI-08052015-123"
I will save that in DB as string value.
But when user clicks on Print button, it is going to fill in the PDF form and then it should add the associated string " MFI-08052015-123" in scanner barcode form. Now I am unhappy with the dll I am using for this. I would like to use my own code instead of readily available dlls. Because, it has to be licensed after trail and it also prints a water mark on the barcode of their company name. I don't want either to happen.
So I am looking for customized code for creating the string to Barcode Image.
sudevsu
28-Jul-15 10:09am
View
Meaning. Can you please give any example for it
sudevsu
28-Jul-15 9:16am
View
Not an extra button, Submit will insert the data to Database and then followed by JavaScript which is below. Multiple things on same button
sudevsu
28-Jul-15 8:10am
View
As said earlier, I already created the PDF on server side. But it opens on same page. Now I want a button to work exactly like a print preview on browser. Could you please tell me how
sudevsu
28-Jul-15 8:01am
View
lol... No he is really good guy. But he has come down to make the non-computer literates (Dealers) happy. :)
He will only be happy if all the possible options are closed.
Now... Exactly print preview of browser should be how the button is supposed to work. Can you tell me how?
sudevsu
27-Jul-15 17:00pm
View
Nope. I knew that someone is gonna tell this. My Manager wants it like that. It should open same exact page like print preview. Can you help me please?
sudevsu
27-Jul-15 16:34pm
View
Yeah. COrrect. I will tell this to my manager And I did complete the solution for showing new data in response to user action on the same window. Thank a lot SA :)
sudevsu
27-Jul-15 15:00pm
View
Yeah when I say Attachment , I mean something like
show new data in response to user action on the same window
Open Save Cancel.
I think that's what you mean. I have done with this as solution for now.
But I really want to new tab / window because most of the dealers using the site are not computer literates , so they want everything open and requested for this
sudevsu
27-Jul-15 14:43pm
View
Ok Instead asking the user to Save/ Open / cancel like an attachment would be better?
sudevsu
23-Jul-15 16:03pm
View
I really don't know the concept of static dictionary so I am not trying the solution. Will surely keep in mind for future .
thank you
sudevsu
23-Jul-15 16:01pm
View
it is not confusing Praveen. I have set of check boxes like Tread, Sidewalk, Other, Bead etc., Now if database value is Sidewalk it going to check Sidewalk and rest all should be unchecked. Simple. Similarly another set of checkboxes in the PDF are Left Front, Trailer, Left Rear etc.,
sudevsu
23-Jul-15 13:54pm
View
This helped me to achieve what I need. I just changed a bit. But idea was from your solution. Thank a lot.
sudevsu
23-Jul-15 9:55am
View
This wont work. I tried it. And it says error at "expression expected" near J++
sudevsu
23-Jul-15 9:51am
View
Because there are checkboxes in the PDF for each field. So I am checking only if the value matches to the field
sudevsu
22-Jul-15 13:36pm
View
I am not using IIS to host. yeah I do see localhost:1234 like url.
However, I just rebooted . stupid solution but worked. Didn't have patience to figure it out. arghhhhh
sudevsu
20-Jul-15 16:14pm
View
I just did what you said and it worked perfectly for my requirement. Thanks
sudevsu
20-Jul-15 9:25am
View
Different meaning It should actually change the orientation
sudevsu
20-Jul-15 9:23am
View
Thanks SA for the solution.
But I wasn't sure about the solution. Because I want entire preview page to look different to my page.aspx
Ignore negative comments.
sudevsu
20-Jul-15 9:20am
View
Suppose my page.aspx has print button. On clicking button, it should get the data into respective controls and fields and display the format as different to page.aspx design
sudevsu
20-Jul-15 9:13am
View
What the hell is wrong with you Shekhosvtsov? When someone is trying to help, how come you comment like that? If cannot help keep quiet . This blog is not to abuse. Its for helping. I haven't read the article tha Sergey provided in the solution, however your comment is not appreciable.
sudevsu
6-Jul-15 11:32am
View
Yeah that's true. But I really don't need it line by line. I don't understand the part from UnionAll. That's where I was stuck. I know its hard to sit and write line by line. But I would be more than happy to make some kind of effort in trying to make it understand rather than telling it blindly ... But yeah I totally agree with u as well.
sudevsu
6-Jul-15 10:43am
View
Do you mean you want your website to work Offline mode?
sudevsu
29-Jun-15 16:44pm
View
Thanks
sudevsu
26-Jun-15 10:08am
View
Anyway I did something like this.
select icitem, icdsc1, icdsc2, ifloc, ifqoh, ifqcm, count(ifqoh) as 'count'
from TESTDATA.VINITMB
join TESTDATA.VINITEM on icitem = ifitem
where ifcomp = 1
and ifdel = 'A'
and ifqoh = 0
and icitem like 'VP%'
group by ifitem having count>0
order by ifloc, ifitem;
But that doesn't make any sense to me. sum (ifqoh)=0 ??? Whaaaattttt
sudevsu
26-Jun-15 10:07am
View
Hehe lol no. I mean how can we sum with a condition?
sudevsu
19-Jun-15 12:44pm
View
Thank you
sudevsu
9-Jun-15 16:40pm
View
Oh I knew I can use session. I thought if there is an another way form form. Thanks anyway
sudevsu
2-Jun-15 15:06pm
View
http://www.codeproject.com/Answers/865157/How-to-send-emails-from-my-website-domain-in-asp-n#answer2
sudevsu
1-Jun-15 15:44pm
View
also you can use Dataview to filter what ever value you want.
sudevsu
1-Jun-15 15:31pm
View
Oh Really? Crazy
sudevsu
29-May-15 12:11pm
View
Oh I really didn't see that. I saw that it is sitting in questions and I answered.
sudevsu
28-May-15 15:13pm
View
who ever downvoted this? Can you please tell me why? Nothing offensive, I just want to know whether it is wrong with code or the approach?
sudevsu
27-May-15 9:13am
View
Thank you. Same answer as solution 1
sudevsu
27-May-15 9:12am
View
Thank you
sudevsu
20-May-15 8:31am
View
Alright thanks for all your time. I just created a new form and did the same process everything seems working fine.
sudevsu
19-May-15 15:12pm
View
Yeah it does... I wonder same code works absolutely fine for one combobox and it doesn't for another. Everything seems weird when you really don't understand the code right! :-/
sudevsu
19-May-15 14:26pm
View
In C#: Me.DrawItem += New DrawItemEventHandler(AddressOf AdvancedComboBox_DrawItem)
Vb.Net : AddHandler Me.DrawItem, AddressOf AdvancedComboBox_DrawItem
sudevsu
19-May-15 10:50am
View
Deleted
I did as u said. No luck!
sudevsu
19-May-15 10:47am
View
Deleted
This piece of code is from another form called EditItem.vb
Where I want to change the color of combo box
If strAcc.Trim().Length > 0 Then
Dim AccName As String = String.Empty
AccName = dbProd.GetAccountNumber("", strAcc)
cmbAccount.Text = AccName
cmbAccount.SelectedValue = AccName
Dim oCmbBox As ComboBoxColor = New ComboBoxColor(cmbAccount)
Invalidate()
sudevsu
19-May-15 10:31am
View
Deleted
Public Sub New(ByVal cmb As ComboBox)
MyBase.DrawMode = System.Windows.Forms.DrawMode.OwnerDrawFixed
AddHandler cmb.DrawItem, AddressOf AdvancedComboBox_DrawItem
End Sub
Private Sub AdvancedComboBox_DrawItem(ByVal sender As Object, ByVal e As DrawItemEventArgs) Handles Me.DrawItem
If e.Index < 0 Then
Return
End If
Dim combo As ComboBox = TryCast(sender, ComboBox)
If (e.State And DrawItemState.Selected) = DrawItemState.Selected Then
e.Graphics.FillRectangle(New SolidBrush(HighlightColor), e.Bounds)
Else
e.Graphics.FillRectangle(New SolidBrush(combo.BackColor), e.Bounds)
End If
e.Graphics.DrawString(combo.Items(e.Index).ToString(), e.Font, New SolidBrush(combo.ForeColor), New Point(e.Bounds.X, e.Bounds.Y))
e.DrawFocusRectangle()
End Sub
sudevsu
19-May-15 10:31am
View
Deleted
Dim oCmbBox As ComboBoxColor = New ComboBoxColor(cmbAccount)
Invalidate()
cmbAccount is the combo box I want to change the color. So I added a parameter in the class method as well.
Show More