|
Hi
I post a link that describe my problem at the first message.
10x.
|
|
|
|
|
I am trying to retrieve the time from TableB into TableA. All it does is post the current date in the format...9/30/2007 0:00:00
What I am looking for is the time value in TableB.
Here is my code..
<pre
scmd.commandtype =="" commandtype.storedprocedure
="" scmd.parameters.add("@scheduleddate",="" sqldbtype.datetime).value="CDate
(startDateTextBox.Text)
" scmd.parameters.add("@starttime",="" "long="" time")=""
'tried="" convert.todatetime(startdatetextbox.text)...didn't="" work...
pre="">
I have made sure the datatypes in the SQL Server database matches in both the Tables.
Let me know why this is failing.
Thanks,
Gym
|
|
|
|
|
What is the value of startDateTextBox? Does it contain a full date and time?
You might be better off storing the entire thing as a single column that holds both the start date and time or storing just the start date and the time as an offset from midnight.
What was the error you got when you tried the Convert.ToDateTime call?
|
|
|
|
|
I finally got the textbox to work but when I use the same value to populate a dropdown list, it does not work. Actually, it works the first time around and after that there is apparently a postback issue. Because the page does not refresh itself and I am not able to figure out how to get that to happen. Also, there is no error message as such.
In a different context, an error message in the form of a warning appears indicating an "Object instance not used" in line 290. What I don't understand to begin with, is the place to find 290 lines of code!! I couldn't find it even among the designer-gen code.
|
|
|
|
|
2. How do i programatically create a gridview with a checkbox and also iterate the grid data to select all checked row?
t.aransiola
|
|
|
|
|
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 ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
"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.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
