SQL Server :: Stuff Available For MS SQL Similar Region In C#?
Feb 12, 2011Similar region in C#, is there stuff available for MS SQL?
View 1 Replies
Similar Messages:
SQL Server :: Want To Capture The Region/Location Information ?
Dec 31, 2010I have a requirement for my client (100000/1 Lakh users) for a Asset Tracker portal (Laptops/Desktops) where in I have a show the Asset (Laptop/Desktop was with whom and currently with whom) history (Trace Infromation) on a Report. There might be a n no of users who have used the same laptop.
From the beginning till the end of the life cycle of an asset, the trace of asset owner needs to be captured thoughout.We need to show the asset history report in a single row of data.e.g: Laptop was with A then with B and then with C and Currently with C. Not alone user history we also need to capture the Region/Location information of the asset and certain other things too.
how to implement this since there are lot of assets which needs to be registered in the portal.I am using SQL 2005.
DataSource Controls :: Copying SQL Server Database Has Not Copied Membership Stuff Correctly?
Jan 19, 2010I have just used the Import and Export Wizard to copy my production SQL Server database, which uses Membership and Roles. I used the option to copy all the data from existing tables and views and did not modify the mapping in any way. Things do not seem to have gone well.....
My source database has a bunch of views with names like vw_aspnet_Applications,vw_aspnet_MembershipUsers, etc. The copy database has these listed as tables!I wondered if running aspnet_regsql.exe might fix things. I needed to run this anyway to create all the missing stored procedures for Membership, etc. However, it failed with the error:Setup failed.Exception:An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 2714 and the SqlException message is: There is already an object named 'vw_aspnet_Applications' in the database.Creating the vw_aspnet_Applications view...I am a bit lost. All I want to do is to create a total clone of my production database for test purposes. Where do I go from here?
Databases :: UI Tool For Oracle Similar To MS SQL Server Profiler?
Jun 29, 2010I would like to monitor all the queries running under Oracle which are being fired. Looking for some good UI tool for Oracle similar to Microsoft SQL Server Profiler.
View 1 RepliesSQL Server :: Selecting A Percent Of A Table And Similar Records?
Oct 19, 2010I have a piece of sql code that selects the top 10% of a table. See below a sample of the database table
And this is my code
[Code]....
So what this code does is add up all the points in the points table, (also works out what percentage of the points each user has) and then displays the top 10%, which in this case will give me "John" and "Dave"
So what I need the sql to do is check if any other records in that table have the same number of points ast the last selected record, and to select it to.
SQL Server :: Vastly Different Performance Of Table Update On Similar Machines?
Oct 21, 2010Two machines. One a little faster than the other. The slow one runs windows xp, visual webdeveloper express 2010, sql server 2008. The fast one runs windows server 2008, visual wev developer express 2010, sql server 2008.The code in queston involves an automatically generated update function in one of the table adapters, called 'adapter'. Our C# code generates a data table called 'table', with which we update our 'datatable' in the table adapter.
The table has about 100 entries.We then update our datatable in the .xsd file by calling.
int rowsaffected = adapater.Update(table);//this is the line that takes long on fast computer return rowsaffected > 0;//since function returns a bool On the slow machine this line of code takes a few milliseconds.One the fast machine it takes 5 seconds.These results are consistent. It has nothing to do with one machine being busy, the other idle.
What could be the reason and how could it be solved? How can the same code, on the same platform, on a faster machine take 500 times longer than on a slower machine?
What Is #region And What Does It Do
Mar 15, 2010What is #region, and what does it do?
View 2 RepliesStuff Viewmodel Into Html.actionlink?
May 7, 2010Is there a way to stuff my ViewModel into an Ajax.ActionLink? edit I'd like to take my 5 search fields on my page which are bind to a view model and send it along my .ActionLink as my object value parameter.
View 2 RepliesWant To Create An Expression For Querystrings, This Stuff Is Hard?
May 7, 2010I want to extract some keywords out of a query string for a search application in asp.net.I decoded the url string first, so it's plain textI have this to start with, but I want to add a keyword group
([?&])q=[^&]+[&]?
I get this ?q=harbour landing dental&I'd like to trim off the stuff for pure words, but not sure if that's possibleI also have a long list of possible query string value fields that I want to check against
?q=
@q=
?qs=
&qs=
C# - Create Page Without All The Codebehind And Designer Stuff?
Sep 9, 2010I would like to create an ASP.Net page without all the codebehind and designer stuff. Basically I want to go back to ASP classic, but keep the CLR and Base Class Library that makes .Net oh-so-wonderful. I'd like just a page something like this:
<html>
<body>
<div>
<%
int customerID = Request.QueryString["CustomerID"];
//Customer and DataAccess classes come from an extenal assembly
Customer customer = DataAccess.GetCustomer(customerID);
%>
You asked for Customer with ID: <%=customerID;%><br />
Name: <%=customer.Name;%><br />
Phone: <%=customer.Phone;%><br />
</div>
</body>
</html>
However there seem to be some problems with that. The Request object is only available from within a Page object. I wish to completely delete the codebehind and designer pages. No intellisense Anything else I should be aware of before I get too deep into this? No idea how to start pulling in extenal libraries
Finding Description About #region PageLoad
Nov 9, 2010Can anybody tell me the description about
"#region PageLoad"
which i absorbed in a code given to me....
C# - Use Region Time Zone With A .Net Application?
May 1, 2010I'm working on an asp.net mvc application. Each user have his own time zone.Right now, I'm using "TimeZoneInfo.GetSystemTimeZones" to generate a drop down list in order for the user to select a timezone and this is what I store in my db
They are like that:
Morocco Standard Time (00:00:00)
UTC (00:00:00)
GMT Standard Time (00:00:00)
...
I know that php use a different timezone set, they are "region timezone", for example:
Europe/Paris
Europe/London
...
My question is: is there a way to play with the region timezone (like php) in an .NET application? The only way I can think of is to bind each php region timezone to the .net timezone.Also, the "TimeZoneInfo.GetSystemTimeZones" list all of the timezone on the machine. Is the list different between windows server, windows vista, windows xp?
Alternative To Sql Difference Coding, Search Engine Stuff?
May 20, 2010i am desire need of google search engine like search in a list of strings. I got list of around 1000 different text i need to basically catch type-o mistakes and give a good suggested search result.
In example is in db "apple on tree" and person searches "aplle"
or "city of los angeles" person searches "city of Angles" and results would be "city of angeles" not "city of somewhere else"sql like or difference just wont work on cases like this. Any suggestion how to do get around spelling mistakes and give reduced list of options. Not sure sql can handle this. but i am willing to go .net code methods as well.
Create Methods To Do Stuff Like Opening The Connection To The Database?
Jun 22, 2010I want to be able to create methods to do stuff like opening the connection to the database.Right now if I want to do that I have to put all the code to open the connection with the database in every class.What I did is create a new class called methods, this class is in the App_code folder.I have researched but don't understand how methods are created and how to call them. If someone can give me an example regarding a database connection method, I might be able to really understand how a method works. Basically, this is the code I have to use everytime I want to open a connection to the database:
string connectionString = ConfigurationManager.ConnectionStrings["dbConn"].ConnectionString;
C# - Extract Region And Replace Them Back For A Template
Oct 16, 2010I have a template where I want to replace certain regions. In my example below, I want to extract the regions between the. comments, manipulate it, then replace them back after the manipulation. I do not need the logic to merge the fields, but I need to extract the regions so I can use my logic and place it back into the template. Does anyone know of an elegant or simple way to extract these regions? I am also hoping to extract the url values in the process as well if it is easy to do along the way.
<table width="700" border="0" align="center" cellpadding="4" cellspacing="0">
<tr>
<td align="center" valign="top">
<!--DynamicSlotStart url="http://www.test.com/itemdisplay0_10751_-1_57436_10001"-->
<table>
<tbody>
<tr>
<td><p><a title="[element='title']" href="[url]"><img border="0" alt="[element='title']" src="[element='photo' property='src' maxwidth='135']" width="135" height="135" /></a></p></td>
</tr>
<tr>
<td><span>[element='h1']</span></td>
</tr>
<tr>
<td><span><strong>[element='price']<br />
</strong></span><span>[element='was_price']</span></td>
</tr>
<tr>
<td><span><a title="[element='title']" href="[url]">Details</a></span></td>
</tr>
</tbody>
</table>
<!--DynamicSlotFinish-->
</td>
<td align="center" valign="top">
<!--DynamicSlotStart url="http://www.test.com/itemdisplay0_10751_-1_3379_10001"-->
<table>
<tbody>
<tr>
<td><p><a title="[element='title']" href="[url]"><img border="0" alt="[element='title']" src="[element='photo' property='src' maxwidth='135']" width="135" height="135" /></a></p></td>
</tr>
<tr>
<td><span>[element='h1']</span></td>
</tr>
<tr>
<td><span><strong>[element='price']<br />
</strong></span><span>[element='was_price']</span></td>
</tr>
<tr>
<td><span><a title="[element='title']" href="[url]">Details</a></span></td>
</tr>
</tbody>
</table>
<!--DynamicSlotFinish-->
</td>
<td align="center" valign="top">
<!--DynamicSlotStart url="http://www.test.com/itemdisplay0_10751_-1_104854_10001"-->
<table>
<tbody>
<tr>
<td><p><a title="[element='title']" href="[url]"><img border="0" alt="[element='title']" src="[element='photo' property='src' maxwidth='135']" width="135" height="135" /></a></p></td>
</tr>
<tr>
<td><span>[element='h1']</span></td>
</tr>
<tr>
<td><span><strong>[element='price']<br />
</strong></span><span>[element='was_price']</span></td>
</tr>
<tr>
<td><span><a title="[element='title']" href="[url]">Details</a></span></td>
</tr>
</tbody>
</table>
<!--DynamicSlotFinish-->
</td>
<td align="center" valign="top">
<!--DynamicSlotStart url="http://www.test.com/itemdisplay0_10751_-1_80977_10001"-->
<table>
<tbody>
<tr>
<td><p><a title="[element='title']" href="[url]"><img border="0" alt="[element='title']" src="[element='photo' property='src' maxwidth='135']" width="135" height="135" /></a></p></td>
</tr>
<tr>
<td><span>[element='h1']</span></td>
</tr>
<tr>
<td><span><strong>[element='price']<br />
</strong></span><span>[element='was_price']</span></td>
</tr>
<tr>
<td><span><a title="[element='title']" href="[url]">Details</a></span></td>
</tr>
</tbody>
</table>
<!--DynamicSlotFinish-->
</td>
</tr>
</table>
Get List Of Keys In Cache - Use Default Name Region?
Jan 14, 2011I am trying to convert a solution using EntLib into using AppFabric caching. By help of a few extension methods this is a fairly pain-free process.
Extension methods I use:
public static bool Contains(this DataCache dataCache, string key)
{
return dataCache.Get(key) != null;
}
public static object GetData(this DataCache dataCache, string key)
{
return dataCache.Get(key);
}
But there are two features of EntLib I find difficult to convert. Namely "Count" (counting number of keys in cache) and "Flush" (removing all data from cache). Both could be solved if I could iterate the keys in cache. There is a method called ClearRegion(string region), but that required me to specify a region name on all Get/Put/Add-methods I use, which would require some manual error-prone work.
Is there any way to get a list of keys in cache?
Is there a default region name I can use?
How can I flush the cache when I haven't used a region name?
Visual Studio :: Remove #Region From Whole Website?
Aug 21, 2010I need to deliver source code to client and my boss need to remove all the comments and #region sections from the whole web site source code.
So is there any functionality available in visual studio 2010 or may be in an other 3rd party tool available to do so, which can remove all the #region from all over the source code ?
Otherwise my developers has to do donkey work.... :(( and I don't wish it.
C# - Can't Add #region To .ashx In Visual Studio 2010?
Mar 15, 2011i create a generic handler (ashx) but i am trying to add region in my code like the following
#region MyRegionName
context.Response.ContentType = "text/plain";
context.Response.Write("Hello World");
#endregion
there is no error but the problem that there is no expand and collapse.
C# - Add Region In Visual Studio In Aspx Files?
Mar 9, 2011I use asp.net with code behind and c#.
So I have two file for every .aspx page in VS 2010.
In .aspx.cs page I am able to add regions in my code using:
#region Name Region
#endregion
My questions:
How to do it in file .aspx? #region seems working only in .cs file. organize better my code both for .aspx and .cs file? Do you know the keyboard shortcuts to expand or collapse all my region in my code?
Possible To Create A Login/registration System On Site Without Using Any Of The Bulit-in Stuff
Mar 16, 2011Is it possible to create a login/registration system on my site without using any of the bulit-in stuff from ASP.NET - just like you can do in PHP? I've almost completely forgotten everything I learned about ASP.NET
View 4 RepliesLibraries For Working With Active Directory (mainly User Related Stuff) In C#?
Feb 17, 2010Has anyone seen any solid libraries for working with active directory (mainly user related stuff) in C# and asp.net. Am I better off intergrating with asp membership or building something customised.
I took a look at LINQtoAD but it doesnt seem to be active anymore.
Forms Data Controls :: Noob Stuff: Querying Any Value From SQL Database?
Jan 10, 2011I'm trying to create a search page that searchs one specific table in the entrie datbase.Basically someone writes what they want in a textbox in search.aspx, they click the search button, and it takes them to another page called search_results.aspx, carrying the inputted text along with it. What search results is supposed to do is at page load, its supposed to query the entire database for all values that are LIKE the text in the querystring, then transport the entire value set of each row that has a field matchign the query string, and then it's supposed take those values and put them in a template that presents them in the way that I want.
The only thing out of all that that I don't know how to do is write the code for taking the querystring and putting it up against all the values in the database like that. I know that you can find a value in a specfic comlumn, i.e.
SELECT Column1, Column2
FROM Table1
Where Column1 = 'blah1', 'blah2'
but how do you write it so that it looks at all the columns for 1 or 2 specfic values (the querystring), and then it returns the entire for each time it finds them?
ScriptManager And EnablePartialRendering - Panel With The Loading Stuff Doesn't Display
Feb 24, 2011I have a page that uses ajax scripmanager > progressupdate so I can display the user a message of "Loading, wait..". Now, my question is the following. I have the EnablePartialRendering set to true, mainly because if I set it to false my panel with the loading stuff doesn't display. When is set to true, then if I want to set the text and visibility on a row that is normally set to visible=false, it just doesn't happen. My row doesn't show. My "Loading" message will only display if a stored procedure exist, if it doesn't I just need to let the user know.
View 1 RepliesC# - UpdatePanel Breaks JQuery Script - Hide / Show Stuff
Jul 7, 2010This is a simplified version of what I want to do. Basically I have a datalist with a bunch of stuff in it and when you mouseover items in the datalist I want jquery to hide/show stuff. The problem is that after I databind my gridview/repeater/datalist jquery quits working if the gridview/repeater/datalist is in an update panel. After you click the button in the sample below, the jquery that makes the span show up when you mouse over quits working. Any ideas of why this is happening, how to fix it or a better way to do this?
<script type="text/javascript">
$(document).ready(function() {
$('.comment-div').mouseenter(function() {
jQuery("span[class=mouse-hide]", this).fadeIn(50);
});
$('.comment-div').mouseleave(function() {
jQuery("span[class=mouse-hide]", this).fadeOut(50);
});
});
</script>
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<div class="comment-div">
<asp:GridView ID="GridView1" runat="server">
</asp:GridView>
<span class="mouse-hide" style="display: none;">sdfgsdfgsdfgsdfg</span>.......................
C# - Define A Region In Google Maps Jquery Plug In?
Feb 9, 2010i put this plug in into my website, how i do define a region and restrict visitors to can not going out of ?
I don't have access [URL] for political reasons.