Comments by Roliking (Top 22 by date)

you need to make sure the fk you are trying to update is present as a pk in the table which the fk is mapped to.

It would be helpful if you provide some code and the error that you are getting.

please add your code..

is this a silverlight project or asp.net project?

can you show me the code?? check if you are inserting the same data into a unique column.

what is the your sql query? what is the query ur using for filling the grid?

or else u can do something like this..

textBox1.Text = arr[0].ToString() + arr[1].ToString() + arr[2].ToString();
this will work perfectly fine!!

yes it is and the number of rows fetched is also significantly large...
but there are other procedures with large output and which takes more than 15sec to execute but they work well.. cannot understand whats happening in this case..
is there any specific issue??

do you want to do this is sql or in vb.net code?

yes, all the queries are run by the same connection string but i am executing only one stored procedure at a time and not all the stored procedures together...


<operationcontract()> Private Function fnStoreProcedureGetDataSet(ByVal strQry As String, ByVal strpara As String) As List(Of SearchData)
Try
retScon.ConnectionString = settings.ConnectionString
retScmd.CommandText = strQry
If strpara.Trim.Length > 0 Then
Dim strPar() As String = Split(strpara, "!@!") // The parameters are concatenated with !@! and later split to individual parameters.
For intcount = 0 To strPar.Length - 1
retScmd.Parameters.AddWithValue(strPar(intcount).Split("|").ElementAt(0), strPar(intcount).Split("|").ElementAt(1))
Next
End If
retScmd.CommandType = CommandType.StoredProcedure
retScmd.Connection = retScon
sadaDapt.SelectCommand = retScmd
sadaDapt.Fill(datsData)
retScon.Close()
Dim IntClnCnt As Integer = 0
Dim StrColumnName As String = String.Empty
For IntClnCnt = 0 To datsData.Tables(0).Columns.Count - 1
If StrColumnName = String.Empty Then
StrColumnName = datsData.Tables(0).Columns(IntClnCnt).ColumnName
Else
StrColumnName = StrColumnName & "," & datsData.Tables(0).Columns(IntClnCnt).ColumnName
End If
Next
Dim clsRpts As New ClsCommonRpt
Return clsRpts.fnGetLargeReportData(datsData)
Catch ex As Exception
Return Nothing
End Try
End Function

Thanks!! But i already knew this and was looking for a validator for all possibilities or atleast for one which does not allow special characters apart from the ones which are allowed in mail ids.. but thanks anyways!!

well work around i mean to say is there any way i can loop through the result set without the use of a cursor.

Thanks it was helpful! I found out one more way to do it using sp_executesql
which is similar to exec()

Thanks anyways...

the query is something like this, the statement that i want to execute is a string which is dynamically created


declare @Fil as varchar(100)
set @Fil= 'from tbl_Accountmaster'
select + @Fil

the query is something like this, the statement that i want to execute is a string which is dynamically created


declare @Fil as varchar(100)
set @Fil= 'from tbl_Accountmaster'
select + @Fil

well i have used the installers but using installers it will create a dll not an exe for asp.net application...
or is there any settings to be made for that..?

well i tried to change the code below
DirectCast(sender, Button).MouseMove += New MouseEventHandler(AddressOf Button_MouseMove)
and did something like this
DirectCast(sender,Button).AddHandler(Button.MouseMove)
but i am not getting the mouse move event here at all,intellisense shows only MouseLeftButtonUp and MouseLeftButtonDown events but no MouseMove,can i directly use the MouseMove event? or what else can be done?

well i know its through the web service that we access the server.But the silverlight enabled wcf service provides methods and classes only for sql connectivity and not mysql.So for this do i have to add any reference dll for mysql or mysql connectors for ado.net? I tried to add a Mysql.Data.dll reference from a windows forms project creating by my coleague,but while doing so i get an error msg stating reference is not built against silverlight runtime... so what has to be done? or is there any other way to connect to mysql? Iam sure that u cant do it directly through web service as it provides methods for sql only and not mysql, so something has to be done here. What is it?