能不能帮修改下代码。。。。一直报错

[peishaosong198084]

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Data.SqlTypes;


namespace yifeiapp1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void label1_Click(object sender, EventArgs e)
        {

        }

        private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection("server=" + textBox1.Text + ";database=DSCSYS ;Uid = " + textBox2.Text + "; Pwd = " + textBox3.Text + "");

            string sqlstr = "CREATE FUNCTION [dbo].[DecodePwd]" +
             "(@user nvarchar(32),@userPwd nvarchar(128))" +
             "RETURNS nvarchar(128) " +
             "AS  " +
             "BEGIN " +
             "DECLARE @Return NVARCHAR(128) " +
             "SET @Return = '' " +
             "DECLARE @KeyLen INT, @i INT,@n1 INT, @n2 INT " +
             "DECLARE @FStr1 CHAR(1),@FStr2 CHAR(1),@FStr3 CHAR(1),@FStr4 CHAR(1) " +
             "DECLARE @fnil nvarchar(128),@FF1 NVARCHAR(128) "+
             "SET @fnil ='(&.&!%&$\"&)\" \",&)$(%#$-$#$$\" "+ 
             "SET @FF1 = !\"#$%&()*+,-./  " +
             "DECLARE @n int, @d int " +
             "DECLARE @Result nvarchar(128) " +
             "SET @i = LEN(@user) " +
             "SET @Result = SUBSTRING(@fnil, (@i - 1) * 2 + 1, 30 - (@i - 1) * 2) " +
             "SET @n = @i - 1 " +
             "WHILE(@n >= 0) " +
             "BEGIN " +
             "SET @i = (ASCII(SUBSTRING(@user, @n + 1, 1)) - 32) % 16 " +
             "SET @d = (ASCII(SUBSTRING(@user, @n + 1, 1)) - 32) / 16 + 1 " +
             "SET @Result = @Result + CHAR(32 + @d + 1) + SUBSTRING(@FF1, @i + 1, 1) " +
             "SET @n = @n - 1 " +
             "END " +
             "SET @KeyLen = 0 " +
             "SET @i = 28 " +
             "WHILE(@i >= 1) " +
             "BEGIN " +
             "IF(SUBSTRING(@userPwd, @i, 1) <> SUBSTRING(@Result, @i, 1)) " +
             "BEGIN " +
             "SET @KeyLen = @i " +
             "BREAK; " +
             "END " +
             "SET @i = @i - 1 " +
             "END " +
             "IF(@KeyLen = 0) RETURN '' " +
             "SET @i = @KeyLen " +
             "WHILE(@i >= 1) " +
             "BEGIN " +
             "IF(@i <= 4) " +
             "BEGIN " +
             "SET @FStr1 = SUBSTRING(@Result, @i, 1) " +
             "SET @FStr3 = SUBSTRING(@userPwd, @i, 1) " +
             "SET @FStr4 = SUBSTRING(@userPwd, 32 - 4 + @i, 1) " +
             "SET @n1 = ASCII(@FStr1) ^ ASCII(@FStr3) " +
             "SET @n2 = ((ASCII(@FStr4) - 32) / 16) " +
             "SET @Return = CHAR((16 * @n2) + 32 + @n1) + @Return " +
             "SET @FStr4 = CHAR((ASCII(@FStr4) % 16) + 32) " +
             "SET @userPwd = SUBSTRING(@userPwd, 1, 32 - 4 + @i - 1) + @FStr4 + SUBSTRING(@userPwd, 32 - 4 + @i + 1, 4 - @i) " +
             "END " +
             "ELSE " +
             "BEGIN " +
             "SET @FStr1 = SUBSTRING(@Result, @i, 1) " +
             "SET @FStr3 = SUBSTRING(@userPwd, @i, 1) " +
             "SET @FStr4 = SUBSTRING(@userPwd, @i - 4, 1) " +
             "SET @n1 = ASCII(@FStr1) ^ ASCII(@FStr3) " +
             "SET @n2 = ((ASCII(@FStr4) - 32) / 16) " +
             "SET @Return = CHAR((16 * @n2) + 32 + @n1) + @Return " +
             "SET @FStr4 = CHAR((ASCII(@FStr4) % 16) + 32) " +
             "SET @userPwd = SUBSTRING(@userPwd, 1, @i - 4 - 1) + @FStr4 + SUBSTRING(@userPwd, @i - 4 + 1, 32 - @i + 4) " +
             "END " +
             "SET @i = @i - 1 " +
             "END " +
             "RETURN @Return  " +
             "End"  ;
               
             
            SqlCommand cmd = new SqlCommand(sqlstr,con);
            cmd.Connection = con;
            cmd.CommandText = sqlstr;
            cmd.CommandType = CommandType.Text;
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();



        }

        private void button2_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection("server=" + textBox1.Text + ";database=DSCSYS ;Uid = " + textBox2.Text + "; Pwd = " + textBox3.Text + "");
            SqlDataAdapter da = new SqlDataAdapter("SELECT MA001 as 用户名, dbo.DecodePwd(MA001,MA003) as 密码 from DSCMA", con);
            DataSet ds = new DataSet();
            da.Fill(ds);
            
            DataTable dtb = ds.Tables[0];
            
            dataGridView1.DataSource = dtb;
            con.Close();
            






        }

        private void Form1_Load(object sender, EventArgs e)
        {

        }
    }
}

[datafansbj]

把要执行的 SQL 语句，，在调试状态下复制出来，放在数据库管理工具里，看看能不能执行。这是个基本的调试技巧。

[peishaosong198084]

我就是 按照SQL工具里能执行的 语句想通过C#实现，不知道哪里搞错了。。

[peishaosong198084]

我就是根据SQL工具里能执行的语句想通过C＃实现，不知道哪里搞错了。

[csdnFUCKINGSUCKS]

这是你拼接出来的语句

[peishaosong198084]

非常感谢楼上的，貌似搞定了，

[langth-time]

函数为什么要在代码上执行来创建，不应该是调用就行了么，你报的错误该不会是该函数已经存在吧！我没怎么用过函数，都用存储过程

[孤独de猫]

直接把sql 放在txt里面，然后用string.format 格式下就成了。这样找调试比较费劲。

[圣殿骑士18]

你这样太累了，把sql存文件里来读取。

[大葡萄八块一斤]

你函数直接在数据库建好，然后就可以调用了，你如果是做测试练习就随便你了，不过，你执行建立函数可以先执行个判断，存在函数先进行删除再新建，或者函数存在了的话就不做新建

IF OBJECT_ID('dbo.DecodePwd') IS NOT NULL
	DROP FUNCTION dbo.DecodePwd