SQL Server :: Dynamically Changing Text Returned From A Query?
Nov 13, 2010
What would be the best way of going about doing this;
On my website I am putting some short stories in and allowing people to change the name of the characters in the story to match their own. I was going to keep the stories in a SQL DB but not quite sure how I would go about changing the names of the characters dynamically?
Would I be best using say (Name1), (Name2) etc in the stories in the DB then changing it using a string query on the code behind or is there a better / quicker way to acheive this?
View 3 Replies
Similar Messages:
Aug 26, 2010
I have a table of skills. In that table, are rows of data with various skill type. I need to return a list of those skills in alphabetical order, with one exception. The skills "General" can't be listed in the "G's", instead, it needs to be the last item. (Crazy, I know, but it's to discourage users from settling on a selection of "General".
This statement returns all the skills in alphabetical order, but "General" is listed right in the middle with other "G's:
SELECT SkillsID, Skill, SkillDesc FROM tSkills ORDER BY Skill
View 3 Replies
Feb 1, 2011
iam using ASP gridview. And i declare one label in headertemplate for setting heading of a particular column. How can i dynamicallly change the header text on a particular button click..
View 2 Replies
May 7, 2010
I'm trying to change the text of a GridView label in an ItemTemplate and I am having some issues. I searched all over and can't find a solution. This is what I am trying to do...
I have a GridView that has a comment field. Normally when the page is rendered the comment field is truncated using a truncate class that limits field length. The full contents can be displayed in a tooltip when the comment field is hovered over. That part works fine.
I also have an export to Excel class that will take the Gridview and export it to Excel and that part works fine as well...
Now the issue... Because of the truncated field, when I do an export it will export exactly what is in that field, the truncated version of a comment. When the export button is clicked I need to change the .text value of the label that is in the GridView ItemTemplate
From this truncated version...
[Code]....
And then back again after the export routine is complete.
I have accessed the contents of a label before using FindControl but never set a value, is this possible? Also, I have captured what is in the comment field on RowDataBound but by that time, it is already truncated.
View 2 Replies
Apr 7, 2010
EDIT: Purpose of this Website: Its called Utopiapimp.com. It is a third party utility for a game called utopia-game.com. The site currently has over 12k users to it an I run the site. The game is fully text based and will always remain that. Users copy and paste full pages of text from the game and paste the copied information into my site. I run a series of regular expressions against the pasted data and break it down. I then insert anywhere from 5 values to over 30 values into the DB based on that one paste. I then take those values and run queries against them to display the information back in a VERY simple and easy to understand way. The game is team based and each team has 25 users to it. So each team is a group and each row is ONE users information. The users can update all 25 rows or just one row at a time. I require storing things into cache because the site is very slow doing over 1,000 queries almost every minute.
So here is the deal. Imagine I have an excel EDIT(Excel is just an example of how to imagine it, I don't actually use excel) spreadsheet with 100 columns and 5000 rows. Each row has two unique identifiers. One for the row it self and one to group together 25 rows a piece. There are about 10 columns in the row that will almost never change and the other 90 columns will always be changing. We can say some will even change in a matter of seconds depending on how fast the row is updated. Rows can also be added and deleted from the group, but not from the database. The rows are taken from about 4 queries from the database to show the most recent and updated data from the database. So every time something in the database is updated, I would also like the row to be updated. If a row or a group has not been updated in 12 or so hours, it will be taken out of Cache. Once the user calls the group again via the DB queries. They will be placed into Cache.
The above is what I would like. That is the wish.In Reality, I still have all the rows, but the way I store them in Cache is currently broken. I store each row in a class and the class is stored in the Server Cache via a HUGE list. When I go to update/Delete/Insert items in the list or rows, most the time it works, but sometimes it throws errors because the cache has changed. I want to be able to lock down the cache like the database throws a lock on a row more or less. I have DateTime stamps to remove things after 12 hours, but this almost always breaks because other users are updating the same 25 rows in the group or just the cache has changed.This is an example of how I add items to Cache, this one shows I only pull the 10 or so columns that very rarely change. This example all removes rows not updated after 12 hours:
DateTime dt = DateTime.UtcNow;
if (HttpContext.Current.Cache["GetRows"] != null)
{
[code]...
View 4 Replies
Feb 23, 2011
i've currently got a registration form that works fully however i've run into a problem getting the validation text to appear. basically i want the form to present the following message "Congrats you are now registered and can login using the login page" only if all the fields in it are filled in. However with what i have coded below it always presents the message, i am using asp.net 2.0 with webmatrix.
[Code]....
View 7 Replies
Sep 25, 2010
i want to add add coulmn name in sql query at run time and if any field is blank or null than it should not goes with sql query for search ....
column name:
firstName.Text
lastName.Text
address.Text
SqlCommand cmd = new SqlCommand("select * from hotelreg where '" + firstName.Text + "' and '" + lastName.Text + "', and '" + address.Text + "' like '%"+textbox1.Text+"%'", con);
View 1 Replies
Jan 3, 2011
Is there any way to convert the following text query to stored procedure? I have multiple Select statements that will depend on the result of the prior Select query. The logic goes like this: While select1 reads select2 read, If select2 reads, select3 execute.
[Code]....
View 6 Replies
Feb 11, 2010
Trying to get the number of rows returned in a query in Visual Basic.The query returns 3 rows.Dim td As Integer = dataset1.Tables(0).Rows(0).ItemArray(0) has a value of 1.Dim tg As Integer = GridView1.DataSource.tables(0).rows.count has a value of 3.1. Why do aren't they both 3 ?2. Is there a best way of getting the number of rows ?3. Where can I find a tutorial or book that explains the notation above ?
View 3 Replies
Apr 15, 2010
I am trying to run the following SQL query
string strConString = ConfigurationSettings.AppSettings[ "conString" ];
myConnection = new OdbcConnection(strConString);
myConnection.Open(); // open connection
string strSelect= "select * from tbl_howells_product_data where title like" + "'" + strsearch + "%" +"'" + "order by product_id asc";
OdbcCommand myCommand = new OdbcCommand(strSelect, myConnection);
dtrReader=myCommand.ExecuteReader();
The problem is I need to check to see if any data has been returned from the SQL query, if there are no rows/ data returned by the query then I need to display a message to say that there aren't. I know that there isn't a 'number of rows method' for the dtrReader, so does anybody know how I could do this?
View 3 Replies
Mar 14, 2011
I need to search my sql database using full text search.
My question is: How do I create the stored procedure and query?
The full text is already created and I ma using asp.net and c# in my application?
Do I need to include the name of the full text index in the stored procedure and query?
View 3 Replies
Sep 22, 2010
how to show the quick changing text as like shown in text editor of mobile phone(While message writing it shows no of characters left)
View 5 Replies
May 29, 2010
I need to check if any rows are returned in a QueryString here's what I have so far.not sure what code to put to see if the row count is greater than 1
private void BindDataToGrid()
{
//MessageBoardEntities3 is ThemeableAttribute connection string name
int TID = Convert.ToInt32(Request.QueryString["ThreadID"].ToString()); // if Post ID is int
var context = new MessageBoardEntities3();
gvPosts.DataSource = from p in context.Posts
where p.ThreadID == TID
select new { p.Post1, p.PostID };
gvPosts.DataBind();
lblNoPosts.Text = "No posts found for this thread.";
}
View 1 Replies
Aug 9, 2010
I have several labels in my application, and I need to manipulate every single one of them. So, I thought the easiest way would be to simply call the manipulating C# method from the aspx page when needed, but oh, I was wrong. I have spent a couple of hours now trying to figure out how to do this, but I have not come to a solution ..
Aspx page:
<asp:Label runat="server" Text='<%= ManipulateLabel("Information") %>'></asp:Label>
Code behind (C#):
protected string ManipulateLabel(string label)
{
return label+" some value";
}
I do not wish to assign each label to value directly from code behind (normally I would do it like this but this time there are so many labels that need a manipulated value that it simply would be too hard updating the application in the future).
When using the code behind, the application simply prints "<%= ManipulateLabel("Information") %>" on the page, which is not what I want :( Also, if I use:
<span><%= ManipulateLabel("Information") %></span>
, it suddenly works. But, I need to use the asp.net web controls, not normal HTML tags.
View 20 Replies
Mar 15, 2010
I have the following javascript:
$.post("/Authenticated/DeletePage/" + PageId);
showStatus("Page deleted...", 10000);
I would like to instead pass showStatus() text that is returned by the $.post() call, rather than hardcoded text. How do I do this?
View 2 Replies
Jan 8, 2010
i need to create a fully funnctional gridview with the results returned from a script serice ( AJAX enabled WCF Service ).
The grid should allow user to sort and page the data.
could any body drive me to the proper technology or a useful link.
View 1 Replies
Apr 30, 2010
it possible to pass the query dynamically to sql server report from .net or from any other source.
View 1 Replies
May 5, 2010
using asp.net/vb.net 2005
In the aspx page I have the EmptyDataText property set
[Code]....
However when no records are not returned I am not seeing the text "No Results Returned" I am populating the gridview using a SqlDataSource. I am not sure why this is happening but thinking about setting the value programmatically, does this make sense and if yes which gridview event should I do this? has anyone else experienced something like this before?
View 19 Replies
Aug 12, 2010
I have a scenario whereby I have a textbox with an autocomplete extender attached and two drop down lists; this enables a user to search for product info. Ideally I'd like to create something that effectivley, 'resets' the drop downs so that when a user clicks on the textbox (maybe I'll do it 'onenter'/'ondelete' if there is such a thing). I've had a look at .Attributes.Add but cannae figure it out. How do you include asp.net controls within this scenario so I could have something along the lines of:
tbxAutoComplete.Attributes.Add("OnClick", ddlLevelAuto.SelectedIndex = 0, ddlItemCategory.SelectedIndex = 0,);
View 1 Replies
Jan 29, 2010
if there is a way to dynamically change the session ID from the context of a SessionStateStoreProvider (or some other customizable module) in C# for ASP.NET.
I am implementing a custom SessionStateStoreProvider, and I was thinking about augmenting the session ID to tell the store provider where to go look for a session. I've implemented a custom SessionIDManager, which lets me augment newly created session IDs with the required tag. The problem is that the desired value of that tag might change during the life of a session. For example, the session may be read from one location, but may need to written to a different location. In this instance the ID would have originally been tagged for location A, but on writing the store would want to write to location B. The tag should be updated to reflect location B for the next session read.
So, from the context of SessionStateProviderBase override...
public override void SetAndReleaseItemExclusive(HttpContext context,
string id, SessionStateStoreData item, object lockId, bool newItem)
... is it possible to change the session ID? I know that the HttpContext.Session.SessionID property is not settable. Is there some other way to feedback an update like this? Or is there a more appropriate to carry state like this across calls?
View 2 Replies
Feb 3, 2011
this may or may not be a big deal but what I am looking to do is based on some data returned to my view I want to change the background-color to what value is being returned. Black, Yellow, etc.... How can I in my aspx page set my Style background-color based on this value in the model. I know Attributes are used in Web forms control but not sure in MVC how to do this
View 3 Replies
Dec 2, 2010
I have a problem that the OnLoad event is not fireing when I navigate to a page and just change the query string. If I do a postback it is called, then changing the query string ones more OnLoad gets called.
Here is how i try. I navigate to the page OnLoad fires -> then change the query string page updates (all bound elements get updated) OnLoad does not fire -> I do a postback using a button OnLoad fires -> then change the query string OnLoad fires. I will try to explain in more detail.
The system has log in window when I log in I navigate to an other aspx page sending two query string messages the last query string is a number (page.aspx?key=text82&key2=2010). When I get to the page the first time PageLoad event gets called and all is fine, if I in the browser change the key2 to 2011 and press enter the PageLoad does not get called but all my bound elements get updated (GrivView etc..). If I then do a postback using a button the PageLoad gets called. If I now change the 2011 back to 2010 and press Enter PageLoad is called. I try this is firefox the PageLoad get called every time. I tired to write a test website but I do not get the same problem, but what i found out is that in IE 8 changing the query string to the same number and pressing enter the PageLoad is not called. But doing so in firefox makes the postback fire. Here is the test code
<%@ Page Title="Home Page" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"
CodeFile="Default.aspx.cs" Inherits="_Default" %>
<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
<h2>
Welcome to ASP.NET!
</h2>
<p>
<asp:Button ID="Button1" runat="server" Text="Button" />
<asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="~/Default2.aspx?t=tt& tttttt=2010">HyperLink</asp:HyperLink>
</p>
<p>
You can also find <a href="http://go.microsoft.com/fwlink/?LinkID=152368&clcid=0x409"
title="MSDN ASP.NET Docs">documentation on ASP.NET at MSDN</a>.
</p>
</asp:Content>
Navigates to
<%@ Page Language="C#" AutoEventWireup="true" MasterPageFile="~/Site.master" CodeFile="Default2.aspx.cs"
Inherits="Default2" %>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label><asp:Button ID="Button1"
runat="server" Text="Button" />
</asp:Content>
OnLoad event Default2.aspx
protected void Page_Load(object sender, EventArgs e)
{
Label1.Text += "Called " + DateTime.Now.ToString();
}
View 1 Replies
Jan 13, 2011
I am using a nested listview to display a seperate grid for each group of data returned from my db query. To get this working, I have adapted a piece of code to group the data prior to it being bound:
[Code]....
I am then using the following html markup:
[Code]....
[Code]....
This works as I want it to however some of the fields within the nested table need to be formatted as currency so I am trying to use Eval and {0:c} to do this however the moment I use Eval, the data items cannot be found
DataBinding: 'System.Data.DataRow' does not contain a property with the name '0'.
View 4 Replies
May 13, 2010
I haven't had any luck finding the answer yet. My problem is that I want to be able to update the dataformatstring on a gridview column at runtime. For example, I switch from displaying # of units to cost of said units... and I want to change the format of the column to {0:c}. It seems like it should be a simple task.
View 2 Replies
Dec 16, 2010
Good sample for dynamically change theme in MVC 3 RC 2 (Razor).
View 1 Replies
