Topics by Naveed_786

Dear All, Good Morning! I am facing this issue i tried a lot but not able to find the issue with this function when i call this function i get error Argument not specified for parameter 'LVL' of 'Public Function UL(LVL As String) As String' The code is listed below, …

Dear Friends, Good Day, I am facing an issue in one of the functions the code is given below if someone can help on this actually this function is supposed to check the work ordewr number if it's nulll then it is suppose to take default value as 4999 and …

Dear All, How Can i prevent duplicate record entry in vb.net. Please help

I am auto generating data grid and I am using check box in Data grid View, Now i am invoking check box state changed event but it produces the following error Handles clause requires a WithEvents variable defined in the containing type or one of its base types. Here the …

When i pass the parameter and run the report it works fine as i close the form it closes the form is there any way so that i should be able to close the crystal report viewer and pass the parameter again and should be able to view report again. …

How can we disable a cell of datagrid in vb.net and how to show date in datagrid cell in vb.net

Here is the code which is working fine for me on another form but creating problem when i use the same code on another form it gives me this error message when i try to insert a new record in DB "Value cannot be null Parameter name: Data Table" and …

Dear all, Can any one tell me how can i take bakup on Every minute and hourly and complete whole day backup using VB.NET i.e i want to know the coding example Thanks in advance

I am using oracle 9i database with VB.NET when i am trying to insert record in my PR_REC table it gives me error "ORA-01722 Invalid number" here is my insert statement and the structure of the table [CODE]com = New OleDbCommand("INSERT INTO PR_REC(pr_no,item1,price1,qty1,item2,price2,qty2,item3,price3,qty3,item4,price4,qty4,item5,price5,qty5,item6,price6,qty6,item7,price7,qty7,item8,price8,qty8,item9,price9,qty9,item10,price10,qty10,Pur_reason,pr_date,Status) VALUES ('" & Me.txtprno.Text.Trim & "','" & …

Hi to all, How can i connect VB.NET with oracle i am using following connecting string for connecting VB.NET with SQL Server [CODE]Public ConnectionString As String = "Data Source=%server%; Initial Catalog=Inventory; Integrated Security=SSPI; Trusted_Connection=True;"[/CODE] And Class for sql server [CODE]Imports System.Data.SqlClient[/CODE] What class should i use for oracle.

I have a problem with date and time picker when i select the date from dtpicker1 then txtdate1 gets the value but when i debug it shows txtdate1 = "" why please help [ICODE]Private Sub DTPicker1_CloseUp() txtdate1.Text = DTPicker1.Value DTPicker1.Refresh End Sub[/ICODE]

Dear all, Please help me i want to check record already exists in database please modify this code please help [CODE]Private Sub txtempno_KeyPress(KeyAscii As Integer) On Error Resume Next If KeyAscii = 13 Then btncalculate.SetFocus rs2.MoveFirst While rs2.EOF = False If Val(txtempno.Text) = rs2.Fields!EmpNo Then txtsub.Text = rs2.Fields!subjects txtempname.Text = …

How can i count the no of records fetched in datagrid from admission table and how to show these no of records in a label i.e Total No of records = 20 Please help

Hi all, 1. I want to know how to add a data grid in vb 6 form? 2. And how to fetch all records in data grid please help Thanks in advance for help.

Can any one tell me how can i make privileges for user to restrict them and only administrator have all rights. Please help me Thanks in advance.

Can any body tell me how can i check that record already exists?

When i mahe setup using setup and deployment wizard it make the setup perfectly but when i try to install it gives me error what is the best way to make a setup and run it perfectlly please help.

Hi guys, Can any help me i had a peoblem please just give me idea. I want to calculate the share of a teacher let me explain how 1.if a teacher teaching three subjects in 10th class and three subjects in 9th 2.i have to calculate 50% of the fee …

Hi guys, Please help me when i install my application on clients it only connect with one user like Naveed/Password on domain but when i login on domain by using other user it gives me connection error what should i modify in my connecting string. [CODE]"PMS.My.MySettings.ConnectionString" connectionString="Provider=SQLOLEDB;Data Source=ITS;Integrated Security=SSPI;Initial Catalog=Payment"[/CODE] …

I am using date and time picker to get current date but when i get date from date and time picker first time it gives me current date and time i save the record and when i try to get date and time second time without unloading the form it …

I want to display date and time on top of the form where normlly written form1 forms name i want to display date in formate of for example 23 August 2010 and time in this formate 12:33:20AM Please please help.

Hi guys, I want to search a customer when i press an alphabet 'a' it should search and show drop down list of all customer those name start with 'a'. Please please help thanks in advance.

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 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 …

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 …

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 …

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

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 …

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 …