|
I'm new in ASP.net. I plan to develope a project based on ASP.net with C#. But I faced problem where how to store the data in ASP.net 2.0. For example, I had a few table in database -SQL server. Once the user search some information in database, it returned a list of record with content so that user can view them. And I planned to use object oriented way - create few classes such as order, order detail and invoice. Once the database returned the data to asp, it inserts data into those classes (order, order detail or invoice) and those classes can contain more that one record such as order1, order2, order 3 etc. But the problem is where should i store those classes that with data ? Should i store it in session or application? It is because once the user click to other asp.net pages, the classes that with data will lost. right?
Sorry that asking this silly question. Any help with examples is appreciated.
Danny
|
|
|
|
|
The web is stateless in it's basic form. As soon as you want to keep state, it will cost you, usually memory resources.
Objects are normally not persisted from page to page, so the standard way of doing it is not to do it. Usually you just fetch them from the database again.
If you want to persist the object, you can put them in session variables. Be carful about storing large objects in sesson variables, though, as the session objects live for a very long time. Objects in a web application usually lives mere milliseconds, so objects persisted in memory for minutes will be using relatively much memory resources.
---
b { font-weight: normal; }
|
|
|
|
|
Ya. I know there is expensive to keep it on memory. But make always make a connection to database to fetch the data also expensive. Besides, users needs to wait for the procedure connect to database and obtain the data always. If I want to keep the data from database, session is the only way that I can use? Is there any other way to keep those data cross page to page?
|
|
|
|
|
Pentellcc wrote: But make always make a connection to database to fetch the data also expensive.
It's not expensive in the same way. Memory is a resource that has an absolute limit, while database calls are only limited by the execution time. Allocating too much memory causes the server to stop, while too many queries only makes it go slower.
Pentellcc wrote: If I want to keep the data from database, session is the only way that I can use? Is there any other way to keep those data cross page to page?
Application variables, application cache, static variables... all those are shared by all users, though, so you need to separate the stored data using a unique key, and you need to use locking to make it thread safe.
---
b { font-weight: normal; }
|
|
|
|
|
 hi all,
