Comments by Kschuler - CodeProject

Kschuler 1-Oct-19 9:43am View

Nice. I lost all my regex bookmarks a while back and haven't gotten around to re-bookmarking those tools. Thanks!

Kschuler 16-May-19 15:52pm View

Not sure what you mean by "just send one cert". I put it into a "collection" because that's what form it needs to be when connecting it to the request object. But it's still the same certificate values as when I pull from one pfx file instead.

Kschuler 16-May-19 15:15pm View

Dude. Thank you for pointing out this tool. Awesome. Unfortunately, it only confirms that I'm after TLS 1.2. I'll dig into the ciphers and see what I can find there. Thanks again, though!

Kschuler 16-May-19 15:04pm View

Yes, they confirmed TLS 1.2.

Kschuler 16-May-19 15:03pm View

No idea about the F5 load balancer. Hitting a third party.

They did specify that I should be using TLS 1.2, though.

Kschuler 16-May-19 14:32pm View

Tried it. Didn't work.

Kschuler 20-Feb-18 12:07pm View

Why isn't your code working? Are you getting an error? Or what is happening?
You should add something to the Catch, just in case you are getting errors. And where does the variable range come from?

Kschuler 12-Jan-17 12:02pm View

If you just want to make the column larger, you can go into design mode and move the columns and fields until they are the way you want. Maybe google for a tutorial to get some background info. You're question is kind of too vague for us to really help you.

Kschuler 12-Jan-17 12:01pm View

I think you mean ClickOnce...and I'm not sure if you can auto update it without being in the program itself. You may want to do some more research here: https://msdn.microsoft.com/en-us/library/142dbbz4(v=vs.90).aspx

Kschuler 14-Dec-16 10:29am View

Can you post exactly what formula you are using?

Kschuler 19-Sep-16 10:52am View

If they aren't supposed to click the button more than once, then you could try stopping them from being able to do that.

Kschuler 11-Aug-16 13:45pm View

Glad someone helped you. Just remember next time to include what error you got. It makes it a lot easier to narrow down the problem. :)

Kschuler 10-Aug-16 16:08pm View

I can't answer this directly...but I'm pretty sure you should research regular expressions.

Kschuler 10-Aug-16 16:04pm View

What error do you get?

Kschuler 10-Aug-16 15:52pm View

What error do you get?

Kschuler 30-Mar-16 12:27pm View

Why didn't labels work? If you have a list of questions, set the label's text property to the first question. When they click the next button, set the label's text property to the next question in the list.

Kschuler 25-Sep-15 8:41am View

Can you post the code you are using to display the report?

Kschuler 23-Sep-15 11:39am View

There isn't enough information in your question for us to help you. Do you have any other clues and/or code and/or error messages that you can provide?

Kschuler 23-Sep-15 11:36am View

"Load report failed" can mean a lot of different things. It might not be the login authorities that is the problem. Can you get it to work when you're not by passing the login prompt?

Kschuler 14-Sep-15 16:04pm View

I was unable to find a way around this. I just had to make sure our help desk and IT Technicians knew about it and made a help document for users to install. Please let me know if you find a way. :)

Kschuler 19-Aug-15 14:28pm View

Can you click the Improve question link and add more information to your question. What kind of project are you doing? Web or Windows Forms or something else? And what code do you have so far to display these controls? Have you tried google first?
https://www.google.com/webhp?sourceid=chrome-instant&rlz=1C1EODB_enUS581US581&ion=1&espv=2&ie=UTF-8#q=image%20in%20richtextbox%20align%20middle%20vb.net

Kschuler 12-Aug-15 10:34am View

I have no idea what you are trying to do and therefore can't (and don't want) to do your work for you. I'm just trying to point you to a resource that you can use to figure it out yourself. If you need more help, you need to supply more information. Step by step tell us what you have already done and what you are having trouble with. You haven't given us any code to try to help you debug. Have you started coding at all? If you don't even know where to start then you need to do more research on the general concepts and come back here with more detailed questions later.

Kschuler 12-Aug-15 10:25am View

I agree with the others who are pointing out security issues. If you explain more about what you are trying to do, perhaps we can give a different suggestion. The only thing I can think of that can kinda of connect a web site and a PC program is to create a PC program and publish using ClickOnce. There is a way to pass URL parms that way. See info here:
https://www.google.com/webhp?sourceid=chrome-instant&rlz=1C1EODB_enUS581US581&ion=1&espv=2&ie=UTF-8#q=clickonce+pass+url+parameters

Kschuler 12-Aug-15 10:21am View

Try going through some tutorials regarding data access:
https://www.google.com/webhp?sourceid=chrome-instant&rlz=1C1EODB_enUS581US581&ion=1&espv=2&ie=UTF-8#q=php+data+access+tutorial

Kschuler 11-Aug-15 15:32pm View

Try starting here:
https://www.google.com/webhp?sourceid=chrome-instant&rlz=1C1EODB_enUS581US581&ion=1&espv=2&ie=UTF-8#q=c%23+crystal+report+tutorial

Kschuler 11-Aug-15 15:14pm View

Could you try asking a different way. Your question is a bit jumbled and confusing. How is your DataGridView loaded initially? Or doesn't it have data right away? Are you saving the data to a database? If so, why not pull from there and use for the crystal report? What code do you have so far?

Kschuler 10-Jun-15 8:41am View

