|
I will give details of the infrastructure I have built and will talk about the problem in the end.
Database table "dbo.SmartPhoneBase" details: Following are the columns in the table.
SmartPhoneBaseID (Identity Primary Key)
Company
PhoneName
RAM
Storage
Database table "dbo.SamsungPhone" details: Following are the columns in the table.
SamsungPhoneID (Identity Primary Kay)
SmartPhoneBaseID (Foreign Key to dbo.SmartPhoneBase)
AndroidVersion
QualcommProcessorTech
AMOLEDDisplayTech
Entity classes for the above tables:
public class SmartPhoneBase
{
public virtual int SmartPhoneBaseID { get; private set; }
public virtual string Company { get; set; }
public virtual string PhoneName { get; set; }
public virtual string RAM { get; set; }
public virtual string Storage { get; set; }
}
public class SamsungPhone:SmartPhoneBase
{
public virtual string AndroidVersion { get; set; }
public virtual string QualcommProcessorTech { get; set; }
public virtual string AMOLEDDisplayTech { get; set; }
}
Mapping class for the above entity classes:
public class SmartPhoneBaseMap:ClassMap<SmartPhoneBase>
{
public SmartPhoneBaseMap()
{
Schema("dbo");
Table("SmartPhoneBase");
Id(x => x.SmartPhoneBaseID)
.Column("SmartPhoneBaseID")
.GeneratedBy.Identity();
Map(x => x.Company).Length(100).Not.Nullable();
Map(x => x.PhoneName).Length(100).Not.Nullable();
Map(x => x.RAM).Length(100).Not.Nullable();
Map(x => x.Storage).Length(100).Not.Nullable();
}
}
public class SamsungPhoneMap:SubclassMap<SamsungPhone>
{
public SamsungPhoneMap()
{
Schema("dbo");
Table("SamsungPhone");
Map(x => x.AndroidVersion).Length(100).Not.Nullable();
Map(x => x.QualcommProcessorTech).Length(100).Not.Nullable();
Map(x => x.AMOLEDDisplayTech).Length(100).Not.Nullable();
}
}
Please note following points.
1. For the subclass "SamsungPhone" the primary key is not allowed to be mapped with the method Id() hence I did not keep the property for same reason in the subclass even though its corresponding table "dbo.SamsungPhone" has a primary key. I created it just for the sake of it.
2. The table "dbo.SamsungPhone" does refer to "dbo.SamrtPhoneBase". Initially I had created a One-To-One relation between their corresponding entities but I saw that the error still appeared as it is (error mentioned below). So for the sake of simplicity I removed the relation from mapping classes even thought it still exist in DB.
Now I wrote the following code in the page load of my sample web application.
var result = nhSession.QueryOver<SmartPhoneBase>().List();
And following is the exception that is thrown and is visible on the browser.
Invalid column name 'SmartPhoneBase_id'.
Invalid column name 'SmartPhoneBase_id'.
Yes it appeared twice.
I am not sure what is going wrong but what I am sure about is that my fluent configuration and my other mappings are all correct as they are all working fine, even the mapping for table-per-class-hierarchy is correct and they are all working fine.
I need some help here.
Thanks in advance!
|
|
|
|
|
Well guys I just got the answer to the above problem. I just missed this mapping in the class SamsungPhoneMap
KeyColumn("SmartPhoneBaseID");
I did not see this being mentioned anywhere, not even the Fluent Nhibernate talks about it. But all's well that ends well, I got the answer at last.
|
|
|
|
|
hello guys.. When I apply some styles to my master page, VS does not show those styles properly in the design mode. If I run the project then these styles are shown properly. How can I fix this issue? thnx
|
|
|
|
|
give up on the design mode view....
maybe not the answer you want to hear but I only use it for a very general and basic idea of how things will look. if I want to see the real result I run it through ie, chrome, safari and firefox.
maybe not the best answer but it's the best I can give based on my experience.
as if the facebook, twitter and message boards weren't enough - blogged
|
|
|
|
|
Yes you are right. But the thing is, when I see some video tutorials online and I see that they are working with no problem whatsoever, then I get worried. If they can work, why can not mine?
|
|
|
|
|
I have a 2010 C# asp.net webform application that I just placed a checkboxlist control on the form. The problem is the selections
that are user can make are extremely large. Thus i am wondering if there is away to make the checkbox list control have a scroll bar?
Can I embedded the checkboxlist control in some type of a web control? If so what would it be?
Should I just use a regular checkbox control and put a group control are the checkboxes? Would this help anything?
|
|
|
|
|
|
step by step how to upload sql server database on webserver
and in which extension
please reply asap
rizvan sivally
|
|
|
|
|
Please don't ask for urgent or asap response. This is a volunteer site and people will answer you on their own time, not yours.
There is a wealth of information available for this if you take the time search
No comment
|
|
|
|
|
If I have selected counrty from dropdown list ,then contry related states shoould be visible in next the dropdun list.
Poonam Jagdale
|
|
|
|
|
|
hi,
im new at asp.net programming. In my menu there are 2 department, dept1 & dept2.Recently i have designed a website. Website's menu is designed by html and css.
Now i registered 2 user using asp.net web administration tool. User1 for dept1 and user2 for dept2. User1 can not access the page under dep2. Now the problem is when I click dept2 as user1, it shows me http404 error that the contents can not be found. Now what I want is if I click dept2 as user1 it will take me to the login page again. Again I made up that menu using css and html.
Any suggestion?
Thank You
|
|
|
|
|
I would suggest either setting the menu items visibility in the code behind depending on the roles (if the user does not have access why even display the menu item to them) or to load the menu items dynamically from the database by associating menu items to roles, and using the current users role to load the menu items and build your menu like that.
No matter how long he who laughs last laughs, he who laughs first has a head start!
|
|
|
|
|
I have a web page in which there is GridView binded with some records.
There are two buttons i.e. delete button and update button in the grid. Now When i click delete button, then the RowCommand event fires and it works perfectly. But when I click on update button to update the current row and then clicks on delete button to delete any row, then the following error occurs :
Invalid postback or callback argument. Event validation is enabled using <pages enableeventvalidation="true"> in configuration or <%@ Page EnableEventValidation="true" %> in a page. For security purposes, this feature verifies that arguments to postback or callback events originate from the server control that originally rendered them. If the data is valid and expected, use the ClientScriptManager.RegisterForEventValidation method in order to register the postback or callback data for validation
I have also used "EnableEventValidation='False'" in the page.aspx
but still getting same error ..
Kindly help ASAP
|
|
|
|
|
Since the sever generated the object, it expects to have full control over it. So the delete has to delete in the server side post back, and then rendered again on page load. It's a security issue in asp.net. You can wrap the object in an update panel, and so a small ajax trip to the server and back, while maintaining server side control.
|
|
|
|
|
I am adding a checkboxlist control to a C# asp.net 2010 since I am new to working with web pages. The following code works if I hardcode the value in the where clause. However, I want to pass the value in the where clause as a paramter. Thus can you tell me what I could change in the code below to pass the value to the where statement not as a hardcoded value?
[^]DBConnection.FillAttChkListBox(ChkBoxLstPlan, "Hnumber", "Hnumber",
DBConnection.ExecuteQuery("select p.Hnumber from dbo.Org o inner join Pl p on o.OrganizationID =p.OrganizationID where OrganizationName='orgname1'"), false);
public static DataTable ExecuteQuery(string SQLstring)
{
string constr = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString;
//string constr = ConfigurationManager.ConnectionStrings["Client_ServiceConnectionString"].ConnectionString;
SqlConnection conn = new SqlConnection(constr);
DataTable dt = new DataTable("tbl");
using (conn)
{
conn.Open();
SqlCommand comm = new SqlCommand(SQLstring, conn);
comm.CommandTimeout = 0;
SqlDataAdapter da = new SqlDataAdapter(comm);
da.Fill(dt);
}
return dt;
}
public static void FillAttChkListBox(CheckBoxList chklistBox, String dataValueField, string dataTextField, DataTable dataTbl, bool bHasBlank)
{
chklistBox.DataTextField = dataTextField;
chklistBox.DataValueField = dataValueField;
chklistBox.DataSource = dataTbl;
chklistBox.DataBind();
if (bHasBlank)
{
chklistBox.Items.Insert(0, new ListItem());
// chklistBox.Items.Insert(1, new ListItem("All"));
}
}[^]
|
|
|
|
|
You can try to make this select statement in a string variable
so you can concatinate your string variable in the where clause
Like that
string query="select p.Hnumber from dbo.Org o inner join Pl p on
o.OrganizationID =p.OrganizationID where
OrganizationName='"+AnyStringVariable+"'";
so that you can add any value in the where clause.
Try This , if it is not working , try to contact me .
Good Luck
Sincerely,
Ibrahim Hebeish | SoftwareDeveloper | Portal Services | EgyptNetwork(Com)
M: +201281744594
Email: i.hebeish@egyptnetwork.com
|
|
|
|
|
|
DBConnection.ExecuteQuery("select p.Hnumber from dbo.Org o inner join Pl p on o.OrganizationID =p.OrganizationID where OrganizationName='orgname1'")
you can make it like that :
string organizationName=_organizationNameTextBox.Text;
string query="select p.Hnumber from dbo.Org o inner join Pl p on
o.OrganizationID =p.OrganizationID where
OrganizationName='"+organizationName+"'";
DBConnection.ExecuteQuery(query)
so you can pass any value to the "Where" Clause (it is simple way).
or
you can make a Stored-Procedure that makes the same Query &
takes a parameter for the Where clause and this is the (recommended solution).
Sincerely,
Ibrahim Hebeish | SoftwareDeveloper | Portal Services | EgyptNetwork(Com)
M: +201281744594
Email: i.hebeish@egyptnetwork.com
|
|
|
|
|
Hi all,
I have this piece of code which sends the pdf to printer, using AcroRd32.exe to achieve this.
for (int i = 2; i <= 3; i++)
string filename = @"\c:\myfile" + i + ".pdf";
string parameters = String.Format(@"/t ""{0}"" ""{1}""", filename, printername);
ProcessStartInfo processStartInfo = new ProcessStartInfo(pdfpath, parameters);
Process process = Process.Start(processStartInfo);
process.WaitForInputIdle(80 * 1000);
process.Kill();
}
I want to print multipe pdfs for this. I put this logic in a for loop. For some reason it does not print the second document. Does the kill completely kill the entire process?
|
|
|
|
|
There is no open brace character "{" after your for statement.
|
|
|
|
|
Hey friends,
I am having a minor problem regarding the use of javascript function in my asp.net page.
Whts the cause of malfunctioning?
The code is as follows:
<script type="text/javascript">
function ask() {
return confirm('Do u really want to delete?');
}
</script>
<asp:Button ID="btnDeletewithoutfn" OnClientClick="javascript:return confirm('Do u really want to delete?');" Text="Delete" CommandName="Delete" runat="server" />
<asp:Button ID="btnDeletewithfn" OnClientClick="ask()" Text="Delete" CommandName="Delete" runat="server" />
The button
btnDeletewithoutfn works as intended i.e. page posts back if user clicks Ok otherwise not.
But the button
btnDeletewithfn always posts back regardless the user clicks Ok or Cancel.
Any guidance about the problem presented.
|
|
|
|
|
that's because you aren't returning the value of the response from your call to the ask() function.
try the following:
<asp:Button ID="btnDeletewithfn" OnClientClick="return ask();" Text="Delete" CommandName="Delete" runat="server" />
as if the facebook, twitter and message boards weren't enough - blogged
|
|
|
|
|
Thanks, Dennis and Alok 
|
|
|
|
|
In an attempt to do human detection for a support web page, I've come up with a scheme I think might be viable, and I wanted to run it past you guys.
The idea is to present a table with a randomly selected number of columns (from three to five), with two rows. the first row contains images, and the second row contains Submit buttons.
The images that can be presented (at least 20, probably more) are contains in a folder with descriptive names, such as "green square", "dog", or "car". When a user goes to the page, the files are randomly selected, and for each file, a file name based on a quid is created, and the original file is copied to a temp folder with the guid file name. One of the selected files is randomly selected as the "correct" image, and the user is prompted to click the appropriate button (based on its original file name, like this:
"Click the submit button under the picture of XXXXX"
where "XXXXX" is the name of the original file (minus the extension, of course). So, if one of the displayed files was "dog 01.jpg", a guid file name would be generated like this - "00000000-0000-0000-00000000.jpg" - and the control's ImageUrl is set to this guid file name, and the prompt would read "Click the Submit button under the picture of the dog."
This mechanism is intended to prevent bots from learning the system by looking at the image name, or expecting a fixed number of choices, and still allows a number of "dog" images to be used so that the image isn't the same every time the page is presented. Post-backs would delete the temporary images.
What do you guys think? Will it be effective?
".45 ACP - because shooting twice is just silly" - JSOP, 2010 ----- You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010 ----- "Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass." - Dale Earnhardt, 1997
|
|
|
|