dynamically adding rows in gridview - ASP.NET Discussion Boards

Why don't images appear in Visual Web Designer?

asdf98911-Nov-08 11:21

11-Nov-08 11:21

1) I'm just working on a website, and the images simple don't display in the Visual Web Designer. They just appear like broken links.

However when I run the page it successfully finds all the images and displays everything correctly.

I'm using a basic tag.

eg

<img src="images/pixi_clear.gif" width="517" height="30"></img>

2) Lets say someone helps me out and tells me how to get the images to display, should the 'width and height' aspects of this be unneccessary as they're built into the image?

Re: Why don't images appear in Visual Web Designer?

asdf98923-Nov-08 8:13

asdf989

23-Nov-08 8:13

I can only assume my questions is too stupid to be answered? Oh well. I'll continue to look at dead image links.

Table height is not being displayed at 100%

y.aitelmaati11-Nov-08 10:43

y.aitelmaati

11-Nov-08 10:43

Hi, i hope u help me, i want to set my table's height to 100% of the browser even if its content is smaller, this is my code :

<html xmlns="http://www.w3.org/1999/xhtml">

<body style="background-color:Aqua">
<form id="form1" runat="server">
<table align="center" width="80%" style="height: 100%">
<tr>
<td style="width: 100%; height: 91px"></td>
</tr>
<tr>
<td style="width: 100%; height: 100%" rowspan="1">
<asp:contentplaceholder id="ContentPlaceHolder1" runat="server">
</asp:contentplaceholder>
</td>
</tr>

</table>
<table width="80%" align="center">
<tr>
<td style="color: white">Copyright 2008 </td>
</tr>
</table>

</form>
</body>
</html>

thanks in advance

Re: Table height is not being displayed at 100%

Brij11-Nov-08 17:20

Brij

11-Nov-08 17:20

Try this

use topmargin="0" in body tag

Cheers!!
Brij

SQL Query and .Net code for Advanced search in my application ??

babisharma11-Nov-08 10:33

babisharma

11-Nov-08 10:33

I have 1 checkboxlist, 5 dropdownlits and three textboxes.I have to write the SQL query and c# code for that advanced search.

<asp:CheckBoxList ID="reposotoryCheckBoxList" runat="server" Style="z-index: 106; left: 226px;position: absolute; top: 18px">
asp:ListItem Text="computer" Value="2"></asp:ListItem>

<asp:ListItem Text="math" Value="3"></asp:ListItem>

<asp:ListItem Text="science" Value="1"></asp:ListItem>--%>

</asp:CheckBoxList><asp:DropDownList ID="DropDownList1" runat="server">
<asp:ListItem>Anywhere</asp:ListItem>

<asp:ListItem>Title Words</asp:ListItem>

<asp:ListItem>Creator Name Words</asp:ListItem>

<asp:ListItem>Subject Words</asp:ListItem>

</asp:DropDownList>

<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><br />

<asp:DropDownList ID="DropDownList2" runat="server">

<asp:ListItem>and</asp:ListItem>

<asp:ListItem>or</asp:ListItem>

<asp:ListItem>not</asp:ListItem>

</asp:DropDownList>

<asp:DropDownList ID="DropDownList3" runat="server">

<asp:ListItem>Anywhere</asp:ListItem>

<asp:ListItem>Title Words</asp:ListItem>

<asp:ListItem>Creator Name Words</asp:ListItem>

<asp:ListItem>Subject Words</asp:ListItem>

</asp:DropDownList><asp:TextBox ID="TextBox2" runat="server"></asp:TextBox><br />

<asp:DropDownList ID="DropDownList4" runat="server">

<asp:ListItem>and</asp:ListItem>

<asp:ListItem>or</asp:ListItem>

<asp:ListItem>not</asp:ListItem>

</asp:DropDownList>

<asp:DropDownList ID="DropDownList5" runat="server">

<asp:ListItem>Anywhere</asp:ListItem>

<asp:ListItem>Title Words</asp:ListItem>

