16,004,727 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 .NET 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 Member 10339067 (Top 37 by date)
Member 10339067
31-Mar-14 2:59am
View
its not working
Member 10339067
5-Mar-14 4:39am
View
SqlDataAdapter adapter1 = new SqlDataAdapter("SELECT Photo FROM tblPatientDetails WHERE PatientID=" + Convert.ToInt32((txtPatientID.Text)) + "", con);
DataTable datatable = new DataTable();
adapter1.Fill(datatable);
adapter1.Dispose();
if (datatable.Rows.Count > 0)
{
byte[] picArray = (byte[])dt.Rows[0]["Photo"];
MemoryStream ms = new MemoryStream(picArray);
ms.Seek(0, SeekOrigin.Begin);
//pictureBoxDisplay.Image = Image.FromStream(ms);
//pictureBoxDisplay.Image = ByteToImage(picArray);
MemoryStream mStream = new MemoryStream();
// byte[] pData = picArray;
mStream.Write(picArray, 0, Convert.ToInt32(picArray.Length));
Bitmap bm = new Bitmap(mStream, false);
mStream.Dispose();
pictureBoxDisplay.Image = bm;
}
Member 10339067
5-Mar-14 4:32am
View
already i used this... but not working
Member 10339067
5-Mar-14 2:46am
View
i am using in windows application.....
Member 10339067
5-Mar-14 2:45am
View
i saved in image datatype
Member 10339067
3-Mar-14 1:03am
View
i need to Pass multiple value as that department...
Member 10339067
3-Mar-14 1:03am
View
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();
Member 10339067
28-Feb-14 2:57am
View
more checkbox
Member 10339067
28-Feb-14 1:28am
View
i need the coding for remove the values from grid2
Member 10339067
28-Feb-14 1:27am
View
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...
Member 10339067
20-Feb-14 8:34am
View
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)
Member 10339067
20-Feb-14 8:21am
View
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)
Member 10339067
20-Feb-14 7:34am
View
thank u sir....
Member 10339067
20-Feb-14 7:28am
View
otherwise do onething pass id as own value
Member 10339067
20-Feb-14 7:06am
View
Sqlserver2005
Member 10339067
20-Feb-14 6:53am
View
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.
Member 10339067
20-Feb-14 6:41am
View
Reply quickly
Member 10339067
12-Dec-13 6:30am
View
Thank u so much
Member 10339067
12-Dec-13 6:17am
View
when i focus the textbox corresponding textbox should change the color,fontstyle,etc...
Member 10339067
12-Dec-13 6:09am
View
Otherwise give sample program to create usercontrol and when i enter the textbox change color of textbox
Member 10339067
12-Dec-13 6:05am
View
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
Member 10339067
12-Dec-13 5:57am
View
it shows are you missing directive or assembly reference
Member 10339067
12-Dec-13 5:52am
View
please correct that coding..
Member 10339067
12-Dec-13 5:51am
View
really i dont know about usercontrol help me.....
Member 10339067
12-Dec-13 5:48am
View
sir i couldnt receive ur messages by code project... im seeing ur replies from my gmail account
Member 10339067
12-Dec-13 5:47am
View
the above mentioned my codings are correct or not?
Member 10339067
12-Dec-13 5:44am
View
but its not working
Member 10339067
12-Dec-13 5:44am
View
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;
}
}
Member 10339067
12-Dec-13 5:38am
View
i need to create in c#.net
Member 10339067
12-Dec-13 5:27am
View
thanks
Member 10339067
6-Dec-13 6:43am
View
thank u
Member 10339067
6-Dec-13 6:08am
View
if (Checkbox is checked)
i need to take checked values only
Member 10339067
2-Dec-13 2:30am
View
Deleted
checkbox Name Amount
[] hamam 20
[] liril 15
if i select lux from grid1 and select liril from grid2, it should show 45
Member 10339067
2-Dec-13 2:26am
View
checkbox Name Amount
[] lux 30
[] dove 40
[] pears 38
[] medimix 25
if select dove,pears it should show 78
Member 10339067
2-Dec-13 2:23am
View
your first link is not working
Member 10339067
2-Dec-13 2:13am
View
c# is in slow in server... so i need in javascript
Member 10339067
2-Dec-13 2:13am
View
c# is in slow in server... so i need in javascript
Show More