|
 Those articles helped me a couple of years ago.
David
|
|
|
|
|
Then you came to the right place. There are many articles on this site that you can go through and even filter down to what you are specifically looking for. And if you get stuck on something specific you can ask in the QA section.
Good luck to you.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
|
hello
I have a problem.please help me.
my program works without ScriptManagerProxy correctly in the page of product.ascx but with it doesn't work! why?
the source of program is available in below:
example
|
|
|
|
|
Please remember that we all do our work entirely voluntary, and most of us do not download zip-Files posted in a Forum because of the risk that it may include a virus.
If you post the code you are referring to (in the appropriate <pre> - tags) you are going to receive a broader feedback, and it is more likely that someone can help you with your issue.
Veni, vidi, caecus | Everything summarizes to Assembly code
|
|
|
|
|
OK!
the .aspx page
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<%@ Register src="admin/productions.ascx" tagname="Product" tagprefix="uc1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<uc1:Product ID="Product1" runat="server" />
</div>
</form>
</body>
</html>
the .ascx page
<%@ Control Language="C#" AutoEventWireup="true" CodeFile="Productions.ascx.cs" Inherits="Admin_Productions" %>
<%@ Import Namespace="System.Data.SqlClient"%>
<%@ Import Namespace="System.Configuration"%>
<asp:ScriptManagerProxy ID="ScriptManagerProxy1" runat="server">
</asp:ScriptManagerProxy>
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<div align="center">
<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True"
DataSourceID="SqlDataSource1" DataTextField="CategoryName"
DataValueField="CategoryID">
</asp:DropDownList><br /><br />
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT * FROM [tbl_ProductCategory]"></asp:SqlDataSource>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
AllowSorting="True" AutoGenerateColumns="False" BackColor="White"
BorderColor="#3366CC" BorderStyle="None" BorderWidth="1px" CellPadding="4"
DataKeyNames="ProductionID" DataSourceID="SqlDataSource2" >
<EmptyDataTemplate>
در این دسته بندی داده ای نیست
</EmptyDataTemplate>
<RowStyle BackColor="White" ForeColor="#003399" />
<Columns>
<asp:CommandField CancelText="انصراف" DeleteText="حذف" EditText="ویرایش"
HeaderText="عملیات" ShowDeleteButton="True" ShowEditButton="True"
UpdateText="بروز رسانی" />
<asp:BoundField DataField="ProductionID" HeaderText="ای دی محصول"
InsertVisible="False" ReadOnly="True" SortExpression="ProductionID" />
<asp:TemplateField HeaderText="ای دی دسته بندی محصول"
SortExpression="ProductionCategoryID">
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server"
Text='<%# Bind("ProductionCategoryID") %>' Enabled="false"></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server"
Text='<%# Bind("ProductionCategoryID") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="ProductionName" HeaderText="نام محصول"
SortExpression="ProductionName" />
<asp:BoundField DataField="Cast" HeaderText="قیمت به تومان"
SortExpression="Cast" />
<%----%>
<asp:TemplateField HeaderText="عکس یا فیلم" SortExpression="ImageFilm">
<EditItemTemplate>
<asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("ImageFilm") %>'></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Image ID="Image1" runat="server" Height="75px" Width="75px" ImageUrl='<%# Bind("ImageFilm") %>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="Comments" HeaderText="توضیحات"
SortExpression="Comments" />
<asp:BoundField DataField="Stock" HeaderText="موجودی" SortExpression="Stock" />
</Columns>
<FooterStyle BackColor="#99CCCC" ForeColor="#003399" />
<PagerStyle BackColor="#99CCCC" ForeColor="#003399" HorizontalAlign="Left" />
<SelectedRowStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
<HeaderStyle BackColor="#003399" Font-Bold="True" ForeColor="#CCCCFF" />
</asp:GridView>
<br />
<br />
<div dir="rtl">
<%----%> <br />
<table class="style1">
<tr>
<td>
<asp:Label ID="Label2" runat="server" Text="ای دی دسته بندی محصول"></asp:Label>
</td>
<td>
<asp:DropDownList ID="DropDownList2" runat="server" AutoPostBack="True"
DataSourceID="SqlDataSource1" DataTextField="CategoryName"
DataValueField="CategoryID">
</asp:DropDownList>
</td>
</tr>
<tr>
<td>
<asp:Label ID="Label3" runat="server" Text="نام محصول"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtProName" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"
ControlToValidate="txtProName" Display="Dynamic"
ErrorMessage="نام محصول را وارد نکرده اید" SetFocusOnError="True">*</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>
<asp:Label ID="Label4" runat="server" Text="قیمت"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtCast" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server"
ControlToValidate="txtCast" Display="Dynamic"
ErrorMessage="قیمت را وارد نکرده اید" SetFocusOnError="True">*</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>
<asp:Label ID="Label5" runat="server" Text="عکس یا فیلم"></asp:Label>
</td>
<td>
<asp:FileUpload ID="FileUpload1" runat="server" />
</td>
</tr>
<tr>
<td>
<asp:Label ID="Label6" runat="server" Text="توضیحات"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtComment" runat="server" TextMode="MultiLine"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server"
ControlToValidate="txtComment" Display="Dynamic"
ErrorMessage="توضیحات را وارد نکرده اید" SetFocusOnError="True">*</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>
<asp:Label ID="Label7" runat="server" Text="موجودی"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtStock" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server"
ControlToValidate="txtStock" Display="Dynamic"
ErrorMessage="موجودی را وارد نکرده اید" SetFocusOnError="True">*</asp:RequiredFieldValidator>
</td>
</tr>
</table>
<br />
<%----%>
<%----%>
<asp:Button ID="btnAddProductions" runat="server" Text="اضافه کردن محصولات"
onclick="btnAddProductions_Click" />
<asp:Label ID="lblResult" runat="server" ForeColor="Red"></asp:Label>
<br />
<asp:ValidationSummary ID="ValidationSummary1" runat="server" />
</div>
</div>
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConflictDetection="CompareAllValues"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
DeleteCommand="DELETE FROM [tbl_Production] WHERE [ProductionID] = @original_ProductionID AND [ProductionCategoryID] = @original_ProductionCategoryID AND [ProductionName] = @original_ProductionName AND [Cast] = @original_Cast AND [ImageFilm] = @original_ImageFilm AND [Comments] = @original_Comments AND [Stock] = @original_Stock"
InsertCommand="INSERT INTO [tbl_Production] ([ProductionCategoryID], [ProductionName], [Cast], [ImageFilm], [Comments], [Stock]) VALUES (@ProductionCategoryID, @ProductionName, <a href="/Members/cast">@Cast</a> @ImageFilm, @Comments, <a href="/Members/stock">@Stock</a>"
OldValuesParameterFormatString="original_{0}"
SelectCommand="SELECT * FROM [tbl_Production] WHERE ([ProductionCategoryID] = @ProductionCategoryID)"
UpdateCommand="UPDATE [tbl_Production] SET [ProductionCategoryID] = @ProductionCategoryID, [ProductionName] = @ProductionName, [Cast] = <a href="/Members/cast">@Cast</a> [ImageFilm] = @ImageFilm, [Comments] = @Comments, [Stock] = <a href="/Members/stock">@Stock</a>WHERE [ProductionID] = @original_ProductionID AND [ProductionCategoryID] = @original_ProductionCategoryID AND [ProductionName] = @original_ProductionName AND [Cast] = @original_Cast AND [ImageFilm] = @original_ImageFilm AND [Comments] = @original_Comments AND [Stock] = @original_Stock">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1" Name="ProductionCategoryID"
PropertyName="SelectedValue" Type="Int32" />
</SelectParameters>
<DeleteParameters>
<asp:Parameter Name="original_ProductionID" Type="Int32" />
<asp:Parameter Name="original_ProductionCategoryID" Type="Int32" />
<asp:Parameter Name="original_ProductionName" Type="String" />
<asp:Parameter Name="original_Cast" Type="Decimal" />
<asp:Parameter Name="original_ImageFilm" Type="String" />
<asp:Parameter Name="original_Comments" Type="String" />
<asp:Parameter Name="original_Stock" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="ProductionCategoryID" Type="Int32"/>
<asp:Parameter Name="ProductionName" Type="String" />
<asp:Parameter Name="Cast" Type="Decimal" />
<asp:Parameter Name="ImageFilm" Type="String" />
<asp:Parameter Name="Comments" Type="String" />
<asp:Parameter Name="Stock" Type="Int32" />
<asp:Parameter Name="original_ProductionID" Type="Int32" />
<asp:Parameter Name="original_ProductionCategoryID" Type="Int32" />
<asp:Parameter Name="original_ProductionName" Type="String" />
<asp:Parameter Name="original_Cast" Type="Decimal" />
<asp:Parameter Name="original_ImageFilm" Type="String" />
<asp:Parameter Name="original_Comments" Type="String" />
<asp:Parameter Name="original_Stock" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="ProductionCategoryID" Type="Int32" />
<asp:Parameter Name="ProductionName" Type="String" Size="100"/>
<asp:Parameter Name="Cast" Type="Decimal" />
<asp:Parameter Name="ImageFilm" Type="String" Size="100"/>
<asp:Parameter Name="Comments" Type="String" />
<asp:Parameter Name="Stock" Type="Int32" />
</InsertParameters>
</asp:SqlDataSource>
</ContentTemplate>
</asp:UpdatePanel>
the .ascx.cs page
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.IO;
public partial class Admin_Productions : System.Web.UI.UserControl
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnAddProductions_Click(object sender, EventArgs e)
{
bool fileOK = false;
string[] allow = { ".jpg", ".jpeg", ".gif", ".bmp", ".png" };
string fileExtension = Path.GetExtension(FileUpload1.FileName).ToLower().Trim();
if (FileUpload1.HasFile)
{
for (int i = 0; i < allow.Length; i++)
{
if (fileExtension == allow[i] && FileUpload1.FileBytes.Length < 1048576)
{
fileOK = true;
}
}
}
if (fileOK==true)
{
FileUpload1.PostedFile.SaveAs(Server.MapPath("~/images/"+FileUpload1.FileName));
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["cn"].ConnectionString);
string query = "insert into tbl_production values (@proCatId,@proName,@proCast,@proPic,@proComment,@proStock)";
SqlCommand cm = new SqlCommand(query, cn);
cm.Parameters.AddWithValue("proCatId", DropDownList2.SelectedValue);
cm.Parameters.AddWithValue("proName", txtProName.Text.Trim().ToLower());
cm.Parameters.AddWithValue("proCast", txtCast.Text.Trim());
cm.Parameters.AddWithValue("proPic", "~/images/"+FileUpload1.FileName.Trim().ToLower());
cm.Parameters.AddWithValue("proComment", txtComment.Text);
cm.Parameters.AddWithValue("proStock", txtStock.Text);
cn.Open();
cm.ExecuteNonQuery();
lblResult.Text = "registered";
cn.Close();
}
else
{
lblResult.Text = "incorrect";
}
}
}
|
|
|
|
|
If you are expecting people to help you with this then you need to explain exactly what the problem is and where in all that code it occurs. Just dumping your code and saying "it does not work" is not enough.
Veni, vidi, abiit domum
|
|
|
|
|
OK but i said that what problem is.
I have three page.
The default page and one user control and third ,code behind of the user control that i have put it in previous post.
My program work correctly without the ScriptManagerProxy (without Ajax) but with it doesn't work.(in the .ascx page).
<asp:ScriptManagerProxy ID="ScriptManagerProxy1" runat="server">
</asp:ScriptManagerProxy>
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<%--------my code--------%>
</ContentTemplate>
</asp:UpdatePanel>
If i remove the Ajax tag that have put above,my program hasn't any problem BUT if put it ,doesn't work properly.
now do you help me?![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
modified 2-Jan-14 5:59am.
|
|
|
|
|
Sorry, I'm not an ASP expert. I was merely suggesting that you need to provide full details of your problem if you want people to help you. Don't assume that people can guess what you are doing.
Veni, vidi, abiit domum
|
|
|
|
|
see,my problem exactly is that my program without putting the ScriptManagerProxy hasn't any problem and works properly.but with it doesn't work.
"doesn't work" is in other word,not that my program has an error,no,only works bad.(i haven't a syntax error while have a runtime error only and only for the ScriptManagerProxy tag )
for more explanations:
in the code below,if we haven't ScriptManagerProxy tag in the page,we can to enter the values in the fiels and press the button to sends the values.but if we put ScriptManagerProxy tag in the page,the program isn't able to send the values because says FileUpload1.HasFile is false (fileupload1 is empty)then the if condition isn't true therefore my Query doesn't run.i hope to explain properly.
<table class="style1">
<tr>
<td>
<asp:Label ID="Label2" runat="server" Text="ای دی دسته بندی محصول"></asp:Label>
</td>
<td>
<asp:DropDownList ID="DropDownList2" runat="server" AutoPostBack="True"
DataSourceID="SqlDataSource1" DataTextField="CategoryName"
DataValueField="CategoryID">
</asp:DropDownList>
</td>
</tr>
<tr>
<td>
<asp:Label ID="Label3" runat="server" Text="نام محصول"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtProName" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"
ControlToValidate="txtProName" Display="Dynamic"
ErrorMessage="نام محصول را وارد نکرده اید" SetFocusOnError="True">*</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>
<asp:Label ID="Label4" runat="server" Text="قیمت"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtCast" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server"
ControlToValidate="txtCast" Display="Dynamic"
ErrorMessage="قیمت را وارد نکرده اید" SetFocusOnError="True">*</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>
<asp:Label ID="Label5" runat="server" Text="عکس یا فیلم"></asp:Label>
</td>
<td>
<asp:FileUpload ID="FileUpload1" runat="server" />
</td>
</tr>
<tr>
<td>
<asp:Label ID="Label6" runat="server" Text="توضیحات"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtComment" runat="server" TextMode="MultiLine"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server"
ControlToValidate="txtComment" Display="Dynamic"
ErrorMessage="توضیحات را وارد نکرده اید" SetFocusOnError="True">*</asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>
<asp:Label ID="Label7" runat="server" Text="موجودی"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtStock" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server"
ControlToValidate="txtStock" Display="Dynamic"
ErrorMessage="موجودی را وارد نکرده اید" SetFocusOnError="True">*</asp:RequiredFieldValidator>
</td>
</tr>
</table>
<br />
<!---------------------->
<!------------------------------------------------------------------------>
<asp:Button ID="btnAddProductions" runat="server" Text="add productions" onclick="btnAddProductions_Click" />
<!------------------------------------------------------------------------>
<asp:Label ID="lblResult" runat="server" ForeColor="Red"></asp:Label>
<br />
<asp:ValidationSummary ID="ValidationSummary1" runat="server" />
in this code behind file in below,the running of the query is dependent to correctness fileOK variable.
therefore first must FileUpload1.HasFile be true.
when the program runs,and i fill the fields and press the button,the program jumps on "else" and runs
lblResult.Text="the format of the image isn't true";
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.IO;
public partial class Admin_Productions : System.Web.UI.UserControl
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnAddProductions_Click(object sender, EventArgs e)
{
bool fileOK = false;
string[] allow = { ".jpg", ".jpeg", ".gif", ".bmp", ".png" };
string fileExtension = Path.GetExtension(FileUpload1.FileName).ToLower().Trim();
if (FileUpload1.HasFile)
{
for (int i = 0; i < allow.Length; i++)
{
if (fileExtension == allow[i] && FileUpload1.FileBytes.Length < 1048576)
{
fileOK = true;
}
}
}
if (fileOK==true)
{
FileUpload1.PostedFile.SaveAs(Server.MapPath("~/images/"+FileUpload1.FileName));
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["cn"].ConnectionString);
string query = "insert into tbl_production values (@proCatId,@proName,@proCast,@proPic,@proComment,@proStock)";
SqlCommand cm = new SqlCommand(query, cn);
cm.Parameters.AddWithValue("proCatId", DropDownList2.SelectedValue);
cm.Parameters.AddWithValue("proName", txtProName.Text.Trim().ToLower());
cm.Parameters.AddWithValue("proCast", txtCast.Text.Trim());
cm.Parameters.AddWithValue("proPic", "~/images/"+FileUpload1.FileName.Trim().ToLower());
cm.Parameters.AddWithValue("proComment", txtComment.Text);
cm.Parameters.AddWithValue("proStock", txtStock.Text);
cn.Open();
cm.ExecuteNonQuery();
lblResult.Text = "the new production is registered";
cn.Close();
}
else
{
lblResult.Text = "the format of the image isn't true";
}
}
}
modified 2-Jan-14 8:22am.
|
|
|
|
|
How to find curses movement in text box
Suppose i have written like 45hgy
now by command button i want to insert betwenn 45h and gy
like 45hanygy
How
Thanks
|
|
|
|
|
Where are you stuck?
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
hello.. i'm having a problem while binding the values to drop down chosen i'm not getting a search box to enter the text for auto search..please, kindly reply as soon as possible
|
|
|
|
|
Explain your question clearly and post your code snippet
To learn all there is to know. I know I'll be disappointed one day, but I've made a good start, and the eventual disappointment is likely to be brief.
-Roger Wright
Never doubt that a small group of thoughtful, committed people can change the world. Indeed, it is the only thing that ever has.-Margaret Mead
|
|
|
|
|
How can we help?
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
|
Hello friends, thanks for your help so far. Please, I developed a chatroom and is working fine. But the challenge here is that:
I placed the repeater control inside a panel control and set the panel scrollbars to auto. But, the panel couldn't scroll to bottom. Please, how can I make the panel control to always scroll to bottom so that users can see the last message? Please render any help. Cheers!!!
|
|
|
|
|
how to define scafolding in mvc?
|
|
|
|
|
|
IS there much difference between ASP.NET or ASP.NET MVC, or many advantages in one over the other?
Ger
Ger
|
|
|
|
|
|
Hello friend's, how is the day going? I need some help here. In my asp.net website, I have fileupload to browse for zip files and save them to a download files folder. The snippet below save uploaded files
--------------------------------------
'get extension type
Dim ext As string=Path.GetFileNameExtension(fileupload1.PostedFile.Filename)
'get filename
Dim filename As string=Path.GetFileName(fileupload1.PostedFile.Filename)
Select Case Ext 'verify file type
Case ".Zip"
'save file to download files folder
fileupload1.SaveAs(Server.MapPath("~/download files/"+ filename))
Case Else
MsgBox("file format not allowed")
End Select
--------------------------------------
the following save the file name to sql Database
Dim constr=("my connection string is here")
Dim con as new SqlConnection(constr)
con.Open()
Dim SaveFile as String="insert into filestbl(filename,desc) values(@filename,@desc)"
Dim cmd as new SqlCommand(SaveFile,constr)
cmd.Parameters.AddWithValue("@filename",filename)
cmd.Parameters.AddWithValue("@desc",txtdesc.Text)
cmd.ExecuteReader
cmd.Dispose
constr.Dispose
constr.Close
----------------------------------
the question is, how can I enable visitors to specify a folder, and code the download button so that the selected file can be downloaded to a folder specify by the person downloading the file. Note, I bind the filestbl to DatalistControl. And, when the file is downloaded, the person should be able to unzip it in his/her system just as it is in codeproject. I am doing this with Asp.net. Any help is welcome! Thanks to all.
-- modified 30-Dec-13 15:11pm.
|
|
|
|
|
I'm not sure what you asking entirely but if a user clicks on the link to download your file the browser will ask them where to save it. So, what is your question?
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
Hello friends, how was the day? Thanks for your helped so far. Please someone should tell me how to count the number of records in sql table. For example if custtbl with columns cusName, cusLoc, has the following records
---------------------------
cusName cusLoc
Tom USA
Patel India
---------------------------
How can I get the total number of records as two from table above and display it on a msgBox using asp.net? Please help.
|
|
|
|
|
Answer 1:
SqlCommand cmd = new SqlCommand("SELECT COUNT(*) FROM custtbl", databaseConnection);
int count = (int)cmd.ExecuteScalar();
There are a lot of examples on the web on how to write complete data access code in c#. Ask google.
Answer 2: adapt this ASP.Net Message Box Alert Display[^] to display the count value in a message box.
modified 28-Dec-13 10:51am.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