i joined newly and am also new to asp.net.
i read the article on aplahabetic paging done with ref using .dll by Mr.Jitendra Bansiwal. it works fine but i have a few other complications so i developed the following code but it doesn't work. it went wrong in itemCreated and itemCommand event.
it would be helpful if any one can check out what's wtong with follwing code:
void GridView1_ItemCreated(Object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{ if (e.Item.ItemType == ListItemType.Footer)
{ e.Item.Cells.Clear();
TableCell tc = new TableCell();
tc.ColumnSpan = 2;
e.Item.Cells.Add(tc);
int i;
string s;
for (i=65;i<=65+25;i++)
{ LinkButton lb= new LinkButton();
LiteralControl lc =new LiteralControl();
lc.Text = " ";
s=Convert.ToString(i);
lb.Text = s;
lb.CommandName = "alpha";
lb.CommandArgument = s;
if (str==s)
{ lc.Text = s + " ";
tc.Controls.Add(lc);
}
else
{
tc.Controls.Add(lb);
tc.Controls.Add(lc);
}}}
protected void ItemCommand(Object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
if (e.CommandName == "alpha")
{ BindGrid(e.CommandArgument.ToString());}
}
Thanks in advance
}
Anu
|
|
|
|
|
Someone knows some good site?
Jesus is Love! Tell to someone!
|
|
|
|
|
Hello Sir/Madam,
I am Ravindra learning ASP.net and very much interested
in AJAX. I am trying to implement AJAX.
But not able to get the output.
I implemented the following steps:
1.Adding the reference AjaxPro.dll.
2.Configuring the web.config
<httphandlers>
<add verb="POST,GET"
="" path="ajaxpro/*.ashx" type="AjaxPro.AjaxHandlerFactory, AjaxPro">
3.implemented the code and method
private void Page_Load(object sender, System.EventArgs e)
{
AjaxPro.Utility.RegisterTypeForAjax(typeof(Ajaxajax.WebForm1));
}
[AjaxPro.AjaxMethod()]
public string GetServerTime()
{
return "Hi I am Ajax";
}
4.Placing the code in HTMLDesigner
5.I also added a javascript file(WebForm1.js) as a new item
and I was confusing to edit which code.
please help me.........
thank you,
Ravindra
|
|
|
|
|
the Max Size of "text" is 255,but it's so short to me.
how should I do?
thank you.
KSCsoft
|
|
|
|
|
Use Memo.
---
b { font-weight: normal; }
|
|
|
|
|
Hi Everyone,
i am beginner,here i have to create one control like login form(two textboxes) and drag thay control into my webform1.aspx and one button also
drag.the main problem is how can i call the user control function for the button code ...
plz help me
suresh babu.k
-- modified at 10:42 Saturday 8th July, 2006
|
|
|
|
|
hi all,
in my dataset i have values like this
(first row belongs to column names)
AccountName RemarkCode RemarkCount Comapany Count
Albert D32 1 AETNA 1
Albert N65 2 Medicaid 1
albert N65 1 MegaLife 1
raj 123 2 MegaLife 1
raj 123 2 Anthem 1
what i want is
AccountName RemarkCode RemarkCount Comapany Count
Albert D32 1 AETNA 1
------ N65 1 Medicaid 1
------ 49ps 1 MegaLife 1
raj 123 2 MegaLife 1
----- ------ ----- Anthem 1
(---- represents no value at that place)
an output like this
can any body help me how to do this and i should display the
out in a datagrid
Thanx in advance
your
peter
-- modified at 10:08 Saturday 8th July, 2006
|
|
|
|
|
Hi Peter,
If I am clear about your problem the following solution might be helpful.
Use the "Item_Databound" event of the DataGrid to check for the columns NULL or Empty values and update that column value with the required string say (----) in the corresponding DataTable (DataSet).
The Item_Databound event fires for each and every row in the DataTable when getting binded to the DataGrid.
Good Luck.
Subrahmanyam K
|
|
|
|
|
how can i find the whois is exist or no
get me a sample that don't use another site
MHF
|
|
|
|
|
this is ConnectionString in the web.config file:
add key="ConnectionString" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\wwwroot\guestbook\DB\guestbook.mdb;"
this is absolute directory in the appSettings element.
I wanna get opposite directory.so,how should I do?
KSCsoft
|
|
|
|
|
From your other thread I see that you mean the relative thread.
Relative to what directory?
---
b { font-weight: normal; }
|
|
|
|
|
look at following:
<appsettings>
<add key="ConnectionString" value="Provider=Microsoft.Jet.OLEDB.4.0;<b>Data Source=F:\wwwroot\gestbook\DB\gestbook.mdb</b>;">
this is the absolute directory,I wanna get the opposite directory.
so,I should I do?
thank you!
KSCsoft
|
|
|
|
|
|
yes,I mean the relative directory.
KSCsoft
|
|
|
|
|
just give Server.MapPath(".") to get the current directory
|
|
|
|
|
Hi All,
I am using combobox i filled combobox and noe I want to access combobox values.
my code is
comboBox1.DataSource =_orderBO.FillCombo("select CustomerId from Customers");
comboBox1.DisplayMember="CustomerId";
comboBox1.ValueMember="CustomerId";
MessageBox.Show ("Item is"+ comboBox1.Items[1].ToString());
Gives value "system.data.datarowview" as messagebox
Please help me....
-- modified at 9:29 Saturday 8th July, 2006
|
|
|
|
|
use databinding for binding your combobox to database
|
|
|
|
|
Like KeyAscii of ENRET key is 13,
What is KeyAscii of UP ARROW KEY & DOWN ARROW KEY
|
|
|
|
|
38 & 40
It was the first hit from google when I searched for: "ascii arrow keys"
|
|
|
|
|
hi all
i have problem ,in html that is inside in the asp.net code,i have table that have rows and colums i want to populate this table through database,bt my whole code is not working...and the following error msgs comes..the
command.text is not define.
tell me the proper way of executing this code.and tell me where i have mistakes
this is my whole code
<%@import namespace="System.Data.OleDb"%>
<%
'dim strConnectionString as new String
'strConnectionString="Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password='';Initial Catalog=dbusa;Data Source=;"
dim conConnection as New OleDbConnection("Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password='';Initial Catalog=dbusa;Data Source=")
conConnection.open()
%>
<%
Dim cmd As New OleDbCommand
cmd.Connection = conConnection
Dim dr As OleDbDataReader
cmd.CommandText = "Select course_title,per_name,std_section from tblTT Group by course_title,per_name,std_section"
cmd.CommandType = CommandType.Text
dr = cmd.ExecuteReader
'Set rs = Server.CreateObject("ADODB.Recordset")
'Set rs2 = Server.CreateObject("ADODB.Recordset")
'rs.open "Select course_title,per_name,std_section from tblTT Group by course_title,per_name,std_section", dbCon
%>
<% while dr.read %>
<%
dim strConnectionString1 as new string="Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password='';Initial Catalog=dbusa;Data Source="
conConnection1 = New OleDbConnection(strConnectionString1)
conConnection1.open()
Dim cmd1 As New OleDbCommand
cmd1.Connection = conConnection1
Dim dr1 As OleDbDataReader
cmd1.CommandText = "Select time_slot_day,time_slot_from,time_slot_to from tblTT where course_title='" & Session.item("Course_title") & "' AND per_name='" & Session.item("Per_name") &"' AND std_section='" & Session.item("std_section") & "'" "
cmd1.CommandType = CommandType.Text
dr1 = cmd1.ExecuteReader
%>
<%
'rs2.open "Select time_slot_day,time_slot_from,time_slot_to from tblTT where course_title='" & rs("Course_title") & "' AND per_name='" & rs("Per_name") &"' AND std_section='" & rs("std_section") & "'" , dbCon
while dr1.read
%>
<%
end while
%>
<%
end while
conConnection.close()
conConnection1.close()
'rs2.close
'rs.movenext
'wend
'rs.close
%>
| Course |
<% =dr.item("Course_title")
Session.add("Course_title",dr.item("Course_title"))
%>
<%
if Trim(dr.item("std_section"))="A" OR Trim(dr.item("std_section"))="B" OR Trim(dr.item("std_section"))="C" then
response.Write(" (Section: ") & dr.item("std_Section") & " )"
Session.add("std_section",dr.item("std_section"))
end if
%>
| | Instructor |
<% =dr.item("Per_Name")
Session.add("Per_Name",dr.item("Per_Name"))
%>
|
|
| <%=dr1.item("time_slot_day")%> | | <%=dr1.item("time_slot_from")%> | <%= dr1.item("time_slot_to")%> |
|
-- modified at 4:43 Saturday 8th July, 2006
|
|
|
|
|
Are you sure that's the code that you are using? It shouldn't even be possible to run. There is a syntax error in the line that set the value of the cmd1.CommandText. There is an extra quote at the end that shouldn't be there.
---
b { font-weight: normal; }
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
