Visual Basic

16-Oct-08 2:28

praveenkumar palla wrote:
and after that another user updated the database but my dataset doesn't have these updates

This requirement just dictated to you that you can't just load the data in FormLoad and hold onto it. Now you have no choice but to keep the round trips and hold onto data only as long as you need to update it.

Search Googling around for "ADO.NET Concurrency" and you'll find that this is not an easy problem to solve.

Oh...and "Merge" isn't going to help you here.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

DLL Issue

Tauseef A15-Oct-08 17:10

Tauseef A

15-Oct-08 17:10

i am aworking in vs2005 vb.net , i have a DLL Project named MYLIBRARY when i build this project individually it creates the dll and other related files in the bin\debug folder of the project directory , but when i add a new project my win application and add it's project reference to my win application and compile the project so it creates the dll and other related files in the bin\ ,
although the setting of the project shows the Bin\Debug path for Dll file. win application works ok , the problem is just witn DLL project.

any idea?
tyhanks in advance

hello

Re: DLL Issue

Dave Kreskowiak15-Oct-08 17:48

Sample Code to get data in a Table A not in other table B to Table C automatically

15-Oct-08 17:48

ghumman63 wrote:
i have a DLL Project named MYLIBRARY when i build this project individually it creates the dll and other related files in the bin\debug folder of the project directory , but when i add a new project my win application and add it's project reference to my win application and compile the project so it creates the dll and other related files in the bin\

This is impossible to read because you're not using any punctuation and the sentence is switching contexts throughout, leaving the reader completely dumbfounded as to what you're refering to and when.

Try explaining this a bit better so we can figure out what problem you're talking about.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Re: DLL Issue

nishkarsh_k15-Oct-08 20:15

nishkarsh_k

15-Oct-08 20:15

What all i can get out of it is there is some issues when u are compiling the project about ur dll reference.

What u can try is go to project properties and then to publish tab. You will have a application files button which lists all the dll and included files. You can change there Publish status of ur missing dll to Include

Good luck

Thayhor15-Oct-08 13:43

Thayhor

15-Oct-08 13:43

I have three table A, B and C. Table A contain list of books borrow everyday. Table B contain the list of Books available in library. Table C suppose to have list of book not borrowed per day. I need a sample code to do this. I am using MS Access as my Backend database.

My Code is as follows:

"Insert into TableC (BookID,[Name], Author) (Select * From Table B where BookID) Not in (Select * from Table C where [Date] between ' " & TextBox1.Text & "' and ' " & TextBox2.Text & "'"

Thank you.

Thayhor

Re: Sample Code to get data in a Table A not in other table B to Table C automatically

jzonthemtn15-Oct-08 13:51

jzonthemtn

15-Oct-08 13:51

Try the SQL forum.

Re: Sample Code to get data in a Table A not in other table B to Table C automatically

Guffa16-Oct-08 1:34

Guffa

16-Oct-08 1:34

Thayhor wrote:
Table C suppose to have list of book not borrowed per day.

Why would you put that data in a table? You are only causing redundancy in the database.