I have no idea how to debug when you use the wizard, I'm not even sure that you can. My advice is to manually set the DataSource in the code.

Kschuler 9-Jun-15 17:16pm View

I thought .xsd files only show the layout of your data. It shows what tables and columns you want. I didn't think it stored actual data. So you are saying the data is attached in like a wizard or in design mode?

Kschuler 9-Jun-15 17:12pm View

I notice that you are only passing one table into the crystal report for the data source...does the report really only need the one table? Or should you be passing the entire dataset?

Kschuler 6-Mar-15 11:34am View

If the people posting solutions aren't posting what you are looking for, you should click Improve Question and add more information that specifies what you are trying to do.

Kschuler 13-Feb-15 15:49pm View

Do you also need the % wildcard character?

Kschuler 12-Feb-15 9:57am View

How would you do this if you had to track it with a paper and pencil? You'll need to store your ticket numbers and include a column that tracks if it's reserved or not, and possibly a code as to who has reserved it.

Kschuler 3-Feb-15 11:01am View

Ack..I figured it out! My module wasn't specified as being public. Thanks for helping me take a closer look! I assumed modules were public by nature.

Kschuler 3-Feb-15 10:58am View

I updated my question to make it a bit more clear.

Kschuler 3-Feb-15 10:52am View

Public

Kschuler 20-Jan-15 16:47pm View

Where is your server side code being called from? The button's click event? Can you provide us with more information on what GetUserName.deleteUser does? What do you mean when you say it doesn't work? Does it error out? If so, what is the error message and where do you get it? Or does it just not delete the record you want it to?

Kschuler 7-Jan-15 16:06pm View

The logic you've posted is a bit confusing. Could you include a few examples of data and how you would want them to calculate?

Kschuler 7-Jan-15 10:18am View

A patch? A patch for what?

Kschuler 7-Jan-15 10:17am View

If you're getting duplicate data than check if your JOINs are correct. Perhaps you are missing a connection? You have a lot of case statements and are grouping by a whole lot of fields. Maybe it would be easier to pass in multiple tables to your crystal report and have the report handle how they connect?

Kschuler 7-Jan-15 10:07am View

Could you provide a specific example and explain when and why and how you are moving the label? Your situation is not clear. What code are you using to move it. The code you have now is just some IF statements that don't actually execute anything.

Kschuler 6-Jan-15 9:11am View

I agree with Nathan. You can't enforce the requirement with out tracking the date and time of the checkin/checkout. But we're not going to do your work for you. Update your question with the code that you tried previously with the date/time stamps and we can help you fix it.

Kschuler 2-Jan-15 15:37pm View

What do you mean when you say "I have selected 2 separate folders, one for Publish and another for install." ?? What screen are you setting these on?

Kschuler 2-Jan-15 15:24pm View

Looks like it's expecting a date-time object but is getting something else instead. Perhaps break up the If Statement. It might be doing the ISNULL check and then also doing the <> 4 check and erroring out because it can't compare null to 4? Otherwise, what data type is Command.Duty-Start? And what is DefaultAttribute? Are they compatible data types?

Kschuler 2-Jan-15 15:17pm View

Perhaps more information would help you get more suggestions. For instance, you just say "send data". Are you talking about a chat application? Or databases interacting? Or what?

Kschuler 23-Dec-14 10:34am View

Try adding the row to the DataSet that the grid is bound to instead of the grid itself.

Kschuler 15-Dec-14 11:25am View

Are you sure that there are at least 4 rows in the grid? Or wait...I mean 4 Columns...Looks like the syntax is DataGridView.Item(columnIndex, rowIndex)
http://msdn.microsoft.com/en-us/library/ms158656(v=vs.110).aspx

Kschuler 12-Dec-14 8:41am View

Is other data from the database appearing properly?

Kschuler 11-Dec-14 14:23pm View

So how are you connecting to the database? Is there other data that IS displaying from the database? I'm wondering if your connection to the database isn't work at all, or if it really is just the images. That could help narrow down the problem.

Kschuler 10-Dec-14 15:35pm View

More details would help us. Is this a web site? Or a PC Project? Or what? Also, how are you connecting the images inside your crystal reports?

Kschuler 2-Dec-14 12:07pm View

What is the 198.70? Is that hours and fractions of hours? I don't understand how you could take a value of 198.70 and it should convert to 199.10. Could you walk us through your reasoning?

Kschuler 7-Nov-14 14:54pm View

In your phase angle example, you end the second javascript statement with % 360. I don't know what that is supposed to do, but I don't see anything in the converted code that does anything with it. Is that what you are missing?

Kschuler 7-Nov-14 14:46pm View

How many parameters does the report have? Are you setting all of them? Try debugging and walking through the code to make sure.

Kschuler 7-Nov-14 9:47am View

Can you provide more context? Could you show us your DLL code? Have you debugged into your DLL to make sure it's really hitting the code that connects with the google API?

Kschuler 30-Oct-14 12:30pm View

I updated my solution with another thing to try.

Kschuler 30-Oct-14 11:36am View

window.open is the javascript funtion. The second parm is the name that you would give the window. Instead of 'PrintMe' try setting them both to '_Blank'

Kschuler 30-Oct-14 11:33am View

Which viewer IS showing?

Kschuler 30-Oct-14 10:52am View

