1. sayfa
<asp:DataList ID="dlKullanici" runat="server" Width="100%"> <HeaderTemplate> <table class="display data_tbl"> <thead> <tr> <th>User Name </th> <th>Name </th> <th>Address </th> <th>Email </th> <th>Thumb </th> <th>Status </th> <th>Action </th> </tr> </thead> </HeaderTemplate> <ItemTemplate> <tbody> <tr> <td> <a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=74883991&url=#" data-href="#"><%#Eval("AdSoyad") %></a> </td> <td> <a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=74883991&url=#" data-href="#">Jhon Doe</a> </td> <td>Address Line </td> <td class="center">jhon@hostname.com </td> <td class="center"> <div class="user-thumb"> <a href="#"> <img height="40" width="40" alt="User" src="images/user-thumb1.png"></a> </div> </td> <td class="center"> <span class="badge_style b_done">New</span><span class="badge_style b_pending">Pending</span> </td> <td class="center"> <span><a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=74883991&url=#" title="Edit" data-href="#" title="Edit">Edit</a></span><span><a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=74883991&url=#" title="delete" data-href="#" title="delete">Delete</a></span><span><a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=74883991&url=#" title="Approve" data-href="#" title="Approve">Approve</a></span><span><a data-test="test" rel="nofollow" style="word-wrap: break-word; text-decoration: underline;" target="_blank" onclick="return dhExternalLinkRedirect(this)" href="/ExternalLinkRedirect?module=pgdcode&messageId=74883991&url=#" title="Suspend" data-href="#" title="Suspend">Suspend</a></span> </td> </tr> </tbody> </ItemTemplate> </asp:DataList>
DataRow drKullanici = baglanti.GetDataRow("select GrupID from KullaniciGrup where GrupAdi='" + "Yönetici" + "'"); DataTable dtKullanici = baglanti.GetDataTable("SELECT dbo.Kullanici.*, dbo.Engel.EngelAdi, dbo.KullaniciGrup.GrupAdi FROM dbo.KullaniciGrup INNER JOIN dbo.Kullanici ON dbo.KullaniciGrup.GrupID = dbo.Kullanici.GrupID CROSS JOIN dbo.Engel where dbo.Kullanici.GrupID=" + drKullanici["GrupID"].ToString()); dlKullanici.DataSource = dtKullanici; dlKullanici.DataBind();
sitemi debug ettiğimde aldığım ilk hata
http://n1305.hizliresim.com/19/7/mutmf.png
ikinci hata databasede 1 kayıt var ama 2 kayıt geliyor
http://o1305.hizliresim.com/19/7/mutp5.png
datalist kodu
.cs kodlarımda bunlar