|
Here is some code:
create this event if you don't already have it.
protected void GridView1_PreRender(object sender, EventArgs e)
{
if ((GridView1.PagerSettings.Position == PagerPosition.Top ||
GridView1.PagerSettings.Position == PagerPosition.TopAndBottom) &&
GridView1.TopPagerRow != null)
{
if (!GridView1.TopPagerRow.Visible)
{
GridView1.TopPagerRow.Visible = true;
}
}
if ((GridView1.PagerSettings.Position == PagerPosition.Bottom ||
GridView1.PagerSettings.Position == PagerPosition.TopAndBottom) &&
GridView1.BottomPagerRow != null)
{
if (!GridView1.BottomPagerRow.Visible)
{
GridView1.BottomPagerRow.Visible = true;
}
}
}
Hope that helps.
Ben
|
|
|
|
|
Unfortunately it didn't help with the showing of the Footer or Header when the grid's datasource property has 0 rows. Basically the insert/add new section of the grid is in the grid's Footer. When there are not rows to display for editing, I would still like the footer to display so that users can insert a new row.
Michael
I firmly believe that any man's finest hour, the greatest fulfillment of all that he holds dear, is that moment when he has worked his heart out in a good cause and lies exhausted on the field of battle - victorious.
Vince Lombardi (1913-1970)
|
|
|
|
|
Hi all,
I am learning asp on the fly here so I need to understand how to turn on control the repeater conditionally. Meaning, if my "linkflag" column in my table = 1, I like to make that row hyperlinkable (if not possible to make entire row clickable then just col1) and display a checkbox with a checked state set to true (indicating that is a hyperlink row). How do I accomplish this? Here is what I have so far. Thanks
<%@ Import Namespace="System.Web.UI.WebControls"%>
<%@ Import Namespace="System.Web.UI.WebControls.Repeater"%>
<%@ Import Namespace="System.Data.SQLclient"%>
<%@ Import Namespace="System.Data"%>
<%@ Import Namespace="System.Data.OleDb" %>
Sub numberLookup(ByVal s As Object, ByVal e As EventArgs)
'If Not IsPostBack Then
Dim connSerial As SqlConnection
Dim myDataList As SqlDataReader
Dim Flags As Int
connSerial = New SqlConnection("server=myserverDB;UID=myID;PWD=myPWD;Database=myDB")
Dim cmd As New SqlCommand("sp_mystoredProc", connSerial)
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.AddWithValue("@mylookupNumber", textSerial.Text)
connSerial.Open()
myDataList = cmd.ExecuteReader()
Repeater1.DataSource = myDataList
Repeater1.DataBind()
myDataList.Close()
connSerial.Close()
End Sub
Protected Sub Repeater1_ItemCommand(
ByVal source As Object, ByVal e As System.Web.UI.WebControls.RepeaterCommandEventArgs)
End Sub
<title>Validation Completion
LookupNumber:
<asp:textbox width="75px" id="textSer" runat="server">
<asp:button text="lookup" id="ser" onclick="numberLookup" runat="server">
<asp:repeater id="Repeater1" runat="server" onitemcommand="Repeater1_ItemCommand">
<headertemplate>
<itemtemplate>
<separatortemplate>
<footertemplate>
|
| radiobuttonarea | col1 | col2
| col3 | | <asp:radiobutton id="RadioButton1" checked="true" runat="server"> | <%#Container.DataItem( "col1")%> | <%#Container.DataItem("col2")%> | <%#Container.DataItem("col3")%> |
----------
CREATE PROCEDURE dbo.sp_mystoredproc (
@Ser VARCHAR(64)
)
AS
SELECT linkflags, col1, col2, col3 FROM myTable
WHERE col1 = @Ser)
GO
|
|
|
|
|
Hi every one,
I need to know the node that fires the "onNodeCheckChanged" event, when the user checks more than one node, in other words, I need to know the order in which the user checks the nodes so that I wanna keep the check on the last node he checked..
any suggestions?
Thanks in advance..
|
|
|
|
|
pls help me with the code to declare an array to create a table when the user enter the number of rows in the textbox
oga m
|
|
|
|
|
string[] rows = new string[Int32.Parse(txtBox.Text)];
|
|
|
|
|
hey i tried man
its working
दुनिया-भर just copy and paste it in your resource file
whe you paste it , it will show as boxes, but when you leave the cell it will show the letters in hindi.
Whenever you update the resource file you must rebuild it. (not build Ok)
Cheers
All the best
Regards,
Sylvester G
sylvester_g_m@yahoo.com
|
|
|
|
|
Hi all,
I have a javascript function written in html block of aspx page. I have string vairible declared in it, when I try to print it on a paper its printing whole page, instead of printing that string variable only. Can anybody please suggest me or give me some code snippet how to do it. If possible give me the code snippet for 2-browsers Mozilla and IExplr
My code is as below :
function printdoc(text)
{
var lbl="<%=str4%>";
if (lbl == "Valid")
{
var lbl1="<%= str1 %>";
text=lbl1;
print(text);
}
else
{
alert("Bio-metrics have not been done");
}
}
Can anybody please tell me how to do it. Thank you.
Regards,
Aleem.
S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.
|
|
|
|
|
Please don't cross post.
You can't print anything other than a page. If you want to print a single value, create a page, put the value there and print the page.
---
single minded; short sighted; long gone;
|
|
|
|
|
Please reply in the forum and not as direct email response.
indian143 wrote: No, I would like to print a string value only on a paper cant you give me any other idea. Either it may be VBscript or Javascript. Any client side scripting.
I would be thank full to u.
As I said, you can't print anything other than a page using client scripting.
---
single minded; short sighted; long gone;
|
|
|
|
|
Hi,
I am having trouble running a .bat file from my web application.
The file is run by the server but it doesn't perform its function correctly.
I can run the .bat file on the server my self and it works fine, so it not written wrong, but when run by my aspx page it just doesn't do what it is supposed to.
I have tried a couple of different methods and neither seem to work.
The app is impersonating an admin account on the server with full domain admin permissions, and the .bat file is running accross multple servers.
does anyone have any Idea what may be the problem?
many thanks
mark
|
|
|
|
|
can you try this..?
Process pr = new Process();
pr.StartInfo.RedirectStandardOutput = true;
pr.StartInfo.UseShellExecute = false;
pr.StartInfo.FileName = Server.MapPath("urapp.bat");
pr.StartInfo.Arguments = "your arguments"
pr.Start();
pr.WaitForExit();
pr.Close();
|
|
|
|
|
hai all,
I am having a gridview.. if i click select button in a row..
the details shuold display in a seperate panel below.i tried
writing visiblity in selectedpage index event.. but its not
working...can anyone help me with this......
with Regards,
Imthiyas Ahamed.A
|
|
|
|
|
Try not to repost questions. I answered your other post below.
Ben
|
|
|
|
|
Hi,
I need to read the contents of a xml file and upload them into a database.
Do we have any xml specific class which could be used in this scenario.
Thanks in Advance:
Rakesh
|
|
|
|
|
Using XmlDocument you can load your xml file.
The namespace would be System.Xml
You can use the Xml Path to acces your nodes in your xml file accordingly.
To see more examples on xpath refer w3schools.com
Gautham
|
|
|
|
|
Thanks for the response
I am already using XMLDocument class. Let me tell you what exactly I am doing:
I am reading one set of record of an xml file and opening a SQL connection and inserting the data and then closing the connection. If I have 100 set of records in the XML file then my application opens connection 100 times which I dont see appropriate. I want to do it at one short. Read all the sets from the xml file, open the connection and insert all the records and close it.
Do we have any way to do this?
Rakesh
|
|
|
|
|
Why are you opening and closing the connection? Why not open the connection and command object, loop through the records in the XML file building the SQL on the fly each time and runnning the query. Only close the connection once your done.
|
|
|
|
|
Yah thats really a simple idea.
But I see one issue here. Let say that there are 100 sets of employee records in the xml file and the process finished inserting 60 of the records and suddenly the connection is lost, then what must be done. I mean how can we track the record to be inserted next.
Thanks:
Rakesh
|
|
|
|
|
I think its very easy to use the Dataset method..
ie use the namespace System.Data
then code as follows
Dataset Ds;
ds.ReadXml(xmlfilepath);
here if you check the dataset viewer, you can see all the xml contents as tables.
from there you can extract data and put it in database.
|
|
|
|
|
Thank you, I will try it out...
Rakesh
|
|
|
|
|
I have implemented your suggestion, but facing some issues:
Below is the code I have used:
protected void Button1_Click(object sender, EventArgs e)
{
string path = @"D:\emp.xml";
string dsTable = "";
string connectionString = @"Server = DB\SQL2; Database = CWBDB; user = sa; password = sa";
DataSet ds = new DataSet("EMPDS");
ds.ReadXml(path);
foreach (DataTable t in ds.Tables)
{
dsTable = t.ToString();
}
SqlConnection con = new SqlConnection(connectionString);
SqlDataAdapter da = new SqlDataAdapter();
da.TableMappings.Add("EMP", dsTable);
if ((da.Update(ds))>0)
{
Label1.Text = "Uploaded the data successfully";
}
else
{
Label1.Text = "Could not Upload the data";
}
}
But I see an exception:
"Update unable to find TableMapping['Table'] or DataTable 'Table'."
Please let me know what needs to be done for this!
Rakesh
|
|
|
|
|
hai all,
I am having a gridview.. if i click select button in a row..
the details shuold display in a seperate panel below.i tried
writing visiblity in selectedpage index event.. but its not
working...can anyone help me with this......
with Regards,
Imthiyas Ahamed.A
|
|
|
|
|
If your select button is not doing a post back, there won't be anything to show since the panel didn't get rendered. So make sure the select button is doing a postback. Then on the gridview rowcommand you can see the command is Select so that that point you can make your panel visible. I would actually get rid of the panel and use a PlaceHolder. Those work much better to show and hide controls on an asp.net page.
Hope that helps.
Ben
|
|
|
|
|
Hi all, I want to redirect searching to google.co.in. The user must get redirected to google page showing the desired keyword..what to do?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
