Comments by Fahid Zahoor (Top 95 by date)

THANKS MAN its help full for me.

thanks man for your response now i write my own algorithm when i complete then i also share with you so explain me my algorithm writing process are professional or not.

some time customer bil amount is 10.04 but we take 10.05 if custome bil is 10.02 then we take only 10.00 can you understand

Now i disconnect the cash draw from printer and direct attach with computer using USB trigger. please help me now from which command i open cash draw.

i want to take backup and save as with .back extension in my computer after that i take this file that has .back extension and put into my second PC and then i restore it. i restore just two tables that(i.e Product and Stock) has in a backup file others table data are not effected due to restore this. please help me how can i do this

i means that
this line of code not working
if (Fotertex.ToString().Length > 19)
{
graphics.DrawString(Fotertex.ToString().Substring(0, 19), myfont, Brushes.Black, new Point(10, startY = startY + 40));
}

please you tell me how can id display my Report1.rdl in ReportViewer1

at that moment there is no data source that i bind. i just display "Its first Report" on my rdlc report.

How can i remove other references from component

i i'm also faild to find backup of my database

You have any answer about my question

ok thanks budy you are great

i don't need SQL Server because i don't want to (shred network version)

Yes i decide I use SQLExpress(Local database)

I'm Beginner thats why i face many problems. so i need your help

please you tell me relevant software libraries i don't know which fills is necessary

but there is no server install in client computer i want to run application with local db

yes i understand now

i create connection in my App.config file
the connection string is
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<connectionstrings>
<add name="dbx"
connectionString="Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename='|DataDirectory|\db\RetilShop_POS;Integrated Security=True"
providerName="System.Data.SqlClient"/>

<startup>
<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.6.1" />

i want to ask an other error that i face when i use localdb for SQL server 2014 Express in my C# Winform application
error message is
"
System.ArgumentException: 'Format of the initialization string does not conform to specification starting at index 35.'

"

good its working now

yes you right i understadn now

ok i try with this code PrinDocument.Print(); if any problem occur then i will share with you

please tell me if i have moew the one page then PrinDocument.Print(); is ablicable or Not

2nd method is work now. Thanks

your method is good please tell me how can i set default printer so, print directly goes to default printer

i have one crystal report named as CustomerCashRecipet.rpt and i use one crystal report viewer named as crystalReportViewer and i also use one crystalreportDocument i load CustomerCashRecipet report to crystalreportDocument and then i display the crystalreportDocument in my report viewer and then take print please tell me something how can i take directly print of crystalreportDocument using button click

i use this but it show error message
CrystalDecisions.CrystalReports.Engine.LoadSaveReportException: 'Invalid report file path.'

ohhhhhhhhh now what can i do.
its not possible to deploy application without SQL server

its good idea "
If you don't need multiuser access, then don't use SQL Server: use SqLite, Access, ... single user databases that require no additional installation (other than the DLL files that get added by your install program anyway).
"
i need a single user database but at that time i complete my project and its time to install application on Client. I completed my database using SQL server 2014. please tell me know how can i mange that.
Is it possible to conver SQL server 2014 Database into SqLite if yes. then explain me how can i do this. And one thing Remember i need to update my database after 15 days. so give me best idea what is best for me.
Thanks Alot OriginalGriff

WinForms

yes yes but i dont found any GotFocus() event in c# please you tell me how can i do this.

thanks its working but please tell me how can i open on screen key bored when my cursor goes to Tex box on screen key bored automatically open

ok so plz tell me how can i convert selected color to integer value and then i store this integer value in database

Color c = Color.AliceBlue;
int i = c.ToArgb();
c = Color.FromArgb(i);
its good method now I'm using it but one problem i face
I'm using colordialouge for selection of color now please tell me how can i put selected color instead this name 'AliceBlue'.
Or 1).you have any idea how can i convert selected color to its name.
2) you have any idea how can i convert button background color to color name and store this color name in any variable of string data type.

I used it but now this error occur
System.InvalidCastException: 'Failed to convert parameter value from a DateTimePicker to a DateTime.'

but please tell me how can i correct it really worried

ohhh i checked it
if row.Cells[5].Value is not NULL.
it show null value but i set today date

when i hover the mouse on "expdate"
the value is {1/1/0001 12:00:00 AM}
but i cannot select this value i set today date .
now how can i refine it