Thayhor wrote:
where BookID) Not in (

You can't have one operand (BookID) inside the parenthesis and the operator (Not in) and the other operand (Select...) outside the parenthesis.

Thayhor wrote:
between ' " & TextBox1.Text & "' and ' " & TextBox2.Text & "'

You should use parameterised queries. Your query is wide open for SQL injection attacks.

Network enabled app

Ekjon15-Oct-08 11:08

15-Oct-08 11:08

I got this old application that needs to be deployed locally.
I am converting it to a network-enabled version.
I finished the SQL Server conversion part.
Now I am going to do the network-enabling part.
I mostly worked with web apps.
So, I'll really appreciate if anyone can point me to the right direction for this.

Thanks.

Dave Kreskowiak15-Oct-08 17:44

15-Oct-08 17:44

Noone can help you at all unless you explain what you mean by "network enabled"?? This is such a generic term that it can mean anything...

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Ekjon16-Oct-08 5:52

16-Oct-08 5:52

Sorry about the confusion.
I basically meant the application will run on the server only, and will be available on the network. Therefore others will be able to use it from their computers, while its running in the server.

Thanks.

Dave Kreskowiak16-Oct-08 6:36

16-Oct-08 6:36

OK, so how are the clients going to use the app if it's "running on the server"?? Obviously, the app has to expose some kind of interface, either UI-based through an existing technology, like a web browser, or through an API that another application uses, such as a Windows Forms app.

Or, did you mean that the .EXE files are going to sit on the server and the clients are going to launch them from the shared location?? In which case, you're going to need to read up on Code Access Security because code running from any remote source, including authenticated file shares, is not trusted by the .NET CLR by default and will run in a heavily restricted sandbox.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Ekjon16-Oct-08 6:56

16-Oct-08 6:56

Hi Dave,

Yes..we want to use the the exe files deployed on the server, because otherwise it will have to be completely rebuild.
Could you please show me the way how to set up the code access security?
I have my assembly set up for AllowPartiallyTrustedCallers, but its not helping.

Thanks.

Ekjon

Dave Kreskowiak16-Oct-08 10:35

16-Oct-08 10:35

AllowPartiallyTrustedCallers doesn't have anything to do with what you want. It's used for code calling code, not people launching code.

Start reading: Code Access Security[^], and Code Access Security in Practice[^]

Let's see, there's also a few CP articles, like Understanding .NET Code Access Security[^] and Using MSI or a strong name to store .NET apps on a network server (Part 1)[^] and Using MSI or a Strong name to store .NET apps on a network server (Part 2)[^]

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Ekjon16-Oct-08 11:01

VB6 Winsock cannot receive NULL?

16-Oct-08 11:01

Thanks so much Dave.
I started reading Mike Downen's and Shawn Farka's articles. Now I got a handful from you. Please pray for me so I don't die from over-eating.

Me

Levisvv15-Oct-08 6:37

Levisvv

15-Oct-08 6:37

I am writing an interface to a Panasonic KX-TDA telephone system using Winsock.

I can connect to the PBX and it accepts my connection properly using TCP, then I can send the initial connect string as follows:

Mtosend = Chr$(&H0) & Chr$(&H25) & Chr$(&H60) & Chr$(&H23) & Chr$(&H80) & Chr$(&H2) & Chr$(&H7) & Chr$(&H80) & Chr$(&HA1) & Chr$(&H7) & Chr$(&H6) & Chr$(&H5) & Chr$(&H2B) & Chr$(&HC) & Chr$(&H0) & Chr$(&H81) & Chr$(&H5A) & Chr$(&HBE) & Chr$(&H14) & Chr$(&H28) & Chr$(&H12) & Chr$(&H6) & Chr$(&H7) & Chr$(&H2B) & Chr$(&HC) & Chr$(&H0) & Chr$(&H82) & Chr$(&H1D) & Chr$(&H81) & Chr$(&H48) & Chr$(&HA0) & Chr$(&H7) & Chr$(&HA0) & Chr$(&H5) & Chr$(&H3) & Chr$(&H3) & Chr$(&H0) & Chr$(&H8) & Chr$(&H0)
Winsock1.SendData Mtosend

When I monitor the connection using WireShark it appears that the PBX accepts the string properly and sends a reply back, I get 51 bytes of data back, but if I read it as a string it simply shows as a "NULL" string. If I read it into a byte array, using the following code I only get zero's:

Private Sub Winsock1_DataArrival(ByVal bytesTotal As Long)
Dim DL As String
Dim DTS As String
Dim byteData(256) As Byte
Dim i As Integer

DL = CStr(bytesTotal)
DTS = ""
Winsock1.GetData byteData(), vbArray + vbByte, Val(Trim(DL))
For i = 0 To bytesTotal - 1
    DTS = DTS & " " & Right$(("00" & Hex$(byteData(i))), 2)
Next
MsgBox "TCP Rx: " & DTS & "  (bytes=" & DL & ")"
Exit Sub

But when I look at the trace in WireShark, the PBX did not send only zero's it sent a valid reply, The PBX returned string started the data with a null, but the rest was valid data. What am I doing wrong?

Please help. Confused | :confused:

Mail sending failed

Sebastian T Xavier15-Oct-08 5:19

Sebastian T Xavier

15-Oct-08 5:19

Hi all,
when I try to send a mil from my application an exception is thrown...
" Transaction failed. The server response was: sorry, the sender name and auth login doesn't coinside (#5.7.1) "
What could be the reason for this?
Thanking you in advance...

Sebastian T Xavier

Ashfield15-Oct-08 5:21

Ashfield

15-Oct-08 5:21

Sebastian T Xavier wrote:
the sender name and auth login doesn't coinside

Its telling you something here. I suspect you are not authenticated properly for the mail server.

Bob
Ashfield Consultants Ltd

Sebastian T Xavier15-Oct-08 5:29

Sebastian T Xavier

15-Oct-08 5:29

Thanks for the quick reply, actually this code segment was working for a long time. today only i got this exception.
I believe i haven't done any changes in settings

Thanks

Sebastian T Xavier

Dave Kreskowiak15-Oct-08 5:35

15-Oct-08 5:35

It's not your code that changed, it's the mail server you're using.

To increase security and prevent people from sending mail, such as spam, impersonating someone else, the server, apparently, now checks the outgoing sender name against the registered account. If they don't match, the server stops you from sending the email.

The bottom line is you are going to have to get with the people managing the mail server and find out what the requirements are. Then you're going to have to modify your code to fulfill those requirements.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008