i am uisng asp.net 2.0 built in crystal report .i already have the connection made and some fileds already on the report. i need to add few more fields to the the existing set of fields from database in the server explorer i have the field that i need but i am not able to drag drop on the crystal report.how do i add the field from datatable to crystal report
View 4 RepliesI'm a php expert, I'm developing oop php applications for over 8 years, I currently live in asia and I'm planning to go to USA, for better income in USA do you think it's good for me to learn ASP.NET too? Which one is better for me, ASP.NET or other PHP Related technologies like other advance PHP Frameworks
View 1 RepliesHow to enable group layout in chart expert of crystal report??
View 1 RepliesI am using RDLC 2008 and I have an amount field which I want to format like 1,000 or 12,000 or 12,200, 345 ...amount can go upto milion or billion so need thousand seperator accordingly and keep one thing in mind that i dont need decimals as the figure is already rounded.What should I write in expression to achieve this.
View 4 RepliesI am exporting ASP.net filed values to Ms-Word using following code without any hurdels .I have around 70 fileds on my webform, all the fields are not filed with values some are blank.when i am taking the print out blank fields should not get printed.How can i modify following code.
[Code]....
i am making a report.rdlc which depend on the statment
[Code]....
which doesn't have a specific column name
how can i fill the table in the report
column value in table =Fields!columnname.Value (how can i get columnname, it is dynamic)
I am working on a simple table with 5 columns with a header and detail records. I need to format those detail records so that when I export to excel the formating stays with it.
I tried this as an example
=FormatDateTime(Fields!StartDate.Value, DateFormat.ShortDate)
It looks fine in report viewer howeverver when I export to excel it formats it as General.
I need to format Dates, Costs, and Text
i am using .rdlc report .I have three fields like length,width ,height.I want to display Length X Width X Height.This is not multiplication .i want to show in a single column.
View 2 Replies[URL] .... I done as per in the given link ....
But I get error unrecognized identifier at GetBreakupstring (
I want to watch field in a single cell in newline in MS reporting service table cell....
I'm successfully using SqlBulkCopy to import spreadsheet data.
I am trying to add 2 additional fields,'UserID' and the specific 'employerID' whom they're logged in as.
Both these ID's are on the page. However how do I tag them on to my column mappings statement?
These ID's aren't on the spreadsheet but I need to know whose imported the data and from where
The columnMappings structure:
[Code]....
I have a web app that is tracking basic medical provider demographica information (name, address, phone). If our client requests us to include gender and DOB as the fields tracked, can this be done on the fly without compiling and publishing my web app?
View 2 RepliesI am attempting to customise the CreateUserWizard by following it in my book, but when I come to reference them in code behind I get an error saying 'FieldName is not declared' for each field i'm adding, they are present in the page with the correct ID's, am I doing something wrong?I am only trying to add a firstName and lastName field to the bottom of the CreateUserWizard and remove the need to a security question.
View 1 Repliesi m trying to add new field named mobile in my create user wizard control for that in my web.config i add
profile
enabled ="true">properties>add
name ="Mobile"
type ="string"/>properties>profile>
in my create user wizard using edit template i add one textbox named 'txtmobile'
nd in my cs i write
CreateUserWizard2_CreatedUser
{
ProfileCommon p = (ProfileCommon)ProfileCommon.Create(CreateUserWizard2.UserName,
true);
TextBox txtM = ((TextBox)CreateUserWizard2.CreateUserStep.ContentTemplateContainer.FindControl("txtMobile"));
p.Mobile = txtM.Text;
//p.Mobile = ((TextBox)CreateUserWizard2.CreateUserStep.ContentTemplateContainer.FindControl("txtMobile")).Text;
p.Save();
}
but it throws the error of 'object reference' nd also let me know how to store that field in db?
I'm using VS 2010 and have a default Register User page. I want to add a few more fields to the default user name, passwor, email.These fields need to be saved to a different table than the apsnet_Users table. I figured I could do this in the CreatedUser event but don't know how to access the text box controls I added - for example First name, last name and so on.
View 2 RepliesI'm just starting out with ASP.NET and I'm not sure how to go about the following:users have to input a part number into a text field. Sometimes they only have to input 1 part number, sometimes 50. I want to have 1 text field where they input the first part number, and if they have another one, they press a "more" button. Then, a new text field appears right beneath the first one. IF they have more part numbers, they just press the more button again... Is there a way to do this? If so, can someone give me any tips or hints on how to approach this?
View 3 RepliesI added new profile in the webconfig file. Also added extra fields in CreateUserWizard.
Web config:
<system.web>
<authentication mode="Forms" />
<compilation debug="true" targetFramework="4.0" />
<pages theme="Theme1" />
<profile enabled="true">
<properties>
<add name="Country" type="string"/>
</properties>
</profile>
</system.web>
Cs code:
public void CreateUserWizard1_CreatedUser(object sender, EventArgs e)
{
Profile.Country = Text1.Text;
//also tried doing:
ProfileCommon p = (ProfileCommon)ProfileCommon.Create(CreateUserWizard1.UserName, true);
p.Country = Text1.Text;
p.Save();
}
The Profile/ProfileCommon gives me an error "missing assembly/Profile doesn't exsit"
I have a application that i am creating in ASP.net i need to be able to update a new column in the table users which is set up automatic with a asp.net project. I am trying to add a address line to the code
This is code that i have so far
TextBox address1TextBox =
(TextBox)RegisterUserWizardStep.ContentTemplateContainer.FindControl("Address1TextBox");
TextBox userNameTextBox =
(TextBox)RegisterUserWizardStep.ContentTemplateContainer.FindControl("UserName");
Profile.
Membership.UpdateUser(user);
how i would even update this column in the user table that i have.
how i could update the address line1 table in the database that comes with a visual studio 2010 project.
I want to create an Select SQL string by some search fields. Since I can't check the blank ones, otherwize it would look for blank, I have to do this on steps, adding them if they where not in blank, so, for that I am using something like this:
String SearchString = "SELECT * FROM Sala ";
String SelectWhere = "WHERE "; //This where is because I may receive all empty, so, the WHERE would make problems in the string.
If (TextClassroom.Text != "") {
SelectWhere += "(Classroom = " + Classroom.Text + ")";
}
But here is the issue. I may search for more than one at once, and that, would make me have to put an "AND" clause between them. How do I check that in the less number of lines as possible? I made a count variable, so I can count when it has been entered. But, getting to the third time it gets in, I have to check if the number is 1, or the number is 2, to see if I need to put an AND, right? And that would start making hard when we have, like, 10 fields. Is there an easier way to check when to put the AND without that many checks inside checks of empty texts?
How to select multiple fields from a dropdownlist..
View 6 RepliesMy C# web app requires the user to enter automobile information. The user can add information for one auto, or more (max 20).
My page has these text fields: Car Number, Car Make, Car Year, Mileage, VIN I have a button that allows the user to "Add More Cars" is to allow the user to add more than one car.
When the user clicks "Add More Cars", how can I dynamically display the text boxes, and keep track of how many cars the user has added (in order to load them to an array and write to database)
are below all 3 points the same?
1)<boundfield>
<asp:button ....>
</boundfield> [code].....
I have an SQL datasource that successfully enters customer details into a table. What it includes is the persons address. First of all we add the persons address, then we add the persons name to that address in a seperate physical procedure. i.e. on a different form.
What I need to do is try and stop users entering the same address twice. The way I have thought of doing this is by making a string field called AddressIdentity and have this contain the door number and the postcode of the address with all the spaces stripped out. Then when adding the address, it checks if this exists before adding it. However I cannot work out how to put the 2 fields together without using the codebehind file, which I don't mind doing if I need to, but I'm sure its avoidable.
Here is my code - I have only included the relevant parts:
InsertCommand="INSERT INTO [tbl_shop_client_addresses] ([FlatNo], [Address1], [Address2], [Town], [County], [Postcode],
[Country], [Telephone], [DoorNo]) VALUES (@FlatNo, @Address1, @Address2, @Town, @County, @Postcode, @Country, @Telephone, @DoorNo)"
<InsertParameters>[code]......
So how do I do it? I was trying:
InsertCommand="INSERT INTO [tbl_shop_client_addresses] ([FlatNo], [Address1], [Address2], [Town], [County], [Postcode],
[Country], [Telephone], [DoorNo], [AddressIdentity]) VALUES (@FlatNo, @Address1, @Address2, @Town, @County, @Postcode, @Country, @Telephone, @DoorNo, @Postcode + @DoorNo)"
but of course AddressIdentity is a string. Do I use ' ' marks with an & sign? Or can't I do this?? Maybe I need to use the codebehind anyway to see if the field exists before inserting it?
ive a DB in access with a single table and no primary key, actually i dont need a primary key but i can consider a date field plus another to make an index. however i want to add a counter field based on every change of date field, for instance ill have many records of 20/May and all must have the same id then when the date is different, the next group of records with that new date must show 2 etc.. is it a quick way to update my database?
View 6 RepliesI need to get two fields from a database table (retrieved using linq-to-sql), one field is a datetime (and is a fixed field) and the other is always a decimal, but the field can be different.
The table holds currency data which is processed twice a day and in different currencies so could have fields such as AM_USD, PM_USD, AM_EUR etc. And I need to get data such as a list of the date against PM_USD or the date against AM_EUR.
I would like to be able to call the data using a lambda expression for example (this is a stripped out example):
data = TableData.Select(x=>new {x.DateTimeAdded, x.[**field name as string**]});
I have been trying to write a function to do this, and am failing dismally.
The closest I have managed is:
private Func<TableData, KeyValuePair<DateTime, decimal>> CreateSelect(string FieldName)
{
var parameterExp = Expression.Parameter(typeof(TableData), "sel");
var dateParameter = Expression.Parameter(typeof(DateTime), "DateTimeAdded");
var fieldParameter = Expression.Parameter(typeof(decimal), FieldName);
ConstructorInfo constructorInfo = typeof(KeyValuePair<DateTime, decimal>).GetConstructor(new[] { typeof(DateTime), typeof(decimal) });
NewExpression constructExpression = Expression.New(constructorInfo, new ParameterExpression[] { dateParameter, fieldParameter});
var lambda = Expression.Lambda<Func<TableData, KeyValuePair<DateTime, decimal>>>( constructExpression, parameterExp);
return lambda.Compile();
}
Which fails with "System.InvalidOperationException: Lambda Parameter not in scope".
I'm sure I missing something obvious, or going about it wrong way.
When I try to insert a record the Filing Date and Report Time fields are always blank in the database.
View 5 Replies