Comments by Joy1979 - CodeProject

Joy1979 11-Nov-14 10:53am View

Phew...As it should be a simple process, I found a solution and adding it as my answer. Thanks for your time and efforts!!

Joy1979 11-Nov-14 8:55am View

Hi, thanks for your reply. Report server seems to be ok as it contains many reports and if this is the case then it would slow down other reports as well.

Joy1979 27-Oct-14 14:18pm View

Hi, I tried adding report parameter over and over with different values but no luck.

Joy1979 27-Oct-14 12:16pm View

Thanks RyanDev for your reply. I agree that an alternative to using a comma delimited parameter is reusing the same parameter like: www.test.com/?pm1=test1&pm1=test2&pm1=test3.
But this approach is not acceptable by the business and would like to have ability to seperate values by coma itself.

Joy1979 6-May-14 12:15pm View

Hi, No problem and dont worry, you would for sure help me if I was enough clear for your better understanding of my question. No hard feelings :) Finally application is running well as I mentioned in my solution.
Again, thanks for your time and concern. I appreciate it. Next time I will try to be more clear over my question. :)

Joy1979 6-May-14 11:20am View

Thank you for your thoughts over my knowledge and potential :)<br>
I am also not sure what exactly you need. I mentioned everything related to this issue here. Yes as I mentioned in very first line of my question it is a VB.Net. I have not written any code yet. I am getting this error by just adding service to the reference.<br>
I would appreciate if you could help me with my question or please feel free to ignore it. Thanks and sorry for wasting your time.

Joy1979 6-May-14 10:50am View

(Form:=System.Xml.Schema.XmlSchemaForm.Unqualified)>

(Getting error on SYSTEM.)

I am very well aware of OOP syntax. If you have read my question, the issue here is with reference.vb file that got generated when we added the service as a reference to the application.
I tired the reference as well but somehow it's still the same error. Not sure where could the issue be.

Joy1979 6-May-14 10:25am View

Sorry if i wasn't clear enough. I have pasted code where I am getting an error. Hope this helps?

Joy1979 6-May-14 10:13am View

Thanks Wes Aday, I have already tried all possible solutions available over Google/Bing. Nothing substantial though.

Joy1979 25-Apr-14 14:11pm View

Hello Maciej Los and Chill60. Sorry for my late response.
Thank you Maciej Los, I've applied the logic mentioned in your answer. Working as expected!! Grt work.

Joy1979 19-Dec-12 12:01pm View

Thanks for help. I have 1000 rows in Design_ID column and If I need to display entire data should I use : exec SP_DELETE_DESIGN_PARAMETERS @DESIGN_ID only? Please advise.

Joy1979 11-Dec-12 11:38am View

Hi..Thx for your reply. I tried with this query but it gave me column with -1 as data in it.

Alter Table Product_Details
Add Modified_By varchar (50) NOT NULL default -1

I tried other query which is not allowing me to add any of column.

ALTER TABLE Product_Details ALTER COLUMN Modified_By varchar (50) NOT NULL

..Please advise.

Joy1979 11-Dec-12 9:53am View

Thx for your help.

cmd.CommandText = "Delete From Design_Parameters where DesignID = @DesignID "
cmd.Parameters.Add(New SqlParameter("@DesignID", TextBox4.Text))

...I can delete records now. :)

Joy1979 11-Dec-12 9:53am View

Thx for your help.

cmd.CommandText = "Delete From Design_Parameters where DesignID = @DesignID "
cmd.Parameters.Add(New SqlParameter("@DesignID", TextBox4.Text))

...I can delete records now. :)

Joy1979 10-Dec-12 17:05pm View

Yes Sir, Correct. Thanks!

Joy1979 10-Dec-12 17:04pm View

Hi, Thanks for your reply. Apologies If my question is not cleared. there is not value in table associated with "?". I have updated my question.

Joy1979 10-Dec-12 16:51pm View

No, I need to delete records by 'DesignID'. user put their order number to form and that order number inserted to 'DesignID' column. If I pick any designID number then I should be able to delete it. Thanks

Joy1979 10-Dec-12 16:29pm View

Yes, I agree but it will only return value with '? ' correct? where I need to find records by 'ID'. Thanks

Joy1979 10-Dec-12 12:17pm View

My code is like this:

Private Sub Searchbtn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Searchbtn.Click

Dim str As String = ""
Dim ds = New DataSet
Dim da = New SqlDataAdapter

str = "Select DesignID From Design_Parameters Where ParameterValue='" & Trim(TextBox4.Text) & "'"
ds = New DataSet()
da = New SqlClient.SqlDataAdapter(str, conn)
da.Fill(ds)
If (ds.Tables(0).Rows.Count > 0) Then
MessageBox.Show("Record Found")
'u can also fetch data from this dataset aslo

Else
MessageBox.Show("No Record Found")
End If

End Sub

Joy1979 10-Dec-12 12:16pm View

Hi, Thank you for your help. I need to display data in a from by using DesignID. (In text box when I enter DesignID like, AB12345) It should return records from table.) Am I missing anything in Select Query? When I try to load form and enter DesignID in Text box, Nothing is happening but screen gets stuck and then I need to start task manager to cancel it. Any try/catch would help?

Joy1979 10-Dec-12 11:17am View

If Not IsDbNull(strValue) Then
If intLevel > 0 Then
strValue = replace(strValue, "'", "''")
strValue = replace(strValue, "--", "")
strValue = replace(strValue, "[", "[[]")
strValue = replace(strValue, "%", "[%]")
End If