<asp:ListItem>Creator Name Words</asp:ListItem>

<asp:ListItem>Subject words</asp:ListItem>

</asp:DropDownList><asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>

The dropdown list items are from different table, Title from tblTitle,Subject from tblSubject and createrName from tblName.

Any help will be highly appreciated.

Thanks

Re: SQL Query and .Net code for Advanced search in my application ??

babisharma11-Nov-08 11:10

babisharma

11-Nov-08 11:10

I did this and I have problem to select the different table from dropdownlist.

here is my sql query:(inside the App_Code)

public static DataSet GetReport(String repository, String name, String title, String subject)
{

String sql = " Select distinct col.ID,col.CollectionAbstract,col.Title,col.SortTi tle,col.Scope,col.CollectionIdentifier from tblCollections_Collections col" +
" LEFT JOIN tblCollections_CreatorIndex colCI " +
" ON col.ID = colCI.CollectionID " +
" LEFT JOIN tblCreators_Creators cr" +
" ON colCI.CreatorID = cr.ID " +
" LEFT JOIN tblCollections_SubjectIndex sbI " +
" ON col.ID = sbI.CollectionID " +
" LEFT JOIN tblSubjects_Subjects sub " +
" ON sbI.SubjectID = sub.ID " +
" where ( 1=1 )" + //
(repository == null || repository.Trim() == "" ? "" : " and col.RepositoryID in( " + repository + " )") +
(title == null || title.Trim() == "" ? "" : " and col.Title like '%" + title + "%'") +
(name == null || name.Trim() == "" ? "" : " and cr.Name like '%" + name + "%'") +
(subject == null || subject.Trim() == "" ? "" : " and sub.Subject like '%" + subject + "%'")+
" order by col.Title";

return SqlHelper.ExecuteDataset(GetConnectionString(), CommandType.Text, sql);
}

aspx.cs file contains:

protected void Button1_Click(object sender, EventArgs e)

{

try
{

String repository = "";
Boolean first = false;

if (reposotoryCheckBoxList.Items[0].Selected == true)
{
repository = " 1,3,5";
}

else
{
first = false;
for (int i = 0; i <= reposotoryCheckBoxList.Items.Count - 1; i++)
{
if (reposotoryCheckBoxList.Items[i].Selected == true)
{
if (first == false)
{
repository = reposotoryCheckBoxList.Items[i].Value.ToString();
first = true;
}
else
{
repository = repository + " , " + reposotoryCheckBoxList.Items[i].Value.ToString();

}
}
}

}

......My questions .....how to implement that 5 dropdownlists here..............???.......

string str = TextBox1.Text.ToString();
string str1 = TextBox2.Text.ToString();
string str2 = TextBox3.Text.ToString();
str = str.Trim();
str1 = str1.Trim();
str2 = str2.Trim();

//throw new Exception();
DataSet ds;
ds = DataAccess.GetReport(repository, str1, str, str2);
Repeater1.DataSource = ds;
Repeater1.DataBind();

}

I have problem to handle these dropdownlists.Any help will be highly appreciated.

Thanks for your help.

AppDomain could not be created Runtime Error

RB@Emphasys11-Nov-08 10:23

RB@Emphasys

11-Nov-08 10:23

Hello All,

We're deploying a .net 2.0 web application to a windows 2003 server running IIS. It currently has various .net 1.* running on it. We created a seperate threading pool, insured the framework was installed, registered it to use .net 2.0, through the app on, and we're getting a rather odd error. The event log states "Failed to execute request because the App-Domain could not be created.Error 0x80131522" We have this app running in similar environments with no issues.

Any ideas would be greatly appreciated,

Thanks,
Ryan

dynamically adding rows in gridview

Mogaambo11-Nov-08 9:16

Mogaambo

11-Nov-08 9:16

hi, what i am trying to do is , when a button is clicked a row should be added containing one column with a textbox in gridview.

For that i have used datatable for binding,, but i am unable to get the added textbox reference using find control method

here is my cs code.

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

public partial class _Default : System.Web.UI.Page
{

protected void Page_Load(object sender, EventArgs e)
{

if (!IsPostBack)
{
loadDynamicGrid();
}
}

private void loadDynamicGrid()
{
DataTable dt = new DataTable();
DataColumn dcol = new DataColumn();
dcol.ColumnName = "gggg";
dt.Columns.Add(dcol);
DataRow drow = dt.NewRow();
dt.Rows.Add(drow);
GridView1.DataSource = dt;
GridView1.DataBind();

}

protected void Button1_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();

DataColumn dcol = new DataColumn("gggg");

dt.Columns.Add(dcol);

foreach (GridViewRow gvr in GridView1.Rows)
{
DataRow drow= dt.NewRow();
TextBox tt = (TextBox)gvr.Cells[0].FindControl("Text1");
drow[0] = tt.Text;//Here gives error as it is always null
dt.Rows.Add(drow);
}

DataRow dr = dt.NewRow();
dr[0] = "";
dt.Rows.Add(dr);
GridView1.DataSource = dt;
GridView1.DataBind();

}

protected void GridView1_RowDataBound1(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
TextBox tb = new TextBox();
tb.ID = "Text1";
tb.Text = "chanu";
e.Row.Cells[0].Controls.Add(tb);

}
}
}

