Comments by itsmehaboob

itsmehaboob 6-May-16 0:52am View

Yeah that's really we are doing now(removing all cursors) but in this case i want to run a sub query before updating CM_table for getting CT_tables's primary key then only possible to update CT_Table(Second Update query in that section) can you give any suggestion for that ?

itsmehaboob 14-Aug-15 5:41am View

i'm having the same problem did you find any solution for that ?

itsmehaboob 7-Mar-15 2:14am View

got it i tried like this WHERE (2%quantity) = 0 this is actually i need Tank you Mika

itsmehaboob 6-Mar-15 1:32am View

tried this but :(

itsmehaboob 13-Jan-15 0:55am View

Tank you for your replay but this is not working :(

itsmehaboob 5-Jan-15 5:32am View

i'am sorry i cant catch you

itsmehaboob 5-Jan-15 5:30am View

yes for all tables,sp,functions modified but i think that's not a proper way

itsmehaboob 17-Dec-14 5:20am View

lol anyway tanx rohan

itsmehaboob 1-Feb-14 2:42am View

Can you connect from sql management tools?

itsmehaboob 9-Jan-14 2:49am View

exe file

itsmehaboob 31-Dec-13 1:37am View

yes the same error coming when i'am debuging

itsmehaboob 31-Dec-13 1:31am View

sorry i cant get your point :(

itsmehaboob 31-Dec-13 1:30am View

visual studio 2008

itsmehaboob 31-Dec-13 1:29am View

no

itsmehaboob 21-Oct-13 3:36am View

this is the code:

try
{

DataTable dtCompany = ObjBL.getCompany();
decimal Vl;
Vl = 0;
Font PrintFont;
clsCommon.getPrinter("[Rec]");
Position = 0;
PrintFont = new Font("Calbri", 10, FontStyle.Bold);
Position = 75;
if (dtCompany.Rows.Count > 0)
{
PrintFont = new Font("ARIAL", 10, FontStyle.Bold);
e.Graphics.DrawString("" + dtCompany.Rows[0]["Company_name"].ToString() + "", PrintFont, Brushes.Black, 75, Position);

Position = Position + 20;
PrintFont = new Font("Calbri", 9, FontStyle.Regular);
e.Graphics.DrawString("" + dtCompany.Rows[0]["Address"].ToString() + "", PrintFont, Brushes.Black, 60, Position);
Position = Position + 14;
e.Graphics.DrawString("" + dtCompany.Rows[0]["Telephone"].ToString() + "", PrintFont, Brushes.Black, 60, Position);
Position = Position + 14;
e.Graphics.DrawString("" + dtCompany.Rows[0]["Street"].ToString() + "", PrintFont, Brushes.Black, 60, Position);
Position = Position + 14;
e.Graphics.DrawString("" + dtCompany.Rows[0]["Email"].ToString() + "", PrintFont, Brushes.Black, 60, Position);
Position = Position + 14;
}
PrintFont = new Font("ARIAL", 10, FontStyle.Bold);
e.Graphics.DrawString("Sales Invoice", PrintFont, Brushes.Black, 75, Position);
PrintFont = new Font("Calbri", 9, FontStyle.Bold);
Position = Position + 20;
e.Graphics.DrawString("V No :" + dudSVno.Text + "", PrintFont, Brushes.Black, 40, Position);
Position = Position + 25;
e.Graphics.DrawString("Date: " + dtpDate.Value.ToString("dd-MMM-yyyy") + " Time :" + DateTime.Now.ToString("hh:mm tt") + " ", PrintFont, Brushes.Black, 40, Position);
Position = Position + 25;
PrintFont = new Font("Calbri", 5, FontStyle.Regular);
e.Graphics.DrawString("==========================================================", PrintFont, Brushes.Black, 30, Position);
Position = Position + 10;
PrintFont = new Font("ARIAL", 9, FontStyle.Regular);
e.Graphics.DrawString("Srl", PrintFont, Brushes.Black, 40, Position);

e.Graphics.DrawString("Item", PrintFont, Brushes.Black, 100, Position);
e.Graphics.DrawString("Tax", PrintFont, Brushes.Black, 150, Position);
e.Graphics.DrawString("Price", PrintFont, Brushes.Black, 200, Position);

e.Graphics.DrawString("Qty", PrintFont, Brushes.Black, 100, Position);
e.Graphics.DrawString("Gross", PrintFont, Brushes.Black, 150, Position);
e.Graphics.DrawString("Discount", PrintFont, Brushes.Black, 200, Position);
e.Graphics.DrawString("Grand Total", PrintFont, Brushes.Black, 200, Position);
Position = Position + 15;
PrintFont = new Font("Calbri", 5, FontStyle.Regular);
e.Graphics.DrawString("==========================================================", PrintFont, Brushes.Black, 30, Position);
Position = Position + 10;
string S;
PrintFont = new Font("ARIAL", 8, FontStyle.Regular);
for (int i = 0; i < dgSales.Rows.Count; i++)
{

e.Graphics.DrawString(dgSales.Rows[i].Cells[2].Value.ToString(), PrintFont, Brushes.Black, 40, Position);
S = (string)(AlignPosition(dgSales.Rows[i].Cells[3].Value.ToString()));
S = (string)(GetPosition(S));
Position = Position + 20;
e.Graphics.DrawString

itsmehaboob 12-Sep-13 4:56am View

so how to stop the print job?

itsmehaboob 28-Mar-13 1:30am View

i want to stop printing when printing data is completed

itsmehaboob 9-Mar-13 2:15am View

No its appearing in front of child form..

itsmehaboob 8-Mar-13 7:28am View

how can you convert string value to numeric?
e.g. (a to numeric)

itsmehaboob 8-Mar-13 5:48am View

i cant get you. can you please tell me whts d purpose of the grid view ?

itsmehaboob 7-Mar-13 8:19am View

i cant get you clearly I'm sorry..

itsmehaboob 7-Mar-13 7:42am View

Please try this.

SELECT q.student_id, q.fee_type, q.amount, q.amount - p.paid AS Current_month_due, ISNULL(q.amount, 0) - ISNULL(g.paid, 0) AS previous_month_due, (q.amount - g.paid)
+ (q.amount - p.paid) AS total_amount
FROM Student_Fee_Quotations AS q LEFT OUTER JOIN
(SELECT student_id, fee_type, SUM(paid_amount) AS paid
FROM FeePaid_Details AS d
WHERE (student_id = '1') AND (fee_type = 'Admission Fee') AND (month = 'jan')
GROUP BY student_id, fee_type) AS g ON q.student_id = '1' AND q.fee_type = 'Admission Fee' LEFT OUTER JOIN
(SELECT student_id, fee_type, SUM(paid_amount) AS paid
FROM FeePaid_Details AS d
WHERE (student_id = '1') AND (fee_type = 'Admission Fee') AND (month = 'feb')
GROUP BY student_id, fee_type) AS p ON q.student_id = '1' AND q.fee_type = 'Admission Fee'

itsmehaboob 7-Mar-13 7:41am View

Deleted

Please try this..

SELECT q.Student_ID, q.Fee_Type, q.amount, q.amount - p.paid AS Current_month_due, ISNULL( q.amount ,0)-ISNULL( g.paid,0) AS previous_month_due, (q.amount - g.paid) + (q.amount - p.paid)
AS total_amount
FROM Student_Fee_Quotations AS q LEFT JOIN
(SELECT d.Student_ID, d.Fee_Type, SUM(d.amount) AS paid
FROM FeePaid_Details AS d
WHERE (d.Student_ID = 'PS20130001') AND (d.Fee_Type = 'Admission Fee') AND (d.Month_Details = 'jan')
GROUP BY d.Student_ID, d.Fee_Type) AS g ON q.Student_ID = 'PS20130001' AND q.Fee_Type = 'Admission Fee' INNER JOIN
(SELECT d.Student_ID, d.Fee_Type, SUM(d.amount) AS paid
FROM FeePaid_Details AS d
WHERE (d.Student_ID = 'PS20130001') AND (d.Fee_Type = 'Admission Fee') AND (d.Month_Details = 'feb')
GROUP BY d.Student_ID, d.Fee_Type) AS p ON q.Student_ID = 'PS20130001' AND q.Fee_Type = 'Admission Fee'

Comments by itsmehaboob (Top 23 by date)