Re: Text files and sql server 2000 - Visual Basic Discussion Boards

First Prev Next

Re: glitch occurs

Dave Kreskowiak3-Jan-06 6:18

Dave Kreskowiak

3-Jan-06 6:18

I think he's just writing a little test app for this. I have no idea if he's trying to really make anything out of this.

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

Re: glitch occurs

tamila_tamila3-Jan-06 19:35

tamila_tamila

3-Jan-06 19:35

yes its really matters, actaully i simulated this problem from my project. suggestion senthil kumar is worth, but i want permanent solution so that it can be fast and feasible for massive inputs.

www.tamilselvan.zoomshare.com

Text files and sql server 2000

fotis-greece3-Jan-06 2:06

fotis-greece

3-Jan-06 2:06

Guys I need some help,

I have a text files xxxyyy.txt which is semi-column delimetted with the first row being the header. How do I create an sql table with the contants of the file.

Is there an article for this maybe...?
Big Grin | :-D

Re: Text files and sql server 2000

Colin Angus Mackay3-Jan-06 2:16

Colin Angus Mackay

3-Jan-06 2:16

You could use DTS - It would be the most effective solution. It would also be the quickest to set up.

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:25

fotis-greece

3-Jan-06 2:25

Colin thanks, but because I am new in all this can you elaborate
a bit more on what you mean with DTS

?

Re: Text files and sql server 2000

J4amieC3-Jan-06 2:47

J4amieC

3-Jan-06 2:47

This is IMO the easiest way.

Open Enterprise Manager and goto your database's "Tables" section
Right-Click in the RHS panel and select All Tasks>Import Data...
Follow the wizard setting "Column Delimiter" and "First Row has Column Names" appropriately

ta.da.

some hints:
You can name the table, or select an existing one on the 3rd from last step
You can save your dts package in SQL Server on the second from last step - it can then be viewed/edited from Data Transformation Services/Local Packages in Enterprise Manager

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

Last Visit: 31-Dec-99 18:00 Last Update: 23-Sep-24 5:30

Refresh

ᐊ Prev 1...3709 3710 3711 371237133714 3715 3716 3717 3718 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.