|
Please tell me the use and implementaion of Roles in asp.net 2.0
Sunil Nair
|
|
|
|
|
website menu / ASP.NET Configuration
and set the rolls for form , user etc.,
and it is added in config.file.
vijaya
|
|
|
|
|
good day everyone...
i need help regarding datatables..
how to use/ or insert records in datatables...
sample codes or link is highly appreciated...
thank you everyone in advance.....
start a new beginning in every ending; thats what life for......
|
|
|
|
|
1. If you want to insert values from the stored procedure, then you will have to call that
procedure and fill the table using SQlDataAdapter
DataTable table = new DataTable();
SqlDataAdapter adapter = new SqlDataAdapter()
adapter.Fill(table);
Else here is a sample code for datatable. (If you really don't know anything about using datatables.
DataTable table = new DataTable();
DataColumn col1 = new DataColumn("select",Type.GetType("System.Boolean"));
DataColumn col2 = new DataColumn("Name", Type.GetType("System.String"));
table.Columns.Add(col1);
table.Columns.Add(col2);
DataRow r1 = table.NewRow();
r1["select"] = true;
r1["Name"] = "Something";
DataRow r2 = table.NewRow();
r2["select"] = false;
r2["Name"] = "nothing";
table.Rows.Add(r1);
table.Rows.Add(r2);
|
|
|
|
|
thank you sir....your help really helps me sir... thank you more than words could express....
start a new beginning in every ending; thats what life for......
|
|
|
|
|
Create a new datatable as
Datatable dt=new Datatable();
whatever columns u would like to insert add them.
if(dt.columns["a"]==null)
dt.columns.add(a);
if(dt.columns["b"]==null)
dt.columns.add(b);
if(dt.columns["c"]==null)
dt.columns.add(c);
DataRow dr = dt.NewRow();
dt.Rows.Add(dr);
dt.AcceptChanges();
nextadd the values into datatable as
dt.rows[0]["a"]=txtbox1.text;
dt.rows[0]["b"]=txtbox2.text;
dt.rows[0]["c"]=txtbox3.text;
|
|
|
|
|
thank you sir/mam, i didnt know how to express my thanks... this is my first time using datatable... and almost all you guys here in forum are really kind and helpful... highly appreciated... thank you very much
start a new beginning in every ending; thats what life for......
|
|
|
|
|
Welcome moomoooomoo..............
Go ahead............
|
|
|
|
|
Hai friends,
I need some information about editable gridview, Please provide.
My question is
i am sending text into one field of database with comma(,) seperated.
I want to retrive that field into editable gridview with different rows each comma seperated word.
i need a editable gridview without showing edit button in asp.net.
Thanking You,
Harinath
|
|
|
|
|
|
Hai
Thanks for providing your suggesion
bye
|
|
|
|
|
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title></title>
<style type="text/css">
.style1
{
width: 119%;
}
.style2
{
width: 119%;
height: 16px;
}
.style14
{
width: 164px;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
</div>
<table border="0" width="100%" >
<tr>
<td width="100%" height="50">
<table height="50px" style="width: 100%">
</table>
</td>
</tr>
<tr>
<td>
<table bgcolor="#666666" width="100%">
<tr>
<td>
<asp:Label ID="Label1" runat="server" Text="Registrant Details"
ForeColor="White"></asp:Label>
</td>
</tr>
<tr>
<td bgcolor="White" height="20">
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table width=100% align="right" style="width: 210px">
<tr align="right" >
<td class="style1" width="100%" align="left">
<asp:Label ID="Label2" runat="server" Text="Registry no"></asp:Label>
</td>
</tr>
<tr align="right">
<td class="style1" align="left">
<asp:Label ID="lblRegNo" runat="server" Text="40013242424" Font-Size="Smaller"></asp:Label>
</td>
</tr>
<tr align="right">
<td class="style1" width="100%" align="left">
<asp:Label ID="Label4" runat="server" Text="Event Date"></asp:Label>
</td>
</tr>
<tr align="right">
<td class="style2" width="100%" align="left">
<asp:Label ID="Label5" runat="server" Text="08/13/2016" Font-Size="Smaller"></asp:Label>
</td>
</tr>
<tr align="right">
<td class="style1" width="100%" align="left">
<asp:Label ID="Label6" runat="server" Text="Pickup Store "></asp:Label>
</td>
</tr>
<tr align="right">
<td class="style2" width="100%" align="left">
<asp:Label ID="Label7" runat="server" Text="St. Albert Centre" Font-Size="Smaller"></asp:Label>
</td>
</tr>
<tr align="right">
<td class="style2" width="100%" align="left">
<asp:Label ID="Label8" runat="server" Text="(000)000-0000" Font-Size="Smaller"></asp:Label>
</td>
</tr>
</table>
</td>
</tr>
<%--for grid--%>
<tr>
<td align="center">
<asp:GridView ID="grdOrders" runat="server" AutoGenerateColumns="false"
Width="1112px" HeaderStyle-BackColor=#CCCCCC ShowFooter="true"
AllowPaging="true" PageSize="5" onrowdatabound="GridView1_RowDataBound" >
<Columns>
<asp:BoundField HeaderText="Qty" DataField="Quantity" ItemStyle-HorizontalAlign="Center" HeaderStyle-Width="10" />
<asp:TemplateField HeaderText="Qty Req'd" ItemStyle-HorizontalAlign="Center" HeaderStyle-Width="20" >
<ItemTemplate>
<asp:Label ID="lblQtyRecvd" runat="server" Text='<%#Eval("QuantityRecieved") %>' />
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField HeaderText="Qty Rec'd" DataField="QuantityRequired" ItemStyle-HorizontalAlign="Center" HeaderStyle-Width="20"/>
<asp:BoundField HeaderText="Description" DataField="SkuName" ItemStyle-HorizontalAlign="left" HeaderStyle-Width="50" />
<asp:TemplateField HeaderText="Price" ItemStyle-HorizontalAlign="Center" HeaderStyle-Width="20" >
<ItemTemplate>
<asp:Label ID="lblDollar" runat="server" Text="$" />
<asp:Label ID="lblPrice" runat="server" Text='<%# (Eval("UnitPrice","{0 ,0.00}")) %>' />
</ItemTemplate>
<FooterTemplate>
<asp:Label ID="lbltxtTotal" runat="server" Text="Sub Total" Font-Bold="True" />
</FooterTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Amount" HeaderStyle-Width="15" ItemStyle-HorizontalAlign="center">
<ItemTemplate >
<asp:Label ID="lblDollar1" runat="server" Text="$" />
<asp:Label ID="lblTotal" runat="server" Text='<%#String.Format("{0:n2}", Convert.ToDouble(Eval("UnitPrice")) * Convert.ToInt64(Eval("Quantity")))%>' />
</ItemTemplate>
<ItemStyle HorizontalAlign="Right" />
<FooterStyle HorizontalAlign="Right" />
<FooterTemplate>
<asp:Label ID="lblDollar1" runat="server" Text="$" Font-Bold="True" />
<asp:Label ID="lbltxtTotalPrice" runat="server" Font-Bold="True" />
</FooterTemplate>
</asp:TemplateField>
<%-- <asp:BoundField HeaderText="Price" DataField="price" ItemStyle-HorizontalAlign="Center" HeaderStyle-Width="20" FooterText="Total Price:"/>
<asp:BoundField HeaderText="total" DataField="total" ItemStyle-HorizontalAlign="left" HeaderStyle-Width="50" }" />--%>
</Columns>
</asp:GridView>
</td>
</tr>
<%-- <asp:BoundField HeaderText="Price" DataField="price" ItemStyle-HorizontalAlign="Center" HeaderStyle-Width="20" FooterText="Total Price:"/>
<asp:BoundField HeaderText="total" DataField="total" ItemStyle-HorizontalAlign="left" HeaderStyle-Width="50" }" />--%> <%--for grid--%><%--last--%>
<tr>
<td width="100%" height="20">
<table height="20px" border="1" align="center" width="1112px">
<tr align="right">
<td align=center class="style14">
<asp:Button ID="btnEmptybag" runat="server" Text="Empty Bag" Height="23px"
Width="95px" />
</td>
<td align="left"
style="font-family: Arial, Helvetica, sans-serif; font-size: small">
when applicable,special promotions and other discounts will be applied to the price(s) when your credit card is charged
</td>
</tr>
</table>
</td>
</tr>
<%-- table ag--%>
<tr>
<td width="100%" height="20">
<table height="50px" border="0" align="center" width="1112px">
<tr align="left">
<td align="left"
style="font-family: Arial, Helvetica, sans-serif; font-size: small">
</td>
<td align=center class="style14">
<asp:Button ID="btnShopping" runat="server" Text="<< Continue Shopping" Height="23px"
Width="145px" />
</td>
</tr>
</table>
</td>
</tr>
<%-- for continue to shopping--%>
</table>
</form>
</body>
</html>
-- modified 19-Sep-13 10:29am.
|
|
|
|
|
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="assignment._Default" %>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<script type="text/javascript">
var TotalChkBx;
var Counter;
window.onload = function () {
TotalChkBx = parseInt('<%= this.grdEmployees.Rows.Count %>');
Counter = 0;
}
function HeaderClick(CheckBox) {
var TargetBaseControl =
document.getElementById('<%= this.grdEmployees.ClientID %>');
var TargetChildControl = "chkBxSelect";
var Inputs = TargetBaseControl.getElementsByTagName("input");
for (var n = 0; n < Inputs.length; ++n)
if (Inputs[n].type == 'checkbox' &&
Inputs[n].id.indexOf(TargetChildControl, 0) >= 0)
Inputs[n].checked = CheckBox.checked;
//Reset Counter
Counter = CheckBox.checked ? TotalChkBx : 0;
}
function ChildClick(CheckBox, HCheckBox) {
//get target control.
var HeaderCheckBox = document.getElementById(HCheckBox);
//Modifiy Counter;
if (CheckBox.checked && Counter < TotalChkBx)
Counter++;
else if (Counter > 0)
Counter--;
//Change state of the header CheckBox.
if (Counter < TotalChkBx)
HeaderCheckBox.checked = false;
else if (Counter == TotalChkBx)
HeaderCheckBox.checked = true;
}
function isDelete() {
return confirm("Do you want to delete this row ?");
}
</script>
</head>
<body>
<form id="form1" runat="server">
<%--for grid--%>
<%-- <asp:boundfield headertext="Price" datafield="price" itemstyle-horizontalalign="Center" headerstyle-width="20" footertext="Total Price:">
<asp:boundfield headertext="total" datafield="total" itemstyle-horizontalalign="left" headerstyle-width="50" }"="">--%><%-- <asp:boundfield headertext="Price" datafield="price" itemstyle-horizontalalign="Center" headerstyle-width="20" footertext="Total Price:">
<asp:boundfield headertext="total" datafield="total" itemstyle-horizontalalign="left" headerstyle-width="50" }"="">--%><%-- <asp:boundfield headertext="Price" datafield="price" itemstyle-horizontalalign="Center" headerstyle-width="20" footertext="Total Price:">
<asp:boundfield headertext="total" datafield="total" itemstyle-horizontalalign="left" headerstyle-width="50" }"="">--%>
<%--for grid--%>
<%--last--%>
<asp:gridview id="grdEmployees" runat="server" autogeneratecolumns="false" width="1112px"
="" headerstyle-backcolor="#CCCCCC" showfooter="true" allowpaging="true" pagesize="5" onrowcommand="grdEmployees_RowCommand" onselectedindexchanged="grdEmployees_SelectedIndexChanged" onrowdatabound="grdEmployees_RowDataBound" onrowdeleting="grdEmployees_RowDeleting">
<columns>
<asp:templatefield headertext="Select">
<itemtemplate>
<asp:checkbox id="chkBxSelect" runat="server">
<HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Width="50px" />
<itemstyle horizontalalign="Center" verticalalign="Middle" width="50px">
<HeaderTemplate>
<asp:checkbox id="chkBxHeader" onclick="javascript:HeaderClick(this);" runat="server">
</HeaderTemplate>
<asp:templatefield headertext="Employee Id" itemstyle-horizontalalign="Center" headerstyle-width="40">
<itemtemplate>
<asp:label id="lblEmpId" runat="server" text="<%#Eval("EmpId") %>">
<HeaderStyle Width="40px"></HeaderStyle>
<itemstyle horizontalalign="Center">
<asp:templatefield headertext="Name" itemstyle-horizontalalign="Center" headerstyle-width="40">
<itemtemplate>
<asp:label id="lblEmpName" runat="server" text="<%#Eval("EmpName") %>">
<HeaderStyle Width="40px"></HeaderStyle>
<itemstyle horizontalalign="Center">
<asp:boundfield headertext="Account" datafield="Account" itemstyle-horizontalalign="Center"
="" headerstyle-width="20">
<HeaderStyle Width="20px"></HeaderStyle>
<itemstyle horizontalalign="Center">
<asp:boundfield headertext="Email" datafield="email" itemstyle-horizontalalign="Center"
="" headerstyle-width="20">
<HeaderStyle Width="20px"></HeaderStyle>
<itemstyle horizontalalign="Center">
<asp:templatefield headertext="Contact No" itemstyle-horizontalalign="Center" headerstyle-width="50">
<itemtemplate>
<asp:textbox id="txtContactNo" runat="server" text="<%#Eval("ContactNo") %>">
<HeaderStyle Width="50px"></HeaderStyle>
<itemstyle horizontalalign="Center">
<asp:templatefield headertext="Experience" itemstyle-horizontalalign="Center" headerstyle-width="10">
<itemtemplate>
<asp:textbox id="txtExp" runat="server" text="<%#Eval("Experience") %>">
<HeaderStyle Width="10px"></HeaderStyle>
<itemstyle horizontalalign="Center">
<asp:templatefield headertext="Skill" itemstyle-horizontalalign="Center" headerstyle-width="20">
<itemtemplate>
<asp:textbox id="txtSkill" runat="server" text="<%#Eval("Skill") %>">
<HeaderStyle Width="20px"></HeaderStyle>
<itemstyle horizontalalign="Center">
<%-- Adding button to gridview --%>
<asp:templatefield headertext="Delete">
<itemtemplate>
<asp:button id="BtnDelete" commandname="dele" runat="server" text="Delete" commandargument="<%# Eval("EmpId") %>" oonclientclick="isDelete()"
="" onclick="BtnDelete_Click">
<%-- <asp:boundfield headertext="Price" datafield="price" itemstyle-horizontalalign="Center" headerstyle-width="20" footertext="Total Price:">
<asp:boundfield headertext="total" datafield="total" itemstyle-horizontalalign="left" headerstyle-width="50" }"="">--%>
<HeaderStyle BackColor="#CC99FF"></HeaderStyle>
|
|
<asp:button id="btnUpdate" runat="server" onclick="btnUpdate_Click" text="Update">
<asp:label id="Label1" runat="server" text="Label">
|
|
|
</form>
</body>
</html>
|
|
|
|
|
public partial class _Default : System.Web.UI.Page
{
StringBuilder StrBuilder;
ClsHBC_Bl ObjHbcBL;
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ObjHbcBL = new ClsHBC_Bl();
DataTable dt = new DataTable();
dt = ObjHbcBL.GetEmployees_BL();
ViewState["dt"] = dt;
grdEmployees.DataSource = dt;
grdEmployees.DataBind();
}
}
protected void BindGrid()
{
grdEmployees.DataSource =(DataTable) ViewState["dt"] ;
grdEmployees.DataBind();
}
protected void BtnDelete_Click(object sender, EventArgs e)
{
GridViewRow gvRow = (GridViewRow)(sender as Control).Parent.Parent;
Label1.Text = "hi";
}
protected void grdEmployees_RowCommand(object sender, GridViewCommandEventArgs e)
{
}
protected void grdEmployees_SelectedIndexChanged(object sender, EventArgs e)
{
}
protected void Button_click_event(Object sender, EventArgs e)
{
Label1.Text = "Hello";
}
protected void grdEmployees_RowDataBound(object sender, GridViewRowEventArgs e)
{
}
protected void grdEmployees_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int cEmployeeID = (int)grdEmployees.DataKeys[e.RowIndex].Value;
ObjHbcBL.DeleteEmployee_BL(cEmployeeID);
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
StrBuilder = new StringBuilder(string.Empty);
StringWriter stringWriter = new StringWriter(StrBuilder);
CheckBox CC;
DataSet ds = new DataSet();
DataTable dt = new DataTable("toUpdate");
dt.Columns.Add("EmpId", typeof(int));
dt.Columns.Add("ContactNo", typeof(String));
dt.Columns.Add("Experience", typeof(String));
dt.Columns.Add("Skill", typeof(String));
ds.Tables.Add(dt);
for (byte i = 0; i <= grdEmployees.Rows.Count-1; i++)
{
CC = (CheckBox)grdEmployees.Rows[i].FindControl("chkBxSelect");
if (CC.Checked)
{
DataRow r;
r = ds.Tables["toUpdate"].NewRow();
r["EmpId"] = int.Parse((grdEmployees.Rows[i].Cells[1].FindControl("lblEmpId") as Label).Text);
r["ContactNo"] = (grdEmployees.Rows[i].Cells[5].FindControl("txtContactNo") as TextBox).Text;
r["Experience"] = int.Parse((grdEmployees.Rows[i].Cells[6].FindControl("txtExp") as TextBox).Text);
r["Skill"] = (grdEmployees.Rows[i].Cells[7].FindControl("txtSkill") as TextBox).Text;
ds.Tables["toUpdate"].Rows.Add(r);
}
DataTable dtnew = ds.Tables["toUpdate"];
dtnew.WriteXml(stringWriter, XmlWriteMode.IgnoreSchema);
StrBuilder.Append(stringWriter);
}
}
}
|
|
|
|
|
hari4ur wrote: I want to retrive that field into editable gridview with different rows each comma seperated word.
You have to do manually.
hari4ur wrote: i need a editable gridview without showing edit button in asp.net
You can trigger the EditCommand using the JavaScript on the click of each row.
|
|
|
|
|
Can we add our own expression in regular expression validtor?
|
|
|
|
|
Yes.
For more Details
Clickety[^]
Regards,
Satips.
|
|
|
|
|
I am having very very strange problems woth VS.NET, I am opening toolbox option having all the web form components but the pin for enabling or disabling auto hide properties just not seem to appear opposit to "x"(cross sign),I want to enable the auto hide property of my toolbox but without the pin sign it is not possible, any one has some idea how it can be achived.
|
|
|
|
|
Right click the Toolbox titlebar and choose "Dockable". Now drag your Toolbox and place it on any side. The Auto Hide button will appear
|
|
|
|
|
I want to create lookup of the type
Field list Conditions: ( i.e >, <,>=) Search
...
...
Data list in the grid based on the condition.
...
OK Cancel
When ever, I call lookup, it has to show me the above form. I must able to send query to this form so as to display filed list and select the data corresponds to that.
How can I do that? And what is best method?
vijaya
|
|
|
|
|
Hey Guys
Need of help on how to longer the session time out in a web site..
I added
<sessionState TimeOut="120"/> in the web config file
I will like to prolong the time out time to two hours
Did i do it the right way cos i have problem on it?
KaKaShi HaTaKe
|
|
|
|
|
HatakeKaKaShi wrote: <sessionState TimeOut="120"/>
Sounds ok...
|
|
|
|
|
What kind of problem do you have?
Maybe it's the lifetime of the authentication cookie (if Forms Authentication)
Maybe ...
I'm not good at guessing, we need more information first...
-^-^-^-^-^-
no risk no funk
|
|
|
|
|
I wanted to display the message box with yes and no button.on the button click event.
for that i am writing the following code.
Dim Msg As String<br />
Dim Icon As Integer<br />
Dim Title As String<br />
Dim Buttons As Integer<br />
Dim Ans As MsgBoxResult<br />
' Fill Message string<br />
Msg = "Are you sure you want to exit?"<br />
' Set dialog Title<br />
Title = "Logout"<br />
' Set icon to critical (X)<br />
Icon = vbQuestion<br />
' Set buttons to abort, retry and ingnore<br />
Buttons = vbYesNo<br />
'Buttons = Buttons + vbDefaultButton2 'set default button to retry<br />
<br />
Ans = MsgBox(Msg, Buttons + Icon, Title)<br />
'alternatively, simply<br />
'Ans = MsgBox(Msg, vbAbortRetryIgnore + vbDefaultButton2 + vbCritical, "Msgbox Example - Abort Retry Ignore")<br />
<br />
' If the user clicked Retry, try again<br />
If Ans = MsgBoxResult.Yes Then<br />
Session("pass") = ""<br />
Response.Redirect("http://136.72.0.5/infoserver/home.htm")<br />
<br />
End If
This code is producing the error.......
Showing a modal dialog box or form when the application is not running in UserInteractive mode is not a valid operation. Specify the ServiceNotification or DefaultDesktopOnly style to display a notification from a service application.
|
|
|
|
|
You cannot use MsgBox in Web Application. The MsgBox will show up while running from VS2005, but when you deploy it in IIS it won't show up. So use JavaScript to do so...
|
|
|
|