|
Gridview not showing first set of data from my query. e.g if my date range is
01/09/2007 to 30/09/2007, the gridview will display data from 02/09/2007 to 30/09/2007
if the range selected is 02/09/2007 to 30/09/2007 it displays data from 03/09/2007 to 30/09/2007
see my query expression
------------------------
Dim strCmd As String = "Select * From vwPOVendor "
strCmd += " Where PODate Between '" & Format(Date1, "yyyy-MM-dd hh:mm:ss") & "' AND '" & Format(Date2, "yyyy-MM-dd hh:mm:ss") & "'"
Dim strConn As String = ConfigurationManager.ConnectionStrings("PODataConnectionString1").ConnectionString
Dim sqlConn As SqlConnection = New SqlConnection(strConn)
If sqlConn.State = ConnectionState.Closed Then
sqlConn.Open()
End If
Dim ds As DataSet = New DataSet()
Dim da As SqlDataAdapter = New SqlDataAdapter(strCmd, sqlConn)
da.Fill(ds, "vendors")
'Closing Sql Connection
sqlConn.Close()
Label1.Text = ds.Tables("vendors").Rows.Count
grdPOrders.DataSource = ds.Tables("vendors")
grdPOrders.DataBind()
ive also tried
--------------
strCmd += " Where PODate >= '" & Format(Date1, "yyyy-MM-dd hh:mm:ss") & "' AND PODate <= '" & Format(Date2, "yyyy-MM-dd hh:mm:ss") & "'"
please help
t.aransiola
|
|
|
|
|
well i suppose to access my local website from another location through internet.
Localwebsite is hosted in my computer.
i assigned my network ip address as 92.67.7.128
i tried to access from http://92.67.7.128/mysite from another location, which show "page cannot be find"
pls help me someone how i can i access this local website through internet.
so much of happy ending...
|
|
|
|
|
Unless that IP address is on the public internet and/or the appropriate rules are setup in any firewalls that might be running at your end you won't be able to do this.
|
|
|
|
|
thanks scott a lot.
but i assigned a ip address which is public the network provider has given.
so how can i make it public?
thanks
so much of happy ending...
|
|
|
|
|
A couple of questions:
- Do you have IIS configured to listen on that IP address?
- If you type in http://localhost, does it bring up your website?
- Do you have any type of firewall running? (Software, hardware, or both)
- Does your network provider support a configuration like this?
|
|
|
|
|
Thanks scott.
I have configured everything. (IIS has been configured)
I can run my website on local host. ( ip address i assigned )
Im using windows xp which has firewall (configured)
Network provider : support ok
thanks
so much of happy ending...
|
|
|
|
|
It's possible that the ip address is non-routable. You may need to work with someone from technical support at your network provider to find out what is going wrong.
|
|
|
|
|
thanks scott for trying help me.
but i solved my problem.
i got a free DNS address and i assigned it to my ip.
it works fine.
without a DNS address it seems not working.
so much of happy ending...
|
|
|
|
|
|
how did you get free DNS???
|
|
|
|
|
Is the Response and Request Cookie Collection the same or do they use two different collections.
If they are different, is the Response Cookie Collection copied over from the Request Cookie Collection when the page is loaded.
I see that with the Response there are to methods one is Add(HttpCookie) the other is Set(HttpCookie). I am setting up a "Keep me logged in for my members" and when they come to the server and don't have an active session I plan to update the cookie they already have with a new expiration date.
I'm just wondering if I should be updating the Response Cookie or adding it to the collection for the response.
|
|
|
|
|
Hi all.
I need some example of following thing:
There is a portal for example www.myportal.com, and users can create their own sub-portals by users logins, for example: www.admin.myportal.com, www.user1.myportal.com
or sub-site structure can be like that:
myportal.com/admin, myportal.com/user1
Something like Sharepoint structure...
The problem is that a got a really huge number of users (>10 000) so physically created IIS directories and files will be hard to maintain and I think not the best solution.
I need some kind of description of solution for this arhitecture, maybe creating special HttpHandlers or smth.
Does anybody faces with problem like that?
http://www.jetideas.com
|
|
|
|
|
hi
is it possible to insert Internet Inbox ? if yes then how?
so that only authorised person can see mail & reply it.
Thanks
bye
|
|
|
|
|
What do you mean? Do you mean the Inbox of any specific program, and where would you like to insert it?
---
single minded; short sighted; long gone;
|
|
|
|
|
I have developed an application in asp .net 2.0 using c# with code-behind.
I found that I was unable to use design mode in VS2005 for my pages subordinate to the master page as whenever I switched to design mode I saw only the master page rendered but greyed out - i.e. none of the subordinate page's controls or content were rendered. I therefore had to resort to editing the raw html in every case. Any user controls which I created showed up correctly when viewed in design mode in isolation, though.
There's nothing wrong with the overall design of the application as it generates valid html for Firefox and IE.
Anybody know of an obvious reason for this? I feel it must be something simple.
|
|
|
|
|
Hello friends..
I am facing one problem with requiredfieldvalidator .My .aspx page contains top, bottom and left web user controls. The middle part of the page contains some textboxes and requiredfield validator associated with them. Left control displays some menus. I use link button to display links on the left control. Now, whenever i click on the link buttons the requiredfiledvalidator displays error because the textbox is empty.The important fact is that both linkbuttons and requiredfieldvalidator lies on same page. How to avoid this?
|
|
|
|
|
Set the CausesValidation Property of the LinkButton to false.
Regards J O H N
"Even eagles need a push." David McNally
|
|
|
|
|
|
I am getting the following error when am adding a table in my page.
Validation(XHTML 1.0 Transitional): Attribute 'height' is not a valid attribute of element 'table'
Validation(XHTML 1.0 Transitional): Attribute 'width' is not a valid attribute of element 'tr'
Validation(XHTML 1.0 Transitional): Attribute 'height' is not a valid attribute of element 'tr'
My Code as follows.
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="AdminLogin.aspx.cs" Inherits="Admin_AdminLogin" %>
<%----%>
<title>Test
I commended the second line eventhough still getting these errors.
|
|
|
|
|
Is this actually preventing you from compiling the site? These are XHTML validation errors that simply mean that the XHTML 1.0 Transitional specification doesn't recognize those attributes as valid for that element. It shouldn't prevent you from being able to compile and run the site.
|
|
|
|
|
Hi,
I have one gridview control with two hidden fields and one dropdownlist.
AutoPostback property of dropdownlist is true.
Now , when selected_index_changed event of dropdownlist fire, that time i want to
know that at which row index dropdownlist is.
kiranbanker
|
|
|
|
|
I have one gridview control with two hidden fields and one dropdownlist.
AutoPostback property of dropdownlist is true.
You can use Item template for inserting a dropdownlist in the datagrid .
<Columns>
<asp:TemplateColumn HeaderText="Action">
<ItemTemplate>
<asp:DropDownList id="DDAction" runat="server" Visible="False" OnSelectedIndexChanged="DropDown_SelectedIndexChanged"
AutoPostBack="True"></asp:DropDownList>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
Now , when selected_index_changed event of dropdownlist fire, that time i want to
know that at which row index dropdownlist is.
Now in the code behind write the following code.
protected void DropDown_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList list = (DropDownList)sender;
if(list.SelectedItem.Text==".......";
.....
//To get the corresponding row
TableCell cell = list.Parent as TableCell;// getting the parent cell of dropdown
DataGridItem item = cell.Parent as DataGridItem;//getting the parent of tablecell ie the row
string p_key=item.Cells[2].Text.Trim();//getting the column values of the row
........
Tickle your brain and the ideas are out
|
|
|
|
|
Hi
I have a problem. i am downloading image from server the problem is that
image get downloaded but when i open it then it is not displayed.
(Preview is not available). Why the image dose not get displayed.
my code is as follow.
<br />
dim iname as string=Request.QueryString("name")<br />
Dim imgname As String = "C:\Inetpub\wwwroot\dotnetupload\image\" & iname<br />
'Dim fname As String = "2_002.jpg"<br />
Dim contentType As String = "image/jpeg"<br />
Dim file As System.IO.FileInfo = New System.IO.FileInfo(imgname)<br />
'Response.AddHeader("Content-Disposition", "multipart/form-data; filename=" & file.Name)<br />
Response.AddHeader("Content-Disposition", "attachment; filename=" & file.Name)<br />
Response.AddHeader("Content-Length", file.Length.ToString())<br />
Response.ContentType = contentType<br />
Response.Write(file.FullName)<br />
Response.End()<br />
<br />
Please help me to solve the problem.
Thanks.
Rahul
People Laugh on me Because i am Different but
i Laugh on them Because they all are same.
|
|
|
|
|
Response.WriteFile(file.FullName)
|
|
|
|
|
i have to insert a value into the table, but before inserting into the database i wanted to check whether that entry exist there or not.
for that i am using two seperate qieries.
can i do this job in a single stored procedure?
Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1
|
|
|
|