I have been using LINQ to SQL for quite a while (about two years). Every thing was fine until now. As usual, I created LINQ to SQL classes and built the project, then created an aspx page. However, I cannot see the DataClassesDataContext in the code behind file. It is not listed in the intellisense list.
im creating a button control in page int and im assing a click event for the button control. here the click event is not firing for the first time. here is my code.
{System.Data.SqlClient.SqlException: Cannot open user default database. Login failed. Login failed for user 'MyMachineASPNET'. File activation failure. The physical file name "MyApplicationPathApp_Dataaspnetdb_log.ldf" may be incorrect.
Using Profile propertiseAs aspnetdb.mdf and aspnetdb_log.ldf are supposed to get created automatically, but only aspnetdb.mdf is getting created log file is not created when i run application and get above error.
a) Assuming a page has a master page associated with it, then all controls (those declared in master page and those declared in content page) created during design time are assigned declarative values only during an Init event? I'm assuming this since to my understanding controls need first to be put into the control tree before they can be assigned their declarative values? And when page has a master page associated with it, then aren't page's controls put into the control tree only during the Pre_Init or perhaps even during the Init event? Then if that is the case, then isn't the earliest that these controls can be assigned their declarative values during Init event?
b) Assuming our page is associated with Master page and also uses a theme --> skin files are also applied during an Init event, so I assume that during an Init event Asp.Net first initializes controls to their declarative values and only then applies skin rules to them?
I need to access a control inside a repeater and change its properties. To enable it or not. I got an erorr message Object reference not set to an instance of an object. Here is my code inside a method. protected void
rptCAP_ItemDataBound(object sender, RepeaterItemEventArgs e) { LinkButton lnDel = (LinkButton)rptCap.FindControl("lnkDelete"); lnkDel.Enabled = false; //<<<<< this is where the error occur }
In my ASP.NET application I am using a lot of ObjectDataSource controls. I want to set the following three properties globally for all ObjectDataSource controls:
I found this function on [URL] It works great and I can get the properties and display them in separate binds. This is how I call the function, as shown In the link above
SELECT userid, username, dbo.aspnet_Profile_GetProfile(userid, 'FirstName', DEFAULT) AS FirstName, dbo.aspnet_Profile_GetProfile(userid, 'LastName', DEFAULT) AS LastName FROM aspnet_users
However, i cant get it to work with a simple querystring...
I want to fetch a users First and last name with a querystring, for example (default.aspx?user=DemoUser) But it doesn't work, it displays the latest entry in the aspnet_profile table. Btw, im trying to display it in a formview.
I create a table in SQL server 2008 and add some colume
after sometime i need to change some properties of colume
but problem come when saveing the table. Error message shown:-
Saving changes are not permitted.the changes you have made required the table to be droped and re-created .you have either made changes to a table that can't be re-created or enabled the option prevent saving changes that required the table to be re-created.
I have created a database along with the tables. The tables have the primary and foreign keys to create the relationship between them. However, I cannot now add the data to the table rows due to the key constraints. How do I now add the data to the tables without making up arbitrary data for the table ID's?
I was wondering if anyone knows of a good login stored procedure that can be freely used and features login limits and so on (basically a good one) With my limited SP knowledge, I've tried to create one myself, I haven't completed it yet as I'm not sure on how to compare the last login attempt time against the current time (it's in the comments).
My users have "demanded" to have an export function to their gridviews, and since they're running from usercontrols there's no way to modify the response stream. My workaround is to create an aspx to run in a hidden iframe. To do that, and to make it modular, I'm trying to dynamically create everything from the querystring. This *seems* to work just fine until I bind my sqldatasource to the dummy gridview. I then get "Procedure or function 'xxx' expects parameter '@NumberResults', which was not supplied."
Say for example, I have script like below whereby everything is same except the table name and each table name will append an incremental number, is it possible for me to have a for loop to dynamically add the incremental number?
i have a table with the following columns; [Id] [CreatedDate] [Title] [Description] the data type for the column [CreatedDate] is Datetime. What i want to achieve is, i want a query that can retrieve records in that were created in the past 24 hours.
I followed the article How to: Create a Database (SQL Server Management Studio)" [URL] I got this:-
//image
Then I tried to add this database in vs08 but at first I got nothing, then I manually started the MSSQLSERVER, after that it just displays the System Databases not the database "test1" I made So how to make it realize that I have made a database and I want it to connect to that database?
//image
i need to connect to the db"test1" so that i can manupilate it using vs08 controls.
I have a custom control which inherit from the Table class and in the constructor, it takes a an integer as an argument. There is no empty constructor.
Is there a way for the user to set that variable in the properties window after they drag the control onto a form.
I know some .NET controls, you can set the source for the parameter to different things like another control's property, QueryString using just the properties window.
Right now, I have to create the control dynamically. I read the query string and then created the object.
I want to set colums, TemplateFied,HeaderTemplate,ItemTemplate with (LinkButton-Text,CommandName,Onclick etc) Here I am showing my code t_name table name it is varable,I want to set various table contains various field,Then I want generate Dynamically Gridview with the above properties.
string str = System.Configuration.ConfigurationManager.ConnectionStrings["sql"].ConnectionString; SqlConnection con = new SqlConnection(str); SqlCommand cmd; SqlDataAdapter ad = new SqlDataAdapter(); con.Open(); cmd = new SqlCommand(“select * from t_name”, con) ad.SelectCommand = cmd; DataSet ds = new DataSet(); ad.Fill(ds, t_name); GridView1.DataSource = ds; GridView1.DataBind();
I've editing a create user wizard to add a 2nd step, this step will collect the users address. i can't get the second step to save into a table. I'm completely new to visual web developer, so if you reply please make it as jargon free as possible, see source code and vb code, i think i'm missing code for the "finish Button click"
Source code is. [Code]....
Code Behind the wizard control Partial Class Registration Inherits BasePage [Code]....
I am staring at the worst mess, my monitor isn't tall enough to see what is going on, and VS 2010 is noI do not have any idea how to refactor this trash.It's 11 AM and I feel like pouring a drink already.Is this just the final proof that I have no business coding? Be honest.
<div id="followedFriends"> <% if (Model.FollowedFriends.Count() > 0) {