Topics by Naveed_786

Can i make privilages to make two modes 1. Admin Mode 2. Ristricted User Mode. Please give me some sample code. I am using vb.net with sql server 2008.

I am using the following code to delete record it did not delete record but just only populate message record deleted successfully what should i do now please please help me. [CODE]If TextBox1.Text = "" Then MessageBox.Show("Please Select record to delete......", "ALI ENTERPRISES", MessageBoxButtons.OK, MessageBoxIcon.Information) Exit Sub End If If …

Hi guys, I am using this code to update a record after searching but it gives me error here is my code please please help [CODE] Dim con As New SqlClient.SqlConnection Dim strCon As String = "Data Source=ITS;Initial Catalog=Payment;Integrated Security=True" Dim strCommand As String = "SELECT * FROM CustomerInformation WHERE …

Hi guys, Can anyone help me how can i search,delete,undo edit record in vb.net using sql server2008 as database please please give me some sample code thanks in advance.

Hi all, I am trying to check a record in database before inerting a new record here is my code but problem is when i enter a names first alphabet it imediatly populate massage please help me i want to check it after entering whole name thanks in advance. [CODE]Private …

Hi dear, I want to pass two dates from crystal report and want to get result between these two dates but it returns result only from one date here is my code any suggestion: [CODE]If TextBox1.Text = "" Or TextBox2.Text = "" Then MessageBox.Show("Please enter Date!", "ALI ENTERPRISES", MessageBoxButtons.OK, MessageBoxIcon.Information) …

Dear All, I am designing a crystal report in VB.NET I have designed a crystal report i want to pass parameter from a textbox but when i pass parameter or without passing parameter run the report it pulls all the records from the database please help my code is as …

Hi all, Can some one tell me why my crystal reports asks for user name and password at run time when i install then from setup please please help me. Thnaks in advance.

Dear All, When i make Setup of my project then my crystal reports keeps old database path how can i resolve it please help me.

Dear All, I have a problem i have made setup of my project when i install it and run the program it asks for the complete path of database like this "C:\Paymentsystem\PaymentSystem\bin\Debug" is there any way i want to change the path i mean i want to place database in …

I have developed my project now i want to make setup how can i do this please help thanks in advance.

How can i generarte crstal report bwtween two dates by passing two perameters in vb.net Thnaks in advance.

Dear All, I am using this code for single perameter [CODE] Dim cryRpt As New ReportDocument cryRpt.Load("C:\PaymentSystem\PaymentSystem\Inst1.rpt") Dim crParameterFieldDefinitions As ParameterFieldDefinitions Dim crParameterFieldDefinition As ParameterFieldDefinition Dim crParameterValues As New ParameterValues Dim crParameterDiscreteValue As New ParameterDiscreteValue crParameterDiscreteValue.Value = TextBox1.Text crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields() crParameterFieldDefinition = _ crParameterFieldDefinitions.Item("PlotNo") crParameterValues = crParameterFieldDefinition.CurrentValues crParameterValues.Clear() crParameterValues.Add(crParameterDiscreteValue) …

Dear All, How can i auto generate number in vb.net Please help thanks in advance for your help

Dear All, I am calling a perameter crstal report which i have made in visual studio when i enter criteria in textbox it does not compare and prompt all the record how to resolve it please help. [CODE]Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.Shared Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, …

When i run the report there comes an error "Invalid data source i am using this code [CODE]Dim cryRpt As New ReportDocument cryRpt.Load("C:\PaymentSystem\PaymentSystem\Instalment.rpt") Dim crParameterFieldDefinitions As ParameterFieldDefinitions Dim crParameterFieldDefinition As ParameterFieldDefinition Dim crParameterValues As New ParameterValues Dim crParameterDiscreteValue As New ParameterDiscreteValue crParameterDiscreteValue.Value = TextBox1.Text crParameterFieldDefinitions = cryRpt.DataDefinition.ParameterFields() crParameterFieldDefinition = _ …

Dear all, Q.No.1 1. I want to make a crystal report 2. It should have two datatimepicker 3. User select two diiferent dates and report must be run Q.No.2 1. How can i run a report when i pass a perametor from textbox. Please give me some Code thanks in …

Can i set margins if so then please tell me how? I am using this code but pagesetup dilog does not effect the print. [CODE]With PageSetupDialog1 .PageSettings = PrintDocument1.DefaultPageSettings End With If PageSetupDialog1.ShowDialog = DialogResult.OK Then PrintDocument1.DefaultPageSettings = PageSetupDialog1.PageSettings PrintForm1.Print()[/CODE]

Hi All, I hope you all would be fine i want to print 1. Only text 2. No controls should be appear in the print like textboxes etc. Thanks in advance.

I have problem in printing i send the print but the blank page comes code i am using as follows: [CODE]Dim linesPerPage As Single = 0 Dim yPosition As Single = 0 Dim count As Integer = 0 Dim leftMargin As Single = e.MarginBounds.Left Dim topMargin As Single = e.MarginBounds.Top …

Dear All, Please help me i want to take print of my form in a short slip please give me some code to fit the print siza on the short page i am usin LQ+ 300 printer for this purpose please please help me. Thanks in advance.

Dear All, I hope you all would be fine please help me in printing i want to take print preview of window form and after taking print preview want to take print of form how can i do this please provide me example. Thanks in advance

Dear All, I have designed a form for a table Instalment from this form i am trying to update a column in other table which is hiring table please guide me how can i do this the code is as folloes thanks in advance. [CODE]Dim cnString As String cnString = …