I just want to grab one field!!

Jonathan Schwarz via DotNetMonster.com

Hi folks, I am a complete newbie to ASP.NET, VB, etc... I am coming from a
Cold Fusion background where it only takes me 4 lines to query a MSSQL db
and display a field name.

Please, how do I connect to my SQL db using the DSN ("mydsnname" ) and then
select "thisfieldn ame" from "thistablename" .

Then how do i display the value in my html page?

....later I will ask how to grab an uplaoded files name and update the same
field via another form.....

Big Picture: I ahve an existing aspx page that I need to add a link to. The
hyperlink should point to a file on the server that I can change via an
upload form yet to be created....

As I said, I am a CFer... but have to do this in a .Net environment.

Thanks for any help!!!

--
Message posted via http://www.dotnetmonster.com

Nov 19 '05 #1

Subscribe Reply

1428

Karl Seguin

You should take a look at:
http://www.dotnetjunkies.com/quickst...ataaccess.aspx

Once you have your connection and command set up, you can the ExecuteScalar
method of the command to retrieve a single field

public shared function GetValue() as string
dim connection as new SqlConnection(" ConnectionStrin g")
dim command as new SqlCommand("sel ect field from table", connection)
try
connection.Open ()
return cstr(command.Ex ecuteScalar)
finally
connection.Disp ose()
command.Dispose ()
end try
end function

this is assuming "field" is a string/char/varchar/text you'll cint() it if
it's a int/long/xxx, cbool if it's a bit...and so on

As far as using a DSN, you can't use it with SqlConnection.. from the docs:
The .NET Framework Data Provider for SQL Server uses its own protocol to
communicate with SQL Server. Therefore, it does not support the use of an
ODBC data source name (DSN) when connecting to SQL Server because it does
not add an ODBC layer.

so you could make use of an OleDbConnection and OleDbCommand instead.

Karl
--
MY ASP.Net tutorials
http://www.openmymind.net/index.aspx - New and Improved (yes, the popup is
annoying)
http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ (more to
come!)
"Jonathan Schwarz via DotNetMonster.c om" <fo***@DotNetMo nster.com> wrote in
message news:55******** *************** *******@DotNetM onster.com...

Hi folks, I am a complete newbie to ASP.NET, VB, etc... I am coming from a
Cold Fusion background where it only takes me 4 lines to query a MSSQL db
and display a field name.

Please, how do I connect to my SQL db using the DSN ("mydsnname" ) and then
select "thisfieldn ame" from "thistablename" .

Then how do i display the value in my html page?

...later I will ask how to grab an uplaoded files name and update the same
field via another form.....

Big Picture: I ahve an existing aspx page that I need to add a link to. The hyperlink should point to a file on the server that I can change via an
upload form yet to be created....

As I said, I am a CFer... but have to do this in a .Net environment.

Thanks for any help!!!

--
Message posted via http://www.dotnetmonster.com

Nov 19 '05 #2

Jonathan Schwarz via DotNetMonster.com

Table name: mei_cc_file
Fields: id(int), filnam(varchar)
Records: 1

I just need to be shown how to display the contents of "filnam" on an aspx
web page. I only plan to use this db and table for this and nothing else.
Can someone show me how this can be done with completely local variables
and parameters (nothing from another file)?

As I said, I am new to VB, and .Net... so please be simple

:)

--
Message posted via http://www.dotnetmonster.com

Nov 19 '05 #3

Karl Seguin

<%@ Imports Namespace="Syst em.Data.SqlClie nt
<html>
<head></head>
<body>
<asp:literal id="fileName" runat="server" />
</body>

<script runat="Server" language="vb">
Sub Page_Load
dim connection as new SqlConnection(" CONNECTION_STRI NG")
dim command as new SqlCommand("SEL ECT Filname from mei_cc_file where id =
@id", connection)
command.Paramet ers.Add("@Id", SqlDbType.Int). Value = 1
try
connection.open ()
lit.text = cstr(command.Ex ecuteScalar())
finally
connection.disp ose()
command.dispose ()
end try
End Sub
</script>

Check out http://www.w3schools.com/aspnet/aspnet_dbconnection.asp ...code
might not work as is as I've typed it off the top of my head, but should be
close...

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/index.aspx - New and Improved (yes, the popup is
annoying)
http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ (more to
come!)
"Jonathan Schwarz via DotNetMonster.c om" <fo***@DotNetMo nster.com> wrote in
message news:dd******** *************** *******@DotNetM onster.com...

Table name: mei_cc_file
Fields: id(int), filnam(varchar)
Records: 1

I just need to be shown how to display the contents of "filnam" on an aspx
web page. I only plan to use this db and table for this and nothing else.
Can someone show me how this can be done with completely local variables
and parameters (nothing from another file)?

As I said, I am new to VB, and .Net... so please be simple

:)

