|
How can i use the project(Windows Application) made by vb.net(use Ado.Net) depend on SQL Server2000 in client pc without install SQL Server2000 in the client pc?
In other words I want ask if there is any way in which we will not install SQL Server2000 on client pc and the program will run properly?
|
|
|
|
|
you just need to change the connection string for the server. So save your connection string in app.config file and use that. or read it from any XML or text file from client machine
|
|
|
|
|
If your application is written dependant on an SQL Server backend, you'll still need an instance of SQL Server running somewhere, either one on the client PC or one on another server. On the local machine, you can install the desktop version of SQL Server. For SQL Server 2000 it's called MS Desktop Engine, or MSDE[^]. For SQL Server 2005, its called SQL Server Express[^].
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
In .net 2005 we have a class "Compression" which performs single file compression and decompression
Is there a way in which i can compress and decompress more than 1 file at once just like WINZIP and WINRAR.
or is there another way in .net to compress and decompress multiple files in a single file.
|
|
|
|
|
You have to supply your own wrapper around a file with multiple compressed streams, otherwise known as a ZIP file. You can find an example of such here[^].
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hi all,
I need an suggestion, I am trying to send an mail (client will send mail in this format) from Outlook express in an specified format as,
Client Name : client name
Urgent : Yes
Date_planning[dd/mm/yyyy] : 29/08/2006
Analyses : Any text
In my application i am reading that mail and has to split it into four coloums i.e client name,Yes,29/08/2006,Any text.... seperatly, finally i will store it in the database with field names as cliend_id, status,date_plan,analysis.
I am using asp.net to split this and i am using ":" as starting index "&vbcrlf" as ending index such i am reading the in between string. But when i implement it i am facing an problem, it's the whole body content is coming as string and storing in the first coloum itself i.e as "Client Name.................. Any text"
So i cant able to split it, can any one suggest an way to send the mail such that i can seperate easily, else how to spli the recived mail.
plz guide me.............
Thanks in advance
Regards
Exelio
|
|
|
|
|
hi
first split the string with "vbcrlf" ,so you will get an array like thins :-
strArray(0)="Client Name : client name"
strArray(1)="Urgent : Yes"
strArray(2)="Date_planning[dd/mm/yyyy] : 29/08/2006"
strArray(3)="Analyses : Any text"
.
.
.
strArray(n)="anything..." as mush as you have lines.
then loop through the strArray and split each row with ":" and you will get new array like this :
strNew(0)="Client Name "
strNew(1)=" client name"
strNew(0)="Urgent "
strNew(1)=" Yes"
hope this will help you
Tamimi - Code
|
|
|
|
|
hi,
Thanks for your reply, i too tried this way first but there was an problem, when analysis contains more than one line like:
Client : volf
Urgent : Yes
Date plane [mm/dd/yyyy] : 10/10/2006
Analyse : This is the test mail from client regarding the template testing in oour test server
then it treates the next line as seperate one. But the second line is the continuation of the first line.
Plz suggest me how to over come this problem..........
by
Exelio
|
|
|
|
|
hi
i just want to say if you know in advance that there are 4 column exactly
then, starting from the 4th Iteration Consider all thr rest lines as part of the analyse column.
feel free to ask again
Tamimi - Code
|
|
|
|
|
Hi,
Ya your right, I too said this my PL, but my bad time he didn't accept this. I has to try for some other options.
Thanks very much
Bye
exelio
Know is Drop, Unknown is Ocean
|
|
|
|
|
In that case split with ":" first giving the following array
strArray(0)="Client "
strArray(1)=" volf
Urgent "
strArray(2)=" Yes
Date plane [mm/dd/yyyy] "
strArray(3)=" 10/10/2006
Analyse "
strArray(4)="This is the test mail from client regarding the template testing in oour test server (and any subsequent lines)"
strArray(4) will give the full analysis text
then loop through values 1 to 3 of strArray and split each with "vbcrlf"
strArray(1) strNew(0)="volf" discard strNew(1) = "Urgent "
strArray(2) strNew(0)="Yes" discard strNew(1) = "Date plane [mm/dd/yyyy] "
strArray(3) strNew(0)="10/10/2006" discard strNew(1) = "Analyse "
=o)
Alex
|
|
|
|
|
Hi All!!
Can anybody tell me if you can call a webservice from eVB or provide some link to sample code.I'm using WinCE 4.20 DAP Device
.
Thanks form your time & help!!
|
|
|
|
|
|
I really need help getting atlas to work...
Can someone help me out?
Tried everything...
A good guide to get atlas (cascading down lists in particular) working?
error at this moment:
Extender controls require a ScriptManager to be present on the page.
(...)
|
|
|
|
|
1. Right click on your toolbox and select "Add Tab".
2. Name this tab "Atlas".
3. Right click on the newly created Atlas tab & select "Choose items...", this will open the Choose Toolbox Items dialog.
4. Browse to the location of the Microsoft.Web.Atlas.dll file and open it.
5. Click ok. This will add all the Atlas components to your toolbox.
ii_noname_ii wrote: Extender controls require a ScriptManager to be present on the page.
All the Atlas controls require the ScriptManager to be added to the form. The ScriptManager is the component that provides partial rendering (i.e. the Ajax effect).
More than that I can't really tell you at the moment. It's still new to me as well.
|
|
|
|
|
Version any i-e 1.0,1.1,2.0
Hello there
I have to build one desktop application in which webBrowser control (ActiveX of Internet explorer) will be used. What i need is after navigating to any site
1. Need to check if the page is 100% downloaded
2. Need to save the open document in web browser Control.
Any help would be highly appreciated.
Best Regards
Rizwan Bashir
|
|
|
|
|
Hi,
I have a created a user control in my application. It has four Imagebuttons. I need to trap the click event of this imagebutton in my aspx page. I am currently working on .Net 2.0.
Please show me the way,
Thanks,
Sandy
|
|
|
|
|
hi,
Anyone know how to convert the code below for vb6 to vb.net?
here is my vb6 source code!
Function LoadLR()
dbrs.Open "select Badge,Time,Day,InOut From TimeAInfor where InOut='" + CStr("<") + "' and Month='" + CStr(Mid(Combo1(3).Text, 1, 2)) + "' and Year='" + CStr(Mid(Combo1(4).Text, 3, 2)) + "' order by Day", dbsql
'j = 0
For j = 0 To Form3.ListView1(2).ListItems().Count - 1
If dbrs.RecordCount <> 0 Then
dbrs.MoveFirst
For i = 0 To dbrs.RecordCount - 1
If Form3.ListView1(2).ListItems(j + 1).SubItems(1) = dbrs.Fields(0) Then
h = DatePart("h", CStr(dbrs.Fields(1)))
h = h * 60
n = DatePart("n", CStr(dbrs.Fields(1)))
F = h + n
If F < WorkIn Or F = WorkIn Then
Form3.ListView1(2).ListItems(j + 1).SubItems(dbrs.Fields(2) + 1) = "-"
Else
If Form3.ListView1(2).ListItems(j + 1).SubItems(dbrs.Fields(2) + 1) <> "-" Then
If F > WorkIn Then
T = Form3.ListView1(2).ListItems(j + 1).SubItems(dbrs.Fields(2) + 1)
If T = "" Then
Form3.ListView1(2).ListItems(j + 1).SubItems(dbrs.Fields(2) + 1) = (F - WorkIn)
Else
If (F - WorkIn) < Val(T) Then
Form3.ListView1(2).ListItems(j + 1).SubItems(dbrs.Fields(2) + 1) = (F - WorkIn)
End If
End If
End If
End If
End If
End If
dbrs.MoveNext
Next
For i = 2 To 32
If Not Form3.ListView1(2).ListItems(j + 1).SubItems(i) = "" And Not Form3.ListView1(2).ListItems(j + 1).SubItems(i) = "-" Then
totalLR = totalLR + Val(Form3.ListView1(2).ListItems(j + 1).SubItems(i))
End If
Next
Form3.ListView1(2).ListItems(j + 1).SubItems(33) = totalLR
totalLR = 0
End If
Next
Call CloseTASystem
For i = 0 To ListView1(2).ListItems().Count
'MsgBox ListView1(2).ListItems().Count
If ListView1(2).ListItems().Count <> 0 Then
If ListView1(2).ListItems.item(i + 1) = "" Then
Exit Function
End If
On Error Resume Next
'MsgBox ListView1(2).ListItems().Count
If Val(ListView1(2).ListItems(i + 1).SubItems(33)) = 0 Then
ListView1(2).ListItems.Remove (i + 1)
' ListView1(2).ListItems().Count = ListView1(2).ListItems().Count - 1
i = i - 1
End If
End If
Next
End Function
Please help! Thanks!!!
charleslau2855
|
|
|
|
|
Do you expect someone to type everything for you ¿
I'll just give advice.
If I were you, I would look into ADO.NET, there are plenty samples on google. Retyping this in .NET, won't help much in any case, because .NET uses DataSets, DataAdapters etc.
Just my 2 cents..
HTG CodeGuru Article Reviewer
|
|
|
|
|
 hi,i have a program to simply add,modify,delete records n display reports for this records. i have a lstbx in add form n also in modify form.the latter has adodc to navigate thru the added records, meanwhile, lstbox in modify form only returns blank when its supposed to show what is added in the lstbx in add form...even though records r adding fine to the appropriate fields in the database.
