|
Well, can your give on practical example, code sample or usefull links, i have basic knowledge of XML, good with ASP.Net, and good with SQL Server as well.
Many Thanks,
Adnan Rafiq
muhammadadnanrafiq@gmail.com
|
|
|
|
|
hai all,
Can anyone guide me how to perform calculations in a datagrid by row wise as well as column wise.... Its urgent....plz
with Regards,
Imthiyas Ahamed.A
|
|
|
|
|
|
ya i already tried that.. but the calculation has done only for columns... there is no calc for rows....Do u have anyidea about this....
with Regards,
Imthiyas Ahamed.A
|
|
|
|
|
Try this
<br />
int[] it3= null;<br />
int it1 = 0;<br />
int it2 = 0;<br />
if(ds.Tables[0].Rows.Count>0)<br />
{<br />
it3 = new int[ds.Tables[0].Rows.Count];<br />
for(int i=0;i<ds.Tables[0].Rows.Count;i++)<br />
{<br />
it1 = Convert.ToInt32(ds.Tables[0].Rows[i]["field1"].ToString()); it2 = Convert.ToInt32(ds.Tables[0].Rows[i]["field2"].ToString());<br />
it3[i] = it1+it2;<br />
}<br />
<br />
for(int i=0;i<dg1.Items.Count;i++)<br />
{<br />
dg1.Items[i].Cells[5].Text = it3[i].ToString();<br />
}<br />
}
This is by adding the 2 fields and display it in the grid.
I only developed this..i couldnt directly add 2 columns in a row.
Try and let me know !
|
|
|
|
|
ya Sure i ll let u know about this by tomo....
i want to implement some formulas also in datagrid is it possible...
have u ever worked like this before....
with Regards,
Imthiyas Ahamed.A
|
|
|
|
|
What I would suggest is on the Datagrid_OnItemDataBound event you look at the Cells in each "Item" or row as it is bound to the grid. You pick out the cell values that you need and then perform the calculations while storing the values in session or whatever you need to do to maintain that variable. As each row is added you can put the value in an extra column or at the end in the footer or in some label somewhere.
I've done this before where I add all the values in the currency column to come up with a total so it is possible to do either way.
Cleako
|
|
|
|
|
ok thanks a lot... I ll try this method...
with Regards,
Imthiyas Ahamed.A
|
|
|
|
|
Hi all,
I want a help from you. I have an XML file in which i have my database. I want to retrive one record from it based on condition. Like we query the database like "select * from TableName where Name='soandso'". But here my database itself is an XML file. Is it possible in anyway. I have tried navigation but i am stuck. Cant seem to go forward in this. Please help me as soon as possible.
Regards,
Lavanya
|
|
|
|
|
hai,
Use this code.
DataSet ds = new DataSet();<br />
ds.ReadXml(Server.MapPath("filename with path"));<br />
DataRow[] drs = ds.Tables[0].Select("column name = '" + "needed filter value" + "'");<br />
DataRow[] drs = ds.Tables[0].Select("column name = " + "filter value");
read the xml to the dataset and use needed filter in the select method of datatable object.now the drs is collection of rows satisfying your condition.
iterate that and use it.
i think this solves your problem.
Cheers
asithangae
|
|
|
|
|
Hi Lavanya,
you can use xQuery in asp.net. This article may help you.
http://aspnet.4guysfromrolla.com/articles/071603-1.aspx
Enjoy programming.
|
|
|
|
|
hi
try to read your xml file into a DataSet, then user the select method
for the table inside the DataSet i.e
DataSet ds = new DataSet();
ds.ReadXml("Users.xml");
DataRow []arrDR = ds.Tables[0].Select("id=5");
// where id=5 is your condeition and id is a colunm name.
When you get mad...THINK twice that the only advice
Tamimi - Code
|
|
|
|
|
Hello
I need to write one function in ASP.NET that will colorize all the keywords and syntax in the page ? Any help ?
Eg : if (a=1) then
so i need to make color for this if and then. like this for all keywords ?
any idea ?
|
|
|
|
|
What exactly do you want?
the class for colors is System.drawing.color
Nana
|
|
|
|
|
any one plz tell me how to add credit card payment module in a project like shoping cart in asp.net with c# plzzzzzzzzz its very urgent...
Pradeep Reddy
|
|
|
|
|
you can use the paypal online payment. they are giving the step by step procedure for that.
www.paypal.com
try it.
Sathesh Pandian
|
|
|
|
|
thank u...
Pradeep Reddy
|
|
|
|
|
Hi All,
I need the help regarding preparation of Design Document for my Portal project using Asp.net and C#. I have got the Requirement Specification from my head.
Now I have planned to prepare the Design Document in proper Format, which can be understandable to everyone.
This is the first time, I am preparing this document. Anybody can give some URL's that will guide me to prepare the document in a better way.
Thanks
Regards,
Jay
|
|
|
|
|
Plz explain the project architecture and project flow while developing a project in dotnet technologies.i.e while using asp.net,c#,sqlserver2000 lz explain the project architecture and flow?
|
|
|
|
|
How can you expect so much from a forum ? 
<l>Thanks and Regards
Sandeep
|
|
|
|
|
hi friends
i want to print barcode images on Crystal Report
barcode images are stored in sql server database as varbinary datatype
i want fetch these images and show it on crystal report
how can i do this ?
thank you
|
|
|
|
|
Hello friends...I use 2 datalists say dtlist1 and dtlist2 and two pagers say pager1 and pager2 for each of them resp..and onpageload dtlist2 is displayed by default. When user clicks on a button dtlist1 is displayed...and after clicking on the pager for that datalist1 ..It shows second datalist i.e. dtlist2 ....becoz on page load dtlist2 is to displayed..To avoid such confict in pager..i decide to use datagrid which has its own pager..Then the problem occurs to show datagrid horizontally...Do anyone have any solution.....
|
|
|
|
|
To get Calender for Past 3 months from present date for Archives
|
|
|
|
|
I have two dropdown lists on a webform using vs 2005/asp.net 2.0. The first is populated via an sqldatasource. The second dropdown list is populated via a second sqldatasource with a where clause based on the selected value of the first dropdown. In visual studio the population of both dropdowns work fine but when I publish to IIS only the first dropdown is populated. At this point I am out of ideas. Any suggestions would be greatly appreciated. Here is the source code.
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>
<title>Untitled Page
<asp:sqldatasource id="SqlMethod" runat="server" connectionstring="<%$ ConnectionStrings:IngresConnectionString %>"
="" providername="<%$ ConnectionStrings:IngresConnectionString.ProviderName %>" selectcommand="Select distinct method from tmaster_shipped ">
<asp:dropdownlist id="ddlMethod" datasourceid="SqlMethod" runat="server" autopostback="True" datatextfield="method" datavaluefield="method" style="z-index: 100;
left: 116px; position: absolute; top: 128px">
<asp:dropdownlist id="ddlLab" runat="server" autopostback="True" datasourceid="labDatasource"
="" datatextfield="lab" datavaluefield="lab" style="z-index: 102; left: 108px; position: absolute;
top: 228px">
<asp:sqldatasource id="labDatasource" runat="server" connectionstring="<%$ ConnectionStrings:LocalMySQL %>"
="" providername="<%$ ConnectionStrings:LocalMySQL.ProviderName %>" selectcommand="SELECT lab FROM tmaster_labs WHERE METHOD=?">
<selectparameters>
<asp:controlparameter controlid="ddlMethod" name="Method" propertyname="SelectedValue" type="String">
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
