我想在Web服务上使用SQL，但我的错在哪里？

问题描述

我无法读取参数zyd，实际上是b。我怎么读这个？我找不到任何问题。但我认为有逻辑问题。我的SQL表 - > KullaniciAdi | Sifre

a | b

NULL | NULL

I can't read parameter "zyd" and actually "b" . How can I read this? I cant find any problem. But I think have logical problem. My SQL table--> KullaniciAdi | Sifre
a | b
NULL | NULL

static string zyd;
[WebMethod]
public void deneme()
{
    string b="a";
    string KullaniciAdi = "a";
    string connect = "Data Source=BERKAY-PC\\SQLEXPRESS;Initial Catalog=Hastahane;Integrated Security=True;";
    SqlConnection deneme = new SqlConnection(connect);
    SqlCommand komut = new SqlCommand("SELECT * FROM Giris where KullaniciAdi='" + KullaniciAdi + "'order by KullaniciAdi desc", deneme);

    try
    {
        deneme.Open();
        SqlDataReader oku = komut.ExecuteReader();
        while (oku.Read())
        {
            b = oku["Sifre"].ToString();
        }
    }
    finally
    {
        deneme.Close();
        komut.Dispose();
    }
    zyd=b;
}

推荐答案

这篇关于我想在Web服务上使用SQL，但我的错在哪里？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！