Hi Spirit,
thank your for the response,
I have tried before, but it does not work.
because, the sender address is not from yahoogroups.com!
rgds
ahnugroho
Hi all,
We just move to Exch 2003 with SP2 and IMF enabled.
the big boss asking us to block all mailing list such yahoogroups.com!
I try to set SenderID filtering by adding domain yahoogroups.com...but it does not work because the sender address is not from yahoogroups.com but from each member...
Hi All,
I have changes the delete methods using DataView.
here is the code and it's working without error.
DeletedView.AllowDelete = True
DeletedView.RowFilter = "ItemNumber='TOTAL_QTY:'"
Dim P, delCount As Integer
delCount = DeletedView.Count
If delCount <> 0...
thanks for all,
I'll try your suggestion!
Actually, the datagrid is contains Production Planning schedule.
And the dataset was fill dinamically from Crosstab Store Procedure. User will be able to filter based on particular data.
When filter being applied, it will create TOTAL_QTY: row at the...
Hi...
I try to create Total Row on Datagrid by add new row then sum each row per column on datagrid using this code:
Dim P, delCount As Integer
delCount = DeletedView.Count
For Each myDatarow In dsSchedule.Tables(0).Rows
For P = delCount - 1 To 0
If P <= 0 And delCount = 0 Then...
Hi bboffin,
I was check the forecolor property and change to another color, but still does not work. This is happen only on my PC.
If I use another PC, it will working fine!
rgds
ahnugroho
Hi..
I was working around 2 days to solve this problem!
I have combo box on the form which have the record from this code:
cboWorkCenter.Items.Clear()
Dim cmWC As New SqlCommand
Dim drItem As SqlDataReader
cmWC.CommandType = CommandType.Text...
Hi all,
I was add reference (DLL) from COM tab to my project.
This DLL was used and Registered by another application.
It's running normally on my Development PC. but when I compile and create setup project on VB.Net then install to my PC. The old application that previously register the DLL...
Hi all,
vongrunt, you're right about serialized rows.
it's Audit trailer table and each column is separated with char ("~").
your code is working fine in my SQL Server and I can get the value what i want.
I have an old application (Access 2K) to retrieve the same table data from SQL 2k.
I...
Hi all,
I have these data in table:
record no 1 :~C~M~I~P010~004~ABC~N~FNSH
record no 2 :~C~~I~P32 ~002~CUSTOM~N~FNSH
I am stack, how to get "P32" and "P010"?
I tried using SUBSTRING in SQL statement.
SELECT SUBSTRING(colPartName,8,4)
FROM tblTransacAudit
it's returns: "P010" and "32 ~"
Does...
Hi All,
I have problem with sqldatareader. I try to populate several data using SqlDatareader, but data which contained in datareader always skip one row.
For example : there are 3 row selected, but if i try to count using sqldatareader.read() or For...next statement always counted only 2 row...
Hi all,
I have problem with my VB.net code. here is my code :
oSQL = "Insert Into db_PurchDet Values(@pd1,@pd2,@pd3,@pd4,@pd5,@pd6,@pd7,@pd8,@pd9,@pd10)"
oCommand = New SqlClient.SqlCommand(oSQL, oConn)
oCommand.Parameters.Add(New SqlClient.SqlParameter("@pd1"...
Hi All,
I've got a problem about VB.NET and SQL SERVER.
I try to insert a new record but error message always shown is "String or Binary Data Woul be Truncated"
This is my code :
Insert Into db_ExpDet (ed1,ed2,ed17,ed18) Values (6,'Test','Test','Test')"
Can you help me ?
Thanks Korach, it's working fine.
I just try .Net 2 months ago. and sometimes the code mixed up with old VB.
another problem comes up.
the text file is locked during reading or open.
Do you have any idea to make the file currently read is not locked, so another application can write to it?
I...
thank you for all your help.
I use another methode to get the last position.
Count the text lines (LastPosition) then the value will be used for next checking.
code:
Do
sLine = sFile.ReadLine()
CurrentRec = CurrentRec + 1
Loop Until LastPosition = CurrentRec
but this...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.