Comments by Member 10339067 (Top 37 by date)

i need to Pass multiple value as that department...

ParameterFieldDefinitions crParameterFieldDefinitions;
ParameterFieldDefinition crParameterFieldDefinition;
ParameterValues crParameterValues = new ParameterValues();
ParameterDiscreteValue crParameterDiscreteValue = new ParameterDiscreteValue();

crParameterDiscreteValue.Value = txtFromDate.Text;
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["FromDate"];
crParameterValues = crParameterFieldDefinition.CurrentValues;

crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);


crParameterDiscreteValue.Value = txtToDate.Text;
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["ToDate"];
crParameterValues = crParameterFieldDefinition.CurrentValues;

crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);

for (int i = 0; i < grid1.Rows.Count; i++)
{
if (Convert.ToInt32(grid1.Rows[i].Cells[0].Value) == 1)
{
crParameterDiscreteValue.Value = grid1.Rows[i].Cells["DepartmentName"].Value.ToString();
}
}
crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields;
crParameterFieldDefinition = crParameterFieldDefinitions["Department"];
crParameterValues = crParameterFieldDefinition.CurrentValues;

crParameterValues.Clear();
crParameterValues.Add(crParameterDiscreteValue);
crParameterFieldDefinition.ApplyCurrentValues(crParameterValues);
//crConnectionInfo.IntegratedSecurity = true;

for (int i = 0; i < grid1.Rows.Count; i++)
{
if (Convert.ToInt32(grid1.Rows[i].Cells[0].Value) == 1)
{
cryRpt.RecordSelectionFormula = "Date({VW_BookingReport.ReceiptDate})>=#" + txtFromDate.Text + "# and Date({VW_BookingReport.ReceiptDate})<=#" + txtToDate.Text + "# and {VW_BookingReport.Type}='" + ddlType.Text + "' and {VW_BookingReport.Department}='" + grid1.Rows[i].Cells["DepartmentName"].Value + "'";
}
}
CrTables = cryRpt.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
{
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crtableLogoninfo);
}

crystalReportViewer1.ReportSource = cryRpt;
crystalReportViewer1.Refresh();

more checkbox

i need the coding for remove the values from grid2

if i check soap it adds to grid2: first column like dove,pears and second column is soap then how to delete from the grid2...

I got the solution to that.. i attached that.. Thank u very much sir........You gave some idea so i got the result thank u so much sir......
INSERT INTO tblProduct(id,Product,Customer)
(SELECT 33,Product,Customer FROM tblProduct WHERE id=2)

Your first query displays NULL to id, second query is working and it is adding the Maximum number +1. Its fine...
Shall we give where condition to that select command(select TOP 2 id+1,Customer,Product From tblProduct group by id,Product,customer WHERE id=@id)

thank u sir....

otherwise do onething pass id as own value

Sqlserver2005

Thank you very much for the solution. But I have a different scenario where the ID are random also the ID value is 'NULL' when executed using the above query.
Please help solving my issue.

Reply quickly

Thank u so much

when i focus the textbox corresponding textbox should change the color,fontstyle,etc...

Otherwise give sample program to create usercontrol and when i enter the textbox change color of textbox

Error 99 The type name 'sttTextBox' does not exist in the type 'HMS.HMS' D:\VELU\Projects\pharmacy\HMS\PharmacyMaster.Designer.cs 191 40 HMS

it shows are you missing directive or assembly reference

please correct that coding..

really i dont know about usercontrol help me.....

sir i couldnt receive ur messages by code project... im seeing ur replies from my gmail account

the above mentioned my codings are correct or not?

but its not working

i used following one:

namespace sttTextBox
{
public partial class UserControl1 : TextBox
{
public UserControl1()
{
InitializeComponent();
this.GotFocus += new EventHandler(UserControl1_GotFocus);
this.LostFocus += new EventHandler(UserControl1_LostFocus);
}

void UserControl1_LostFocus(object sender, EventArgs e)
{
this.BackColor = Color.White;
this.ForeColor = Color.Black;
}

void UserControl1_GotFocus(object sender, EventArgs e)
{
this.BackColor = Color.Aqua;
this.ForeColor = Color.Brown;
}
}

i need to create in c#.net

thanks

thank u

if (Checkbox is checked)
i need to take checked values only

checkbox Name Amount
[] lux 30
[] dove 40
[] pears 38
[] medimix 25
if select dove,pears it should show 78

your first link is not working

c# is in slow in server... so i need in javascript

c# is in slow in server... so i need in javascript