Software Applications Programming Errors and solutions.

Prerequisites for Microsoft Visual Studio 2010 Express installation Architectures x86, x64  Supported Operating Systems Windows XP (x86) with Service Pack 3 Windows Vista (x86 & x64) with Service Pack 2 Windows 7 (x86 and x64) Windows Server 2003 (x86 & x64) with Service Pack 2 - all editions Users must install MSXML6 if it is not already present. Windows Server 2003 R2 (x86 and x64) - all editions Windows Server 2008 (x86 and x64) with Service Pack 2 - all editions Windows Server 2008 R2 (x64) - all editions Hardware Requirements GHz or faster processor 1024 MB RAM (1.5 GB if running on a virtual machine) 3 GB of available hard-disk space 5400 RPM hard-disk drive DirectX 9-capable video card running at 1024 x 768 or higher display resolution DVD-ROM drive

This is example of c#.net code to Upload Image through image upload control and save image to table of database. using System.Data; using System.Data.SqlClient; public partial class ImageUpload : System.Web.UI.Page {     SqlConnection sqlcon=new SqlConnection(@"Server=SQLEXPRESS;database=abc;uid=xxxx;pwd=yyyy;");     SqlCommand sqlcmd=new SqlCommand();     String ImageName,ImageType;     protected void Button1_Click(object sender, EventArgs e)     {         if (FileUpload1.HasFile)         {             int len = FileUpload1.PostedFile.ContentLength;             byte[] picture = new byte[len];             ImageName = FileUpload1.FileName;     ...

Master of Computer Applications Rollwala Computer Center, Gujarat University, Ahmedabad GLS Institute of Computer Applications G.L.S. Campus, Opp : Law Garden, Ellisbridge, Ahmedabad H. L. Institute of Computer Applications H. L. Campus, Near Commerce Six Roads, Navrangpura, Ahmedabad L. J. Institute of Computer Applications Near Sanand Cross Road, S.G. Highway, Ahmedabad L. D. College of Engineering Near Gujarat University, Navrangpura, Ahmedabad Indira Gandhi National Open University – IGNOU Opp : Nirma University, S. G. Highway, Chharodi, Ahmedabad Shri Chimanbhai Patel Institute of Computer Applications Opp : Karnavati Club, S.G.Highway, Ahmedabad

RTSlink DLL is a Dynamic Link Library (DLL) that allows Software developers to Integrate their Applications with Tally Accounting Software. Using RTSlink, developers can push or pull data from Tally Software in real-time. RTSlink is based on the Client/Server principles which are as follows:- The Client Application sends a Request to the Tally Server. The request may be either to Write data (Import data into Tally) or Read data (Export data from Tally). The Server processes the request and sends a response back to the client. RTSlink DLL - Functions Open() Checks whether Tally Software is running or not. If the connection is successful, a zero value is returned. If the connection fails, the error code number is returned. Send() Sends a request to the Tally Software in form of XML message/tags. SQLRequest() Retrieve Tally Software data (Masters or Vouchers) using SQL-SELECT statement. SQLDelete() Delete Tally Software data (Masters or Vouchers) using SQL-DELETE statemen...

CPU 80486 RAM Minimum 16MB Minimum 32MB required for replication Hard Disk Minimum 60MB Additional 15MB for Microsoft SQL Server Online File System FAT or NTFS OS Windows NT Server 3.51 or higher

@AMTNUMERIC(9,2)=NULL, @TAX NUMERIC(9,2)=NULL, @DISCNUMERIC(9,2)=NULL, @G_TOTAL NUMERIC(9,2)=NULL ) AS SELECT @TOT_AMOUNT=SUM(AMOUNT) FROM TRANS WHERE TNO=@CNO SELECT @TAX=ISNULL(SUM(TAX_A),0) FROM TAX WHERE NO=@TCNO SELECT @TOT_DISC_A=ISNULL(SUM(DISC_A),0) FROM DISCOUNT WHERE NO=@CNO SET @G_TOTAL = (@AMT- @TOT_DISC_A) + @TAX UPDATE FOOT SET SUBTOTAL=@TOT_AMOUNT,TAX=@TAX,DISCOUNT=@TOT_DISC_A,G_TOTAL=@G_TOTAL WHERE CNO=@CNO

