Category Archives: Asp.net

c# base64转字符串

转成 Base64 形式的 System.String:

string a = "base64字符串与普通字符串互转";

byte[] b = System.Text.Encoding.Default.GetBytes(a);

//转成 Base64 形式的 System.String

a = Convert.ToBase64String(b);

Response.Write(a);

转回到原来的 System.String:

byte[] c = Convert.FromBase64String(a);

a = System.Text.Encoding.Default.GetString(c);

Response.Write(a);<br>

from:https://www.cnblogs.com/daimaxuejia/p/12893207.html

龙生 20 Jan 2021

View Details

c# 确定dynamic类型的数据对象是否存在某个属性

public static bool IsPropertyExist(dynamic data, string propertyname)

{

if (data is ExpandoObject)

return ((IDictionary<string, object>)data).ContainsKey(propertyname);

return data.GetType().GetProperty(propertyname) != null;

}

https://www.cnblogs.com/94cool/p/8135579.html

龙生 19 Jan 2021

View Details

百度搜索 URLScan V3.1，进行软件下载，根据操作系统版本，有32和64位的区分，如下图所示：以管理员身份运行对应版本的软件，然后勾选“I accept the terms in the License Agreement”，然后点击“Install”，如下图所示：直至安装完成，点击“Finish”，如下图所示：我们在浏览器中打开Server服务器上部署的Web应用，然后通过fiddler软件进行查看Header头信息，可以看到Server:Microsoft-IIS/7.5，如下图所示：此时我们打开URLScan默认安装路径C:\Windows\System32\inetsrv\urlscan，找到UrlScan.ini文件，如下图所示：使用记事本工具打开UrlScan.ini文件，找到RemoveServerHeader=0配置节然后修改为RemoveServerHeader=1，最后保存文件，如下图所示：此时重新启动下服务器上的IIS服务，打开命令提示符，输入iisreset即可，如下图所示：此时我们刷新Web应用地址，重新使用fiddler进行Header信息观察，现在就看不到Server这个Header头配置信息了，如下图所示： from:https://jingyan.baidu.com/article/6d704a1379629a28db51ca37.html urscanV3.1下载

龙生 14 Dec 2020

View Details

MySql连接数据库

C#中连接MySql数据库，需要配置MySql.Data。 1.配置项目- 管理NuGet程序包 – 安装MySql.Data。 2.示例代码

using MySql.Data.MySqlClient;

using System;

namespace MySQL

