|
|
I am doing a application connecting to a remote SQL server .....
my code is
myConnectionString = "Data Source=***.**.***.***;Initial Catalog=Project;User ID=sa;Password=****;"
Dim myConnection As New SqlConnection(myConnectionString)
when i am using my com to access it .... i can work but if i bring my project to another computer to run it ...
it can't work and the error is this server do not exist...
can any one can help with this....
|
|
|
|
|
I'm going to use my psychic powser and guess your using Sql Server 2005 Express? You might want to be a bit more detailed if you expect decent help :P
If you do have Sql Server 2005 Express then read this:
http://www.datamasker.com/SSE2005_NetworkCfg.htm[^]
If your not then be more detailed. Tell us what version of Sql Server, give us the exact error message and any error codes.
|
|
|
|
|
sorry about that...... i am using MS SQL server .... no 2003 no 2005
plainly ms sql server
and the error is
An unhandled exception of type 'System.Web.Services.Protocols.SoapException' occurred in system.web.services.dll
Additional information: Server was unable to process request. --> SQL Server does not exist or access denied.
|
|
|
|
|
hi am a Junior to those who know me, thanks to your code Project and People like Dave, i moved from VB6, and had a c++ and java background, i did not have problem using oops in vb.net. i have done the Project. and they need me to Document the Project. what Format should i use? what is it it is Supposed to be in the Functional specification documents?
please Post a link to help or set the Guidelines for me
Thanks
Vuyiswa Maseko
|
|
|
|
|
Vuyiswamb wrote: they need me to Document the Project. what Format should i use?
By "they" I presume you mean your employer. As for what format, many companies will have a set of templates for such things. Follow the format of the template.
Vuyiswamb wrote: what is it it is Supposed to be in the Functional specification documents?
See Functional Specification[^]
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
"I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless."
My website
|
|
|
|
|
Why am I getting all these one-votes for my answers?
I thought the answer above would be quite useful. The link I gave gives a good overview of the subject then links out to two excellent, and more in depth, articles on the subject.
If I have somehow managed to offend someone I'd like to know what it was that caused such offence, because, quite frankly, following me around the programming forums voting practically everything I post a 1 is childish in the extreme.
-- modified at 7:45 Tuesday 17th July, 2007
Surprise, surprise! This post gets voted a one too. 
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
"I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless."
My website
|
|
|
|
|
I don't think its much use to ask who's doing this
if that person is really childish anough to vote 1 on every post you do I doubt he/she will be man/women enough to come out and say how he/she is
If I were you I wouldn't pay much attention to it
you're answers have been quite usefull to me in the past so I'd say keep up the good work and thanks for al you're afforts
modified
sorry made a typo 
|
|
|
|
|
And as if by magic alot of your 1 posts have returned to 3 
|
|
|
|
|
 Thanks. 
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
"I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless."
My website
|
|
|
|
|
|
i have one datatable contains price column
i need to calculate the sum of the prices
and then delete all the rows from the table
my code is :
dim total as decimal
total=dataset.tables("sourcetable").columns("price").experssion="sum(price)"
but when the code executed it generate exception
can not use experssion in an circual function
second:
i need to know how to delete all rows from datatable at run time
regards to all
|
|
|
|
|
don't know about the first question but for the second:
dataset.tables("sourcetable").clear
(I didn't test it but it should work)
about the first question if you have a db backhand why not do that in sql?? (just a suggestion)
|
|
|
|
|
the clear method clears the dataset table only and when i call update method nothing happen
i know that i can get sum from SQL and use stored procedure to execute the statments
but i need to di it through VB experssion method
thanks for help
-- modified at 6:17 Tuesday 17th July, 2007
|
|
|
|
|
What you did was try to put the expression in the column, which won't work. You have to enumerate the rows in the table, adding up the prices, and you can also delete each row in the datatable, then call the update method on the dataadapter for this datatable/dataset to write the changes back to the database.
|
|
|
|
|
i want to buy a book for vb.net 2005 anybody can suggest book for both(beginners and also for high level) tell separate book also
sathish
|
|
|
|
|
(1) Pro-ASP.NET 2.0 in VB 2005 by Laurence Moroney, edited by Matthew MacDonald by apress publication
(2)ASP.NET 2.0 Web Programming with VB 2005 by Murach Publication.
(3)Professional VB 2005 by Bill Evjen, Billy Hollis, Rockford Lhotka, Tim McCarthy, Rama Ramachandran, Kent Sharkey, Bill Sheldon by wrox publication.
Regards,
Satips. ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
Don't walk in front of me, I may not follow;
Don't walk behind me, I may not lead;
Walk beside me, and just be my friend. - Albert Camus
|
|
|
|
|
Use Microsoft Press Book
or
WROX books VS2005 is also one of the useful book
regards,
koolprasad2003
Be a good listener...Because Opprtunity knoughts softly...N-Joy
|
|
|
|
|
Hi,
Currently I am working on a multilingual application.
1. I willing provide a Button on UI which will toggle IME mode, say from English to Japanese. How can do that ?
2. How can I detect if systems IME mode is changed by user ?
3. As well as above I want to transliterate the inputed text to english. Can I do it ?
Regards
Prasad
|
|
|
|
|
|
Thanx for ur efforts Dragon,
but it didn't helped me. What u have given dosent carries information about how .NET handles IME things. Thanx allot.
Prasad
|
|
|
|
|
Hello, I encounter strange phenomenon with my listview and smallimages. The images disappear and don't come back, even after reboot, run the application on a different machine. If i create a new listview, it works again for a while. Does anyone can help me with this annoying thing.
The imagelist has 2 images and when i replace the listview i reuse it. Here you have my code, first the declaration of the listview, and second, how i add during the program one element.
Thanks for to take a look into this.
Declaration:
'
'ListView2
'
Me.ListView2.AccessibleDescription = resources.GetString("ListView2.AccessibleDescription")
Me.ListView2.AccessibleName = resources.GetString("ListView2.AccessibleName")
Me.ListView2.Alignment = CType(resources.GetObject("ListView2.Alignment"), System.Windows.Forms.ListViewAlignment)
Me.ListView2.Anchor = CType(resources.GetObject("ListView2.Anchor"), System.Windows.Forms.AnchorStyles)
Me.ListView2.BackgroundImage = CType(resources.GetObject("ListView2.BackgroundImage"), System.Drawing.Image)
Me.ListView2.Columns.AddRange(New System.Windows.Forms.ColumnHeader() {Me.clh_1, Me.clh_2, Me.clh_3, Me.clh_4, Me.clh_5, Me.clh_6, Me.clh_7, Me.clh_8, Me.clh_9, Me.clh_10})
Me.ListView2.Dock = CType(resources.GetObject("ListView2.Dock"), System.Windows.Forms.DockStyle)
Me.ListView2.Enabled = CType(resources.GetObject("ListView2.Enabled"), Boolean)
Me.ListView2.Font = CType(resources.GetObject("ListView2.Font"), System.Drawing.Font)
Me.ListView2.FullRowSelect = True
Me.ListView2.GridLines = True
Me.ListView2.HeaderStyle = System.Windows.Forms.ColumnHeaderStyle.Nonclickable
Me.ListView2.ImeMode = CType(resources.GetObject("ListView2.ImeMode"), System.Windows.Forms.ImeMode)
Me.ListView2.LabelWrap = CType(resources.GetObject("ListView2.LabelWrap"), Boolean)
Me.ListView2.LargeImageList = Me.ImageList1
Me.ListView2.Location = CType(resources.GetObject("ListView2.Location"), System.Drawing.Point)
Me.ListView2.Name = "ListView2"
Me.ListView2.RightToLeft = CType(resources.GetObject("ListView2.RightToLeft"), System.Windows.Forms.RightToLeft)
Me.ListView2.Size = CType(resources.GetObject("ListView2.Size"), System.Drawing.Size)
Me.ListView2.SmallImageList = Me.ImageList1
Me.ListView2.TabIndex = CType(resources.GetObject("ListView2.TabIndex"), Integer)
Me.ListView2.Text = resources.GetString("ListView2.Text")
Me.ListView2.View = System.Windows.Forms.View.Details
Me.ListView2.Visible = CType(resources.GetObject("ListView2.Visible"), Boolean)
Add element with imageindex set on 0
Dim item As New ListViewItem("") ' 0
item.ImageIndex = 0
item.SubItems.Add("-") ' 1
item.SubItems.Add("-") ' 2
item.SubItems.Add("-") ' 3
item.SubItems.Add("-") ' 4
item.SubItems.Add("-") ' 5
item.SubItems.Add("0") ' 6
item.SubItems.Add("0") ' 7
item.SubItems.Add("0") ' 8
item.SubItems.Add("No") ' 9
Me.ListView2.Items.Add(item)
|
|
|
|
|
I don't immidiatly know why you're images disapear but I'd start by trying to figure out when exactly they disapear
(after a specific action or time)
also try triming you're code to the minimum (perhaps even rewrite some in a differant project and see if the same happens there)
since I'v never encountered this before (and I'v used listviews with images a few times before) I would think that somewhere in you're code there is a mistake that clears the images from the listview or the images from the imagelist
so I'm afraid this might be one of those trial and error debugging things
|
|
|
|
|
Do you think that all these lines are normal? For example: CType(resources.GetObject("ListView2.Dock"), System.Windows.Forms.DockStyle)
It is referring to the resources file, I am a C# programmer, but I have to make something in vb.net and in .NET 1.1, so I am using VS2003. I never saw this before.
Another, if I change the listview, i have images for a while and than it falls back to its old habit.
This sucks. I'll try to figure out what is causing this problem.
|
|
|
|
|
did you import you form or did you start from scratch, added the listview, set its properties,...?
it is possible that you get strange code like that from the designer when importing a form or when copying a control (I don't know why or how but it doesn't always work)
if you did copy it or import it I would suggest you make a new project and start from scratch there (not you whole prog just the bit with the lisview code) and see if you still have the behavior you described if so then something is probebly wrong with the code if you don't get that behavior and you copyed it or imported it then that is probably the reason
if you could providy more detail about all this I might be able to reproduce the behavior and help you further
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
