SQL DataReader İle Birden Fazla Kayıt Değişkeni Oluşturma ve Zamana Bağlı Güncelleme

C# Tarafı

string cs1 = ConfigurationManager.ConnectionStrings["musteriCS"].ConnectionString; protected void Timer1_Tick(object sender, EventArgs e) { string saat = DateTime.Now.ToLongTimeString(); Label5.Text = saat; if (saat == "11:00:10") { SqlConnection baglanti1 = new SqlConnection(cs1); SqlCommand cmd1 = new SqlCommand("TRUNCATE TABLE musteri_sabit", baglanti1); baglanti1.Open(); cmd1.ExecuteNonQuery(); baglanti1.Close(); SqlConnection baglanti2 = new SqlConnection(cs1); SqlCommand cmdcek = new SqlCommand("SELECT TOP 10 DEFINITION_ , TCNO_VERGINO FROM DELL_MUSTERI", baglanti2); baglanti2.Open(); SqlDataReader dr = cmdcek.ExecuteReader(); while (dr.Read()) { string def_degiskeni = dr["DEFINITION_"].ToString(); string tcvergi_degiskeni = dr["TCNO_VERGINO"].ToString(); SqlConnection baglantiekle = new SqlConnection(cs1); SqlCommand eklecmd = new SqlCommand("insert into musteri_sabit (musteriadi,tcno_vergino) values('" + def_degiskeni + "','" + tcvergi_degiskeni + "')", baglantiekle); baglantiekle.Open(); eklecmd.ExecuteNonQuery(); baglantiekle.Close(); } dr.Close(); baglanti2.Close(); Response.Redirect("sqldeneme.aspx"); }

ASP Tarafı

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:musteriCS %>" SelectCommand="SELECT * FROM [musteri_sabit]"></asp:SqlDataSource> <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:musteriCS %>" SelectCommand="SELECT TOP 10 * FROM [DELL_MUSTERI]"></asp:SqlDataSource> <asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager> <asp:Timer ID="Timer1" Interval="1000" runat="server" OnTick="Timer1_Tick"></asp:Timer> <asp:UpdatePanel runat="server" id="TimedPanel" updatemode="Conditional"> <Triggers> <asp:AsyncPostBackTrigger controlid="Timer1" eventname="Tick" /> </Triggers> <ContentTemplate> <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label> </ContentTemplate> </asp:UpdatePanel>

Hiç yorum yok:

Yorum Gönder