If I make changes to a table or view in the datacontent (dbml), is there any way to refresh the fields in the dbml without deleting the datasource and inserting it back again?
View 1 RepliesI have MyDB.dbml in my Models folder that was created by dragging tables from Server Explorer. I'd like to make some changes to the design of those tables. Before I do that, how do I get the dbml to refresh itself?
I do expect to have to fix code where field definitions change & that's okay. I just don't want to have to start over from scratch.
I have a dbml file which I have added a couple of tables to. The database also contains synonyms which point to other tables in a different database. I can't seem to drag the synonyms to the design surface though?
View 4 Repliesi have some confusion using compund from in linq.I know the concept of compound from but in database table how can we use.can anyone give me example of it.
View 3 RepliesI used SQLMetal to generate a DBML file, which worked fine. The problem is that since this DBML file is so big (185,000 lines at 840Kb) it takes literally hours to load in VS2008. What is the recommended way to resolve this? I tried using a third party tool call SqlMetalInclude to break the DBML up into multiple data contexts, but that tool generates only designer.cs files, not dbml files.
View 2 RepliesHow do add read-only computed column in LinqToSql designer (dbml)? My existing table structure:
Name: ID, Type: int, AutoGenerate: true, AutoSync: OnInsert, PrimaryKey:
true, ServerDataType: int not null identity, Source: IDName: Name, Type: string, ServerDataType: nvarchar(100) not null, Source:
NameName: Value, Type: byte[], ServerDataType: VarBinary(max), Source:
Value, UpdateCheck: Never
I want add the 4th colum name: Name: HasValue, Type: bool --> [Value] != null
I have a DBML file in C#. And I have drag and drop some Stored Procedurs in it . Now I have changed some SPs. Now I want to refresh the dbml file without drap and drop the SPs. How can I do it in C#. Is there any way that the changes Made in SPs will come with out drag ang drop the SPs.
View 3 RepliesIs there a way to clean all tables or objects within a database and make it like a brand new database?
View 3 RepliesI'm still relatively new to asp.net I'm trying to figure out the best way to write and implement this.
I have a cell that needs to autoincrement by 1 for every new database row in my table, Unfortunately I have to have the autoincrement restart at 1 at the beginning of each year so I can't use SQL Server identity increment. Maybe i'm wrong about the last statement and I just don't know how to do it.
The code i have is something like this:
If thereadedyear <> Now.Year then
theReadedYear = Now.Year
SomehowWrite readedYear
StartNumber = 1
Else
StartNumber =+ 1
End if
How do I implement this in a Insert Template?
I have LinqDataSource ID="LinqDataSource1" with values - EnableDelete="True", EnableInsert="True" EnableUpdate="True" on my ascx page, furthermore GridView, button a few textboxes, where a fill new values, which I would like save in my database. After click on button I insert new value to the table throught in function stored in ascx.vb page. It is works, but I don't know, how I refresh GridView on ascx page. I tried
LinqDataSource1.DataBind()
GridView1.DataBind()
without any good result, I must refresh page manualy (F5).
yes i know half post ack occurs but it does occur right?so why doesnt the dropdownlist get refreshed when the timer ticks on?. for alternative i tried manually clicking a button to create postback but still no refresh of connection of th list
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<br />
<asp:UpdatePanel ID="UpdatePanel2" runat="server">
<ContentTemplate>
<asp:Label ID="Label1" runat="server" Text="Status"></asp:Label>
<asp:Timer ID="Timer1" runat="server" Interval="6000">
</asp:Timer>
<asp:GridView ID="GridView1" runat="server"
AutoGenerateColumns="False" DataKeyNames="Username"
DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="Username"
HeaderText="Username" ReadOnly="True" SortExpression="Username" />
<asp:BoundField DataField="Password"
HeaderText="Password" SortExpression="Password" />
<asp:BoundField DataField="Code" HeaderText="Code"
SortExpression="Code" />
<asp:BoundField DataField="Validated"
HeaderText="Validated" SortExpression="Validated" />
<asp:BoundField DataField="Silenced"
HeaderText="Silenced" SortExpression="Silenced" />
<asp:BoundField DataField="Full_Name"
HeaderText="Full_Name" SortExpression="Full_Name" />
<asp:BoundField DataField="Batch" HeaderText="Batch"
SortExpression="Batch" />
<asp:BoundField DataField="Department"
HeaderText="Department" SortExpression="Department" />
<asp:BoundField DataField="abuse" HeaderText="abuse"
SortExpression="abuse" />
<asp:BoundField DataField="Status" HeaderText="Status"
SortExpression="Status" />
<asp:CommandField ShowDeleteButton="True"
ShowEditButton="True" ShowHeader="True" ShowInsertButton="True"
ShowSelectButton="True" />
</Columns>
</asp:GridView>
<br />
<asp:DropDownList ID="DropDownList1" runat="server"
DataSourceID="SqlDataSource2" DataTextField="Username"
DataValueField="Username">
</asp:DropDownList>
<br />
</ContentTemplate>
</asp:UpdatePanel>
I have created a simple dataset with my ObjcetDataSource to my SQL table named Invoices and a new FormView. My form inserts are working 100% correctly, however after some testing i noticed the insert happens again if i hit the refresh button on my browser after an initial insert. I am currently submitting the form back to itself with a success/fail message returned on the page so that the user can keep inserting more records if they choose. This is done in my Inserted behaviour.
In my ObjectDataSource_Inserting code i am setting the values of a date prior to my insert. How do i stop a second INSERT from happening when the user refreshes the browser? I thought it was what IsPostBack was used for? Here is my code:
[Code]....
I've had to update my datasource as a field on my report has change. he StoredProcedure works just fine. However the report data source WILL NOT UPDATE so I cannot add the new field to the report!
View 2 RepliesI am building an image gallery, and decided to try out LINQ to SQL in it. My problem is when I try and remove an image from the database, it gives me the error:
"An object specified for refresh is not recognized. Right before this, I call a stored procudure that removes the the row, then I tell the DataContext to refresh (Otherwise it seems that the changes never get applied).
Here the code:
[Code]....
The last line is where the error is thrown. I've tried removing the last two lines both one at a time and altogether, and the code executes without an error, but the changes never seem to be applied as subsequent SELECT statements return the deleted row.
The whole application has access to the same instance of the Shared DataContext.
I have a linkbutton that displays a different record each time the page is loaded. When I first bring the page up, I can hit F5 repeatedly and the linkbutton works properly rendering a diff record each time. But in a dropdown list, or any other control that causes a postback, the linkbutton remains static, why?
In my Page_load I have
AccessDataSource1.SelectCommand = "SELECT blah FROM table where trim(recid)=" &
"'" & rndVal &
"'"
AccessDataSource1.DataBind()
LinkButton1.Text = DetailsView1.Rows(0).Cells(1).Text
to use a datasource from within another datasource..?
View 8 Repliesi have problem white Object datasource. i have a multi-tier Application that include common layer ,DAL Layer,business logic and persantation layerwhen i add a object datasource to my page, it bring me only common layer classes . but i want use bisuiness layer classes what do i do ?
View 1 RepliesI have several web forms which use a GridView linked to a DataSource control which is defined at design time as follows:
<cc1:pgsqldatasource
id="dsStates"
runat="server"
connectionstring="<%$ ConnectionStrings:PgSqlConnection %>"
oldvaluesparameterformatstring="Original_{0}"
providername="<%$ ConnectionStrings:PgSqlConnection.ProviderName %>" >
</cc1:pgsqldatasource>
As you can see, the connectionstring parameter is defined to a specific connection string name and I need to be able to set such a parameter to a different value, for example, to a session variable content.
i am trying to create connection using OLEDB connection in my app. but i am not able to create the connection as in datasource i want to use Server.mappath, but cudn't find the right method to use it. i am trying to make connection with Access database file. following is code i have tried:
string path = Server.MapPath("~/uploadaccess/Production.mdb");
string ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("~/uploadaccess/Production.mdb")&";";
and also
OleDbConnection myConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & path&";");
and tried this
OleDbConnection myConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("~/uploadaccess/Production.mdb"));
and this is the error i am getting:
Operator '&' cannot be applied to operands of type 'string' and 'string'
I am storing a custom "Organisation" object as a session variable. One of the properties of the Organisation object is "OrganisationID" (integer). I have a DataSource that requires a parameter value to run, and I want to use a SessionParameter to populate this. In a previous version, I stored the OrganisationID directly as a session variable. In that case, I could easily access it like this:
[Code]....
However, how do I now access the OrganisationID property of an "Organisation" type session variable (called "Organisation")? I have tried this, which does not seem to work: <asp:SessionParameter Name="OrganisationID" SessionField="Organisation.OrganisationID" Type="Int32" />
i have two sqldatasource controls. one i use to display data in textbox's ,filter'd by a select parameter in page behind code. Once checked, i want to copy this data to the other datasource ,by selecting checkbox.Then display this data in detailsview control.
At present the two datasource controls declared , render data to the page simultaneously during pageload. I want to first check data in textbox's from first source, before second datasource is rendered to screen. note, both are filtered by a page variable. i wish to leave the textbox datasource control in situ, as other controls and code depend on it.The other detailsview datasource is my problem?
ASP.net SQL datasource C# code behind
I want the webpage to show a message that there is no data selected,
Instead of showing blank details view
here is a picture of blank details view:
[URL=http://img28.imageshack.us/i/errorks.jpg/][IMG]http://img28.imageshack.us/img28/4328/errorks.jpg[/IMG][/URL]
What C# code do i need to use so that, whenever I enter that page, only an error message will show up
instead of the details view ..etc.
im explaining this base on a test page that i have hosted as i was trying to track down my problem, i have a hosted page which i have hosted on the internet on a hosting service provider. the page has a normal gridview that is linked to a SqlDataSource. and theSqlDataSource has sql statements for selecting data, updating and deleting. They all work fine locally and even if i host them locally through IIS. but on the hosting service they down work. only the select work, which means i can view my data on the gridview but i cant manipulate it, delete and updating dont wanna work, they dont do anything. and the worse part is that im not even getting an error from them, on the grid i have enabled the autogenerate edit button and the delete, how can i make the update and delete work, or what is it that makes them not to work. the code for my test page is below
[Code]....
I've a listview with checkbox control in it and datasource as object data source.
I'm updating the values in listview using update method in object data source, problem is I'm not able to pass the value of checkbox checked in the update event as parameter.
Scenario:
I am creating a custom gridview control which has a custom CheckBoxTemplateField column (deriving from TemplateField class). This template field column has custom Checkboxheadertemplate (implementing ITemplate) and CheckboxItemTemplate (also implementing ITemplate). In InstantiateIn method of both templates (header as well as Item template), I am adding a checkbox control which has Autopostback = true.
My requirement is:
I want to mark all the values in the binding column of datasource if checkbox in headertemplate is checked. I dont want to mark only rows visible on grid. I WANT TO MARK ALL ROWS IN DATASOURCE. I want to do this in _CheckedChanged event of checkbox in header template.
Problem I am facing: When I check/uncheck the checkbox in header, it postbacks. so in OnCheckedChanged event, gridview's datasource is null. Secondly, in any event of gridview, I could access only those rows of datasource for which corresponding rows are visible in gridview through Gridviewrow.DataItem property. But I want to set it for all rows in datasource.