freelanceprogrammers.org Forum Index » ASP
Re: asp.net
Joined: 06 Jun 2005
Posts: 4
Re: asp.net
Visual Basic .NET
Dim strConn, strSQL As String
strConn = "Provider=SQLOLEDB;Data Source=(local)NetSDK;" & _
"Initial Catalog=Northwind;Trusted_Connection=Yes;"
Dim cn As New OleDbConnection(strConn)
cn.Open()
strSQL = "SELECT CustomerID, CompanyName FROM Customers"
Dim cmd As New OleDbCommand(strSQL, cn)
Dim rdr As OleDbDataReader = cmd.ExecuteReader()
While rdr.Read()
Console.WriteLine(rdr("CustomerID") & " - " & rdr("CompanyName"))
End While
rdr.Close()
Visual C# .NET
string strConn, strSQL;
strConn = "Provider=SQLOLEDB;Data Source=(local)\NetSDK;" +
"Initial Catalog=Northwind;Trusted_Connection=Yes;";
OleDbConnection cn = new OleDbConnection(strConn);
cn.Open();
strSQL = "SELECT CustomerID, CompanyName FROM Customers";
OleDbCommand cmd = new OleDbCommand(strSQL, cn);
OleDbDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
Console.WriteLine(rdr["CustomerID"] + " - " + rdr["CompanyName"]);
rdr.Close();
-----Original Message-----
From: Said Talsam Ahmed [mailto:AhmadS@...]
Sent: Monday, December 01, 2003 3:19 AM
To: AspNetAnyQuestionIsOk@yahoogroups.com
Subject: [AspNetAnyQuestionIsOk] asp.net
Hi there
Can any one help me to write a function which will take a value as input
and
search in a table using a select statement and return a value like the
statement below in asp.net, i am using vbscript
Thanks
function get_employee_name(aa)
SQL = "SELECT employee_name FROM employee where employee_code = " &
aa
return employee_name
end function
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark
Printer at MyInks.com. Free s/h on orders $50 or more to the US &
Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/saFolB/TM
---------------------------------------------------------------------~->
To unsubscribe from this group, send an email to:
AspNetAnyQuestionIsOk-unsubscribe@yahoogroups.com
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
[Non-text portions of this message have been removed]
Joined: 10 Jan 2006
Posts: 33
Re: asp.net
No but there is a folder browse button in HTML and you can use that to get
the path. As for a static path I don`t understand why you think this isnt
an option. Can you explain more?
Travis D. Falls | Consultant RAFT.Net IT | 860.547.4070 |
travis.falls@...
-----Original Message-----
From: AspNetAnyQuestionIsOk@yahoogroups.com
[mailto:AspNetAnyQuestionIsOk@yahoogroups.com]On Behalf Of kuskaus
Sent: Friday, September 09, 2005 12:28 AM
To: AspNetAnyQuestionIsOk@yahoogroups.com
Subject: [AspNetAnyQuestionIsOk] asp.net
This is my problem i want to upload a whole folder(or) i need to
save all the files in the folder to sql database from client machine
to server machine..
i need to save a whole folder files to server in a single button
click..
There is two option to get the folder path. Option 1 is i can give
some control and give path for the folder
Option 2 is i may give static path for that folder. we may take any
of one option..
If option 2 is possible that is very good... i think its not
possible..
In web based program i feel there is no folder Browse control is
there...
When i click a button it should automatically save all the files one
by one to sql database as a binary in image column..
It all should from client to server not server to server...
I should not use activex ... If unable to find solution we may go
for activex but pls keep in mind if we use
activex then in client machine it should not ask to download...
dll.... or any think
Yahoo! Groups Links
*************************************************************************
PRIVILEGED AND CONFIDENTIAL: This communication, including attachments, is
for the exclusive use of addressee and may contain proprietary,
confidential and/or privileged information. If you are not the intended
recipient, any use, copying, disclosure, dissemination or distribution is
strictly prohibited. If you are not the intended recipient, please notify
the sender immediately by return e-mail, delete this communication and
destroy all copies.
*************************************************************************
All times are GMT
Page 1 of 1
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Freelace Website Designer - Customer web design and software building.
China Wholesale - Electronics Products
Character Studio - Tutorials and Help
China Wholesale - Electronics Products
Character Studio - Tutorials and Help