{

class Program

{

static void Main(string[] args)

{

string server = "172.0.0.1";

string database = "test";

string uid = "root";

string password = "123456";

string SslMode = "none";

string connectionString;

connectionString = "SERVER=" + server + ";" + "DATABASE=" +

database + ";" + "UID=" + uid + ";" + "PASSWORD=" + password + ";" + "SslMode=" + SslMode;

MySqlConnection mycon = new MySqlConnection(connectionString);

mycon.Open();

MySqlCommand mycmd = new MySqlCommand("insert into buyer(name,password,email) values('小王','dikd3939','1134384387@qq.com')", mycon);

if (mycmd.ExecuteNonQuery() > 0)

{

Console.WriteLine("数据插入成功！");

}

Console.ReadLine();

mycon.Close();

}

3.注意事项运行上述代码，如果出现异常 “IOException: Unable to read data from the transport connection: 由于连接方在一段时间后没有正确答复或连接的主机没有反应，连接尝试失败”。首先，确认数据库是否允许远程连接；其次，防火墙是否打开；最后，连接字符串是否正确，是否支持SSL。出现异常“The host localhost does not support SSL connections.”说明不支持SSL，需要在连接字符串里添加SslMode = "none"。 from:https://blog.csdn.net/liyazhen2011/article/details/82845279

龙生 04 Dec 2020

View Details

visual studio 容器工具首次加载太慢 vsdbg\vs2017u5 exists, deleting 的解决方案

========== 正在准备容器 ==========

正在准备 Docker 容器...

C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe -NonInteractive -NoProfile -WindowStyle Hidden -ExecutionPolicy RemoteSigned -File "C:\Users\MESTC\AppData\Local\Temp\GetVsDbg.ps1" -Version vs2017u5 -RuntimeID linux-x64 -InstallPath "C:\Users\MESTC\vsdbg\vs2017u5"

Info: Using vsdbg version '16.0.20412.1'

Info: Using Runtime ID 'linux-x64'

Info: C:\Users\MESTC\vsdbg\vs2017u5 exists, deleting.

如上情况感兴趣可以打开 GetVsDbg.ps1

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

.SYNOPSIS

Downloads the given $Version of vsdbg for the given $RuntimeID and installs it to the given $InstallPath

.DESCRIPTION

The following script will download vsdbg and install vsdbg, the .NET Core Debugger

.PARAMETER Version

Specifies the version of vsdbg to install. Can be 'latest', 'vs2019', 'vs2017u5', 'vs2017u1', or a specific version string i.e. 15.0.25930.0

.PARAMETER RuntimeID

Specifies the .NET Runtime ID of the vsdbg that will be downloaded. Example: linux-x64. Defaults to win7-x64.

.Parameter InstallPath

Specifies the path where vsdbg will be installed. Defaults to the directory containing this script.

.INPUTS

None. You cannot pipe inputs to GetVsDbg.

.EXAMPLE

C:\PS> .\GetVsDbg.ps1 -Version latest -RuntimeID linux-x64 -InstallPath .\vsdbg

.LINK

For more information about using this script with Visual Studio Code see: https://github.com/OmniSharp/omnisharp-vscode/wiki/Attaching-to-remote-processes

For more information about using this script with Visual Studio see: https://github.com/Microsoft/MIEngine/wiki/Offroad-Debugging-of-.NET-Core-on-Linux---OSX-from-Visual-Studio

To report issues, see: https://github.com/omnisharp/omnisharp-vscode/issues

Param (

[Parameter(Mandatory=$true, ParameterSetName="ByName")]

[string]

[ValidateSet("latest", "vs2019", "vs2017u1", "vs2017u5")]

$Version,

[Parameter(Mandatory=$true, ParameterSetName="ByNumber")]

[string]

[ValidatePattern("\d+\.\d+\.\d+.*")]

$VersionNumber,

[Parameter(Mandatory=$false)]

[string]

$RuntimeID,

[Parameter(Mandatory=$false)]

[string]

$InstallPath = (Split-Path -Path $MyInvocation.MyCommand.Definition)

)

$ErrorActionPreference="Stop"

# In a separate method to prevent locking zip files.

function DownloadAndExtract([string]$url, [string]$targetLocation) {

Add-Type -assembly "System.IO.Compression.FileSystem"

Add-Type -assembly "System.IO.Compression"

[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12

Try {

$zipStream = (New-Object System.Net.WebClient).OpenRead($url)

}

Catch {

Write-Host "Info: Opening stream failed, trying again with proxy settings."

$proxy = [System.Net.WebRequest]::GetSystemWebProxy()

$proxy.Credentials = [System.Net.CredentialCache]::DefaultNetworkCredentials

$webClient = New-Object System.Net.WebClient

$webClient.UseDefaultCredentials = $false

$webClient.proxy = $proxy

$zipStream = $webClient.OpenRead($url)

}

$zipArchive = New-Object System.IO.Compression.ZipArchive -ArgumentList $zipStream

[System.IO.Compression.ZipFileExtensions]::ExtractToDirectory($zipArchive, $targetLocation)

$zipArchive.Dispose()

$zipStream.Dispose()

}

# Checks if the existing version is the latest version.

function IsLatest([string]$installationPath, [string]$runtimeId, [string]$version) {

$SuccessRidFile = Join-Path -Path $installationPath -ChildPath "success_rid.txt"

if (Test-Path $SuccessRidFile) {

$LastRid = Get-Content -Path $SuccessRidFile

if ($LastRid -ne $runtimeId) {

return $false

}

} else {

return $false

}

$SuccessVersionFile = Join-Path -Path $installationPath -ChildPath "success_version.txt"

if (Test-Path $SuccessVersionFile) {

$LastVersion = Get-Content -Path $SuccessVersionFile

if ($LastVersion -ne $version) {

return $false

}

} else {

return $false

}

return $true

}

function WriteSuccessInfo([string]$installationPath, [string]$runtimeId, [string]$version) {

$SuccessRidFile = Join-Path -Path $installationPath -ChildPath "success_rid.txt"

$runtimeId | Out-File -Encoding utf8 $SuccessRidFile

$SuccessVersionFile = Join-Path -Path $installationPath -ChildPath "success_version.txt"

$version | Out-File -Encoding utf8 $SuccessVersionFile

}

$ExplitVersionNumberUsed = $false

if ($Version -eq "latest") {

$VersionNumber = "16.0.20412.1"

} elseif ($Version -eq "vs2019") {

$VersionNumber = "16.0.20412.1"

} elseif ($Version -eq "vs2017u5") {

$VersionNumber = "16.0.20412.1"

} elseif ($Version -eq "vs2017u1") {

$VersionNumber = "15.1.10630.1"

} else {

$ExplitVersionNumberUsed = $true

}

Write-Host "Info: Using vsdbg version '$VersionNumber'"

if (-not $RuntimeID) {

$RuntimeID = "win7-x64"

} elseif (-not $ExplitVersionNumberUsed) {

$legacyLinuxRuntimeIds = @{

"debian.8-x64" = "";

"rhel.7.2-x64" = "";

"centos.7-x64" = "";

"fedora.23-x64" = "";

"opensuse.13.2-x64" = "";

"ubuntu.14.04-x64" = "";

"ubuntu.16.04-x64" = "";

"ubuntu.16.10-x64" = "";

"fedora.24-x64" = "";

"opensuse.42.1-x64" = "";

}

# Remap the old distro-specific runtime ids unless the caller specified an exact build number.

# We don't do this in the exact build number case so that old builds can be used.

if ($legacyLinuxRuntimeIds.ContainsKey($RuntimeID.ToLowerInvariant())) {

$RuntimeID = "linux-x64"

}

Write-Host "Info: Using Runtime ID '$RuntimeID'"

# if we were given a relative path, assume its relative to the script directory and create an absolute path

if (-not([System.IO.Path]::IsPathRooted($InstallPath))) {

$InstallPath = Join-Path -Path (Split-Path -Path $MyInvocation.MyCommand.Definition) -ChildPath $InstallPath

}

if (IsLatest $InstallPath $RuntimeID $VersionNumber) {

Write-Host "Info: Latest version of VsDbg is present. Skipping downloads"

} else {

if (Test-Path $InstallPath) {

Write-Host "Info: $InstallPath exists, deleting."

Remove-Item $InstallPath -Force -Recurse -ErrorAction Stop

}

$target = ("vsdbg-" + $VersionNumber).Replace('.','-') + "/vsdbg-" + $RuntimeID + ".zip"

$url = "https://vsdebugger.azureedge.net/" + $target

DownloadAndExtract $url $InstallPath

WriteSuccessInfo $InstallPath $RuntimeID $VersionNumber

Write-Host "Info: Successfully installed vsdbg at '$InstallPath'"

}

========== 正在准备容器 ==========

正在准备 Docker 容器...

Info: Using vsdbg version '16.0.20412.1'

Info: Using Runtime ID 'linux-x64'

Info: C:\Users\MESTC\vsdbg\vs2017u5 exists, deleting.

下面说说解决方案下载包

1	https://vsdebugger.azureedge.net/vsdbg-(你的版本号.号换成-号)/vsdbg-(你的Runtime ID).zip

例如我的

https://vsdebugger.azureedge.net/vsdbg-16-0-20412-1/vsdbg-linux-x64.zip

下载之后解压到你的安装路径

例如我的

-InstallPath "C:\Users\MESTC\vsdbg\vs2017u5"

然后在该文件下添加一个<em>success_rid.txt文件,内容为</em>你的Runtime ID

例如我的linux-x64

还要添加一个success_version.txt文件,内容为你的版本号,如16.0.20412.1

重启 visual studio

下面还会下载另一个,相同的处理方式,再重启一次就ok了

使用 Docker 排查 Visual Studio 开发方面的问题

未启用卷共享。启用“Docker CE for Windows”设置中的卷共享（仅 Linux 容器）若要解决此问题，请执行以下操作：右键单击通知区域中的“Docker for Windows” ，并选择“设置” 。选择“共享驱动器” ，并共享系统驱动器和项目所在的驱动器。备注如果文件显示“已共享”，可能仍需要单击对话框底部的“重置凭据…”链接，以便重新启用卷共享。若要在重置凭据后继续，可能必须重启 Visual Studio。提示如果未配置共享驱动器，Visual Studio 2017 版本 15.6 之后的版本会发出提示。容器类型向项目添加 Docker 支持后，请选择 Windows 或 Linux 容器。 Docker 主机必须运行类型相同的容器。要更改正在运行的 Docker 实例中的容器类型，请右键单击系统托盘中的 Docker 图标，再选择“切换到 Windows 容器…”或“切换到 Linux 容器…” 。无法开始调试其中一个原因可能与在用户配置文件的文件夹中有过时调试组件有关。请执行以下命令来删除这些文件夹，以便在下次调试会话上下载最新调试组件。 del %userprofile%\vsdbg del %userprofile%\onecoremsvsmon 调试应用程序时特定于网络的错误尝试执行可从清理容器主机网络下载的脚本，此操作会刷新主机上的网络相关组件。装载被拒绝使用 Docker for macOS 时，可能会遇到引用文件夹 /usr/local/share/dotnet/sdk/NuGetFallbackFolder 错误。将文件夹添加到 Docker 中的“文件共享”选项卡 Docker 用户组使用容器时，可能会在 Visual Studio 中遇到以下错误：复制

The current user must be in the 'docker-users' group to use Docker Desktop.

Add yourself to the 'docker-users' group and then log out of Windows.

必须是“docker-users”组的成员，才有使用 Docker 容器的权限。若要将自己添加到 Windows 10 中的组，请执行以下步骤：从“开始”菜单中，打开“计算机管理” 。展开“本地用户和组”，并选择“组” 。找到“docker-users”组，右键单击并选择“添加到组” 。添加用户帐户或帐户。注销后再次登录，以使更改生效。还可以在管理员命令提示符下使用 net localgroup 命令向特定组添加用户。 cmd复制

1 2	<span class="hljs-built_in">net</span> localgroup docker-users DOMAIN\username /add

[…]

龙生 28 Oct 2020

View Details

【C# DateTime】如何一次性修改DateTime的默认ToString格式

【问题】网站项目里经常用到DateTime类型变量，要求所有日期时间类型格式标准为“yyyy-MM-dd HH:mm:ss”，但默认Tostring格式为 yyyy-M-d H:m:s ,没有前置0，需要修改【分析】 1、修改代码里所有DateTime类型的Tostring为 ToString("yyyy-MM-dd HH:mm:ss"),不方便 2、找见统一的修改地方， Thread.CurrentThread.CurrentCulture = new CultureInfo("zh-CN", true) { DateTimeFormat = { ShortDatePattern = "yyyy-MM-dd", FullDateTimePattern = "yyyy-MM-dd HH:mm:ss" }; 发现不起作用经分析DateTimeFormat 类的属性，发现 LongTimePattern 起作用【结论】增加 LongTimePattern 属性

Thread.CurrentThread.CurrentCulture = new CultureInfo("zh-CN", true) {

DateTimeFormat = { ShortDatePattern = "yyyy-MM-dd", FullDateTimePattern = "yyyy-MM-dd HH:mm:ss", LongTimePattern ="HH:mm:ss"}

};

from:https://blog.csdn.net/onemetre/article/details/52042907

龙生 27 Oct 2020

View Details

vs 2019 显示方法被调用次数

VS 是一个很强大的编译器以前都是根据方法名Ctrl+F 搜索很不方便但VS已经有方便的提示功能了设置方法工具>>文本文本编译器>>所有语言>>CodeLens >> 选择启用Code了Lens from:https://blog.csdn.net/q465162770/article/details/104039869

龙生 14 Oct 2020

View Details

C# this关键字的四种用法(转)

用法一 this代表当前类的实例对象

namespace Demo

{

public class Test

{

private string scope = "全局变量";

public string getResult()

{

string scope = "局部变量";

　　　　　　　// this代表Test的实例对象

　　　　　　　// 所以this.scope对应的是全局变量

　　　　　　 // scope对应的是getResult方法内的局部变量

return this.scope + "-" + scope;

}

class Program

{

static void Main(string[] args)

{

try

{

Test test = new Test();

Console.WriteLine(test.getResult());

}

catch (Exception ex)

{

Console.WriteLine(ex);

}

finally

{

Console.ReadLine();

}

用法二用this串联构造函数

namespace Demo

{

public class Test

{

public Test()

{

Console.WriteLine("无参构造函数");

}

// this()对应无参构造方法Test()

　　　　 // 先执行Test()，后执行Test(string text)

public Test(string text) : this()

{

Console.WriteLine(text);

Console.WriteLine("有参构造函数");

}

class Program

{

static void Main(string[] args)

{

try

{

Test test = new Test("张三");

}

catch (Exception ex)

{

Console.WriteLine(ex);

}

finally

{

Console.ReadLine();

}

用法三为原始类型扩展方法

namespace Demo

{

public static class Extends

{

　　　　 // string类型扩展ToJson方法

public static object ToJson(this string Json)

{

return Json == null ? null : JsonConvert.DeserializeObject(Json);

}

// object类型扩展ToJson方法

public static string ToJson(this object obj)

{

var timeConverter = new IsoDateTimeConverter { DateTimeFormat = "yyyy-MM-dd HH:mm:ss" };

return JsonConvert.SerializeObject(obj, timeConverter);

}

public static string ToJson(this object obj, string datetimeformats)

{

var timeConverter = new IsoDateTimeConverter { DateTimeFormat = datetimeformats };

return JsonConvert.SerializeObject(obj, timeConverter);

}

public static T ToObject<T>(this string Json)

{

return Json == null ? default(T) : JsonConvert.DeserializeObject<T>(Json);

}

public static List<T> ToList<T>(this string Json)

{

return Json == null ? null : JsonConvert.DeserializeObject<List<T>>(Json);

}

public static DataTable ToTable(this string Json)

{

return Json == null ? null : JsonConvert.DeserializeObject<DataTable>(Json);

}

public static JObject ToJObject(this string Json)

{

return Json == null ? JObject.Parse("{}") : JObject.Parse(Json.Replace(" ", ""));

}

class Program

{

static void Main(string[] args)

{

try

{

List<User> users = new List<User>{

new User{ID="1",Code="zs",Name="张三"},

new User{ID="2",Code="ls",Name="李四"}

};

// list转化json字符串

string json = users.ToJson();

　　　　　　　　　 // string转化List

users = json.ToList<User>();

// string转化DataTable

DataTable dt = json.ToTable();

}

catch (Exception ex)

{

Console.WriteLine(ex);

}

finally

{

Console.ReadLine();

}

public class User

{

public string ID { get; set; }

public string Code { get; set; }

public string Name { get; set; }

}

用法四索引器（基于索引器封装EPList，用于优化大数据下频发的Linq查询引发的程序性能问题，通过索引从list集合中查询数据）

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

using System;

using System.Collections.Generic;

using System.Linq;

using System.Reflection;

using System.Text;

namespace MyDemo.Web

{

/// <summary>

/// EPList 支持为List创建索引

/// </summary>

/// <typeparam name="T">类型</typeparam>

public class EPList<T>

{

#region 成员变量

/// <summary>

/// 索引

/// </summary>

private List<string[]> m_Index = new List<string[]>();

/// <summary>

/// 缓存数据

/// </summary>

private Dictionary<string, List<T>> m_CachedData = new Dictionary<string, List<T>>();

/// <summary>

/// List数据源

/// </summary>

private List<T> m_ListData = new List<T>();

/// <summary>

/// 通过索引值取数据

/// </summary>

/// <param name="indexFields">索引字段</param>

/// <param name="fieldValues">字段值</param>

/// <returns></returns>

public List<T> this[string[] indexFields]

{

get

{

string key = string.Join(",", indexFields);

if (m_CachedData.ContainsKey(key)) return m_CachedData[key];

return new List<T>();

}

#endregion

#region 公共方法

/// <summary>

/// 创建索引

/// </summary>

/// <param name="indexFields">索引字段</param>

public void CreateIndex(string[] indexFields)

{

if (m_Index.Contains(indexFields)) return;

m_Index.Add(indexFields);

}

/// <summary>

/// 添加

/// </summary>

/// <param name="record">记录</param>

public void Add(T record)

{

m_ListData.Add(record);

m_Index.ForEach(indexFields =>

{

string key = getKey(record, indexFields);

if (m_CachedData.ContainsKey(key))

{

m_CachedData[key].Add(record);

}

else

{

List<T> list = new List<T> { record };

m_CachedData.Add(key, list);

}

});

}

#endregion

#region 私有方法

/// <summary>

/// 获取值

/// </summary>

/// <param name="record">记录</param>

/// <param name="fieldName">字段名</param>

/// <returns></returns>

private object getValue(T record, string fieldName)

{

Type type = typeof(T);

PropertyInfo propertyInfo = type.GetProperty(fieldName);

return propertyInfo.GetValue(record, null);

}

/// <summary>

/// 获取Key

/// </summary>

/// <param name="record">记录</param>

/// <param name="indexFields">索引字段</param>

private string getKey(T record, string[] indexFields)

{

List<string> values = new List<string>();

foreach (var field in indexFields)

{

string value = Convert.ToString(getValue(record, field));

values.Add(field + ":" + value);

}

return string.Join(",", values);

}

/// <summary>

/// 获取Key

/// </summary>

/// <param name="indexFields">索引字段</param>

/// <param name="fieldValues">字段值</param>

/// <returns></returns>

private string getKey(string[] indexFields, object[] fieldValues)

{

if (indexFields.Length != fieldValues.Length) return string.Empty;

for (int i = 0; i < indexFields.Length; i++)

{

fieldValues[i] = indexFields[i] + ":" + fieldValues[i];

}

string key = string.Join(",", fieldValues);

return key;

}

#endregion

}

给EPList创建索引，并添加数据

private EPList<SysDepartInfo> GetEPListData()

{

EPList<SysDepartInfo> eplist = new EPList<SysDepartInfo>();

eplist.CreateIndex(new string[] { "ParentId" });

string sql = "select Id,ParentId,Code,Name from SysDepart";

SqlHelper.ExecuteReader(sql, null, (reader) =>

{

SysDepartInfo record = new SysDepartInfo();

record.Id = Convert.ToString(reader["Id"]);

record.ParentId = Convert.ToString(reader["ParentId"]);

record.Code = Convert.ToString(reader["Code"]);

record.Name = Convert.ToString(reader["Name"]);

eplist.Add(record);

});

return eplist;

}

通过索引高效查询数据

/// <summary>

/// 获取子节点

/// </summary>

/// <param name="data"></param>

/// <param name="parentId"></param>

private IEnumerable<TreeInfo> CreateChildren(EPList<SysDepartInfo> data, TreeInfo node)

{

string id = node == null ? "0" : node.id;

List<TreeInfo> childNodes = new List<TreeInfo>();

// ParentId字段上创建了索引，所以这里就可以通过索引值直接取出下一层子节点数据，避免Linq查询引发的效率问题

var indexValues = new string[] { "ParentId:" + id };

var childData = data[indexValues];

childData.ForEach(record =>

{

var childNode = new TreeInfo

{

id = record.Id,

text = record.Code + " " + record.Name

};

childNodes.Add(childNode);

childNode.children = CreateChildren(data, childNode);

});

return childNodes.OrderBy(record => record.text);

}

from:https://www.cnblogs.com/yellowcool/p/7908607.html

龙生 27 Aug 2020

View Details

« Previous 1 … 4 5 6 … 48 Next »

April 2024
M	T	W	T	F	S	S
« Mar
1	2	3	4	5	6	7
8	9	10	11	12	13	14
15	16	17	18	19	20	21
22	23	24	25	26	27	28
29	30