|
you are welcome 
Regards,
Jamil
|
|
|
|
|
HI ALL,
I have one requirement
i want to create one grid view in a grid view
first column and row will come from the data base
00:00 - 08:00 | 08:00 - 20:00 | 20:00 24:00 ( this is timing)
feesbydrA want textbox
feesbydrB
feesbydrC
excep these all will be text box where i can mace entry and can save.
Thanks and regards
amit Patel
|
|
|
|
|
So create your gridview anf if face any problem post your issue
|
|
|
|
|
i have already created grid view but those text boxes are not coming how to add dynamically template field.
|
|
|
|
|
Can you post your code snippet?
|
|
|
|
|
<br />
<asp:gridview ID="Gridview1" runat="server" ShowFooter="true" <br />
AutoGenerateColumns="false" onrowediting="Gridview1_RowEditing"><br />
<br />
<Columns><br />
<br />
<asp:BoundField DataField="RowNumber" HeaderText="Modality" /><br />
<br />
<asp:TemplateField HeaderText="00:00-08:00"><br />
<br />
<ItemTemplate><br />
<br />
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><br />
<br />
</ItemTemplate><br />
<br />
</asp:TemplateField><br />
<br />
<asp:TemplateField HeaderText="08:00-20:00"><br />
<br />
<ItemTemplate><br />
<br />
<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox><br />
<br />
</ItemTemplate><br />
<br />
</asp:TemplateField><br />
<br />
<asp:TemplateField HeaderText="20:00-24:00"><br />
<br />
<ItemTemplate><br />
<br />
<asp:TextBox ID="TextBox3" runat="server"></asp:TextBox><br />
<br />
</ItemTemplate><br />
<br />
<%-- <FooterStyle HorizontalAlign="Right" />--%><br />
<br />
<%-- <FooterTemplate><br />
<br />
<asp:Button ID="ButtonAdd" runat="server" Text="Add New Row" OnClick ="ButtonAdd_Click" /><br />
<br />
</FooterTemplate>--%><br />
</asp:TemplateField><br />
<br />
</Columns><br />
<br />
<br />
</asp:gridview><br />
<br />
this function is initializing grid<br />
<br />
private void SetInitialRow()<br />
{<br />
ReportAction reporting = new ReportAction();<br />
Int32 userId = Convert.ToInt32(Session["userId"].ToString());<br />
MySqlDataReader reader = reporting.getModalityList(userId);<br />
int numberofmodality = 0;<br />
<br />
while (reader.Read())<br />
{<br />
if (numberofmodality == 0)<br />
{<br />
DataTable dt = new DataTable();<br />
<br />
DataRow dr = null;<br />
<br />
dt.Columns.Add(new DataColumn("RowNumber", typeof(string)));<br />
<br />
dt.Columns.Add(new DataColumn("Column1", typeof(string)));<br />
<br />
dt.Columns.Add(new DataColumn("Column2", typeof(string)));<br />
<br />
dt.Columns.Add(new DataColumn("Column3", typeof(string)));<br />
<br />
dr = dt.NewRow();<br />
<br />
dr["RowNumber"] = reader[1].ToString();<br />
<br />
dr["Column1"] = string.Empty;<br />
<br />
dr["Column2"] = string.Empty;<br />
<br />
dr["Column3"] = string.Empty;<br />
<br />
dt.Rows.Add(dr);<br />
<br />
dr = dt.NewRow();<br />
<br />
<br />
ViewState["CurrentTable"] = dt;<br />
<br />
Gridview1.DataSource = dt;<br />
Gridview1.DataBind();<br />
numberofmodality++;<br />
}<br />
else<br />
{<br />
}<br />
<br />
}<br />
<br />
}<br />
<br />
<br />
This function is adding column<br />
<br />
private void AddNewRowToGrid(string modality)<br />
{<br />
<br />
int rowIndex = 0;<br />
<br />
if (ViewState["CurrentTable"] != null)<br />
{<br />
<br />
DataTable dtCurrentTable = (DataTable)ViewState["CurrentTable"];<br />
<br />
DataRow drCurrentRow = null;<br />
<br />
if (dtCurrentTable.Rows.Count > 0)<br />
{<br />
<br />
for (int i = 1; i <= dtCurrentTable.Rows.Count; i++)<br />
{<br />
<br />
TemplateField ckhColumn = new TemplateField();<br />
<br />
TextBox box1 = (TextBox)Gridview1.Rows[rowIndex].Cells[1].FindControl("TextBox1");<br />
<br />
TextBox box2 = (TextBox)Gridview1.Rows[rowIndex].Cells[2].FindControl("TextBox2");<br />
<br />
TextBox box3 = (TextBox)Gridview1.Rows[rowIndex].Cells[3].FindControl("TextBox3");<br />
<br />
drCurrentRow = dtCurrentTable.NewRow();<br />
<br />
drCurrentRow["RowNumber"] = modality;<br />
<br />
drCurrentRow["Column1"] = box1.Text;<br />
<br />
drCurrentRow["Column2"] = box2.Text;<br />
<br />
drCurrentRow["Column3"] = box3.Text;<br />
<br />
rowIndex++;<br />
<br />
}<br />
<br />
<br />
dtCurrentTable.Rows.Add(drCurrentRow);<br />
<br />
<br />
ViewState["CurrentTable"] = dtCurrentTable;<br />
<br />
<br />
Gridview1.DataSource = dtCurrentTable;<br />
<br />
Gridview1.DataBind();<br />
<br />
}<br />
<br />
}<br />
<br />
else<br />
{<br />
<br />
Response.Write("ViewState is null");<br />
<br />
}<br />
<br />
<br />
<br />
}<br />
<br />
this is my grid view
i dont want to define template field in code it should come from the database
|
|
|
|
|
|
Hi,
I have developed a web application and created a virtual directory of that application(which is of Windows server 2003).After two weeks i found a problem.
ie when a user login(via virual directory link) i am taking his userid from database(sql 2005) with given userid and password and assigning that userid in session
ie Session["UserId"] = int.Parse(dstLogin.Tables[0].Rows[0]["UserId"].ToString());
then i am checking whether it is null or not
if (Session["UserId"] != null)
{
Response.Redirect("Home.aspx");
}
but in other pages when a user adding some data to database
i am not getting this UserId there.
ie while inserting userid of insering person will also store in database.while designing the table i made that field as "not null".
Not regularly but sometime users are getting an error like this
"Cannot insert userid as null". But most time it works fine
any solution or any idea to prevent this?
Known is a drop, unknown is an ocean
|
|
|
|
|
You problem is not very clear. Code is also looking fine .There must be some the data is not retrieved properly and not saved properly in session etc.. Have proper checks at the time saving and retrieving the data.. you'll get the actaul problem
|
|
|
|
|
Hi,
i ve developed an application which is now in testserver.my mates are testing(using the virtal directory link) it by entering data.last 2 week it was fine.but from last day after entering more than 30000 data now they are getting error which is i mentioned above. when i restart or move mouse of that testserver , again it works fine. after 5 mins (i think if there is any slow internet connection) it will raise same error. ive to do same thing again and again.
this is the problem
Known is a drop, unknown is an ocean
|
|
|
|
|
|
Hi all, i new at asp.net and need to create a website page using asp.net , but i don't know how<<<<<<<<<<<<<<
regards...
|
|
|
|
|
Well, try searching on CP or google, there are thousands of articles - or go out and buy a book.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
So buy some basic ASP.NET book and study..
|
|
|
|
|
|
In my project, onrowEditing is inside the childgrid. The parentgrid doesnot have onrowEditing.In this case, is it possible to find the id of childgrid inside onrowEditing method?
Thanks in Advance
|
|
|
|
|
I hope i understand you right.
The row-editing event passes an object as first parameter, its usually named "sender". This
is the grid raising that event. So you could cast that object to the type of your grid and
do anything you want with it. You could also retrieve the id by using YourGrid.ClientID.
|
|
|
|
|
Dear all,
I have a rdlc report using matrix. The number of columns varies in the runtime as per the data and it is just getting extended to right with horizontal scroll bars. Because of this the report viewing is difficult and printout/export options are also misbehaving. I would like to fit it to a page by limiting the number of columns appearing in a page and showing the balance columns which are yet to be shown (and other related fixed column information) in the next page, so that the report is legible for reading as well as printing/exporting to pdf.
I checked the web and could find out some workarounds only to fix the number of rows per page of the report. Is there any way to fix the number of columns in a matrix report to meet my requirements?
Thanks in advance
Binu
|
|
|
|
|
First thing is you can change the layout to Landscape for printing.
Now, since you are not aware of number of columns from before, matrix is being used. Thus the column numbers cannot be controlled. Though SSRS itself will display the possible columns in one page and rest in other. (Once the page height/Width & Interactive height/width is properly defined... W:11in & H:8.5in for landscape)
|
|
|
|
|
Thank you Sandeep for the quick response.
I think, such a requirement is very common and is available in other similar reporting tools like Crystal reports / Oracle report builder. (At least to fix the maximum width of the page so that the remaining columns along with the fixed columns will be spilled to the next page).
All our reports are rdlc's and we would like to standardise the reports in this platform itself. So basically do not want to switch over to Crystal or any other tools. Thats why I am exploring this.
Any other views?
Thanks and regards,
Binu
|
|
|
|
|
hi,
currently i m using asp.net 2005 (framework 2.0)
i m going to use the cookie for the 1st time in my project (its intranet productivity tool). i need some clarifications...
1. Can we go with Sessions or Cookies? which is best one?
2. If i set cookie expire time as 1 hour, then after 1 hour will it expire? OR every time when user using the application it will retain its time, so that when user didnt work for 1 hour it will get expire? which is right one.
3. Also i want to capture the applications logout time of individual user. so when session expire, can i get those values (say, loginID;team name;department name etc...) and update in my database table?
help me plz - KARAN
|
|
|
|
|
Karan_TN wrote: 1. Can we go with Sessions or Cookies? which is best one?
You can use either one.Better to go for Session because cookies might be disabled at some browser so may not work properly.
Karan_TN wrote: 2. If i set cookie expire time as 1 hour, then after 1 hour will it expire? OR every time when user using the application it will retain its time, so that when user didnt work for 1 hour it will get expire? which is right one.
One need to give specific time to Expiresproperty so it will expire at that time only.So it doesn,t matter whether user works for an hour or not.These are called Persistent cookies, if you set the expires time then it will there in browsers memory and will be removed when one close the browser, these are called <code>Non Persistent cookies</code> and stored on Browser memory while persistent one stored in local hard disk.
for details in Cookies, have a look Beginner's Guide To ASP.NET Cookies
Karan_TN wrote: Also i want to capture the applications logout time of individual user. so when session expire, can i get those values (say, loginID;team name;department name etc...) and update in my database table?
For this, use session There is two method in Global.asax file one is Session_Start and another is Session_End.Session_Start is called whenevr any new session is getting created and Session_End is called whenever a session ends, so for your requirement you can use Session_End and you can get all those values that you said and can update in datatbase from here only.
Let me know if any issue
|
|
|
|
|
thanks a lot brij. got cleared with all my doubts. As per your guidance, i will go with sessions itself and take care to remove it at proper place to utilize the memory hope i m right. THANKS A LOT!
|
|
|
|
|
your most welcome
|
|
|
|
|
Brij wrote:
for details in viewstate, have a lookBeginner's Guide To ASP.NET Cookies
Small Correction Brij,
It should be "For details of Cookies" not ViewState
Cheers !
Abhijit Jana | MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
