I think that type of data types is really smart.and hope some can help me with something more.I could not find any links about it.Right now, I can only make a getdata (), which shows all data:
[code]...
I am trying to create strogly typed datasets for my project. When I right click on the xsd file that I need to generate a strongly typed dataset for I can't find the 'Advanced' properties as described in the below article (almost half way down)[URL]As I do not see the Advanced properties option I can't find the 'Custom Tool' property/option to set its value to 'MSDatasetGenerator'. Do I have to install some kind of patch on my VS 2005?
View 5 Replieswhere can i find the tableadapeter to add data to my database table? and is that the best way or there a easier way... i have a csv file that i would like to add to my data table but i don't know how?
View 1 RepliesI'm using Postgresql/Npgsql in my asp.net application, so I can't use LINQ to SQL. I implemented the following method of User class:
[Code]...
I am writting a custom class with which I manipulate the data for my website. I was wondering if there is a way to connect to a database and retreive the column names for a given table with out sellecting any data in the table.
Currently I am using an sql select and connection string to create an SqlComman object. Then I use the command object to create a SqlDataAdapter object which I use to fill a DataSet. At the end of all that I am able to retrieve the column names but I have select data and retreived data.
I have a GridView whose datasource is set programatically. The sorting is also handled in code via the OnSorting event of the GridView.Since I'm stuck in crappy dotnetnuke, I've had to change the doctype of the skin to XHTML Transitional so that the AjaxControlToolkit would work properly with IE.fter doing this, the sorting of this GridView stopped working... if I remove the doctype change file, it goes back to working again.I can tell that the event is firing, but it is now unable to find the underlying DataSource of the GridView to have something to sort. My OnSorting event follows; whenever it is fired, the "Data Source not Found" message is displayed.
[Code]....
protected void gvGrads_Sorting(object sender, GridViewSortEventArgs e)
How can I find the 5 last records ?
CREATE PROC [dbo].[SP_NEWS_SELECT]
(
@NB_NEWS int,
@ID_NEWS int,
@DT_PUBLICATION datetime
)
AS
SELECT TOP @NB_NEWS *
FROM [REP_CLI].[S_ETATS].[T_NEWS]
ORDER BY [DT_PUBLICATION] ASC
This does not work
I have a webapp. use links with DB data and link this data to a masterpage side?
View 2 RepliesI created a database on SQL Server 2005 developer edition with MS SQL Server Mangement Studio Express. Now I created code that accessess a stored procedure named 'pS_TableData'. However I have one problem the code raises an exception "Could not find stored procedure 'pS_TableData 'Letters''."the code looks like this:
[Code]....
Note I am using (for now) the same connection that I used to create my database so in essence my web site is the administrator. I tried a simple SELECT from a table with the same connection and it raised no exceptions!When I run EXECUTE ps_TableData 'Letters' in SSMS it has no . I also tried EXECUTE ps_TableData 'Letters' as the command paramated for SqlCommand but it had the same effect
I have to write a stored procedure to get the biggest two values out of three in three different columns in the same table.
I have a table , for instance,
total marks1 - column1 ( eg values - 1000)
total marks2 - column 2 (eg values - 500)
total marks3 - column 3 (eg values - 800)
i have to get (return the value) 1000 and 800.
best Way to find out if record exists?
[Code]....
how to find particular date is Sunday or not? in sql 2000
View 3 RepliesI have a Windows 2003 test server hosting an asp.net 2.0 application and Sql Server 2005 running as Sql Server 2000(80).During a recent a security review we decided that it wasn't such a hot idea to use sql authentication with an sysadm user as the database user for the asp.net application. Having done a bit of reading (http://msdn.microsoft.com/en-us/library/ms998258.aspx#pagguidelines0001_dataaccess) I decided to use a lower privilege database user account and windows authentication.Starting from scratch I created a new custom service account (http://msdn.microsoft.com/en-us/library/ms998297.aspx) and assigned this to the process identity for the application pool.I then created a new database login and user for this account. I added the db_datareader and db_datawriter roles to this user and I also granted EXECUTE permissions for user defined stored procedure and functions. However when I started the application I got this error 'User does not have permission to perform this action.Cannot find the object 'AspNet_SqlCachePollingStoredProcedure', because it does not exist or you do not have permission.' - after a quick hunt I found thishttp://forums.asp.net/p/1487216/3493362.aspx and followed the advice herehttp://msdn.microsoft.com/en-us/library/system.web.caching.sqlcachedependencyadmin.aspx and granted the user CREATE TABLE and CREATE PROCEDURE permissions.Still no joy - after digging around and looking at sql profiler I found what I believe to be the offending piece of sql:
/* Create notification table */
...sql
/* Create polling SP */
..more sql
..finally
GRANT EXECUTE ON dbo.AspNet_SqlCachePollingStoredProcedure to aspnet_ChangeNotification_ReceiveNotificationsOnlyAccess
My understanding is that to issue 'GRANT EXECUTE' the user must db_owner or db_secadmin. Indeed it all works fine if I give the service account user login the db_owner role.This sql is caused by: SqlCacheDependencyAdmin.EnableNotifications(ConnectionString), this is called once and once only by the application start event.Is there a work around for this? I would like to use the lower privilege account as per best practice but this issue is making it tricky.
I have created a table in my SQL database that has a primary column (Title) and another column named Callsign. How can I access the table row that has a certain title and Callsign using C# in a web page event handler?
View 7 RepliesI have a stored procedure that has hyperlinks in it when I call that stored procedure into a gridview those hyperlinks are displayed which is fine. I want them removed when I export the gridview to excel but remember they are in my stored procedure.
Here's the query
SELECT '' AS reg, RegionAcronym, '<a href=nation.aspx?RegionAcronym=' + Regionacronym + '>' + 'PHI' + '</a>' as area,
SUM(totpenfodds) AS 'totpenfodds',
SUM(pendinfo) AS 'pendinfo', SUM(pendndds) AS 'pendndds',
SUM(pendfo300) AS 'pendfo300',
[Code] .....
I am showing data on a gridview.I want to show one of the column as hyperlinks and when i click that column value and it need to releated value information in a sepereate page.
I am trying to use hyperlinkfield but it wont take values (data).How to acheive my task..
I need to display foders n files information(type,size,date modified etc) of a particular directory in a gridview.I need to make the folders as links and files as labels before binding the data.
View 1 RepliesI'm trying to access and display certain data in my database using category ID's. I've added values to the links in a link list and I was to have the selected value as the one that determines the selection in the selection statement. For example, "SELECT [ID_key] AS ID_Key, [Title], [Source], [PublicationDate], [Url], [CatID] FROM [Newsarts] WHERE ([CatID] = Linklist1.SelectedValue)". I know Linklist1.SelectedValue doesn't work or it may work and I don't know how but I want to be able to use the value selected from the previous link. Is there a way?
Also, after all the data is displayed, I would like them to become links themselves. Basically, I want to choose a category, then choose an article in that category, and they hit the link to display the article's content.
i need the northwind databse. i dont have it in the database where i can find it and who to add it to my database in sql server so can i c it in the combo box off the database
View 1 RepliesThere is one sp(1) which is called from another sp(2)How can I find from which sp it is called.
View 2 RepliesI have come accross a scott's blog today;
http://weblogs.asp.net/scottgu/archive/2010/06/30/new-embedded-database-support-with-asp-net.aspx
what is exactly Sql server compact edition? it says that I do not need a sql server to store my databases if I use that in my bin folder? so I can use my mdf databases in app_data folder. is that true?
I have ported over the website to my localhost running windows 7, I got the Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'. before so I ran the aspnet_regsql.exe and fixed it after the error I fixed I was able to login into the CMS however when I try to save content it gives me :-
Could not find stored procedure 'dbo.sp_UpdateContentById'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Could not find stored procedure 'dbo.sp_UpdateContentById'. Source Error:
[Code]....
Line 73: public int sp_UpdateContentById([Parameter(Name="ContentId", DbType="Int")] System.Nullable<int> contentId, [Parameter(Name="Content", DbType="VarChar(MAX)")] string content)Line 74: {Line 75: IExecuteResult result = this.ExecuteMethodCall(this, ((MethodInfo)(MethodInfo.GetCurrentMethod())), contentId, content);Line 76: return ((int)(result.ReturnValue));Line 77: }
Source File: c:IQTECHPROApp_CodeCkEditor.designer.cs Line: 75
I have to following Linq query, where I look for some different timestamps in an DB:
[Code]....
My problem is that I would like to filter the query, to only return entries, where OutOfOrderStart and OutOfOurderEnd is from the same row. How can I accomplish this?
I've created details masters before but can't remember what links the two together. When an item is selected with a master, such as a gridview, what is used to tell the details view which record to display? Is it the DataKeyNames property?
View 4 Replies In the below code I have data displayed in the webform in a datagrid which has links in it.when I click the link of seperate order or property number they dont work.
<asp:Repeater ID="rptClientBooking" runat="server" OnItemDataBound="rptClientBooking_ItemBound">
<ItemTemplate>
<tr> [code]....