Win forms

Thanks

i use search engine but i did'n find answer that i want

Its my Table
CREATE TABLE [dbo].[Product_Details](
[PID] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](50) NULL,
[PDescription] [nvarchar](250) NULL,
[Category] [nvarchar](50) NULL,
[Scategory] [nvarchar](50) NULL,
[SScategeory] [nvarchar](50) NULL,
[Brand] [nvarchar](50) NULL,
[GroupName] [nvarchar](50) NULL,
[Vatpercentage] [nvarchar](50) NULL,
[VatState] [nvarchar](50) NULL,
[Ptype] [nvarchar](50) NULL,
[Weight] [nvarchar](50) NULL,
[QtyAlret] [float] NULL,
[Isactiveoffer] [bit] NULL,
[Isexpiryproduct] [bit] NULL,
[PImage] [image] NULL,
CONSTRAINT [PK_Product_Details] PRIMARY KEY CLUSTERED
(
[PID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
=============================================
Its my Store procedure please check it
ALTER procedure [dbo].[USP_Insert_Product_Details]
(@Name nvarchar(50)
,@PDescription nvarchar(250)
,@Category nvarchar(50)
,@Scategory nvarchar(50)
,@SScategeory nvarchar(50)
,@Brand nvarchar(50)
,@GroupName nvarchar(50)
,@Vatpercentage nvarchar(50)
,@VatState nvarchar(50)
,@Ptype nvarchar(50)
,@Weight nvarchar(50)
,@QtyAlret float
,@Isactiveoffer bit
,@Isexpiryproduct bit
,@PImage image)
as
begin
INSERT INTO [dbo].[Product_Details]
([Name]
,[PDescription]
,[Category]
,[Scategory]
,[SScategeory]
,[Brand]
,[GroupName]
,[Vatpercentage]
,[VatState]
,[Ptype]
,[Weight]
,[QtyAlret]
,[Isactiveoffer]
,[Isexpiryproduct]
,[PImage])
VALUES
(@Name
,@PDescription
,@Category
,@Scategory
,@SScategeory
,@Brand
,@GroupName
,@Vatpercentage
,@VatState
,@Ptype
,@Weight
,@QtyAlret
,@Isactiveoffer
,@Isexpiryproduct
,@PImage )
end

i follow your code but it give this type of error message

System.Data.SqlClient.SqlException: 'Procedure or function 'USP_Insert_Product_Details' expects parameter '@LogoImage', which was not supplied.'
but i supply this parameter please help me

ok and in datetime i use 12 Hours or 24 Hours how can i differentiate AM and PM

and which one is best for sending time in database Datetime picker and Textbox???

Still give error under all the columns, the error is invalid column name
when i use case then this error come when i remove case then error also removed automatically me b some problems still occur in case
Any Suggestion

i download a file from your given link a new Exe file is appear in my download folder that's name is SSMS-Setup-ENU and the description of fille is "Microsoft SQL Server Management Studio - 18.0 Preview 4"
please do you tell me I download right file or Not?

I'm using vs 2014 please tell me what is the name of latest version

image dimensions is 1920*1200
How can i check the dimensions of Application Form

Application is develop in VB not in .Net framework
but its a big project for POS of restaurant and also dial up modem is connect wit VB application.
is it possibility to convert application with complete feature.
Thanks for your response

I don't understand whats says google about this. i/m biggenr so you tell me in simple way how can i make this type of application

ok thanks. MVC 5 is available in community version of vs 2017

sorry for that i don't clearly tell you my problems let me Explain my problem again.
when i open any form by clicking on dashboard button and then i minimized the previously open form and try to open new form it doesn't work .but when i close previous form that i open from dashboard then i easily open new form.
But Now i want to open more then one form by minimizing the old form.

ok thanks i will try

i have both version but i'm beginner so you suggest me as a beginner which version is best for practices

please suggest which version of VS 2015/Vs 2017 is best for MVC 5.

i try this but it give an error
i use port no 995
failure :sending field
now tell me what can i do

but i dont export only datagridview data i also export Some TextBox Data in Report Form as a Dynamic Order as i set

But I don't Make a report using Database i print Report without Database. I take Data From List For Report.
Suggest me any tool And Also give me Link for toll for Developer Addition and also provide me Link for Clint Computer

how we can do the same thing but using (Sum) not Max
i'm using this but it does not return Zero if there is no available Qty is according to productID beacuse there is no stock add in this productId. please tell me how can i do this.
availableQty have int datatype
select
COALESCE(sum([AvailableQty]),0) as'Avil'
from [dbo].[Stock]
group by [ProductID]
having [ProductID]= '2'

how we can do the same thing but using (Sum) not Max
i'm using this but it does not return Zero if there is no available Qty is find
select
COALESCE(sum([AvailableQty]),0) as'Avil'
from [dbo].[Stock]
group by [ProductID]
having [ProductID]= '2'

Thanks You solve my paroblem

but if i use internet and then do the same tash is it possibal becuse as you said my all computers are connect with server using wires but i can do this without wires beacuse may be one is my computer application that use the same database and other is my andriod app that also used with same database.

you tell me the solution,i use it in my next project you just explin me how can i do this thanks

I'm using crystal report viewer for preview the report

No i am using crystal report not rdlc

yes i install crystal report but i don't know its runtime version or not.
please you tell me how can i download runtime crystal report.
i'm using latest version of crystal report that sport visual studio 2017

yes i very the database connection . my application save and retrive data from database .

I install crystal report for visual studio 2017.
but when i try to create new report I'm facing This error
"The system cannot find File specified(EXCEPTION From HRESULT 0x80070002) "
please help me how can i solve this Issue.

WPF

its my server name.
CTRLSOFT-ELDHL3\SQLEXPRESS
its my Databse Name.
CNG

i verify already server name and database name is same.

what is the meaning of 5ed!

i want when my app is start then set a condition on tic event of clock .my reminder message is display .My reminder message is come from database as i saved my message at the time of set reminder. and i also want to add a button when i click on button the reminder message is removed from sql DB.
please you send me code how i save my reminder message and datetime in database

ohhh Thank You Sooo Much You solve my problem

ohh thank you soo much you solve my problem.

please mention this error in my coding thanks

system.sql.sqlclint.sqlexception:Cannot open Backup device.
operating system error. access denied.
Backup database terminating abnormally

system.sql.sqlclint.sqlexception:Cannot open Backup device.
operating system error. access denied.
Backup database terminating abnormally

which datatype i used for 0 or 1 in sql table

Thanks It Will Runing.

System.Data.SqlClient.SqlException: 'Operand type clash: nvarchar is incompatible with image'
This Error is Occur when i using DBNull.Value

Yes I'm using this. Now Paroblem is that only Date is Shown in GridView But when i take the print 12:00 this Time is also add to all the records...

No I use Form Default Close Button In my Application Only Two Form is Create paroblem Which is Dash Bord Form And EmPoly Record Form. When i click the close Button of EmpolyForm DashBord Alos Hide But Application Coding Remain runing.

But i need these Records where EmName is Same And any one Date is Same Just Like Any one date is same from StartDate and EndDate.

if (NumberOfItemPrintedSoFar <= CustomerDetilsdataGridView.Rows.Count)
{

e.Graphics.DrawString(""+p, new Font("Arial", 12, FontStyle.Bold), Brushes.Black, new Point(23, ysp));
// e.Graphics.DrawString(CustomerDetilsdataGridView.Rows[i].Cells[0].Value.ToString(), new Font("Arial", 16), Brushes.Black, 23, ysp);
e.Graphics.DrawString(CustomerDetilsdataGridView.Rows[i].Cells[1].Value.ToString() , new Font("Arial", 16), Brushes.Black, 120, ysp);
//e.Graphics.DrawString(CustomerDetilsdataGridView.Rows[i].Cells[3].Value.ToString(), new Font("Arial", 16), Brushes.Black, 330, ysp);
e.Graphics.DrawString(CustomerDetilsdataGridView.Rows[i].Cells[4].Value.ToString(), new Font("Arial", 16), Brushes.Black, 440, ysp);
e.Graphics.DrawString(CustomerDetilsdataGridView.Rows[i].Cells[9].Value.ToString(), new Font("Arial", 16), Brushes.Black, 640, ysp);
ysp += 30;
p++;
}

Yes I'm Using Data GridView

This error is occuer and ToString underLine By read color line
"Return a string that represent the current object. No over Load for method ToString takes 1 Arguments"
Tell me what i do next???

Yes