First of all...What's with your else if?...you are doing the same check in the IF as you are in the ELSE IF? Basically you need to call the window.open for both of them, but you probably just need to give them different window names. Otherwise it's probably opening the first report in a window, then opening the second report over it. And I don't think you need that IF statement at all. It might not be running the second code. I've never tried something like that.

Kschuler 30-Oct-14 10:24am View

I'm curious about this ![] notation that you use. I couldn't find any documentation on it. Is that just to access a column/cell in the datarow? And this statement: Kontainer = Kontainer + rd3![NoCont] + vbCrLf The NoCont variable appears to be set to an empty string, so could that be the problem?

Kschuler 30-Oct-14 10:17am View

It depends. Are these CR Viewers supposed to be displaying different reports? If so, how are they different? Is it a different webpage that you open up? Or do both use ReportFormFTE.aspx? And if they both use the same webpage, then how do you distinguish which report should display?

Kschuler 20-Oct-14 15:48pm View

Without more info, it's hard to help. What error messages are you getting? What exactly isn't working properly?

Kschuler 20-Oct-14 15:42pm View

Have you setup the proper links in the design of your crystal report? Open the database expert and view the links tab.

Kschuler 2-Oct-14 16:51pm View

I think the OP is asking how to make a report that is two pages of details. The first page would have the data for columns 1-100, the second page would have data for columns 101-200. So if only one record was printing, it would still print two pages. I think it's a legit question. And even if it's messy, coders rarely have a say in what the users ask for. If there is no alternative, it has to be done this way.

Kschuler 2-Oct-14 16:37pm View

Why don't you take a stab at stepping through the problem one more time. You have a DataGridView and you don't talk about it all in your walk through of the problem. Do you have a combobox and then a grid that has many comboboxes? Why is it looping the grid? This method is called for a combobox named cboTOL1...is it called for the comboboxes in the grid as well?

Kschuler 2-Oct-14 16:27pm View

What error message are you getting?

Kschuler 2-Oct-14 16:18pm View

If all instances use the same program you'll have to do some research and think about how you want to handle database conflicts. For example, if one user opens a screen and load some data the same time as someone else. Then user 1 updates the data. Then user 2 tries to update the data. Good luck with your project.

Kschuler 1-Oct-14 14:16pm View

How are you deploying your project? ClickOnce? A Setup Project? Or just copying the exe? Setting up the db as a datasource in the project is nice for some people, but I prefer to manually do that stuff in code rather than in a wizard. It's easier to keep track of how it's being setup and where exactly the database is located. Are you trying to make a program where all instances of the program use the same database in some shared network location? Or does each install need it's own database?

Kschuler 1-Oct-14 11:17am View

Can you post your code? Have you tried putting a try catch around it so you can get a more detailed error message?

Kschuler 1-Oct-14 10:46am View

Are some of your machines 32 bit and some 64 bit? What operating systems are they running? And are you installing the REDISTRIBUTABLE for crystal reports? Or the actual Crystal Reports for Visual Studio 2010....are you installing Visual Studio on those machines?

Kschuler 29-Sep-14 14:57pm View

So what's the ;1 mean?

Kschuler 25-Sep-14 15:05pm View

If it were me...I'd give every conversation an Message ID, and use THAT to pull the data. That way you'd get both the FROM and the TOs.

Kschuler 25-Sep-14 14:08pm View

So....what's your SELECT statement? "My Query" isn't going to pull anything.

Kschuler 25-Sep-14 14:07pm View

search for the keyword "BLOB" which stands for Binary Large Object something or other.

Kschuler 25-Sep-14 11:56am View

Post your code for how you attach the data to the grid.

Kschuler 24-Sep-14 13:57pm View

Can you post the code that is blowing up?

Kschuler 24-Sep-14 13:55pm View

Could you please explain what you are doing and what you want it to do? What is sp_cr_getSubsequentVisitBySubVisitId ?

Kschuler 24-Sep-14 8:31am View

Yikes. Well I second what George Jonsson said. You'll want to research regular expressions. Good luck!

Kschuler 23-Sep-14 13:46pm View

The value in the Status column is a delimited string with all kinds of level and rank information? Why don't you have separate columns for Level and Rank?

Kschuler 8-Sep-14 16:58pm View

Does the information HAVE to pass via the USB cable? Or can you use a web service?

Kschuler 5-Sep-14 14:39pm View

Without specifics, we can't really help you much. Can you post the code that you've got so far? Click the Improve Question link to add more specific information to your question.

Kschuler 2-Sep-14 8:37am View

If you are really compiling to x86, then you need to install the 32 bit Crystal Reports Runtime, even on 64 bit machines.

Kschuler 2-Sep-14 8:36am View

x86 means 32 bit. x64 means 64 bit. So which are you compiling to?

Kschuler 28-Aug-14 10:59am View

Is your program compiled to 64 bit, 32 bit, or any CPU?

Kschuler 27-Aug-14 17:04pm View

You haven't asked a question. Which part are you having trouble with? We need more details in order to help you. We don't know anything about your project or your requirements, so it's hard to even give general advice.

Kschuler 27-Aug-14 11:14am View

What is ExplorerBrowser? Do you mean an OpenFileDialog control?

Kschuler 26-Aug-14 15:21pm View

Research Custom Controls and the RichTextBox control.

Kschuler 25-Aug-14 17:03pm View

Where are you putting this formula? Is this data all in table? Or is it pulling from several? If several, have you setup your database links in the Database Expert?

