Web Forms :: Display A Record Count From Sql Database Connection?
Oct 29, 2010
sometimes learning asp.net feels so heavy handed compared to some of the general purpose scripting languages like php. for examples, all i want to do is create a sql connection that pulls a row count and displays that number. I don't need a grid, list, detail page, etc., nothing this heavy... a simply query that will display a simple bit of text. for the life of me I can't figure out how to do it. Using these controls, I'm not in the code behind with the query, so I wouldn't attach this to a label (or would i), and there's nothing i see in the toolbox that does what i want. Perhaps i'm too accustomed to php but it feels like with asp.net, major things are simple, and simple things are hard.
I am counting from a table for that i have written code as below
protected void get_Id_Afterpoint() { int counter = 0; string strSql = "select count(*) as ID from tblEnergy where ID=?"; OdbcCommand com = new OdbcCommand(strSql, con); com.Parameters.AddWithValue("ID", DropDownList1.SelectedValue); OdbcDataAdapter oda = new OdbcDataAdapter(com); DataTable dt = new DataTable(); oda.Fill(dt); if (dt.Rows.Count == 0) { lblID2.Text = "1"; } else { counter = dt.Rows.Count; counter = counter + 1; lblID2.Text = Convert.ToString(counter); } }
there is no record related to DropDownList1.SelectedValue. but as i am counting if(dt.rows.count) and i put break point on the bolded part it shows 1 record. how it can be possible?
I have one div in my page i want show my store information in that div from DB
Name:Itally mall
Address:Italy
Tel:123456879
Description:test test test
It is just one time per page how i can do it?I know that i can use gridview,datalist but here i just need read my data just 1 time from DB i dont want repeat it so what can i do?
I HAVE A GRID VIEW IN asp.net + VB Code. There is a drop down list and the selected data is displayed in web page. I placed a label in web page and code behind i used following code.
Protected Sub GridView1_DataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles GridView1.DataBound Label1.Text = GridView1.Rows.Count.ToString() Dim ONYO As Integer = 0 Dim DONE As Integer = 0 For i As Integer = 0 To GridView1.Rows.Count - 1 If GridView1.Rows(i).Cells(0).Text = "ON YO" Then
I am creating a web app that using a DataList for display and editing purposes. A datareader is used to populate the DataList. I have the total number of records in the Datalist being displayed in the Footer. In the DataList, I have a checkbox. How can I iterate thru each record in the Datalist to get the number of checkboxes that are checked?
I'm writing an update script that goes through each record and performs various updates, and I want the current record to display while it's processing.
For Each row As DataRow In DS.Tables(0).Rows
'Label Inside Ajax Panel Label_Ajax.Text = row.Item("product_id").ToString 'Label Inside Ajax Update Progress Panel Dim newlabel As Label = UpdateProgress1.FindControl("Label_AjaxProgress") newlabel.Text = row.Item("product_id").ToString ' Tried straight to console, but doesn't work Console.Write(row.Item("product_id").ToString)
Next
I've tried all three methods shown above, but they all end up displaying the last record after the iteration is complete. How can I get the current record to display on the screen during the iteration?
Protected Sub movebtn_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles movebtn.Click Dim con As New SqlConnection con.ConnectionString = ConfigurationManager.ConnectionStrings("26ConnectionString").ConnectionString con.Open() If persno.Text = "" Then Page.ClientScript.RegisterStartupScript(Me.GetType, "Forms", "<script> alert('Enter Pers No of Offr ..........') </script>")
[Code] ....
I want to add a confirmation before deleting the data and popup message box...
i m doing when i enter travel id in textbox1 and click on button1 then in textbox2 i retrieve the travel agency name according to the travel id i entered in textbox1, I want when no record is found according to the travel id i entered in textbox1 then in textbox2 it shows the message no record found ...this is coding i use to retrieve record in textbox2 by enter travel id in textbox1 : have a look ...
Protected Sub Button4_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button4.Click Dim SQLData As New System.Data.SqlClient.SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|ASPNETDB.MDF;Integrated Security=True;User Instance=True") Dim cmdSelect As New System.Data.SqlClient.SqlCommand("SELECT * FROM a1_vendors WHERE VendorId ='" & TextBox1.Text & "'", SQLData) SQLData.Open() Dim dtrReader As System.Data.SqlClient.SqlDataReader = cmdSelect.ExecuteReader() [code]...
I want to display all records from database in gridview when pageload and also i wanna search for particular record using textbox appear in my webform .
Means by default all records from the table will appear in gridview using sqldatasource and i also wanna search for a particular record by enter ID in text box ...
I am using VS2008 and oracle 10g ODP.Net. The oracle database that I used in the connection is working and tested it using sql plus.The connection string when used in a GriDView works perfectly. Now when I created a new listview control with the same connection it gives an error.Database schema could not be retrieved for this connection. Please make sure connection settings are correct and the database is online
Object reference not set to an instance of an object at VSDataObjectSupport (478,6)
General Info:Aspx page holds an Ascx User control. Inside the User control, the Repeater is contained inside a View, contained inside a Multiview. Asp.Net 2.0 framework / C#
Details:I have a repeater(inside an ascx user control) that shows records, and the first column is a checkbox. If checked, that row will be deleted.OUtside the repeater, I have a button that will deleted all rows that are checked.Everything works fine, but have been asked to add a pop up "confirm delete" message that includes the number of records that will be deleted if the user clicks "Ok" on the pop up.
Something like: "You are about to delete 8 records".
Currently my button looks like this:
<asp:Button ID="btnDeleteAllRecords" runat="server" Text="Delete all Checked Records" Onclick="btnDeleteAllRecords_Click" OnClientClick="javascript:GetCbCount();" />
I have this javascript code block:<script type="text/javascript"> function GetCbCount() { var cb = document.getElementById("rptrVoicemail").getElementsByTageName("input"); [code]....
<asp:SqlDataSource ID="totalcount" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT COUNT ([CID]) FROM [WWAMembers] WHERE([CID] IS NOT NULL)"></asp:SqlDataSource>
how do I get the totals displayed with label or other control?
i am using sql 2005 db and visualstudio 2005. i have created a table called attendance where i store employee attendance, i want to separate number of absence for a particular employee and particular month. It have to show number of absence of a particular employee and particular month. Also i have to count no of absence.for eg: if an employee absence for two days for a particular month, it have to display2 count.. how to do this? also how to write the store procedure for this? I have to display the number of count from db to vb.net form..I have display the number of absence from db to form using label or text box.. please forward some coding regarding this..
