MJV

I think you would start by setting up a parameter field in crystal reports for your the date field in your table. Then you would have a date on your report where you would use the select expert (when you left click on the field this will be an option) …

I have a datepicker on my form that I need to use as an integer value in the form yyyymmyy in an sql procedure. Can anyone tell me how to extract the datepicker value to an integer variable? Thanks

I have code that is giving me the following errors The best overloaded method match for 'EstimatorC.EstimatorDataSet.QuoteCalcHeaderDataTable.this[int]' has some invalid arguments E:\VisualStudioProjects\EstimatorC\EstimatorC\Estimate.cs 1653 13 EstimatorCArgument '1': cannot convert from 'string' to 'int' E:\VisualStudioProjects\EstimatorC\EstimatorC\Estimate.cs 1653 46 EstimatorC Code: private void findBN_Click(object sender, EventArgs e) { string aFilter = ""; ////Search name …

I have the following error: Argument '1': cannot convert from 'string' to 'int' E:\VisualStudioProjects\EstimatorC\EstimatorC\Estimate.cs 1653 46 EstimatorC Any help is appreciated. Note estimateno is an integer in the table QuoteCalcHeader. with this code: private void findBN_Click(object sender, EventArgs e) { string aFilter = ""; ////Search name starts with aFilter = …

I have searched everywhere but im not able to determine if you can show two or more data fields in a combo box. If so can anyone help me with the code to do so as I am stumped. Thanks in advance.

I have a c# program that uses crystal reports to print a quote. When I run the code off the internet site it does not bring up the database name in the logon screen of crystal reports nor does it allow me to enter this. When I run the program …

Is there a way to have a multiple field combo box using Microsoft Visual Studio with C#

I have a program that has several forms that uses the same sql data table through the same data source and dataadapter tables. Is this ok if more than one form is being used at the same time which references the same data adapter table.

[QUOTE=MukeshZ;510179]Hi I am facing logon Failed problem in VB.Net Crystal Reports after i deployed it at client side... A window showing Database name, user name, Server and password I fill it manually still it fails... Can any one help me to sort out this solution... Thanks :)[/QUOTE] Did you ever …

I have the following code that executes an sql stored procedure and I pass a customer name and customer contact to the procedure to use to create a new record in a table. When I execute the stored procedure in sql it inputs the customer and contact in the new …

Im working on a project that involves attaching attaching the results of a crystal report to an oultlook email and forwarding it. Can anyone point me in the right direction on knowledge to perform this.

I would like to create assign a value from a combo box selection to a variable. I'm not sure how to do this as im new to programming. I know how to trigger the assigment of the variable from the combo box when the combo box changes but Im not …

I have a form with combo boxes and calculations based on the value of the combo box. I set a default value in the combo box on loading the form but this value is not seen for calculations unless i go and reselect it with a mouse pick. What is …

I have a form with datepicker. This datepicker comes up with the current date automatically so is not usually selected by the user. Unfortunately because the field is not selected it is not validated and the attached table is not updated with the date. Im struggling with code to validate …

I have a stored procedure which returns a parameter @quotenum when run in sql but I'm having trouble getting a return value in my C# form. I'm trying to get the message box to show the @quoteno parameter but im failing misserably. The connection is working an the parameter @estnum …

I have created and tested a stored procedure that works in sql. This stored procedure has one parameter that it requires to run "quoteno" . I already have the database attached to the form. Can anyone help me with the code for this. The name of my stored procedure is …

I have a solutin with forms that use table adapters to input data into sql tables and that all works fine. My trouble comes when I have another form that uses a sql stored procedure. When I try to connect to the server I get an error that the login …

How can I stop this error, here is my code and there error occurs where i have decimal.TryParse(.... class EstCalc { static void Variables (string[] args) { decimal bl; //blank length decimal bw; //blank width decimal bp; //blank perifery decimal pd; //part depth decimal dq; //die quantity decimal.TryParse(quantityTB.Text, out dq); …

I have a case statement that evaluates a string in a combo box on a form which is either English or Metric. What I'm finding is that the case statement does not see the pull down box contents which is loaded by default unless it is physically reselected by the …

I have a quote program I have made and i'm looking for a way to lock the records once it has been approved. I have a form that is filled out and a calculation that is done based on the fields that are linked to an sql table. What method …

I have some code that checks a value in a combo box before it executes but it does not appear to be seeing the value selected in the combo box until I select the item in the combo box for a second time. Note the value in the combo box …

What would be the most efficient way to check that a series of text boxes are completed prior to allowing the execution of code since executing the code without values being completed errors out the program.

If I have code that is executed by a button statement and I would like this code to be executed at different times from other actions can I use a goto stateent to execute it? If so how. I can't seem to find a correct way or method to label …

Im getting an "unknown selection" error on this code. Can anyone help me. I don't know what is wrong. My two text boxes both have English selected. blankl and blanlkw have both been initialized as decimals. if (bunitsCB.Text == "English") { switch (dieunitsCB.Text) { case "English": dielTB.Text = Convert.ToString(blankl + …

When i write case statements my last line is always: default: throw new Exception("Unknown selection"); how can I change this so a message comes up for the user to do something with the data he or she inputted so the default will not occur.

I need to create a table that will display different variables. Is there a canned table control I could use.

Im trying to assign a decimal value of 1 to a variable if a check box is checked but I having trouble getting it to work. Here is my code: decimal nitrodsgn; decimal lnitro; decimal unitro; if (nitrogenLowerCheckBox.Checked) lnitro = 1; if (nitrogenUpperCheckBox.Checked) unitro = 1; nitrodsgn = (lnitro + …

I have a form that has a table adapter for a table called costing. Im not using any of the items in this table in any textboxes etc.. on the form but I would like to use them in calculations that will give results to put in text boxes on …

I have a text box designTB and a double variable totaldsgn. I cannot create the following equation because the designTB is a string and totaldsgn is a double designTB.Text = totaldsgn I have tried this and it still does not work designTB.Text = totaldsgn.tostring Any suggestions? Is there a way …

Im new to C# and having trouble with this code: I have a combo box on a form optypeCB and when a particular type is picked(Draw,Form,Pierce,Trim) I would like a numerical value assigned to a text box designhrsTB. My code is as follows but it does not work can anyone …

I have 3 text boxes 1TB,2TB and 3TB. I would like to multiply 1TB by 2TB and put the answer in 3TB. Can anyone help me with this code. Im new to C# and I keep getting errors. Thanks in advance.

Hi im new to C# and I have a form with customer data on it. There is a combo box with the customer name and some address fields. When I select the customer name I would like the address field to be automatically updated from the customer table. Can anyone …