Kschuler 25-Aug-14 9:26am View

Are you wanting to copy files on the server or client side?

Kschuler 19-Aug-14 9:39am View

I've never done anything with injecting a DLL into another process, so I can't really help you. But you should click the Improve question link and add this information to your original question. It's much clearer with this information. And you'll be much more likely to get a response from someone who actually knows about these things. Good luck.

Kschuler 19-Aug-14 9:34am View

Call the code from where? The program that injected it? Or are you trying to get the program that you've injected the dll into to call it? Maybe you could just explain a bit more about what you are trying to do...because it sounds a bit shady.

Kschuler 19-Aug-14 9:26am View

What do you mean by "injects it into a process."? What exactly are you trying to do?

Kschuler 18-Aug-14 17:30pm View

Which line of code causes the error? And did you try googling the error message?

https://www.google.com/search?q=Unable+to+read+data+transport+layer+error+c&rlz=1C1EODB_enUS581US581&oq=Unable+to+read+data+transport+layer+error+c&aqs=chrome..69i57&sourceid=chrome&es_sm=122&ie=UTF-8

Kschuler 14-Aug-14 9:20am View

http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.menuitemcollection.remove(v=vs.110).aspx

Kschuler 14-Aug-14 9:14am View

Search the internet all you want, but you're never going to find EXACTLY what you are looking for so that you can copy it and paste it into your project. You need to read the article and learn what they are doing and then modify them to your own needs. We can help you with a specific question but this sounds like you want us to do your work for you. What have you done so far and where are you stuck?

Kschuler 14-Aug-14 9:10am View

Can you give us a sample of your data? Perhaps your data has a lower case "d" instead of a capital "D"?

Kschuler 12-Aug-14 15:46pm View

If you wanted it to be the DropDownList...look into the .SelectedValue or .SelectedItem of the combobox instead of the .Text. (Which one you use depends on how you loaded the data in the first place.)

Kschuler 7-Aug-14 8:25am View

It should be very similar code. Start trying things and see what works. A lot of programming is trial and error.

Kschuler 6-Aug-14 14:22pm View

What exactly is your project supposed to do? Is it a Windows Forms project? Are users supposed to share a single database or are they supposed to have one of their own on each machine the program is installed in? You need to give us more information. And also...what have you tried? If you tried the above and tested it and it works...then what's the problem?

Kschuler 6-Aug-14 14:04pm View

What are the exact error messages that you are seeing? We can't help with just general possible errors. There could be many things that cause them and we know nothing about your project.

Kschuler 5-Aug-14 14:07pm View

You want to print the report without click the print button? So when exactly is it supposed to print? What code are you currently using to print it?

Kschuler 5-Aug-14 14:05pm View

You might want to include the code for LengthenSnake(). Click the Improve question link and add it to your question.

Kschuler 17-Jul-14 9:32am View

It's good that you are researching before starting, but you are asking very general questions for a multitude of things. It's hard for anyone to recommend anything without more knowledge of your project. I suggest you take one feature at a time, research it on the web, then when you are more knowledgeable about your options you could post questions here like "why is this way better than that way" or "if i'm concerned about speed/quality/ease of use which way is better"...that kind of thing. Hope this helps. Good luck!

Kschuler 17-Jul-14 9:27am View

From what I understand, which isn't much, it's very difficult because each printer has different capabilities and there isn't a standard (that I know of) for how those settings are stored. You might have to look into something hardware specific.

Kschuler 20-Jun-14 11:40am View

What if the report is supposed to have a header? This may help him find the cause but it isn't a solution.

Kschuler 20-Jun-14 11:37am View

Please post only relevant code. And try to break it up and give more explanation about what each piece of code does and how/why it isn't working. And remove commented out stuff unless it's comments that help us understand. If you don't help us understand your code, we can only see what it does, not what you want it to do. And if there is a lot of code, you're asking for a large dedication of someone's time. You'll get more responses if you put more into your question.

Kschuler 18-Jun-14 9:49am View

Your question is unclear. Please explain more about what you are trying to do and what you want it to look like. We may have a different idea of what "cascading dropdown" means. And are you asking for the drop down to include all items in the gridview? Or that each row in the gridview has a dropdown? We can't help without more information.

Kschuler 17-Jun-14 15:02pm View

To clarify. You are opening a Crystal Report in a Crystal Report Viewer. Then selecting data and copying. Then pasting into a text pad? Is that correct? What do the characters look like? Have you tried pasting into a different text editor program like Word, Word Pad, and notepad? What does the data are you selecting look like? Are you selecting data from multiple columns at the same time? Without more information it is hard to help.

Kschuler 12-Jun-14 9:38am View

Just because someone hasn't posted code doesn't mean they are putting No Effort into a solution. You forget what it's like to be a newbie and not even know where to start or what to search for. This website is to HELP people. If you can't be bothered to even try to help people who are under a certain level of experience then you are the one with No Effort.

Kschuler 11-Jun-14 15:21pm View

Can you post the code in your button click event?

Kschuler 11-Jun-14 15:19pm View

What have you tried? Can you Improve the Question and add your code?

Kschuler 10-Jun-14 10:04am View

These guys gave you the basic syntax. If you need the specific function that Access uses, then you should try googling it. I found this link which may help.
http://www.techonthenet.com/access/functions/date/format.php