--
Message posted via http://www.dotnetmonster.com

Nov 19 '05 #4

Jonathan Schwarz via DotNetMonster.com

Thank You!!!

Any hope of learning how to update that field in a similar fashion but by
using
Dim filename As String = Path.GetFileNam e(postedFile.Fi leName)

to get the actual filename of a file that is being uploaded?

--
Message posted via http://www.dotnetmonster.com

Nov 19 '05 #5

Karl Seguin

Jonathan, you really should look into the link I provide or simply look for
other free online tutorials (or buy a book)....

dim connection as new SqlConnection(" CONNECTION_STRI NG")
dim command as new SqlCommand("upd ate mei_cc_file set filename = @filename
where id = @id", connection)
command.Paramet ers.Add("@Id", SqlDbType.Int). Value = 1
command.PAramet ers.Add("@FileN ame", SqlDbType.VarCh ar, LENGTH).Value =
filename
try
connection.open ()
command.Execute NonQuery()
finally
connection.disp ose()
command.dispose ()
end try

replace Length with the length of the data colum field...

Karl
--
MY ASP.Net tutorials
http://www.openmymind.net/index.aspx - New and Improved (yes, the popup is
annoying)
http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ (more to
come!)
"Jonathan Schwarz via DotNetMonster.c om" <fo***@DotNetMo nster.com> wrote in
message news:37******** *************** *******@DotNetM onster.com...

Thank You!!!

Any hope of learning how to update that field in a similar fashion but by
using
Dim filename As String = Path.GetFileNam e(postedFile.Fi leName)

to get the actual filename of a file that is being uploaded?

--
Message posted via http://www.dotnetmonster.com

Nov 19 '05 #6

Jonathan Schwarz via DotNetMonster.com

Karl,

Thank You for your help. You are absolutley correct. I need to spend some
time on this. I will be looking for a few good books (recommendation s
welcome - remember... not much vb background here - former Cold Fusion guy)
.. I did spend some time at that url you provided, it was helpful.

I wonder if you might take a look at what I have tried and see if you can
tell me what I am doing stupidly. I jsut can't get the update to work.
You'll not I have chnaged a few things from what you had initially
suggested for the update, until I get more founded in this language, I do
need to finish this thing via trial by fire and its not very fun (esp with
..net error messages).

<%@ Import namespace="Syst em.IO"%>
<html>
<head>
<title>Uploadin g a File</title>
<script language="VB" runat="server">

Dim savePath As String = "D:\Customers\a bc\hr\"
Sub Upload_Click(so urce As Object, e As EventArgs)

If Not (uploadedFile.P ostedFile Is Nothing) Then
Try
Dim postedFile = uploadedFile.Po stedFile
Dim filename As String = Path.GetFileNam e(postedFile.Fi leName)
Dim contentType As String = postedFile.Cont entType
Dim contentLength As Integer = postedFile.Cont entLength

postedFile.Save As(savePath & filename)
message.Text = postedFile.File name & " uploaded" & _
"<br>conten t type: " & contentType & _
"<br>conten t length: " & contentLength.T oString()
Catch exc As Exception
message.Text = "Failed uploading file"
End Try
Dim command As System.Data.SQL Client.SqlComma nd
Dim connection as System.Data.SQL Client.SQLConne ction

