I have an application that uses multiple identical databases. When the user logs in they select the database that will be working with for that session. I am EF 4.0 for to access the database. What I can't figure out is how to dymaically pass the database name of the database from a session variable to the code in the EDMX file.
View 2 Replies
i've created my own custom model binder to handle a Section DropDownList defined in my view as:
Html.DropDownListFor(m => m.Category.Section, new SelectList(Model.Sections, "SectionID", "SectionName"), "-- Please Select --")
And here is my model binder:
public class SectionModelBinder : DefaultModelBinder
{
public override object BindModel(ControllerContext controllerContext, ModelBindingContext bindingContext)
{
var value = bindingContext.ValueProvider.GetValue(bindingContext.ModelName);
if (bindingContext.ModelType.IsAssignableFrom(typeof(Section)) && value != null)
{
if (Utilities.IsInteger(value.AttemptedValue))
return Section.GetById(Convert.ToInt32(value.AttemptedValue));
else if (value.AttemptedValue == "")
return null;
}
return base.BindModel(controllerContext, bindingContext);
}
}
Now within my controller i can say:
[HttpPost]
public ActionResult Create(FormCollection collection)
{
var category = new Category();
if (!TryUpdateModel(category, "Category")
return View(new CategoryForm(category, _sectionRepository().GetAll()));
}
This validates nicely and the correct value for the section is assigned when the model is updated, however it does not select the correct value if another property doesn't validate.
I'm building an application that will be used by a number of different schools who want completely separate databases so I've decided to have multiple connection strings and membership/role providers in my web.config file. In my code, I'm trying to set which connection string and provider to use at runtime for the correct database according to the logged in user.
I'm coming into a lot of bits in my code that previously worked fine, that now don't. For example, I used to use:
[Code]....
But now that I've changed it to this, it doesn't work anymore:
[Code]....
The compiler tells me that AddUserToRole is not a member of 'r'. I've had similar problems not just with Roles but Membership too, like with calling CreateUser.
I'd still like to be able to use all these methods that I was using before which are extremely handy. I just want to be able to set the membership/role provider at runtime rather than use the default one. Am I doing something wrong? Is there a simpler way to go about this?
I'm starting with asp.net MVC 2. Very cool.I have been reading about the data annotations validation attributes that can be set on the view model properties.It's cool but I have a scenario where I need to determine at runtime whether one of the property is required or not.How can I achieve this ? I want to have client side validation enabled too.
View 6 RepliesI am making a web project now. And i meet some problems working with Entity Framework. My program needs to have dynamic model. I try to explain. So i have classes and database is created from them. At the beginning of work program checks in folder Modules for assemblies and looks for classses that needs to be created as tables in database(this classes have to become a part of ef model). And i need at runtime create database.If some new classes was added so add this tables to database, but not recreate it(as it is made by default). If i delete classes the tables are not deleted.
View 2 RepliesIs there a way of selecting returned values from a call to an sql database in the code behind? For example assume that I used the following to select values from a table called Products;
SELECT Price, Qty, Numbersold FROM Products
How can I now get the returned values e.g. Price in the c# codebehind and display it in a textbox? I know that in the asp markup that I can use EVAL and Bind statements to do this for example I can do Eval("Price") but is there a way of getting any of the selected values (Price, Qty or Numbersold) in the codebehind?
I know that I can use three separate select statements and make three separate calls to return each value and then do something like the following
Price = Convert.ToInt32(myCommand.ExecuteScalar());
I want to select a row in gridview and add the data of the row into a DataBase Table.
I have 2 tables
Table A and Table B.
I am displaying Table A data using gridview.When the user clicks the select command button in the gridview then i need to add that row data into Table B.
I'm trying to select a random record from my database and display the details of the record on screen. The table I am using is the aspnet_Users table which as I'm sure you all know holds the details of users. After a bit of googling, I found the following code:-
[Code]....
I've built my page and I get no errors which is a great start I just can't seem to figure out how to then display the results of this query on the page. I just want to display the username for the record that is selected.
This is a simplified example of what I need. Imagine a person table with several different club tables. Every person can belong to any number of clubs, but must belong to at least one club. The association would be a 1 to zero or one between the person table and each of the club tables.I've created the databases, then the entity model. The associations are all 1 to many, which isn't what I want.
Is there a way to modify the database so that the model is created correctly? I'm still building the project, making lots of changes, and I've had problems with updating the model, so I keep recreating it. Setting up the database correctly would be preferable.I'm trying to follow the quickstart here: [URL]but I'm using the SQL Management Studio designer, and I can't find how to fix the associations I add.
I've been reading about using or not using foreign keys in the model, but it's only confused me more. Can someone help me understand this? I'm starting to write code with what I have, and I'm running into problems. I'm about to start using joins, which means I'm trying to use a hammer instead of a saw because I don't know how to use my saw. I'd rather understand my tools and use them the right way!
I created an Entity Frameworks model (.edmx).
Now, I want to change the database that my model is using.
How do I do that? Just change the connection string in the .edmx Properties, or is there more that is required?
when using Forms Authentication to validate against a SQL database, all the Forms Authentication samples utilizes the connection string from the web.config file. Is there a way of specifying the connection string for Forms Authentication to use, programatically at runtime?
Without going into great details, my web app will be utilizing different databases depending upon other factors. So, sometimes, the app will be utilizing Database1, and other times, Database2. Both databases will have the same Forms Authentication tables, just different values.I'm hoping there is a simple way of just specifying the database connection string to utilize, without having to go so far as to start implementing my own custom providers. Yet, I haven't come across any documentation that talks about how to do that (yet).
Im just wondering how you go about creating dynamic properties on entities that generated from a database generated model.For example I have a UserInformation table. In that table it has basic information on the user (well derr) like user name, address details etc etc. I want to add a readonly property that concatenates the user's Name, Address details and Phone Number into one string that I can output to a view. Any ideas on how i would go about creating this dynamic property. This is just a simple example, i am wanting to do some more complex calculating and concatenating.
View 1 RepliesI am trying to get the FailedPasswordAttemptCount from the ASP.NET built in objects and I am not able to find one, is there any way I can get this value without creating a new storedProc?
View 1 RepliesI have a group of radiobuttons. The field they are 'bound' to is of datatype tinyint (sql server), byte .NET. It is set to NOT accept nulls in the database column (col1) and no default value has been set for the column, or indeed, anywhere else.
View code as follows:
<ul> <li><%= Html.RadioButton("col1", "1")%></li> <li><%= Html.RadioButton("col1", "2")%></li> <li><%= Html.RadioButton("col1", "3")%></li></ul><%= Html.ValidationMessage("col1", "*") %>
If the user doesn't select any of them, I would expect null to be that the model would attempt to insert into the database. I would therefore get a validation error that I can display to the user, prompting them to choose one of the options.
However, instead of null, the model inserts a 0 into the database. As this does not fail, no error is raised.
I am not setting the default value to 0 anywhere, not in the mvc app or the database
Is there a way to create dynamic access database, tables and it's columns in c# and export or insert the data in it from excel file in c#?
How can I create the Access database and tables at run time using c#?
Please advice me how can we create we create a new table or can add rows in database sql server 2005 while user make changes in site?
View 5 RepliesI've been using entity data models for quite a few sections of my website and find it really good for saving things to the database.
After searching for a while, I can't seem to find a good way to populate a new instance with data from a database other than using a data reader. E.G:
MyClass.myID = reader("myID")
I've described my model using an Ado Entity Data Model file (*.edmx), and i wish now to generate my db schema and tables from it. Is it possible?
View 1 Repliesi am creating some of the control at runtime according database values. problem is that when i click onto the button, if the text box is empty, the required field validator(genrated at runtime) show first time that the text box is empty. but one agin i click on to the button, it doest show any error messege and all of the control which i am genrating at run time are hiding when i see at the page source, no control is find there.
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using AjaxControlToolkit;
using click2install.controls;
public partial class FeebackForm_Client : System.Web.UI.Page
{
HtmlGenericControl table = new HtmlGenericControl("table");
DataSet ds = new DataSet();
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
CreateForm();
}
}
public void CreateForm()
{
ds = DBManager.ExecuteDataset("[FeedBack_FeedbackDetail_get]");
for (int i = 1; i < ds.Tables[0].Columns.Count - 1; i = i + 4)
{
//CreateControl(txtAddress.Text.ToString(), txtAddressRun, false, false, txtAddressToolTip.Text, txtAddressWaterMark.Text);
string Name = ds.Tables[0].Rows[0][i].ToString().Replace(" ","");
if (Name != "")
{
TextBox txtControl = new TextBox();
//RequiredTextBox txtControl = new RequiredTextBox();
txtControl.ID = "txt" + Name;
txtControl.CausesValidation = true;
bool RequiredField;
bool ToolTip;
if (ds.Tables[0].Rows[0][i + 3].ToString() == "True")
{
RequiredField = true;
}
else
RequiredField = false;
if (ds.Tables[0].Rows[0][i + 1].ToString() != "")
{
ToolTip = true;
}
else
ToolTip = false;
string TooltipText = ds.Tables[0].Rows[0][i + 1].ToString();
string WaterMarkText = ds.Tables[0].Rows[0][i + 2].ToString();
CreateControl(Name, txtControl, RequiredField, ToolTip, TooltipText, WaterMarkText);
}
}
HtmlGenericControl tr = new HtmlGenericControl("tr");
HtmlGenericControl td1 = new HtmlGenericControl("td");
HtmlGenericControl td2 = new HtmlGenericControl("td");
HtmlGenericControl td3 = new HtmlGenericControl("td");
HtmlGenericControl td4 = new HtmlGenericControl("td");
Button btnInsertRun = new Button();
btnInsertRun.Text = btnSubmit.Text.ToString();
btnInsertRun.ValidationGroup = "Check";
td2.Controls.Add(btnInsertRun);
tr.Controls.Add(td1);
tr.Controls.Add(td2);
tr.Controls.Add(td3);
tr.Controls.Add(td4);
table.Controls.Add(tr);
pnlPreview.Controls.Add(table);
System.Threading.Thread.Sleep(500);
ScriptManager.RegisterStartupScript(this, GetType(), Guid.NewGuid().ToString(), "Hide();", true);
System.Threading.Thread.Sleep(500);
ScriptManager.RegisterStartupScript(this, GetType(), Guid.NewGuid().ToString(), "ShowAddDisability()", true);
}
public void btnInsertRun_Click(object sender, System.EventArgs e)
{
CreateForm();
//ds = DBManager.ExecuteDataset("[FeedBack_FeedbackDetail_get]");
//TextBox txt1,txt2,txt3,txt4,txt5=new TextBox();
//objBox2 = this.Page.FindControl("objBox2") as TextBox;
string ss = "txt" + ds.Tables[0].Rows[0][1].ToString();
//TextBox objTextBox = (TextBox)PnlControlPanel1.FindControl(strControlName);
TextBox txt1 = new TextBox();
txt1 = (TextBox)this.Page.FindControl("txt" + ds.Tables[0].Rows[0][1].ToString());
//txt1=this.pnlContainer.FindControl("txt"+ds.Tables[0].Rows[0][1].ToString()) as TextBox;
// txt2 = this.pnlContainer.FindControl("txt" + ds.Tables[0].Rows[0][5].ToString()) as TextBox;
// txt3 = this.pnlContainer.FindControl("txt" + ds.Tables[0].Rows[0][9].ToString()) as TextBox;
// txt4 = this.pnlContainer.FindControl("txt" + ds.Tables[0].Rows[0][13].ToString()) as TextBox;
// txt5 = this.pnlContainer.FindControl("txt" + ds.Tables[0].Rows[0][17].ToString()) as TextBox;
string fh = txt1.Text;
//DBManager.ExecuteNonQuery("Feedback_FeedbackInsert", ds.Tables[0].Rows[0][1].ToString(), txt1.Text,ds.Tables[0].Rows[0][5].ToString(), txt2.Text,ds.Tables[0].Rows[0][9].ToString(), txt3.Text,ds.Tables[0].Rows[0][13].ToString(), txt4.Text,ds.Tables[0].Rows[0][17].ToString(),
txt5.Text);
Response.Write("Ho Gya");
}
public void CreateControl(string Name, TextBox ControlID, bool RequiredField, bool Tooltip, string TooltipText, string WaterMarkText)
{
if (WaterMarkText == "")
WaterMarkText = Name;
HtmlGenericControl tr = new HtmlGenericControl("tr");
HtmlGenericControl td1 = new HtmlGenericControl("td");
HtmlGenericControl td2 = new HtmlGenericControl("td");
HtmlGenericControl td3 = new HtmlGenericControl("td");
HtmlGenericControl td4 = new HtmlGenericControl("td");
td1.InnerText = Name;
ControlID.ValidationGroup = "Check";
//ControlID.ValidatorMessage = Name + " is Required Field";
//ControlID.ValidatorDisplayType = ValidatorDisplay.Dynamic;
//ControlID.ValidatorEnableClientScript = true;
td2.Controls.Add(ControlID);
if (RequiredField == true)
{
//RequiredFieldValidator Valid = new RequiredFieldValidator();
//Valid.ID = "Valid" + Name;
//Valid.ControlToValidate = ControlID.ID.ToString();
//Valid.ErrorMessage = Name + " is Required Field";
//Valid.Text = "*";
//Valid.Display = ValidatorDisplay.Dynamic;
//Valid.EnableViewState = true;
//Valid.SetFocusOnError = true;
//Valid.Enabled = true;
//Valid.EnableClientScript = true;
//Valid.InitialValue = WaterMarkText;
//Valid.ValidationGroup = "Check";
//td3.Controls.Add(Valid);
}
if (Tooltip == true)
{
HtmlGenericControl span = new HtmlGenericControl("span");
//span.Attributes.Add("class", "hotspot");
span.Attributes.Add("onmouseout", "tooltip.hide();");
span.Attributes.Add("onmouseover", "tooltip.show('" + TooltipText + "');");
HtmlImage img = new HtmlImage();
img.Src = "info.png";
span.Controls.Add(img);
td4.Controls.Add(span);
}
//TextBoxWatermarkExtender WaterMark = new TextBoxWatermarkExtender();
//WaterMark.WatermarkText = WaterMarkText;
//WaterMark.EnableClientState = true;
//WaterMark.TargetControlID = ControlID.ID.ToString();
//WaterMark.Enabled = true;
//WaterMark.ID = "WaterMark" + Name;
//td1.Controls.Add(WaterMark);
tr.Controls.Add(td1);
tr.Controls.Add(td2);
tr.Controls.Add(td3);
tr.Controls.Add(td4);
table.Controls.Add(tr);
}
}
after rendring the page...
<div id="pnlContainer">
<table><tbody><tr><td>Email</td><td><input type="text" id="txtEmail" name="txtEmail"></td><td></td><td><span onmouseover="tooltip.show('Email');" onmouseout="tooltip.hide();"><img src="info.png"></span></td></tr><tr><td>FirstName</td><td><input type="text"
id="txtFirstName" name="txtFirstName"></td><td></td><td><span onmouseover="tooltip.show('First Name');" onmouseout="tooltip.hide();"><img src="info.png"></span></td></tr><tr><td>LastName</td><td><input type="text" id="txtLastName" name="txtLastName"></td><td></td><td><span
onmouseover="tooltip.show('Last Name');" onmouseout="tooltip.hide();"><img src="info.png"></span></td></tr><tr><td>City</td><td><input type="text" id="txtCity" name="txtCity"></td><td></td><td><span onmouseover="tooltip.show('City');" onmouseout="tooltip.hide();"><img
src="info.png"></span></td></tr><tr><td>Address</td><td><input type="text" id="txtAddress" name="txtAddress"></td><td></td><td><span onmouseover="tooltip.show('Address');" onmouseout="tooltip.hide();"><img src="info.png"></span></td></tr></tbody></table></div>
but after the click on to the button it shows only the container div..
<div id="pnlContainer"></div>
I want to have site.sitemap file that is build runtime from my sql database.
View 2 RepliesI Want To Save The name off control in BataBase and Whwnw My page is loading Add The Control in the page
View 6 Repliesin which i want to add number of buttons in the update panel based on the database so dat if i add a new entry in database the new button with the same name on it can be created !
i am using visual studio 2005 with c#
something like this on link http://webpos.businesstantra.in/DineIn.aspx
I'm having trouble connecting to my model to my existing database using Entity Framework . Here is the code I'm working with:
[Code]....
How can i make this work like i have 5 fields in my database table . 2) i created a model for validation with datannotation and created the compare password field as well with comparepassword attribute. (now my model has 6 fields including one external field compare password and 5 database fields)3) i created a view with that model.(User)4) now i created a controller as well but the problem arise here that when calling that actionmethod the compiler complains about the external field and tells it cannot find any extension method . how can i create the extension method or solve this error?
[Code]....
I ask this because i'm using Partial classing to extend my db model, and in doing so some snags i've run into using inheritance and also snags i've run into declaring my db model in another class as a property and just using it like that ie: Public Property DBModelClass as DBModelClassType - however, doign direct partial classing has worked out the best, with no snags... except for an issue i seem to be running into now.
that is, i create new properties with half-page code in the 'Get' part of the property decleration, these are like virtual/new properties that the db or db model isn't supposed to know anything about, the sort of stuff you generate/use but without saving it in your db, as i'm sure all of you have these. every time i submit my DBModel through an action, somehow, one of these properties 'Get' section is running (being called) even though i'venever asked for it to. of course, because it aint ready to run (it shouldn't) errors like null errors get returned (however, they wouldn't error if it were to run only when i asked for it to).
edit:
so this second part of my question, are all properties in a model generated from a db (linq to sql) ran or called by the model state automatically? without being asked to do so?
an aside:
(i do do a modelstate.isvalid - however, this running occurs before isvalid is called as it errors out before i even see validation information). that being, is the auto calling of all properties on a db model object even when not used normal? i tried using bind(false) and scaffold off on the problemed properties. and the first part of my question, just as a reminder, is if i should or should not be using partial classing as a substitute to inheritance when extending db model's?