Kschuler 4-Jun-14 9:04am View

Is it giving you an error message? Or just still popping up the logon prompt?

Kschuler 2-Jun-14 12:36pm View

Your request seems very odd. Why 102? Are you ALWAYS going to get 407 images? What happens if you get more than can fit in the 4 strings? Perhaps if you explained further we could point you to an easier way to do it. Otherwise, just think how you would accomplish this if you were doing it by hand. You'd setup a counter and when you got to 103 you'd start using the other string variable. Or you could use the Mod or Math.IEEERemainder to find if the counter is divisible by 102 as your indicator. There are lots of ways to do it, it's just hard to make suggestions when we don't have more information.

Kschuler 28-May-14 15:45pm View

You could do it either way.

Kschuler 14-May-14 15:41pm View

That is a statement? What is your question? What do you mean by "access control"?

Kschuler 9-May-14 15:32pm View

Does the user that you are impersonating have the appropriate rights to whatever you're trying to access?

Kschuler 9-May-14 11:29am View

If your app requires those components....then they have to be installed. You can use the Crystal Reports redistributable so it's not a full version of Crystal Reports but if your user needs the .Net framework....then they need the .Net framework. They can either install it via Windows Updates or you can include the Prerequisites so that it will prompt to install before your app does as described above.

Kschuler 9-May-14 11:26am View

You cannot install the .Net framework by just including some DLLs in your app. And I'm not sure if you CAN for Crystal Reports, but if you can it's not recommended. They have redistributable packages for just this purpose.

Kschuler 9-May-14 11:24am View

If they are already installed on the machine that you are trying to install your app on, then they will NOT require you to install them again. That will be handled for you.

Kschuler 9-May-14 11:09am View

If you are using ClickOnce and you follow my solution, it will all be installed at once. I believe that it will still have to popup a special box with the terms of agreement for the .Net framework, etc which the user will have to click Agree on. But the components will install together with your app.

Kschuler 9-May-14 10:55am View

You may want to research regular expressions. I think that's going to be your best bet.

Kschuler 8-May-14 13:58pm View

Can you post the basic layout and perhaps sample data of your tables. Then show us the SQL statement that you are currently using to pull the data. Without this information we can only give you general advice.

Kschuler 2-May-14 9:13am View

Yes, but are you moving the cloned rows into a new grid? Or just to the bottom of the existing grid?

Kschuler 1-May-14 16:12pm View

I think OP only has one datagrid.

Kschuler 1-May-14 16:09pm View

Which line are you getting the error on?

Kschuler 29-Apr-14 17:27pm View

Where are you placing this code? In an event? In a method/function? I'd guess that whatever it's container is, you're calling it three times. Or else you have three rows which all have the same name.

Kschuler 25-Apr-14 14:06pm View

I have no idea what student details project is. If you really want help you need to explain further. We have no background knowledge of your project or your setup or anything. What code do you have so far? How is it failing to work? Are you getting any error messages and if so, what are they?

Kschuler 25-Apr-14 13:50pm View

Click the Improve question link and you can edit your original question.

Kschuler 25-Apr-14 13:50pm View

Particular column of what? What kind of project are you working on? What have you tried so far?

Kschuler 24-Apr-14 16:41pm View

Are you getting an error message? If so, what is it?

Kschuler 24-Apr-14 10:59am View

Did you try reading any of these?
https://www.google.com/search?q=The+OLE+DB+provider+%22Microsoft.ACE.OLEDB.12.0%22+has+not+been+registered&rlz=1C1EODB_enUS581US581&oq=The+OLE+DB+provider+%22Microsoft.ACE.OLEDB.12.0%22+has+not+been+registered&aqs=chrome..69i57&sourceid=chrome&es_sm=122&ie=UTF-8

Kschuler 23-Apr-14 10:15am View

The keyword that you are looking for here is BLOB which stands for Binary Large Object. If you google for how to use a BLOB you may find more help and/or tutorials.

Kschuler 22-Apr-14 16:17pm View

What have you tried?

Kschuler 21-Apr-14 15:44pm View

Have you googled it?:
https://www.google.com/search?q=crystal+reports+totals+from+subreports&rlz=1C1EODB_enUS581US581&oq=crystal+reports+totals+from+subreports&aqs=chrome..69i57j0l5.10256j0j8&sourceid=chrome&es_sm=122&ie=UTF-8

Kschuler 21-Apr-14 15:42pm View

Are you just including the DLLs in your setup? Or are you installing the run time? You may want to check this out: http://wiki.scn.sap.com/wiki/display/BOBJ/Deploying+Crystal+Reports+for+Visual+Studio+2010+Runtime

Kschuler 18-Apr-14 17:21pm View

Why the many to many relationship? That means you MUST have a student in order to have a Subject exist in your system. I think you should have 3 tables. Student, Subject, and StudentSubject. The Student file would just have Student ID. The Subject file would just have Subject ID. The StudentSubject file would have Student ID and Subject ID. This allows lists of Students and lists of Subjects to be edited independently.

Kschuler 18-Apr-14 17:15pm View

If your report doesn't error out but isn't showing what you expect it to, I'd start with making sure it's setup properly. Is everything properly linked in the Database Expert of your Crystal Report? Are you doing anything special in the report like sub reports or graphs or anything?

Kschuler 10-Apr-14 9:37am View

