|
Hi,
I am using TypedDataset in my appliaction, It has 3 tables and those tables have some relations among them. In the second datatable there are some computed columns(even it has some aggregate functions). When I am trying to set the one of the computed column as a parameter to my update storedprocedure it is raising an exception when i am calling dataadapter.update() method on the ssecond table.
It is giving {"The column mapping from SourceColumn "XXX" failed because the DataColumn "XXXX" is a computed column." }, How to resolve this. Is there any possibility that we can use the computed columns in the datatable for updating. If not is there any workaround for this.
Thanks in advance
|
|
|
|
|
If the computed columns are based on the data in your dataset, surely you can just put the computations into your update sql...
|
|
|
|
|
diffrence between ASP.NET 1.1 and 2.0
|
|
|
|
|
anig wrote: diffrence between ASP.NET 1.1 and 2.0
The version number: 1.1 and 2.0  .
The article below can give you some insight:
ASP.NET 2.0 Internals[^]
|
|
|
|
|
Do not cross-post!
--------------------------------------------------------
My development blog
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!
|
|
|
|
|
Masterpages
Aspx file intelliscence
Partial classes
Design support
Asynchronous Model
Performance Improovements
Built in Server not required IIS at the time of Developement
LoginControls and Enhanced Controls
Enhanced Functionality and many more
"Aim to go where U have never been B4 and Strive to achieve it"
http://groups.yahoo.com/subscribe/dotnetforfreshers
http://himabinduvejella.blogspot.com
|
|
|
|
|
am getting an Error when refering an external config file from web.config file, code is
string str = System.Configuration.ConfigurationSettings.AppSettings["KeyToBeAdded"];
Response.Write(str);
the Exception is
The root element must match the name of the section referencing the file, 'appSettings' (c:\inetpub\wwwroot\referexternalfiles\firstfile\YourSettings.config line 10)
plz help me
coolsweety
|
|
|
|
|
Hello,
My question is in my database there is content stored in the format given below.some content.i want the the content only to display,is there any particular key word or something like that in .net 2003 databse is sql server.pls help me to sort this problem.
Thanks in advance.
alex.
|
|
|
|
|
just set the pages validaterequestprperty to false, then try
coolsweety
|
|
|
|
|
i want create datagrid programaticaly.i dont want create it from property builder
i want the number of my column be depends on the number of my records in database.
|
|
|
|
|
there is a good article here on CP somewhere.
Can't find it right away, but if you try several keywords you'll get there (also try MSDN)
(keywords you can try, dynamically create datagrid, datagrid at runtime, ...)
Coulda, woulda, shoulda doesn't matter if you don't.
|
|
|
|
|
I have a question about the Post Back, I dont think Ive really got it yet. I have a form with checkboxes and a submit button. I put in a break point in the page load method and my onClick method of the button. First time, page loads, grand. Checkbox values are populated from a DB grand. Then I change the values of the check boxes and click submit. The first breakpoint i encounter is the one in page load, which reloads the checkbox values from the DB and then these go into the onClick method. So my question is why is the order pageload, click submit, page load, onClick method? Ive tried putting the generation of the checkboxes in a if(!page,ispostback) but then in the submit method i call FindControl and it cant find them because I guess they were never created. What I want to know is why is this second pageload in there? I dont want it and its wrecking things. Thanks in advance,
|
|
|
|
|
read up on the page life cycle[^].
Coulda, woulda, shoulda doesn't matter if you don't.
|
|
|
|
|
i want create datagrid programaticaly.i dont want create it from property builder
i want the number of my column be depends on the number of my records in database.
|
|
|
|
|
ICollection CreateDataSource()
{
// Create sample data for the DataGrid control.
DataTable dt = new DataTable();
DataRow dr;
// Define the columns of the table.
dt.Columns.Add(new DataColumn("IntegerValue", typeof(Int32)));
dt.Columns.Add(new DataColumn("StringValue", typeof(string)));
dt.Columns.Add(new DataColumn("CurrencyValue", typeof(double)));
// Populate the table with sample values.
for (int i = 0; i < 9; i++)
{
dr = dt.NewRow();
dr[0] = i;
dr[1] = "Item " + i.ToString();
dr[2] = 1.23 * (i + 1);
dt.Rows.Add(dr);
}
DataView dv = new DataView(dt);
return dv;
}
void Page_Load(Object sender, EventArgs e)
{
// Create a DataGrid control.
DataGrid ItemsGrid = new DataGrid();
// Set the properties of the DataGrid.
ItemsGrid.ID = "ItemsGrid";
ItemsGrid.BorderColor = System.Drawing.Color.Black;
ItemsGrid.CellPadding = 3;
ItemsGrid.AutoGenerateColumns = false;
// Set the styles for the DataGrid.
ItemsGrid.HeaderStyle.BackColor =
System.Drawing.Color.FromArgb(0x0000aaaa);
// Create the columns for the DataGrid control. The DataGrid
// columns are dynamically generated. Therefore, the columns
// must be re-created each time the page is refreshed.
// Create and add the columns to the collection.
ItemsGrid.Columns.Add(CreateBoundColumn("IntegerValue", "Item"));
ItemsGrid.Columns.Add(
CreateBoundColumn("StringValue", "Description"));
ItemsGrid.Columns.Add(
CreateBoundColumn("CurrencyValue", "Price", "{0:c}",
HorizontalAlign.Right));
ItemsGrid.Columns.Add(
CreateLinkColumn("http://www.microsoft.com", "_self",
"Microsoft", "Related link"));
// Specify the data source and bind it to the control.
ItemsGrid.DataSource = CreateDataSource();
ItemsGrid.DataBind();
// Add the DataGrid control to the Controls collection of
// the PlaceHolder control.
Place.Controls.Add(ItemsGrid);
}
BoundColumn CreateBoundColumn(String DataFieldValue,
String HeaderTextValue)
{
// This version of the CreateBoundColumn method sets only the
// DataField and HeaderText properties.
// Create a BoundColumn.
BoundColumn column = new BoundColumn();
// Set the properties of the BoundColumn.
column.DataField = DataFieldValue;
column.HeaderText = HeaderTextValue;
return column;
}
BoundColumn CreateBoundColumn(String DataFieldValue,
String HeaderTextValue, String FormatValue,
HorizontalAlign AlignValue)
{
// This version of CreateBoundColumn method sets the DataField,
// HeaderText, and DataFormatString properties. It also sets the
// HorizontalAlign property of the ItemStyle property of the column.
// Create a BoundColumn using the overloaded CreateBoundColumn method.
BoundColumn column = CreateBoundColumn(DataFieldValue, HeaderTextValue);
// Set the properties of the BoundColumn.
column.DataFormatString = FormatValue;
column.ItemStyle.HorizontalAlign = AlignValue;
return column;
}
HyperLinkColumn CreateLinkColumn(String NavUrlValue,
String TargetValue, String TextValue, String HeaderTextValue)
{
// Create a BoundColumn.
HyperLinkColumn column = new HyperLinkColumn();
// Set the properties of the ButtonColumn.
column.NavigateUrl = NavUrlValue;
column.Target = TargetValue;
column.Text = TextValue;
column.HeaderText = HeaderTextValue;
return column;
}
this is a sample code from msdn, try it
coolsweety
|
|
|
|
|
I have two tables in my table and i want to inser the values in two tables using single queiry is it possible
|
|
|
|
|
To be more clear write an sp to insert data into two tables simultanously
Execute the Procedure
"Aim to go where U have never been B4 and Strive to achieve it"
http://groups.yahoo.com/subscribe/dotnetforfreshers
http://himabinduvejella.blogspot.com
|
|
|
|
|
hi im developing a mail application.im able to send mail through smtp mail .but my requirement is i have to receive mails thro pop3 .i did that thro this code
try {
// You will need to set these to your settings.
// The settings here are settings for a local
// demo POP3 server
// that I use for testing.
string xHost = "127.0.0.1";
string xUsername = "chad";
string xPassword = "pass";
using (POP3 xPOP3 = new POP3()) {
xPOP3.Username = xUsername;
xPOP3.Password = xPassword;
xPOP3.Connect(xHost);
int xCount = xPOP3.CheckMessages();
if (xCount == 0) {
Console.WriteLine("No messages on account.");
}
else {
Message xMsg = new Message();
xPOP3.Retrieve(1, xMsg);
Console.WriteLine("Subject: " + xMsg.Subject);
Console.WriteLine("From: " + xMsg.From.Text);
Console.WriteLine("To: " + xMsg.Recipients[0].Text);
Console.WriteLine();
Console.WriteLine(xMsg.Body.Text);
}
try {
}
finally {
xPOP3.Disconnect();
}
}
}
catch (Exception e) {
Console.WriteLine(e.Message);
}
Console.WriteLine("");
Console.WriteLine("Press enter");
Console.ReadLine();
but i edited the attributes according to the req but im geting an error like reference is not their for POP3 class .im using system.web.mail name space
please help with this.
hi to all
with regards,
susa
|
|
|
|
|
hello friends
how can i refer the external files from web.comfig files
coolsweety
|
|
|
|
|
You mean you want to place some settings in an external file, and refer to it from the web.config? If so, you can check out the file[^] attribute of the appSettings element.
|
|
|
|
|
hello you all
what I want is to maintain the session of a user when he register or login with us side by side I want to maintain the session for the cart content
neeru
|
|
|
|
|
U can do that by using Session["UserId"]
Creates and stores userid as a Session
"Aim to go where U have never been B4 and Strive to achieve it"
http://groups.yahoo.com/subscribe/dotnetforfreshers
http://himabinduvejella.blogspot.com
|
|
|
|
|
session["RegNo"]=13;
coolsweety
|
|
|
|
|
yes I know this but I want to maintain it through globle files
|
|
|
|
|
onfiguration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: Access is denied: 'Microsoft.Practices.EnterpriseLibrary.Data'.
Source Error:
Line 196: <add assembly="System.EnterpriseServices, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
Line 197: <add assembly="System.Web.Mobile, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
Line 198: <add assembly="*">
Line 199:
Line 200:
Source File: c:\winnt\microsoft.net\framework\v1.1.4322\Config\machine.config Line: 198
Assembly Load Trace: The following information can be helpful to determine why the assembly 'Microsoft.Practices.EnterpriseLibrary.Data' could not be loaded.
=== Pre-bind state information ===
LOG: DisplayName = Microsoft.Practices.EnterpriseLibrary.Data
(Partial)
LOG: Appbase = file:///c:/inetpub/wwwroot/AutoSys/Procurements/Web
LOG: Initial PrivatePath = bin
Calling assembly : (Unknown).
===
LOG: Policy not being applied to reference at this time (private, custom, partial, or location-based assembly bind).
LOG: Post-policy reference: Microsoft.Practices.EnterpriseLibrary.Data
LOG: Attempting download of new URL file:///C:/WINNT/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET Files/autosys_procurements_web/14145ce2/887b2a67/Microsoft.Practices.EnterpriseLibrary.Data.DLL.
LOG: Attempting download of new URL file:///C:/WINNT/Microsoft.NET/Framework/v1.1.4322/Temporary ASP.NET Files/autosys_procurements_web/14145ce2/887b2a67/Microsoft.Practices.EnterpriseLibrary.Data/Microsoft.Practices.EnterpriseLibrary.Data.DLL.
LOG: Attempting download of new URL file:///c:/inetpub/wwwroot/AutoSys/Procurements/Web/bin/Microsoft.Practices.EnterpriseLibrary.Data.DLL.
LOG: Policy not being applied to reference at this time (private, custom, partial, or location-based assembly bind).
LOG: Post-policy reference: Microsoft.Practices.EnterpriseLibrary.Data, Version=1.1.0.0, Culture=neutral, PublicKeyToken=null
This error is accuring most commonly.....Any solutions to rectify it?
"Aim to go where U have never been B4 and Strive to achieve it"
http://groups.yahoo.com/subscribe/dotnetforfreshers
http://himabinduvejella.blogspot.com
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
