Comments by Naqash Younis (Top 18 by date)

Where i have to call cn.Dispose()
and please also check either my all codes are in proper format

this is code
Protected Sub OnRowEditing(sender As Object, e As GridViewEditEventArgs)
GridView1.EditIndex = e.NewEditIndex
Me.BindGrid()
End Sub

im using this code but this code generate only one student record

no you dont understand.
i want if i have total three student and one of them pay fee for april and it will update in MonthlyFeeGenrate and its mention this student paid fee for april .so when i click on query it will add balance in rest of two students

but in this way it will create only one fee voucher. i want if students are 20 in table its create 20 voucher on single click

this is not suitable please give me any other solution.
its difficult to create pdf file one by one of all student then need to convert in pdf .

is there any solution for direct printing of rdlc report of all students

No Solution ????

thanks for telling me such a thing.
but my problem is same .could you tell me how can i print all Callahan FROM dbo.PrintChallan Table dbo.PrintChallan store monthly base fee vouchers for many students class wise i want to print all fee voucher in single click i mentioned my source code also.

this is code which i am using for print single fee voucher but i want Multiple fee voucher in single click




Public Function itemQillareport() As DataSet
Dim dsData As DataSet
Try

'dsData = DalHelper.ExecuteDataset(m_ConString, CommandType.Text, "select * from PrintChallan where Reg_num='" & StidentFee.TextBox14.Text & "' and fee_Month='" & StidentFee.ComboBox1.Text & "' and Fea_year='" & StidentFee.TextBox4.Text & "'")
dsData = DalHelper.ExecuteDataset(m_ConString, CommandType.Text, "SELECT dbo.PrintChallan.*, dbo.School_Info.* FROM dbo.PrintChallan CROSS JOIN dbo.School_Info where PrintChallan.Reg_num='" & StidentFee.TextBox14.Text & "' and PrintChallan.fee_Month='" & StidentFee.ComboBox1.Text & "' and PrintChallan.Fea_year='" & StidentFee.TextBox4.Text & "' and School_Info.Id='1'")
Catch ex As Exception
Return Nothing
End Try
Return dsData

End Function

Private Sub Employe_Led_report_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load


ReportViewer1.LocalReport.ReportEmbeddedResource = "KTC.Report36.rdlc"
Dim rdsNumberofReferrals As New Microsoft.Reporting.WinForms.ReportDataSource()

rdsNumberofReferrals.Name = "DataSet1"
Dim dsBrands As DataSet = itemQillareport()
rdsNumberofReferrals.Value = dsBrands.Tables(0)
ReportViewer1.LocalReport.DataSources.Add(rdsNumberofReferrals)
ReportViewer1.Update()
Dim newPageSettings As New System.Drawing.Printing.PageSettings
newPageSettings.PaperSize = New Printing.PaperSize("Custom", 820, 1150)

newPageSettings.Landscape = True
newPageSettings.Margins = New System.Drawing.Printing.Margins(10, 10, 10, 10)
ReportViewer1.SetPageSettings(newPageSettings)
Me.ReportViewer1.RefreshReport()



End Sub

where text file is Stored ? now i dont want to implement i just want to get it out.because still im making the software but just because of setting save not any even single changes update on my vb.net application

i dont know how to do it please give me example or source code suppose my Local database is Database1 and online database on serer is database2 how i compare it ?

i removed all code of checkupdate and trail version etc also remove it from visual studio project app setting i just want to get it out form this bull sh*t problem