Can you please explain more. You set a second parameter the same way you would set the first. What do you mean that it depends on the first parameter? That you may not have a second? Or that the value of it may change based on the first?

Kschuler 8-Apr-14 15:04pm View

It would also depend on how you calculate "overtime". If I normally work 9AM to 6PM and one day I work from 9 AM until 2AM the next day, but the rest of the week I work only from 9AM until noon...that ONE day did I work overtime? Or is it calculated by how many hours are worked in the week? And then how would you calculate it if someone worked more than 24 hours straight? You would still mark all of those hours down on the day they timed in? And then have a day where there are no hours marked even if they were there?

Kschuler 2-Apr-14 17:25pm View

Is your development machine 32 bit or 64 bit? And what is the machine you are trying to install on?

Kschuler 4-Feb-14 13:51pm View

It looks like you're hitting a web page, not a report file. Are you trying to kick of code to generate a report first or something? What exactly are you trying to retrieve?

Kschuler 28-Jan-14 13:55pm View

You need to explain more about what you are doing. What is currently in your grid and what even occurs that makes the row or rows move to the next form? How are you loading data into your grid, etc. We can't help without more context.

Kschuler 22-Jan-14 15:06pm View

options for what?

Kschuler 30-Dec-13 15:22pm View

Is there anything more to the error statment other than "Syntax error in INSERT INTO statement."? Are you able to view the insert statment that the command builder creates while debugging? If so, what is it?

Kschuler 27-Nov-13 15:24pm View

If I put a DataGridView on a form, setup a textbox column and then a comobox column, then run my app, type in the first cell, then hit tab...it moves focus to the combobox column. Is yours not doing that? If it isn't, then could you provide any settings that you've put on the DataGridView? Maybe one of them has changed the way it functions? Otherwise, please be more specific and walk us through your problem.

Kschuler 6-Nov-13 15:12pm View

You need to reply to his solution, he won't get notification of this message otherwise.

Kschuler 4-Nov-13 17:11pm View

What kind of project is this? Win forms? Web? (Please click the Improve question and add tags to your question to specify this) What is a UserType_CMBbox? And you really should look into using parameters instead of directly concatting values into your SQL statement.

Kschuler 4-Nov-13 15:13pm View

What line does the error occur on? When you are debugging, which variable has "nothing" as it's value?

Kschuler 30-Oct-13 17:13pm View

It's possible to do this with some DBs...just not good practice. If you separate the file names with a comma in the FROM I believe it assumes an inner join. You'll need to put the conditions that would have gone in the "ON" in the WHERE clause instead. It's a much better practice to specifically state the JOIN. The code will be much easier to understand and easier to maintain and/or change or later.

Kschuler 30-Oct-13 9:53am View

I updated my solution.

Kschuler 30-Oct-13 9:14am View

So you solved it or got around it? Maybe just change the title to say it's been solved so others know.

Kschuler 29-Oct-13 17:03pm View

What do you mean complaining about? If it's a warning, just ignore it. If it's stopping you from compiling then is there any way you can change the file extension?

Kschuler 29-Oct-13 13:40pm View

Ha. I knew I was missing something.

Kschuler 29-Oct-13 10:07am View

Why not have your game process check periodically if the security one is running, and shut down if it is not?

Kschuler 21-Oct-13 10:45am View

Your questions isn't very clear. Please click the Improve Question link and add the code that you are having trouble with so that we can better help you.

Kschuler 18-Oct-13 13:49pm View

What is your question? Can you explain more? Tell us what the code is currently doing and what you WANT it to do. Tell us if you are getting an error message and what the exact error message is.

Kschuler 15-Oct-13 9:35am View

What type of project are you working with? Windows forms? Web site? Can you add tags to your question to specify that, please?

Kschuler 15-Oct-13 9:31am View

Do you just want the count of how many rows are pulled back from the join? If so, just add COUNT(*) to the SELECT.

Kschuler 10-Oct-13 11:51am View

You're using the word "Form" which made me think this was a Windows Forms issue, but it looks like it's really an asp.net issue. You should add that to the tags in the question.

Kschuler 8-Oct-13 13:57pm View

Is the actual image in the database, in a blob field? Or is it just a string of the path it's located in? If the image is IN the database, you should research blobs (Binary Large Objects) If not, then just use System.IO classes to open and/or work with the image files.

Kschuler 7-Oct-13 12:14pm View

Could you specify more about how you setup this ClickOnce Deployment? Generally you wouldn't activate a .exe file with ClickOnce. Instead you have an application reference. And most of the application files are burried in wierd temporary files under your windows's user name. So how did you use ClickOnce?

Kschuler 7-Oct-13 9:47am View

Is your sql actually pulling back any data? Can you see it when you debug?

Kschuler 4-Oct-13 9:44am View

You keep saying "should"...what we need want to know is did you debug it and see that this is actually happening by QuickWatching the variables? Also, what is the exact error message that you are getting?

Kschuler 3-Oct-13 12:22pm View

As for syntax...I googled and found this: http://stackoverflow.com/questions/12270816/datetime-format-issue-in-vb-net-with-ms-access-database-when-using-sql-statement

Kschuler 3-Oct-13 12:20pm View

If you are not getting any data from the access database then it's your SQL statement that needs fixing, not the Crystal report. You likely do not have the date formatted in a way that access recognizes. You can google to find out the syntax that is needed, or if you look at the link in the solution thatraja posted, there is a sample that uses parms instead. Parms are nice because it knows when things are strings/numeric/dates, etc. And they help avoid sql injection attacks.

