nelson2391 - Viewing Profile

nelson2391's Profile User Rating:

Reputation: -1 Dishonored

Group:: New Members
Active Posts:: 14 (0.02 per day)
Joined:: 25-May 11
Profile Views:: 1,277
Last Active:: May 19 2013 02:26 AM
Currently:: Offline

Previous Fields

Country:: IN
OS Preference:: Windows
Favorite Browser:: Chrome
Favorite Processor:: Who Cares
Favorite Gaming Platform:: Who Cares
Your Car:: Who Cares
Dream Kudos:: 0

Latest Visitors

Atli
12 Feb 2013 - 13:09
modi123_1
16 Oct 2012 - 07:05
sela007
25 Mar 2012 - 13:40
nK0de
23 Mar 2012 - 14:28
FinFin
16 Jan 2012 - 21:16
RetardedGenius
17 Jun 2011 - 15:45
macosxnerd101
17 Jun 2011 - 10:59
trevster344
08 Jun 2011 - 07:38
Jeff H
07 Jun 2011 - 03:18

nelson2391 Hello I'm new here........

Posts I've Made

In Topic: Printing a form using info from list box

Posted 23 Mar 2012

Post your code.Then we can help you.

In Topic: "Having" Query errors

Posted 23 Mar 2012

just include declare statement to declare "@Param1"
Try it. but Im not sure. okay

 

 Dim da As New SqlDataAdapter(" Declare @Param1 as Varchar(50) SELECT MONTH(Head.SalesDate) AS Month, Detail.ProductID , SUM (Detail.Qty) AS TotalSold , SUM (Detail.Qty/30 ) As Average FROM  Head INNER JOIN Detail ON Head.HeadID = Detail.HeadID Group By MONTH(SalesDate), Detail.ProductID  HAVING (MONTH(Head.SalesDate) = @Param1)", con)

In Topic: Error handling

Posted 19 Jan 2012

Sorry for that.
Thanks for helping me.

smohd, on 18 January 2012 - 11:41 AM, said:
Then you will need to catch SQlException( but doesnot guarantee that the error will be that), then use catch block to replace.
Or a simply way is just to replace them in every input without waiting for the exception to occur, because the replace method will simply ignore if it didnt find what to replace.

But I am also thinking you didnt use parameter-style query, this will help avoid user input from added as a normal query and instead treated as input...

okay i will try it..
thanks

In Topic: datagridview in vb.net

Posted 9 Nov 2011

hi
create a form and place a grid

use the below code

Public Class Form1

    Private Sub DataGridView1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles DataGridView1.KeyPress
        Dim x As Integer = DataGridView1.CurrentRow.Index
        If e.KeyChar = Chr(13) Then
            DataGridView1.CurrentCell.Selected = False
            DataGridView1.Rows(x).Cells(3).Selected = True
        End If
    End Sub

End Class