How to make a connection between a word in the cell (href)?and a rule of the same or another table with sql. Is there also finished editors?
View 3 RepliesI have href links inside a datalist and want to make sure that the top link is clicked by default. The reason for this is that the href inside the datalist will show a different friendly url each time one is selected and also fill a seperate detailsview with data based on values from the query string. I want the user to see the friendly url and first lot of data once he navigates to a page is this possible ?.
View 1 RepliesI want add every time in cell. When I run script must add word.
declare @tbl as table(id int, name varchar(100))
insert into @tbl(id,name)values(1,'apple')
update @tbl
set name = name+','+'cherry'
select name from @tbl
Output:
apple,cherry,cherry
For example, a persons name will never have anything it it but alphabetical characters.
My book "Murachs ASP.NET 3.5 With C#2008" tells me how to verify that it is:
any number
not any number
any word character(abc' and 123's)
not any word character
characters in range
everything you could possibly want to know except what I woudl consider to be the most obvios.
I have a listvieiw with url's in some of the cells. When I click on them they do nothing. I formated the cells to be "hyperlinks" but still nothing.
View 8 Repliesim just trying to use this answer, but im getting an error on my page:
"A field or property with the name 'returnantID' was not found on the selected data source."
Im not really sure what the "returnantID" is but it appears my page isn't liking it, not sure if i was sopposed to cswap it out for some other data or not.
This is my current gridview:
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" GridLines="None"
DataSourceID="ObjectDataSource1">
<Columns>
<asp:BoundField DataField="ProductName" HeaderText="ProductName"
SortExpression="ProductName" />
<asp:BoundField DataField="Price" DataFormatString="{0:c2}" HeaderText="Price"
SortExpression="Price" />
<asp:BoundField DataField="Length" HeaderText="Length"
SortExpression="Length" />
<asp:BoundField DataField="Engine" HeaderText="Engine"
SortExpression="Engine" />
<asp:BoundField DataField="Colour" HeaderText="Colour"
SortExpression="Colour" />
<asp:BoundField DataField="Description" HeaderText="Description"
SortExpression="Description" />
</Columns>
</asp:GridView>
would just like the ProductName to link to the corresponding products page(using its Id)
p.s this is what i tried:
<asp:HyperLinkField DataNavigateUrlFields="returnantID" DataNavigateUrlFormatString="Details.aspx?id={0}" DataTextField="ProductName" NavigateUrl="Details.aspx" />
**Update** I changed the "returnantID" to "ProductName" which turned the name of my product into a link but clicking that link gave me this new error:
Input string was not in a correct format.
me how can i make each cell of a gridview selectable(Web Project)?
Basically my requirement is to do some action when i select a cell without having postback. And I am not allowed to use ajax or jquery here. how can i do this using only asp.net gridview and javascript(possibly).
For Example, i want to make some control visible/invisible or enable/disable based on the cell selected.
I believe this is a newbie question, but i just figure out my head around.. does anyone know how to auto adjust the control in the table cell so its width follows the width of table cell?
View 14 RepliesI'd like to make some words of a cell in gridview Bold. For example - "MRN No.: SI0021848 Name: Cherry" like my attachment. I could query this field value from database but don't know how to make some words Bold. How to do it?
View 2 RepliesResponse.RedirectPermanent(Url); can redirect permanently to a url.
However, during my SEO process, I decided to change my routhing rule.
For example,
I change "/tag/{tag}-quotes" routing rule to "quoes-about/{tag}", but I don't want to lose all the traffic to old routing url.
What is the best way to handle this permanent redirection?
I want to setup a DB connection from aspx page and not from aspx.vb.
View 1 RepliesI generate dynamic grids based on a count value returned from some DB tables. the code for it goes like this : I give and Id to each grid that is generated.
if (myDataList1.Count >= 1)
{
for (int i = 0; i < myDataList1.Count; i++)
{
//retrieving the exact i count from pageload
ViewState.Add("newCount", i);
//creating the dynamic grid with its corresponding gridview properties.
grvDynamic = new GridView();
grvDynamic.ID = "GridView" + (i+3);
grvDynamic.AutoGenerateColumns = false;
grvDynamic.RowCreated += GridViewRowCreated;
grvDynamic.RowDataBound += grvDynamic_RowDataBound;
//adding bound field columns to retrieve data from stored proc
BoundField metric = new BoundField();
metric.HeaderText = "Goal ";
metric.DataField = "metric";
grvDynamic.Columns.Add(metric);
BoundField mtd = new BoundField();
mtd.HeaderText = "MTD";
mtd.DataField = "value_MTD";
grvDynamic.Columns.Add(mtd);
BoundField goal = new BoundField();
goal.HeaderText = "Tier Level Achieved";
goal.DataField = "value_goal";
goal.HeaderStyle.Width = Unit.Percentage(10);
grvDynamic.Columns.Add(goal);
BoundField you1 = new BoundField();
you1.HeaderText = "Month End";
you1.DataField = "firstLevel_you";
grvDynamic.Columns.Add(you1);
BoundField you2 = new BoundField();
you2.HeaderText = "Month End";
you2.DataField = "secondLevel_you";
grvDynamic.Columns.Add(you2);
ButtonField singleClick = new ButtonField();
singleClick.CommandName = "clickHyperlink";
singleClick.Visible = false;
grvDynamic.Columns.Add(singleClick);
BoundField metricId = new BoundField();
metricId.HeaderText = "Metric Id";
metricId.DataField = "metricID";
metricId.Visible = true;
grvDynamic.Columns.Add(metricId);
//binding the gridview to data.
grvDynamic.DataSource = data;
grvDynamic.DataBind();
grvDynamic.Columns[5].Visible = false;
}
}
protected void grvDynamic_RowDataBound(object sender, GridViewRowEventArgs e)
{
//this basically gets the metric Id's of rows with the ishyperlink flag set to 'Y'. I need to make these particular cells clickable var isClickable = (from md in myDataList3 where md.IsHyperLinkFlag == 'Y' &&
md.value_MTD != null select md.metricID).ToList();
if (e.Row.RowType == DataControlRowType.DataRow)
{
// Get reference to button field in the gridview.
LinkButton _singleClickButton = (LinkButton)e.Row.Cells[5].Controls[0];
if (isClickable.Contains(Convert.ToInt32(e.Row.Cells[6].Text)))
{
e.Row.Cells[1].Style["cursor"] = "hand";
e.Row.Cells[1].Style["color"] = "blue";
e.Row.Cells[1].Style["textdecoration"] = "Underline";
e.Row.Cells[1].Attributes.Add("onClick", "window.location ='../HeaderPages/page2.aspx' ");
}
}
}
This code works perfectly fine , depending on the ishyperlink flag in the database...specific cells in the grid are made clickable and then redirected to page2.aspx My Issue: I need to capture which specific cell in which specific grid the user has clicked. store some information in sessions based on the cell clicked and use that information in page2.aspx.
I am currently using Visual Web Developer and have a website with 2 pages which are "Tables.aspx" and Variables.aspx". I was wondering if their is a way to make a specific cell in a gridview clickable/as a hyperlink so that it would take the user to another page and display the required information in another gridview based on what Table Name from the gridview has been clicked on?
The gridview on the "Tables.aspx" page has 5 fields and they are Table ID, Table Name, Table Description, Source and Record Count. The field that I want to make as a hyperlink is the Table Name field and when clicked upon I would like all the relevant information (Table Name, Variable Name, Variable Description) for this field to appear in a gridview in the "Variables.aspx" page. The database table names that would be required are "variables" and "tables". In order to do this would I have to create/run some sort of SELECT command in behind the source tab for the gridview?
NB table name comes from tables database table and variable name and variable description comes from the variables database table.
No sense in showing a competely blank column. how to make a GridView column invisible if every cell in that column is empty?
View 3 RepliesI am planning to create HR Management System using asp.net & sql server 2005. In this application we need to manage different kinds of Employee Documents like Offer letter,Salary certificate etc.. Now,What we need is we will store templates for these documents(ms word,excel) in the application and needs to genereate these documets corresponding to the selected employee like mail merge.
View 3 RepliesIam trying to make a socket connection and am facing with the following error.
Socket tempSocket =new
Socket(ipe.AddressFamily,
SocketType.Stream,
ProtocolType.Tcp);
The tempSocket is connected to the particular IP and tempSocket.Connected is giving me value as True. But the property MultiCastLoopBack property is giving me the following error with error code 10042.
"An unknown, invalid, or unsupported option or level was specified in a getsockopt or setsockopt call."
So is there any problem with the IP or Tcp is not supported with Stream as SocketType?
how make the class for database activities and it can be used in code behind
coz i want avoid the connection opening, closing activities, insert,update etc methods in code behind frequently.
the class should include connection open and closing method, passing values to stored procedures etc.
How should we construct it?
When I load my page I populate my repeater with the following code.
Dim conn As Data.SqlClient.SqlConnection
Dim Comm As Data.SqlClient.SqlCommand
Dim reader As Data.SqlClient.SqlDataReader
[code]...
Is it possible to make a sql connection in the master-file for my asp.net website, that all included sites have the connection too? Like when I include a header-file in asp classig.
View 1 RepliesI have a grid view populated with some data included bit fields and I made an export to excel function For each row i need to check the cell with the bit value to change the cell color, but the cell is always empty, even if is the field is set to False or True. foreach (GridViewRow row in gv.Rows)
View 2 RepliesI'm having a weird problem where the GridView cell that I'm programmatically updating turns grey, and throws a null error when attempting to save row. I have been searching all day and have not been able to find a solution. I'm guessing there is a problem with my code, so here it is:
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
How to set Height and ItemSource(Business Object as DataSource for Cell) for every Cell in DataGrid/ Grid? Shown below is part of code I am currently using with Grid Control. What I am currently doing is that I am using ListBoxItem, set Item Height and ItemSource at ListBoxItem Level, Add ListBoxitem to ListBox and then Add ListBox to Grid, It leaves me with just one row and multiple columns in the Grid, which is perhaps not the best way of doing it as it doesn't allow me to take benefits from UI Virtualization of Grid.
[code]....
I am open to use any control i.e. Grid/ DataGrid provided it allows me to set Cell Height and item source at Cell level. In my requirement, Cell height depends on the Item duration and size of image, which means the height of the cells may not be same across cells in any particular row.
I receive the following error, when trying to consume Wcf service:
"An existing connection was forcibly closed by the remote host". Consuming the service works fine when the host and the client are on the same machine. When I move the client to Hyper-V virtual machine (I didn't try it on a real computer) - it throws the error. Both firewalls are turned off Do you know what can cause such behaviour? Here are the details:
Both the client (hyper-v) and the service are on Windows server 2008 R2
Service url - http://wcftest/CalculatorService.svc (wcftest is the website and is mapped in the hosts file to localhost)
Service config:
[Code]....
Client config:
[Code]....
Are there any configuration settings which I'm missing?
If I m using Windows Auth in my connectionstring i.e Integrated Security = SSPI / Trusted_Connection = Yes,
Is there any way to retrieve the USERID that is being used to make connection?
I try to connect my database for so long so i wrote two type of codes. Let's discuse first on.
I have database called PhoneDirectory.
It have only one table named Residents.
I have button wiht ID="Button1".
I want when i click this button to see all of my residents.
I want to see the result in DetailsView and to be able to edin, delete and add new resident.
First try with SqlDataSource so i wrote this:
<asp:SqlDataSource ID="Resident Details" runat="server" ProviderName="System.Data.SqlClient" ConnectionStrings="<%$ ConnectionStrings:ThisIsTheConnection%>"