Kschuler 3-Oct-13 11:26am View

If the first five digits are not editable by the user, then why don't you put those in a label right next to the textbox. That way the user can always just edit the textbox and not those first five digits. Later if you need them all put together you can concat them.

Kschuler 3-Oct-13 11:21am View

It may be helpful if you could give us the exact error message.

Kschuler 3-Oct-13 11:03am View

I'm not sure you can and not sure why you'd want to. It's possible that other programs would want to use the crystal run time. If the user already had it installed, you don't need them to install it AGAIN when they install your app. Plus who knows what would happen to the registry if you had your version of crystal and the user had the regular version because of some other program....it could get very messy. Why are you wanting this?

Kschuler 2-Oct-13 15:24pm View

Can you explain this more? I don't understand what you are asking. It would help to have more information about what you are trying to do and why.

Kschuler 2-Oct-13 15:21pm View

What do you mean not working? Have you debugged? What is in the Dt? Is it not pulling back any data? What data type is the FeesMonth column? We need more information to help.

Kschuler 2-Oct-13 15:18pm View

What exactly do you mean by standardized form of image? Without specifics, I don't know if anyone will really be able to help you.

Kschuler 2-Oct-13 9:33am View

If I were doing this, I think I'd have one table that contains the student name and the group number. A second table would contain the student name and ONE preference. That table would contain multiple records for each student. That way you can more easily lookup how man preferences a student has, or how many times a student was preferred.

Kschuler 1-Oct-13 15:55pm View

Do you have the exact error message? If so, please post it.

Kschuler 1-Oct-13 15:54pm View

Is this a website or a window form application or what? Please add tags.

Kschuler 1-Oct-13 15:45pm View

does the group table contain anything other than the group id? If not, then why do you even have it?

Kschuler 1-Oct-13 12:34pm View

I still am not sure what you are trying to do. So you mean that if student A prefers B,C,D, and E...you will make that a group, even if Students B,C,D, and E don't prefer each other? Yikes. As for the minimum...How would you do that if you were doing it by hand? Just add more students to the group (who don't currently have a group) until it's met the minimum. Without seeing the code you have, it's hard to be more specific than that.

Kschuler 1-Oct-13 12:30pm View

What do you mean by "if any students have entered 4 preferences"? How can they enter 4 preferences if you only have columns for 3? ----Edit --- Okay...I see the comment now that there are actually 7 preference columns....ha. That's what was confusing me.

Kschuler 1-Oct-13 11:55am View

With problems like this I think the best way to tackle it is to think about how you would accomplish this if you were doing it manually with paper and pencil. We don't know exactly what kind of rules you want to put into place, for example, if two students both pick each other does that take precedence over one student picking a student who didn't pick them back? In general, I would recommend that you setup the groups in an in-memory DataTable and only when you are done organizing the groups would you write stuff back to the database. If your groups can have 5 to 8 students in them, then how can you be sure how many groups you will actually end up with?

Kschuler 20-Sep-13 9:35am View

Which statement is erroring, the one before or after your comment about the error? And what is the exact error message?

Kschuler 19-Sep-13 16:07pm View

Saying "Code not working" is not going to get you any answers. We don't know HOW it is supposed to work and we don't know why it isn't working right now. Please tell us what you mean by not working. Are you getting an error? If so, what is the exact error message and which line of code is blowing up? If you are not getting an error, please tell us what your code is currently doing and then explain what you want it to do.

Kschuler 28-Aug-13 8:44am View

The new machine doesn't need visual studio, but it DOES need the crystal report runtime. You can manually install it or you can create a setup project and make it a prerequisite so that it will always install before your exe installs. See this link for info: http://wiki.sdn.sap.com/wiki/display/BOBJ/Deploying+Crystal+Reports+for+Visual+Studio+2010+Runtime

Kschuler 26-Aug-13 17:21pm View

How are you installing the program on another computer? Do you use ClickOnce or have a setup project or third-party installer? Or are you just copying the exe and pasting it on another machine? The error message says it "Cannot find the file specified." so it is likely unable to find the .rpt file. Where are you saving this file? How are you referencing the path it in your code? Perhaps that path does not exist on the second machine?

Kschuler 26-Aug-13 17:14pm View

A primary key is a unique identifier for each row in a table. For example, if your data table had a list of people in it, you could possibly have a social security number as your unique identifier. This is how the data base knows which lines to update with which information. Otherwise it doesn't know which record(s) to update. Typically it will want to update JUST the records that changed, not the entire database. That wouldn't be effiecient. Sorry but I'm not sure how you specify it in this particular scenario. I have never used excel as a datasource. But you could try googling for some examples to learn from. I found this article there: http://support.microsoft.com/kb/316934

Kschuler 8-Aug-13 15:30pm View

Your question isn't clear. It's hard to understand. But if you are trying to make your code run as soon as the program starts, the you would want to put it in the form's load event instead of a button's click event. And it sounds like what you want could actually be done with an SQL statement...why are you putting data into several textboxes and then immediately merging them into another textbox? If you provide more information about your database and table structure we might be able to show you a quicker way to accomplish your task.

Kschuler 8-Aug-13 14:44pm View