connection = ("server=(local ); initial catalog=abc_env ; uid=abcd;
pwd=abcde")
command = ("update mei_cc_file set filename = @filename", connection)
command.Paramet ers.Add("@FileN ame", SqlDbType.VarCh ar, 255).Value =
filename
try
connection.open ()
command.Execute NonQuery()
finally
connection.clos e()
command = Nothing
end try
End If
End Sub
</script>

</head>
<body>

<form enctype="multip art/form-data" runat="server">
Select File to Upload:
<input id="uploadedFil e" type="file" runat="server">
<p>
<input type=button id="upload"
value="Upload"
OnServerClick=" Upload_Click"
runat="server">
<p>
<asp:Label id="message" runat="server"/>
</form>

</body>
</html>
Any help woulf be strongly appreciated... and if you ever run into Cold
Fusion and need assistance, let me know! I'd like to return the favor!!

--
Message posted via http://www.dotnetmonster.com

Nov 19 '05 #7

Karl Seguin

Jonathan:
You didn't tell me what error youa re getting, but my guess is a
NullReference.. .
you are never creating new instances of the connection and command
objects..simply declaring them and then trying to do stuff with them...

Dim command As System.Data.SQL Client.SqlComma nd
Dim connection as System.Data.SQL Client.SQLConne ction

needs to change to

Dim command As new System.Data.SQL Client.SqlComma nd
Dim connection as new System.Data.SQL Client.SQLConne ction

and

connection = ("server=(local ); initial catalog=abc_env ; uid=abcd;
pwd=abcde")

to

connection.Conn ectionString = "server=(local) ; initial catalog=abc_env ;
uid=abcd; pwd=abcde"

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/ - New and Improved (yes, the popup is
annoying)
http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ (more to
come!)
"Jonathan Schwarz via DotNetMonster.c om" <fo***@DotNetMo nster.com> wrote in
message news:22******** *************** *******@DotNetM onster.com...

Karl,

Thank You for your help. You are absolutley correct. I need to spend some
time on this. I will be looking for a few good books (recommendation s
welcome - remember... not much vb background here - former Cold Fusion guy) . I did spend some time at that url you provided, it was helpful.

I wonder if you might take a look at what I have tried and see if you can
tell me what I am doing stupidly. I jsut can't get the update to work.
You'll not I have chnaged a few things from what you had initially
suggested for the update, until I get more founded in this language, I do
need to finish this thing via trial by fire and its not very fun (esp with
.net error messages).

<%@ Import namespace="Syst em.IO"%>
<html>
<head>
<title>Uploadin g a File</title>
<script language="VB" runat="server">

Dim savePath As String = "D:\Customers\a bc\hr\"
Sub Upload_Click(so urce As Object, e As EventArgs)

If Not (uploadedFile.P ostedFile Is Nothing) Then
Try
Dim postedFile = uploadedFile.Po stedFile
Dim filename As String = Path.GetFileNam e(postedFile.Fi leName)
Dim contentType As String = postedFile.Cont entType
Dim contentLength As Integer = postedFile.Cont entLength

postedFile.Save As(savePath & filename)
message.Text = postedFile.File name & " uploaded" & _
"<br>conten t type: " & contentType & _
"<br>conten t length: " & contentLength.T oString()
Catch exc As Exception
message.Text = "Failed uploading file"
End Try
Dim command As System.Data.SQL Client.SqlComma nd
Dim connection as System.Data.SQL Client.SQLConne ction

connection = ("server=(local ); initial catalog=abc_env ; uid=abcd;
pwd=abcde")
command = ("update mei_cc_file set filename = @filename", connection)
command.Paramet ers.Add("@FileN ame", SqlDbType.VarCh ar, 255).Value =
filename
try
connection.open ()
command.Execute NonQuery()
finally
connection.clos e()
command = Nothing
end try
End If
End Sub
</script>

</head>
<body>

<form enctype="multip art/form-data" runat="server">
Select File to Upload:
<input id="uploadedFil e" type="file" runat="server">
<p>
<input type=button id="upload"
value="Upload"
OnServerClick=" Upload_Click"
runat="server">
<p>
<asp:Label id="message" runat="server"/>
</form>

</body>
</html>
Any help woulf be strongly appreciated... and if you ever run into Cold
Fusion and need assistance, let me know! I'd like to return the favor!!

--
Message posted via http://www.dotnetmonster.com

Nov 19 '05 #8

Jonathan Schwarz via DotNetMonster.com

Karl,

I made the changes you suggested. Still getting error. Unfortunately all
errors are handled by error handler, actual error is posted to an error
log. Here's what it gives me:

2005-03-03 10:26:05 => System.Web.Http CompileExceptio n: External component
has thrown an exception. at
System.Web.Comp ilation.BaseCom piler.ThrowIfCo mpilerErrors(Co mpilerResults
results, CodeDomProvider codeProvider, CodeCompileUnit sourceData, String
sourceFile, String sourceString) at
System.Web.Comp ilation.BaseCom piler.GetCompil edType() at
System.Web.UI.P ageParser.Compi leIntoType() at
System.Web.UI.T emplateParser.G etParserCacheIt emThroughCompil ation()

any of this make sense to you?

my current code:
<%@ Import namespace="Syst em.IO"%>
<html>
<head>
<title>Uploadin g a File</title>
<script language="VB" runat="server">

Dim savePath As String = "D:\Customers\m iller-env\miller_hr\"
Sub Upload_Click(so urce As Object, e As EventArgs)

If Not (uploadedFile.P ostedFile Is Nothing) Then

Try
Dim postedFile = uploadedFile.Po stedFile
Dim filename As String = Path.GetFileNam e(postedFile.Fi leName)
Dim contentType As String = postedFile.Cont entType
Dim contentLength As Integer = postedFile.Cont entLength

postedFile.Save As(savePath & filename)
message.Text = postedFile.File name & " uploaded" & _
"<br>conten t type: " & contentType & _
"<br>conten t name: " & filename & _
"<br>conten t length: " & contentLength.T oString()
Catch exc As Exception
message.Text = "Failed uploading file"
End Try

Dim command As new System.Data.SQL Client.SqlComma nd
Dim connection as new System.Data.SQL Client.SQLConne ction
connection.Conn ectionString = ("server=(local ); initial
catalog=miller_ env; uid=miller; pwd=wat3rt3st")
command = ("update mei_cc_file set filename = @filename", connection)
command.Paramet ers.Add("@FileN ame", SqlDbType.VarCh ar, 255).Value =
filename
try
connection.open ()
command.Execute NonQuery()
finally
connection.clos e()
command = Nothing
end try
End If
End Sub
</script>

</head>
<body>

<form enctype="multip art/form-data" runat="server">
Select File to Upload:
<input id="uploadedFil e" type="file" runat="server">
<p>
<input type=button id="upload"
value="Upload"
OnServerClick=" Upload_Click"
runat="server">
<p>
<asp:Label id="message" runat="server"/>
</form>

</body>
</html>

--
Message posted via http://www.dotnetmonster.com

Nov 19 '05 #9

Karl Seguin

Jonathan:
Not sure about that error...but there are a number of issues with your
code...not sure if your just sending me a sample...

<%@ Import namespace="Syst em.IO"%>
<%@ Import namespace="Syst em.Data"%>
<html>
<head>
<title>Uploadin g a File</title>
<script language="VB" runat="server">

Dim savePath As String = "D:\Customers\m iller-env\miller_hr\"
Sub Upload_Click(so urce As Object, e As EventArgs)

If Not (uploadedFile.P ostedFile Is Nothing) Then
dim filename as string = nothing
Try
Dim postedFile = uploadedFile.Po stedFile
filename = Path.GetFileNam e(postedFile.Fi leName)
Dim contentType As String = postedFile.Cont entType
Dim contentLength As Integer = postedFile.Cont entLength

postedFile.Save As(savePath & filename)
message.Text = postedFile.File name & " uploaded" & _
"<br>conten t type: " & contentType & _
"<br>conten t name: " & filename & _
"<br>conten t length: " & contentLength.T oString()
Catch exc As Exception
message.Text = "Failed uploading file"
End Try

Dim command As new System.Data.SQL Client.SqlComma nd
Dim connection as new System.Data.SQL Client.SQLConne ction
connection.Conn ectionString = ("server=(local ); initial catalog=miller_ env;
uid=miller; pwd=wat3rt3st")
command.Command Text = "update mei_cc_file set filename = @filename"
command.Connect ion = connection
command.Paramet ers.Add("@FileN ame", SqlDbType.VarCh ar, 255).Value = filename
try
connection.open ()
command.Execute NonQuery()
finally
connection.clos e()
command = Nothing
end try
End If
End Sub
</script>

--
MY ASP.Net tutorials
http://www.openmymind.net/ - New and Improved (yes, the popup is
annoying)
http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ (more to
come!)
"Jonathan Schwarz via DotNetMonster.c om" <fo***@DotNetMo nster.com> wrote in
message news:65******** *************** *******@DotNetM onster.com...

Karl,

I made the changes you suggested. Still getting error. Unfortunately all
errors are handled by error handler, actual error is posted to an error
log. Here's what it gives me:

2005-03-03 10:26:05 => System.Web.Http CompileExceptio n: External component
has thrown an exception. at
System.Web.Comp ilation.BaseCom piler.ThrowIfCo mpilerErrors(Co mpilerResults
results, CodeDomProvider codeProvider, CodeCompileUnit sourceData, String
sourceFile, String sourceString) at
System.Web.Comp ilation.BaseCom piler.GetCompil edType() at
System.Web.UI.P ageParser.Compi leIntoType() at
System.Web.UI.T emplateParser.G etParserCacheIt emThroughCompil ation()

any of this make sense to you?

my current code:
<%@ Import namespace="Syst em.IO"%>
<html>
<head>
<title>Uploadin g a File</title>
<script language="VB" runat="server">

Dim savePath As String = "D:\Customers\m iller-env\miller_hr\"
Sub Upload_Click(so urce As Object, e As EventArgs)

If Not (uploadedFile.P ostedFile Is Nothing) Then

Try
Dim postedFile = uploadedFile.Po stedFile
Dim filename As String = Path.GetFileNam e(postedFile.Fi leName)
Dim contentType As String = postedFile.Cont entType
Dim contentLength As Integer = postedFile.Cont entLength

postedFile.Save As(savePath & filename)
message.Text = postedFile.File name & " uploaded" & _
"<br>conten t type: " & contentType & _
"<br>conten t name: " & filename & _
"<br>conten t length: " & contentLength.T oString()
Catch exc As Exception
message.Text = "Failed uploading file"
End Try

Dim command As new System.Data.SQL Client.SqlComma nd
Dim connection as new System.Data.SQL Client.SQLConne ction
connection.Conn ectionString = ("server=(local ); initial
catalog=miller_ env; uid=miller; pwd=wat3rt3st")
command = ("update mei_cc_file set filename = @filename", connection)
command.Paramet ers.Add("@FileN ame", SqlDbType.VarCh ar, 255).Value =
filename
try
connection.open ()
command.Execute NonQuery()
finally
connection.clos e()
command = Nothing
end try
End If
End Sub
</script>

</head>
<body>

<form enctype="multip art/form-data" runat="server">
Select File to Upload:
<input id="uploadedFil e" type="file" runat="server">
<p>
<input type=button id="upload"
value="Upload"
OnServerClick=" Upload_Click"
runat="server">
<p>
<asp:Label id="message" runat="server"/>
</form>

</body>
</html>

--
Message posted via http://www.dotnetmonster.com

Nov 19 '05 #10

Similar topics

1350

html input file - just want to browse

by: darren | last post by:

When using the html input file (input type=file), is there anyway to NOT have the file loaded on the server? I am only interested in using this control to browse to a file and then get the filename, but when the form posts the file ends up on the server. I am using a popup window with 4 input file controls on it, and just want to return the file names to the parent window when the popup window closes, I don't want the files loaded. Is...

ASP.NET

4009

INPUT Type="FILE" - Just want to get the file name and path as string

by: kevin | last post by:

Hi, I am trying to create a page so the user can browse the network, select a file and have that file name (text) inserted into our sql DB so I can build the hyperlink path later on. Here's what seems to be the problem. These are video files and are enormous with long crazy names so trying to hand type the file name in a text box is not an option. So I'm using an Input "file" control so when the user browses out onto the network...

ASP.NET

1849

ASP.NET and cache - just want to be sure

by: SCG | last post by:

Hi, I have had a site running for 6 months now. This morning I started observing the following behaviour pretty much out of the blue: I load a blob of XML into the ASP.NET cache with a timeout of 15 mins, and a callback set up to log the unload of the data.

ASP.NET

2671

Converting date and time to just a date field

by: jacc14 | last post by:

Hi Hope there is someone out there that can help. I am sure this is an easy one although not easy to explain. I have a form which produces a report using a query. On the form I have a start and end date which is in the query. So >=!!!. If I enter 2 dates it will produce the data I need. However the date field is a date and time field. in the form if I put say 27/07/07 00:01 to 27/07/07 23:59 it will bring up all records with a...

Microsoft Access / VBA

1389

hey guys i just want to placing a picture at the top on a myspace profile

by: oky | last post by:

hey guys i just want to placing a picture at the top on a myspace profile just like www.myspace.com/bhhta can u help me plisss... thanks

HTML / CSS

1559

Just want to have first name only

by: samuel123 | last post by:

Greetings All, Once again back to this forum. I have got a problem and hope to get solution. Senario.. I have a table called users, it has following fields user_name firstname lastname ---------------- -------------- ------------- Parker Alan & Jenny Parker

MySQL Database

1249

Hi Just want to find out if regular expression is possible.

by: Vinay Bhushan | last post by:

Hello Strange problem with regex parsing. The regular expession search text 217.173.102.220 - foomart regular expression. (.*\s)(-)(\s)(.*)

C# / C Sharp

2240

I want a field value to change automatically from status

by: nlijkwan | last post by:

I want a field value to change automatically from status from "waiting" into "received, when the values of the field named " Weight" and "number" are filled in

Microsoft Access / VBA

8395

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8310

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8732

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8503

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8605

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7330

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6166

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5632

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

1615

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General