You can write following code to generate ID from any Table through stored procedure. Here Generate_Id is parameter to pass Id field name. You may have different field name for your table so this stored procedure is common for all tables. This stored procedure may be very helpful for you. This is a Common code for all table just call this stored procedure and pass table Name, Criteria and Primary key column Name as parameter. set ANSI_NULLS OFF set QUOTED_IDENTIFIER OFF GO Create PROCEDURE [dbo].[Generate_ID] @TablePK CHAR(50), @Table CHAR(30), @Criteria VARCHAR(300)='' AS BEGIN IF @Criteria <> '' BEGIN EXEC('SELECT MAX(convert(int,RIGHT('+@TablePK+',5)))AS ID FROM '+@Table+' WHERE '+@Criteria+'') END ELSE BEGIN EXEC('SELECT MAX(convert(int,RIGHT('+@TablePK+',5)))AS ID FROM '+@Table+'') END END RETURN

Function GETFINYR(ByVal strDate) Dim strDt, strenddt, strstdt Dim strdd, strmm, stryy, strst_dt, strend_dt Dim date1, enddate, startdate strDt = Split(strDate, "/") strdd = strDt(0) strmm = strDt(1) stryy = strDt(2) If Right(stryy, 2) = "99" Then strend_dt = "31/03/" & Left(stryy, 2) + 1 & "00" Else If Right(stryy, 1) <> "9" Then strend_dt = "31/03/" & Left(stryy, 3) & Right(stryy, 1) + 1 Else strend_dt = "31/03/" & Left(stryy, 2) & Right(stryy, 2) + 1 End If End If strenddt = Split(strend_dt, "/") strst_dt = "01/04/" & stryy strstdt = Split(strst_dt, "/") date1 = CDate(CInt(stryy) & "/" & CInt(strmm) & "/" & CInt(strdd)) enddate = CDate(CInt(strenddt(2)) & "/" & CInt(strenddt(1)) & "/" & CInt(strenddt(0))) startdat...

Search Record in Grid Using Vb.Net Code If intOldcnt <= IntTblCount - 1 Then dgMain.UnSelect(intOldcnt) End If Dim inti As Integer If strToSearch.Trim <> "" Then For inti = 0 To IntTblCount - 1 If Convert.ToString(dgMain.Item(inti, 0)).Trim.ToUpper Like strToSearch.Trim.ToUpper & "*" Then If blnFlag = True Then dgMain.Select(inti) IntCount += 1 End If dgMain.CurrentRowIndex = inti intOldcnt = inti txtSearch.Focus() Exit For End If Next End If

Imports System.Data.SqlClient Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.Shared Imports System.data Public Class CrysReport ‘Variables Declaration Private obj As New Class1 Dim crParameterDiscreteValue As ParameterDiscreteValue Dim crconnectionInfo As New ConnectionInfo Dim crParameterFieldDefinitions As ParameterFieldDefinitions Dim crParameterFieldLocation As ParameterFieldDefinition Dim thisFormulaField As CrystalDecisions.CrystalReports.Engine.FormulaFieldDefinition Dim crParameterValues As ParameterValues Dim crtableLogoninfos As New TableLogOnInfos() Dim crtableLogoninfo As New TableLogOnInfo() Dim CrTables As Tables Dim CrTable As Table ‘This function is to shows value through formula text Public Sub report_date_formula(ByVal crReportDocument As CrystalDecisions.CrystalReports.Engine.ReportDocument, ByVal from_date As String, ByVal to_date As String) Try For Each thisFormulaField In crRep...

This is code sample to Set label in MDI Form on which label data taken from table using Timer in visual basic language. Dim rs As New Recordset Private Sub MDIForm_Load() open_recordset "select *from MASTER1 ", rs MDIForm1.Top = 0 MDIForm1.Left = 0 MDIForm1.Width = Screen.Width MDIForm1.Height = Screen.Height End Sub Private Sub MDIForm_Unload(Cancel As Integer) Timer1.Enabled = False rs.Close End Sub Private Sub Timer1_Timer() While Not rs.EOF If rs.Fields(0).Value = Format(Date, "dd/MM/yy") Then myform(i).Label1 = rs.Fields(1).Value myform(i).Show End If i = i + 1 rs.MoveNext Wend If Not rs.EOF Then rs.MoveFirst End If Timer1.Enabled = False End Sub

We love ourselves even after doing many mistakes. Then how can we hate others for their one mistake. Think before you hate someone or hate yourself. Swimming along the flow is effortless but swimming against it needs effort.Don't go the way life takes you, but take life the way you wanna go. Dare to be different.  The greatest advantage of speaking the truth is that you don't have to remember what you said. Think about it. A beautiful saying: If your eyes are positive you would like all the people in the world. But if your tongue is positive all the people in the world like you. Life is about the art of drawing without an eraser, so be careful while taking decisions about the most valuable pages of your life. A nice thought: I met money and said why everyone runs behind you, you are just a piece of paper. Money smiled and said of-course I am just a piece of paper, but I haven't seen a dustbin yet in my whole life. Life is like a coin. Pleasure and Pain are the two si...