Home Backend Development C#.Net Tutorial C# implements a small example of uploading photos to a physical path and saving the address to the database

C# implements a small example of uploading photos to a physical path and saving the address to the database

May 12, 2018 pm 02:12 PM

C#实现上传照片到物理路径,并且将地址保存到数据库的小例子

效果:

C# implements a small example of uploading photos to a physical path and saving the address to the database

C# implements a small example of uploading photos to a physical path and saving the address to the database

思路:
首先,获取图片物理地址,然后进行判断将图片保存到文件夹下,再将图片的信息保存到数据库。
数据库:

create table image1  
(  
ID int identity(1,1) primary key,  
ImageName varchar(100) ,  
ImageType varchar(20),  
ImagePath varchar(200)  
)
Copy after login

代码:

<body>  
    <form id="form1" runat="server">  
    <p>  
        <table>  
            <tr>  
                <td colspan="2" style="height: 21px">  
                       
                </td>  
            </tr>  
            <tr>  
                <td style="width: 400px">  
                    <asp:FileUpload ID="FileUpload1" runat="server" />  
                     <asp:Label ID="label1" runat="server" ForeColor="Red"></asp:Label>  
                </td>  
                <td style="width: 80px">  
                    <asp:Button ID="UploadButton" runat="server" Text="上传图片" OnClick="UploadButton_Click" />  
                </td>  
            </tr>  
            <tr>  
                <td colspan="2" align="center">  
                    <br />  
                    <br />  
                    <asp:Image ID="Image1" runat="server" Height="118px" Width="131px" />  
                </td>  
            </tr>  
        </table>  
    </p>  
    </form>  
</body>
Copy after login
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.IO;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;

namespace InExcelOutExcel
{
    public partial class UpWord : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }
        string SQLString = ConfigurationManager.ConnectionStrings["ConnectionStr"].ToString();
        protected void UploadButton_Click(object sender, EventArgs e)
        {
            try
            {
                using (SqlConnection sqlcon = new SqlConnection(SQLString))
                {
                    string FullName = FileUpload1.PostedFile.FileName;//获取图片物理地址
                    FileInfo fi = new FileInfo(FullName);
                    string name = fi.Name;//获取图片名称
                    string type = fi.Extension;//获取图片类型
                    if (type == ".jpg" || type == ".gif" || type == ".bmp" || type == ".png")
                    {
                        string SavePath = Server.MapPath("~\\excel");//图片保存到文件夹下
                        this.FileUpload1.PostedFile.SaveAs(SavePath + "\\" + name);//保存路径
                        this.Image1.Visible = true;
                        this.Image1.ImageUrl = "~\\excel" + "\\" + name;//界面显示图片
                        string sql = "insert into image1(ImageName,ImageType,ImagePath) values(&#39;" + name + "&#39;,&#39;" + type + "&#39;,&#39;~\\excel" + name + "&#39;)";
                        SqlCommand cmd = new SqlCommand(sql, sqlcon);
                        sqlcon.Open();
                        cmd.ExecuteNonQuery();
                        this.label1.Text = "上传成功";
                    }
                    else
                    {
                        this.label1.Text = "请选择正确的格式图片";
                    }
                }
            }
            catch (Exception ex)
            {
                Response.Write(ex.Message);
            }
        }
    }
}
Copy after login

以上就是C#实现上传照片到物理路径,并且将地址保存到数据库的小例子的内容,更多相关内容请关注PHP中文网(www.php.cn)!


Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Active Directory with C# Active Directory with C# Sep 03, 2024 pm 03:33 PM

Guide to Active Directory with C#. Here we discuss the introduction and how Active Directory works in C# along with the syntax and example.

Random Number Generator in C# Random Number Generator in C# Sep 03, 2024 pm 03:34 PM

Guide to Random Number Generator in C#. Here we discuss how Random Number Generator work, concept of pseudo-random and secure numbers.

C# Data Grid View C# Data Grid View Sep 03, 2024 pm 03:32 PM

Guide to C# Data Grid View. Here we discuss the examples of how a data grid view can be loaded and exported from the SQL database or an excel file.

Patterns in C# Patterns in C# Sep 03, 2024 pm 03:33 PM

Guide to Patterns in C#. Here we discuss the introduction and top 3 types of Patterns in C# along with its examples and code implementation.

Prime Numbers in C# Prime Numbers in C# Sep 03, 2024 pm 03:35 PM

Guide to Prime Numbers in C#. Here we discuss the introduction and examples of prime numbers in c# along with code implementation.

Factorial in C# Factorial in C# Sep 03, 2024 pm 03:34 PM

Guide to Factorial in C#. Here we discuss the introduction to factorial in c# along with different examples and code implementation.

The difference between multithreading and asynchronous c# The difference between multithreading and asynchronous c# Apr 03, 2025 pm 02:57 PM

The difference between multithreading and asynchronous is that multithreading executes multiple threads at the same time, while asynchronously performs operations without blocking the current thread. Multithreading is used for compute-intensive tasks, while asynchronously is used for user interaction. The advantage of multi-threading is to improve computing performance, while the advantage of asynchronous is to not block UI threads. Choosing multithreading or asynchronous depends on the nature of the task: Computation-intensive tasks use multithreading, tasks that interact with external resources and need to keep UI responsiveness use asynchronous.

MySQL: Simple Concepts for Easy Learning MySQL: Simple Concepts for Easy Learning Apr 10, 2025 am 09:29 AM

MySQL is an open source relational database management system. 1) Create database and tables: Use the CREATEDATABASE and CREATETABLE commands. 2) Basic operations: INSERT, UPDATE, DELETE and SELECT. 3) Advanced operations: JOIN, subquery and transaction processing. 4) Debugging skills: Check syntax, data type and permissions. 5) Optimization suggestions: Use indexes, avoid SELECT* and use transactions.

See all articles