Visual Basic Discussion Boards

First Prev Next

Re: Text files and sql server 2000

Colin Angus Mackay3-Jan-06 2:48

Colin Angus Mackay

3-Jan-06 2:48

Here is an overview: Data Transformation Services in SQL Server 2000[^]

ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

Re: Text files and sql server 2000

fotis-greece3-Jan-06 2:57

fotis-greece

3-Jan-06 2:57

Thanks guys, have been very helpful,

Just have to figure out how to do this in code from vb,

Smile | :)

Web Service Debugging Problem :(

Sufyan_shani3-Jan-06 1:55

Sufyan_shani

3-Jan-06 1:55

HI All!
when i try to debug my web service breakpoints show question marks..and while tracing control can't reach to the ?-marked breakpoints in vb.net2003 any body can help???
Thanks in advance,
Sufyan,

Re: Web Service Debugging Problem :(

Dave Kreskowiak3-Jan-06 5:25

Dave Kreskowiak

3-Jan-06 5:25

Looking for this[^]?

If you follow it, it pretty much gives you the checklist for making sure you have met the requirements for debugging a web service.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

how to do authentication and authorisation using login form

ajay bharti3-Jan-06 1:20

ajay bharti

3-Jan-06 1:20

hi,

i have devlop an windows application in vb.net i want to do authorisation and authentication in software using login form.

i need login_name authentication on main forms menu as well as on others forms.

For examples...Menu Item should be disable when the user name is USER, else should be enable.

how to get login name from loginform to MAIN FORM & OTHER CHILD FORM.

Help me, with ur suggestions.

hi this ajay bharti

Re: how to do authentication and authorisation using login form

albCode3-Jan-06 1:28

albCode

3-Jan-06 1:28

should you serach for username and passowrd in table if itexists or not (database) or u set manualy username and passowrd???

Re: how to do authentication and authorisation using login form

ajay bharti3-Jan-06 23:27

ajay bharti

3-Jan-06 23:27

i have to search username and password in database primarily and have to authenticate in mainform that who is logged in.

On Client computer i have to maintain current user information for form's authentication.

hi this ajay bharti

Date Problem

jitendrapatel3-Jan-06 0:59

jitendrapatel

3-Jan-06 0:59

Hi,
Friend

I hv one problem. I use DateTimePicker Control in My Application in vb.net. Some times i don't want to select date and i want to display blank in datetimepicker. so i get value either blank or date which i select from datetimepicker control. so please give me solution.

Thank You in Advance.

J. A. Patel

Re: Date Problem

Dave Kreskowiak3-Jan-06 5:21

Dave Kreskowiak

3-Jan-06 5:21

There's no such thing as a "blank" date to the DateTimePicker. The default date is always the current date. If nothing is selected, you'll get todays date. There' is no getting around this, since a value type cannot be Nothing.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Calling File/Folder properties window from my Application?

shaimaa-galal2-Jan-06 22:09

shaimaa-galal

2-Jan-06 22:09

Hi all, i need to call the Windows XP File Properties window from my application (giving it the path of the file or folder to open its roperties window)
Hints:
1- my application is in VB.Net
2- operating system : Windows XP Prffessional
Please, if any one could help, reply me as soon as possible
Thank u all

Re: Calling File/Folder properties window from my Application?

shaimaa-galal2-Jan-06 22:44

shaimaa-galal

2-Jan-06 22:44

First: Sorry for posting in the wrong forum, but i posted my question in the VB.Net forum also if any one need to continue the discussion there.
Seconed: It was not my question "How to find a file/or Folder properties?"
i mean how to call the actual 'File/Folder Properties Window' embeded in Windows XP OS
Thank u

Re: Calling File/Folder properties window from my Application?

J4amieC3-Jan-06 1:13

J4amieC

3-Jan-06 1:13

Found this for you - example in VB6 of how to do it using API calls

http://vbnet.mvps.org/index.html?code/shell/propertypage.htm

This may also be useful - the entry on pinvoke on calling ShellExecuteEx

http://www.pinvoke.net/default.aspx/shell32/ShellExecuteEx.html?diff=y[^]

Simple bit of conversion over to .NET

DateTime Class

microuser_20002-Jan-06 21:51

microuser_2000

2-Jan-06 21:51

hellow to all..
i am trying to work with the datetime calss
i wana Subtract values from current date ,
let say i wana subtract today value with 7days befor and so on ..

any helpfull code ?
thxx ..

Re: DateTime Class

Paritos2-Jan-06 21:58

Paritos

2-Jan-06 21:58

hi
Just Elaborate ur requirement...

bye Sniff | :^)

Paritosh

Re: DateTime Class

Colin Angus Mackay2-Jan-06 22:09

Colin Angus Mackay

2-Jan-06 22:09

microuser_2000 wrote:
i wana Subtract values from current date

If you want to subtract from the current date then use DateTime.Add()[^] and supply a negative number.

microuser_2000 wrote:
let say i wana subtract today value with 7days befor and so on

See also: DateTime.AddDays()[^]

ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

Re: DateTime Class

microuser_20002-Jan-06 23:31

microuser_2000

2-Jan-06 23:31

the (-) method worked fine for me thxx ..

Problem in accessing other form controls

yaminilathatv2-Jan-06 21:26

yaminilathatv

2-Jan-06 21:26

Hi everyone,
I am trying to change the color of form2 when i click the button in form1. Problem is that form2 and colordialogbox also displays but the form2 is not changed to the selected color from the color dialogbox. I dont know where am I going wrong.The code is as follows in form1

Button1_click.....
dim frm as new form2
frm.colordialog1.showdialog()
frm.forecolor=colordialog1.color
frm.showdialog()
end

Please help me
thanx in advance

Re: Problem in accessing other form controls

albCode2-Jan-06 21:33

albCode

2-Jan-06 21:33

frm2 = As New Form2()
frm2.BackColor = System.Drawing.Color.YellowGreen
frm2.Show()

Re: Problem in accessing other form controls

Dave Kreskowiak3-Jan-06 5:17

Dave Kreskowiak

3-Jan-06 5:17

If the color dialog in on form2, run it from form2.
Try not to modify forms from other forms! It's really considered bad practice.

' Form 1 Button click
Dim frm As New Form2
frm.ShowDialog()

' Form 2 Load event or Button Click on Form2
colorDialog1.ShowDialog()
Me.BackColor = colorDialog1.Color

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

data synchronization between 2 sql servers through vb.net code

himagiri2-Jan-06 18:38

himagiri

2-Jan-06 18:38

need to synchronize data between our main Server and local Client Servers

both contain Patient Records, but the Local Client server contain only patient records related to that client

please give me the ways we can synchronize this data

and suggest a better solution of synchronization.

things to be considered

the synchronization process should be controller by the client application (or some front end)i.e. the synchronization should take place when the user wants it to be done and he should be able to pause or resume the synchronization optionally he may choose data for synchronization (i.e. he may not want few details that has bulk data to be synchronized)

Thanks & Regards
himagiri

Re: data synchronization between 2 sql servers through vb.net code

Colin Angus Mackay2-Jan-06 22:13

Colin Angus Mackay

2-Jan-06 22:13

himagiri wrote:
suggest a better solution of synchronization.

SQL Server: Replication[^]

ColinMackay.net
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

[VB.NET] How to hide a form?

cylix20002-Jan-06 18:05

cylix2000

2-Jan-06 18:05

I have make a Project and start from Module -> sub main
I have two forms in this project.
The main form, I have a notify icon, and a button for hide the form.
In Sub Main,

<br />
frmMain.showdialog<br />

After the form is shown, I would like to click the button for hide this form by

<br />
me.hide()<br />

However, it just finish the application.
How can the button just Hide the form and the notify icon still here(that's the application still running)?

Thank you.

Re: [VB.NET] How to hide a form?

albCode2-Jan-06 20:53

albCode

2-Jan-06 20:53