does lstbx work well with adodc or am i missing out on some coding?
below is an illustration of what my program is designed to do...luks like its not completing the transition from database to frmModify!! any help/guidance is gr8ly welcome!
frmAdd: (lstAttach)
file1
file2
file3
db1: tbl1(Attachment field)
file1;file2;file3
frmModify: (lstAttach)
file1
file2
file3
|
|
|
|
|
when you are adding data in your listbox just check that whether that particular data already exists in you list box or not. if not then add it simultaniously to you table
Thanks and Regards
|
|
|
|
|
Does anyone have an example of creating a User Control based on a ComboBox that ALSO utilizes a Class which iherits the ComboBox.ObjectCollection. I have tried various techniques but always fail as the underlying 'itemCollection' never gets propogated with the items therefore once a 'SelectedIndex = n' gets executed then the ArgumentIndexOutOfRangeException throws - EVENTHOUGH I can see that a FULL count of items exists in both Debug and actually displayed in the ComboBox ?
I have gotten as far as the Class which inherits the ComboBox and the associated ComboBoxItem (useful for adding images to comboboxes!) but as soon as I try and extend the Add Function of the Items Collection in the Class which inherits the ObjectCollection then the problems start...
Cheers,
Desmond.
|
|
|
|
|
Hi All
Could somebody give me a bit of advice? The problem I have at the moment is I’m sending a complex data type of about 30 bytes in length from a vb.net application to a vb.net web service every two seconds. Once the application has packaged the data into the soap \ xml request it grows in size to around 750 bytes on each request. This works out to approx 32.4mb per day of traffic to the web server. My questions is
Is there an more efficient way of streaming 30 bytes of data from an application to a web service without the overheads of the Http / XML headers.
Any info or tips would be gratefully received
Cheers
Tony G
|
|
|
|
|
I have one listbox and one textbox.
The listbox has over 300 items and you can select multiple items.
How can i make that selected items apear in textbox, and if i unselect the same item that its not in textbox annymore. Thanx
|
|
|
|
|
Well I guess you could be clever and keep a reference to all the selections but I have found that using the Stringbuilder Class takes a lot of overhead out of string manipulation - note each time a selection/deselection is made then a complete rebuild is done - beats having to keep track of other stuff - great advantage of the StringBuilder is SPEED. There is another more fancy way for handling this using Predicates and Actions as described in the new article (worth a read)http://msdn.microsoft.com/msdnmag/issues/06/09/AdvancedBasics/default.aspx
Anyway to keep things simple....Hope this helps...
Private mstrbld As New StringBuilder
Private mcolSelectedObjects As ListBox.SelectedObjectCollection
Private mobjSelectedObject As Object
Private Sub lstListBox_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles lstListBox.SelectedIndexChanged
mstrbld.Length = 0
mcolSelectedObjects = Me.lstListBox.SelectedItems
For Each mobjSelectedObject In mcolSelectedObjects
mstrbld.Append(mobjSelectedObject.ToString & vbCrLf)
Next
Me.txtTextBox.Text = mstrbld.ToString
End Sub
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