//here is my aspx code

]]>

<title>Untitled Page

<asp:scriptmanager id="ScriptManager1" runat="server" xmlns:asp="#unknown">

<asp:updatepanel id="UpdatePanel1" runat="server" xmlns:asp="#unknown">
<contenttemplate>
<asp:gridview id="GridView1" runat="server">
Width="200px"

onrowdatabound="GridView1_RowDataBound1" >
<columns>

<asp:button id="Button1" runat="server" onclick="Button1_Click" text="Button">

“You will never be a leader unless you first learn to follow and be led.”
–Tiorio

"Coming together is a beginning, staying together is progress, and working together is success." Henry Ford

Export to Excel

kishorg111-Nov-08 3:46

kishorg1

11-Nov-08 3:46

i have show data in gridview
now i want to Export that data to Excel on click of button so user can save it.

Re: Export to Excel

jzonthemtn11-Nov-08 5:06

jzonthemtn

11-Nov-08 5:06

Search and ye shall find...

http://www.google.com/search?sourceid=navclient&ie=UTF-8&rlz=1T4GGLL_en&q=gridview+to+excel[^]

Re: Export to Excel

kishorg112-Nov-08 0:06

kishorg1

12-Nov-08 0:06

thnx

Validation

shanthi jothi11-Nov-08 2:27

shanthi jothi

11-Nov-08 2:27

Hi,
please tell me how to validate ” dd/mm/yyyy” date format using comparevalidator…

Re: Validation

Brij11-Nov-08 3:13

Brij

11-Nov-08 3:13

use regex

Cheers!!
Brij

Re: Validation

jzonthemtn11-Nov-08 5:05

jzonthemtn

11-Nov-08 5:05

If I hadn't just wrote it I would never post it.

<asp:CompareValidator id="DateValidator" runat="server" Type="Date" Operator="DataTypeCheck" ControlToValidate="TextBox1" ErrorMessage="!" />

adding multiple records

Mogaambo11-Nov-08 2:10

Mogaambo

11-Nov-08 2:10

i am reading from a gridview that have atleast 10 rows

i want to insert all rows at a time how can i do it without using any loop.

“You will never be a leader unless you first learn to follow and be led.”
–Tiorio

"Coming together is a beginning, staying together is progress, and working together is success." Henry Ford

Datetime

shanthi jothi11-Nov-08 1:53

shanthi jothi

11-Nov-08 1:53

How Can I convert MM/dd/yyyy format into dd/MM/yyyy and the date.
using Asp.net 2.0 with c#

Re: Datetime

Guffa11-Nov-08 3:08

Guffa

11-Nov-08 3:08

Use the DateTime.ParseExact method to parse the string into a DateTime value, then use the ToString method on the value to format it into the desired string.