Do you WANT the grid to reload when it comes back from the other form? If so, you could try setting the DataGridView's DataSource property = Nothing before reloading it.

Any other suggestions we could give really depend on your code. Please click the Improve question link and paste your code in the original question so that we can see what you are doing and better advise you.

Other relevant information would be helpful too, such as are ALL of your columns in the grid put there via data binding? Or do you have some columns pre-defined from design mode? And if so, what kind of column is the id column?

And when you say you've tried everything to clear the columns....well what have you tried? We need to know so that we don't suggest that method to you again.

Kschuler 1-Aug-13 12:27pm View

It's a lot easier for us to help when we can see the code formatted. Next time, instead of posting extra information in the comments, please click the Improve Question link and post your code in the original question. I think you'll get more help that way.

Kschuler 1-Aug-13 12:23pm View

Is it trying to install the 32 bit version of .net 3.5 on the 64 bit machine? Are you compiling specifically for a 32 bit machine because you have an access database or something? It's hard to help without more information. What other prereqs do you have and are those installing properly?

Kschuler 31-Jul-13 17:33pm View

Yes. You've told the OP that his code is crap. But you didn't tell him how to actually fix his problem and get the result he's looking for. Ledtech3's comment is productive.

Kschuler 31-Jul-13 16:55pm View

Good call. You should post this as a solution.

Kschuler 31-Jul-13 14:00pm View

I think your problem is that you're trying to think of everything at once. Don't do that. Break the problem up into smaller bites or you will choke. First design your database in the way that makes the most sense. If I were you, I'd combine two of the tables. Instead of an IN and an OUT (which have virtually the same columns) I would have one table and just have a column in it that contains the value IN or OUT. Once you've got your database set, then work on each query that you need to do in your vb.net program one at a time. When you're stuck on how to get the query to work, post a question here on CodeProject with the query that you are using and details about what you want it to pull and why it's not working.

Kschuler 31-Jul-13 12:17pm View

Can you supply more information? The code you have there is nice, but we dont' know what emp is....we dont' know what your functions do....this looks like it's setting some text boxes...is that what it is supposed to do? Or were you trying to update a database?

Kschuler 31-Jul-13 12:14pm View

What does "...list of all products order that is enter first time in day." mean? You want a list of all productions? Or all productions that were ordered on a certain day? Or all products that were the first to be ordered on a day? Or what? And also what do your tables look like?

Kschuler 30-Jul-13 16:23pm View

It's really hard to understand what you are trying to do...but I get the impression that maybe you need to look into groups.

Kschuler 23-Jul-13 17:10pm View

Do you always have the same number of radio buttons, or at least a maximum number that you are using? If so, then simply put that many radio buttons on your form. You can access them very easily by name. If the number of buttons varies, and you have a maximum...you know you will never have more than five, for example....then put five on the screen and hide the ones you don't use for a given question. (I assume the radio buttons are used for multiple choice answers?)

Kschuler 23-Jul-13 10:55am View

This isn't really a question, it sounds a lot more like you're asking someone else to convert a web app into a desktop one for you. Instead of asking for general help, try to narrow it down. You said you tried but got stuck. What did you get stuck on? Give us that code and tell us why it didn't work or what error messages you got. Also, some of us haven't read any other questions you've posted...so instead of referencing them, give us the necessary details from it. For instance, if we knew more about why and how you were using the radio button list on your web project, perhaps we could suggest a windows forms control that would work best for you.

Kschuler 23-Jul-13 10:44am View

Your question is a bit confusing. I think some of the problem is just the wording you are using. There are objects called Tab Controls and they each contain a Tab Page. Are you really trying to add multiple tab controls? Or multiple tab pages? I'm also wondering if when you are using the word "form" if you are really referring to a tab page as well? Perhaps you should first start by researching the Tab Control class. Check out the MSDN link here (There are code examples if you scroll way down): http://msdn.microsoft.com/en-us/library/system.windows.forms.tabcontrol.aspx
Also, regarding the code above...I see that you have a method called MyTabs() which seems to be doing some stuff with tab controls, but I don't see anywhere that you are calling that method except in the method tab() which is not called anywhere else. The code won't run unless you call it from somewhere...or did you just not include that code?

Kschuler 19-Jul-13 12:12pm View

Are you building a program to do this? If so, a PC program or web? And what language? Or are you just using crystal reports stand alone?

Kschuler 19-Jul-13 10:42am View

Without more information, I'm not sure anyone can help you. Can you describe more about how you set up your report? Were you using more than one Detail section? What are your tables like and how have you linked them?

Kschuler 15-Jul-13 14:08pm View

I assume this is a windows forms project? Are you using ClickOnce to publish or are you using a setup project?

Kschuler 3-Jul-13 10:17am View

Please remember that we have no idea what your project is about and you need to explain in detail for us. What do you mean by "user want to select few banks by giving bank account number in text box(before checkedbox)". Do you mean that they will filter the list? Or that they are allowed to just enter any numbers? And what are you doing with these numbers? Saving them to a file? We need more information please.

Kschuler 3-Jul-13 10:13am View

I've never really used the parms that you are using with your .Fill statement. I'm wondering if the second parm, the string which you have as "gm862", could be the problem. That table doesn't exist in your DataSet until AFTER the fill is completed. Try removing that parm and see what happens. So you'd just have: dataadapt.Fill(datset)

Comments by Kschuler (Top 200 by date)