If intLevel > 1 Then
Dim myArray As Array
myArray = Split("xp_ ;update ;insert ;select ;drop ;alter ;create ;rename ;delete ;replace ", ";")
Dim i, i2, intLenghtLeft As Integer
For i = LBound(myArray) To UBound(myArray)
Dim rx As New Regex(myArray(i), RegexOptions.Compiled Or RegexOptions.IgnoreCase)
Dim matches As MatchCollection = rx.Matches(strValue)
i2 = 0
For Each match As Match In matches
Dim groups As GroupCollection = match.Groups
intLenghtLeft = groups.Item(0).Index + len(myArray(i)) + i2
strValue = Left(strValue, intLenghtLeft - 1) & " " & right(strValue, len(strValue) - intLenghtLeft)
i2 += 5
Next
Next
End If

Joy1979 10-Dec-12 11:15am View

Deleted

Hi, Thank you for your reply. For Sql Injection please review below code. Am I missing something to implement? Sorry I am trying to learn.

If Not IsDbNull(strValue) Then
If intLevel > 0 Then
strValue = replace(strValue, "'", "''") strValue = replace(strValue, "--", "")
strValue = replace(strValue, "[", "[[]")
strValue = replace(strValue, "%", "[%]")
End If

If intLevel > 1 Then
Dim myArray As Array
myArray = Split("xp_ ;update ;insert ;select ;drop ;alter ;create ;rename ;delete ;replace ", ";")
Dim i, i2, intLenghtLeft As Integer
For i = LBound(myArray) To UBound(myArray)
Dim rx As New Regex(myArray(i), RegexOptions.Compiled Or RegexOptions.IgnoreCase)
Dim matches As MatchCollection = rx.Matches(strValue)
i2 = 0
For Each match As Match In matches
Dim groups As GroupCollection = match.Groups
intLenghtLeft = groups.Item(0).Index + len(myArray(i)) + i2
strValue = Left(strValue, intLenghtLeft - 1) & " " & right(strValue, len(strValue) - intLenghtLeft)
i2 += 5
Next
Next
End If

Joy1979 10-Dec-12 11:14am View

Deleted

Hi, Thank you for your reply. For Sql Injection please review below code. Am I missing something to implement? Sorry I am trying to learn.

If Not IsDbNull(strValue) Then
If intLevel > 0 Then
strValue = replace(strValue, "'", "''") ' Most important one! This line alone can prevent most injection attacks
strValue = replace(strValue, "--", "")
strValue = replace(strValue, "[", "[[]")
strValue = replace(strValue, "%", "[%]")
End If

If intLevel > 1 Then
Dim myArray As Array
myArray = Split("xp_ ;update ;insert ;select ;drop ;alter ;create ;rename ;delete ;replace ", ";")
Dim i, i2, intLenghtLeft As Integer
For i = LBound(myArray) To UBound(myArray)
Dim rx As New Regex(myArray(i), RegexOptions.Compiled Or RegexOptions.IgnoreCase)
Dim matches As MatchCollection = rx.Matches(strValue)
i2 = 0
For Each match As Match In matches
Dim groups As GroupCollection = match.Groups
intLenghtLeft = groups.Item(0).Index + len(myArray(i)) + i2
strValue = Left(strValue, intLenghtLeft - 1) & " " & right(strValue, len(strValue) - intLenghtLeft)
i2 += 5
Next
Next
End If

Joy1979 10-Dec-12 10:54am View

Yes I Do know. I was trying with following code but somehow it is giving me error..I guess I am missing something here.

Private Sub Searchbtn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Searchbtn.Click
' Dim
' Str = "Select * From Design_Parameters Where DesignID,ParameterName,ParameterValue="" & Trim(txtname.text) & " '"
' ds = New DataSet()
' da = New SqlClient.SqlDataAdapter(Str, conn)
' da.fill(ds)
' If (ds.Tables(0).Rows.Count > 0) Then
' MessageBox("Record Found")
' 'u can also fetch data from this dataset aslo
' Else
' MessageBox("No Record Found")
' End If
' End Sub
'End Class

Joy1979 10-Dec-12 10:07am View

Hello Debasis.Logica..Thanks a lot for your help. I am able to get expected result with this code.

Joy1979 10-Dec-12 10:02am View

Hi, Thanks a lot for your help. Yes It worked!!

Joy1979 7-Dec-12 18:37pm View

Yes John, This table is a child table and whenever any query runs against parent table data will populate from this table. I was trying to add some data into table and by mistake add duplicate data. Thx:)

Joy1979 7-Dec-12 17:49pm View

Hi, Thanks for your reply and query. It works perfectly fine but when I execute it as Result I get only Headers without data.(i.e. "StudentDetail StudentRecords gradedes grade")only. I do have data in tables. Am I missing something? any PK/FK relationship? between those two tables? Sorry If I am asking basic question as I am new to .Net and trying to learn things. :)

Joy1979 7-Dec-12 17:08pm View

Thanks for you reply, I agree with your suggestion and I have tried that before but let's say I need to stick to above mentioned data model as task requirement.

Joy1979 4-Dec-12 15:09pm View

Thanks for you reply. I have form where I have textboxes and comboboxes (design like aplication form) I am creating some rules/criteria for users. When they do selection they get choices available in form based on criteria. basically I am trying to create one table with logical conditions based on other tables(same database) values. Hope it gives answer to your questions?

Comments by Joy1979 (Top 30 by date)