Despite everything, the person most likely to be fooling you next is yourself.

tab control with same position

r aa j11-Nov-08 1:39

r aa j

11-Nov-08 1:39

I am developing website...I want to display 3 table details using Tab control...I am using following code..but its displaying different position..i wnt to display with same position...

function VisibleMe(no)
{
//alert("test");
document.getElementById("div1").style.visibility = "hidden";
document.getElementById("div2").style.visibility = "hidden";

document.getElementById("div"+no).style.visibility = "Visible";

document.getElementById("div"+no).style.left = 0+"px";
document.getElementById("div"+no).style.top = 0+"px";
//document.getElementById("tabtd").innerHTML=document.getElementById("div"+no).innerHTML;
}

<table>

<tr><td>
<div id="div1" style="overflow:scroll;width:814px;position:absolute;">
<table width="1600" border="0" cellspacing="0" cellpadding="0" align="center">
<tr><td valign="middle" width="110"><div class="client">PublisherName</div></td>
<td valign="middle" width="110"><div class="client">AdName</div></td>
<td valign="middle" width="120"><div class="client">ServedImpressions</div></td></tr>
</table></div>

<div style="overflow:scroll;width:814px;position:absolute;" id="div2">
<table width="2000" border="0" cellspacing="0" cellpadding="0" align="center">
<tr><td valign="middle" width="110"><div class="client">PublisherName</div></td>
<td valign="middle" width="110"><div class="client">InteractionRate</div></td>
<td valign="middle" width="170"><div class="client">InteractionAverageDuration</div></td></tr>
</table></div>

</div>
<table border="0">
<tr>
<td id="td1" onclick="VisibleMe(1)"><b>Creative Summary</b></td>
<td id="td2" onclick="VisibleMe(2)"><b>Engagement</b></td>

</tr>
<tr><td valign="top" align="left" bgcolor="#FCFCFC" colspan="3">
<span id="tabtd"></span>
</td>
</tr>
</table>
</td></tr></table>

if anybody knows..plz reply me..

Thanks

Raaj

Re: tab control with same position

J a a n s11-Nov-08 1:55

J a a n s

11-Nov-08 1:55

Try to change the display style. Even if you change the visibility of the control, it will occupy the area for rendering it.

*jaans

Re: tab control with same position

r aa j11-Nov-08 1:58

r aa j

11-Nov-08 1:58

I changed position equalto relative and absolute....but I couldnt get

Raaj

Re: tab control with same position

J a a n s11-Nov-08 4:19

J a a n s

11-Nov-08 4:19

I asked you to change style.display.The code will be

document.getElementById("div1").style.display = "none";

for making it invisible and

document.getElementById("div1").style.display = "block";

for making it visible.

*jaans

Saving upLoaded File with Client Call Back

Ajeet mittal11-Nov-08 1:37

Ajeet mittal

11-Nov-08 1:37

Hi,

I am using ASP,NET 2.0,
In my application,I have to save file through Client Call Back.

Can any one help me in this regards

thanks

Retain link Color?

Prasadsm11-Nov-08 1:30

Prasadsm

11-Nov-08 1:30

How to retain hyperlink color when clicked?

Thanks in Advance.

Re: Retain link Color?

Ashfield11-Nov-08 1:32

Ashfield

11-Nov-08 1:32

Check out a:visited, that is what you are trying to set.

Bob
Ashfield Consultants Ltd

Re: Retain link Color?

Prasadsm11-Nov-08 2:18

Prasadsm

11-Nov-08 2:18

Hi Bob,
Thanks for your reply.

I have written the script as follows

a:link {
COLOR: #0000FF;
}
a:visited {
COLOR: #800080;
}
a:hover {
COLOR: #FF0000;
}
a:active {
COLOR: #00FF00;
)

when I click on a link..its color gets changed and redirects to some xyz.apsx page(assume).Now the link color gets refreshed in that page.I need to retain the color of link (i.e visited color) in redirected page.
how can this be done?

Thanks in advance.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.