i have many to many RelationShip and repesnt it in GridView without any problem but the real problem when draw Data the same row repeated with anther item
for example :
i have table
A with data
1 2 3
and table B
with data
a
b
grid view Draw data as
1 2 3 a
1 2 3 b
but i want
1 2 3 a,b
Is it possible to allow repeated nulls on a column with a unique constraint? This column will won't always be populated with data upon insert, a condition must be met before the value is update. Once updated, it needs to be unique. Do I need to assign a temporary, random value or
View 1 RepliesI created ajax tab dynamicaly.it works well except one thing .every time i clicked on menuitem a new tab created and if I clicked on that menuitem again the tab created again.I dont want to create one tab repeatedly I just want to create each tab just once and if I click on repeated menuitem the existed tab just be active.
here is my code:
[Code]....
private void PopulateYear()
{
DDYEAR.Items.Clear();
ListItem lt = new ListItem();
lt.Text = "YYYY";
lt.Value = "0";
[CODE]
i have the following code repeated in many pages in some cases only the sql query chnages instead of repeating all code lines in each and everypage
how can i use the same from class file
How to counting the repeated words in a text box using Asp.net with c#..
I want to display like this,
words no.of occurrences
Rose 5
india 2
was 1
select 10
We have a web application using VS 2008, c#. We try to filter siteMap nodes based on security roles. We have our customized the mether GetRolesForUser() in RoleProvider class to determine a user's role. In this method, roles will be returned by querying an SQL Server database. However, we found that each time a page was loaded/refershed, this GetRolesForUser() was called, and the database would be queried. This is too MUCH and expensive. We thought the roles should be queried only once when a user logs in. After that, role info should be stored somewhere for this user, rather than query DB all the time.
View 3 Repliesi used ajax control ModalPopupExtender.ModalPopupextender has panel. in that panel, text boxes and gridview placed and OK button. it has three textboxes and gridview and ok button sequentially. While edit button of gridview and after entering the some intextboxes, the text of textboxes repetedly show on textbox with camma.
View 1 RepliesI have problem like to count the repeated chars from a string using sql server.Also i have used functions in sql server thats working fine.But i want the solution using a sql query...
[i have a column like ID,name,Secure_name],here 1 ,'kamal','welcome'.so findout 'e' howmany times repeated in a column secure_name.....
my repeater binding repeated rows.
TableAdapters.myorderTableAdapter tblerows= new TableAdapters.myorderTableAdapter();
DataTable dt = tblerows.GetDataByUserName(username);
DataTable outputTable = dt;
for (int i = 0; i < 4; i++)
{
outputTable.ImportRow(dt.Rows[i]);
}
Repeater1.DataSource = outputTable;
Repeater1.DataBind();
from the above code i got number of rows for the seleted username. so i need to show only resulted rows. here repeater1 repeating my rows.
I seem to recall that it was possible to supress repeated values , or am i wrong?
Team Field date
Joes 1 3/1
2 3/3
Toms 3 3/4
Eds 1 3/6
how do i write a async class like WebClient? Is there anyway i can keep it short and does not have to repeat it for every method?
for example, i have:
Download(string a)
Download(string a, string b)
do i have to rewrite Async + Complete method for each of these?
The below query produce the below output.
[code]...
select r.Name,c.Name,s.Name,(select count(p1.id)from profiles p1 where r.id=p1.religion and c.id=p1.caste and s.id=p1.subcaste and p1.Gender=1)as Male,(select count(p1.id)from profiles p1 where r.id=p1.religion and c.id=p1.caste and s.id=p1.subcaste and p1.Gender=2)as Female from religion r,profiles p,caste c,subcaste s where r.id=p.religion and c.id=p.caste and s.id=p.subcaste group by r.Name,c.Name,s.Name,r.id,c.id,s.id
I have one asp.net application using Sql server as back end.. in sql server database i have one table which consist two fields.. ItemName and RateI have one notepad file which consist around 700 ItemName with Rate..
So how to get this ItemName and Rate in my Table...
In my Membership.aspx, I added a LoginView control. Then on the LoggedInTemplate, I typed "You are Logged in. Welcome," and a LoginName control. After testing from ASP.NET Development server and IIS server, now my LoggedInTemplate showed "You are Logged in. Welcome," several times before displayed only one LoginName/UserName. Why? Something wrong when testing in the ASP.NET Development environment or IIS server configuration?
View 3 RepliesI'm using RegularExpressionValidator controls to impose password rules when creating new passwords. I want to avoid repeatitons such as 'aaaa' or sequences such as '12345' in the password.
How do I write the validationexpression to a RegularExpressionValidator to impose this rule? I do not want to do thing using C#, just with a regular expression that could be put within the validator control like below:
<asp:RegularExpressionValidator
ID="RegularExpressionValidator3"
runat="server"
ErrorMessage="Password
should contain Minimum 8 Characters"
ControlToValidate="txtPwd"
ValidationExpression="w{8,30}"><asp:RegularExpressionValidator>
i have a datalist .
i used an object datasource to show data in datalist .
and my datalist have two or more repeated columns .
how i can make header for top of each column ?
not for each item and not for each row .just for each column .?
my gridview shows multiple repeated pages for one page and I dont know from where come the problemand im treating the event of the paging well
Protected Sub GridView1_PageIndexChanging(ByVal sender As Object, ByVal e As GridViewPageEventArgs)
GridView1.PageIndex = e.NewPageIndex
If lstCustomer.Visible = True Then
[code]...
I have a grid view which consists of some 16 fields in which i have to take print in A4 sheet
In which every sheet the page must contain headers
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Report_AssistantEngineer.aspx.cs" Inherits="Report_AssistantEngineer" %>
<!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">
[Code] ....
1- how can i display data with repated columns like i can do in datalist
2-im give it a datatable as datasource so im handling Next-Prev button dayinamicly but its works fine with linkbutton only image button cant accept that
I was told to use a Repeater control in what I am doing which is a "Data Entry" screen with ASP.NET controls -a standard "address" like form. In cases, the fields on the form will repeated twice, once for the original values, one for the changed values. I have not used this control before but it seems like I have to bind to a database. Instead, I have an Entity object that has been obtained via a Repository. Can I bind to an object like this?
[DataContract()]
public class RON
{
[code]...
This has reference to the article on ASPSnippets "Load data while Scrolling Page down with jQuery AJAX and ASP.Net".Records repeat after scrolling (e.g. Records 1-10 repeat after 10th record)
I verified that the pageIndex gets incrimented after the scroll by setting breakpoints at the point where the cmd.parameters value is being set(could not verify that further from hereafter though).
The stored procedure is able to fetch records e.g. 41-50 correcly affter excution in standalone mode by passing pageIndex=5 and pagesize=10 parameters etc. etc. etc.I also verified the code(line by line) from the site but, could not resolve the issue in more than a day's work.
I have a very simple situation where I'm pulling records from a db and displaying a picture of someone by their name and showing the location underneath the picture.
The problem is that the person has a row for each location they are in so I end up pulling three pictures of the same person. I can't see a way to tell the db that these are the same person in SQL.
Is there a way, once I have these records pulled to say if the string for the photo is the same to only show it once?
Here is the code for my datalist:
<asp:DataList ID="DataList3" runat="server" DataKeyField="Expr1"
DataSourceID="SqlDataSource5" RepeatColumns="5"
RepeatDirection="Horizontal" CellPadding="15" CellSpacing="15"
Visible="False" Width="721px">
<ItemTemplate>
<a href="mailto:<%# Eval("email") %>"><img src="../Images/Staff/<%#Eval("photo") %>" alt="<%#Eval("firstname") %> <%#Eval("lastname") %>" border="0"/></a><br />
<asp:Label ID="firstnameLabel" runat="server" Text='<%# Eval("firstname") %>' />
<asp:Label ID="Label1" runat="server" Text='<%# Eval("lastname") %>' />
<br />
<span style="font-size:12px;"><asp:Label ID="LocationNameLabel" runat="server"
Text='<%# Eval("LocationName") %>' /></span>
</ItemTemplate>
</asp:DataList>
How Can I (Or Is It Possible?) Add Item to Html Combobox ServerSide ?Or Bind It in behind Code in asp.net ?Does My question Clear?
View 1 Replies I'm kind of at my wits end here as it appears not many others have had this problem so it's possible that I'm missing something very simple but what is it?
I'm using SQL Express 2008 R2, Visual Web Devel Express 2010, .NET framework 4 and tell me whatever else you need to know.
I'm not being able to use add new item feature to insert an empty SQL database into my little project. It tells me connection to a .mdf file require SQL server to be installed and running on local computer. Well I can connect to server with management studio and connect to it inside VS. Database explorer will show me a database when I manually connect using tools>connect to database then data source = Microsoft SQL Server. It then shows up in database explorer. So why isn't the add new item feature working for me? What gives?
Table1
Col1(varchar)
japan
taiwan
china
malaysia
singapore
japan
china
How to find the row index of "china" occuring first in the column. I need to get 3 as result for the query ?