|
Try to catch the exception if server is down and then send proper message
cheers,
Abhijit
|
|
|
|
|
Recetly we update our database on access. we addedd more cloumns of data on one of the tables. I have five tables on the access " active,master,customer,user,...)The table I added more cloumn is "master" table. before we had: part-no., descrption,price" now we have "part-no.,descption,price,MVC,NRC,NPN". the ASP program it will upload an excel file with part-no. and qty then it will display the data from these two tables"active and master" by active being the first choice the master the second. can you please look at this ASP code to see how can i add other column to be printed with new data. Thanks. Kamran
<!--#include file="conn.asp"-->
<!--#include file="verify.asp"-->
<html>
<head>
<title>new page</title>
<link rel="stylesheet" type="text/css" href="css.css">
<meta http-equiv="Content-Type" content="text/html;">
</head>
<body>
<form name="form" method="post" action="savexls.asp" enctype="multipart/form-data" >
<input type="file" name="file1" size="20">
<input type="submit" name="Submit" value="UPLOAD">
<p>
</p>
<%
set rst = server.createobject("adodb.recordset")
sql="select top 1 * from active"
rst.open sql,conn,1,1
%>
<table style="border-collapse: collapse" bordercolor="#C0C0C0" width="100%" id="AutoNumber3" cellspacing="1" height="0" border="1">
<tr>
<% j=0
for each x in rst.fields %>
<% fieldname=trim(x.name)
if fieldname="pn" then
fieldname="Part-No."
end if
if fieldname="price" then
fieldname="Cost"
end if
if j=2 then %>
<td width="7%" height="50" align="center" bgcolor="#E1E1E1"><b><font face="Arial" style="font-size: 11pt">Qty</font></b></td>
<td height="50" align="center" bgcolor="#E1E1E1"><b><font face="Arial" style="font-size: 11pt"><%=ucase(left(fieldname,1))&right(fieldname,len(fieldname)-1)%></font></b></td>
<% else
%>
<td height="50" align="center" bgcolor="#E1E1E1"><b><font face="Arial" style="font-size: 11pt"><%=ucase(left(fieldname,1))&right(fieldname,len(fieldname)-1)%></font></b></td>
<%
end if
j=j+1
next
%>
<td align="center" bgcolor="#E1E1E1" height="50"><b><font face="Arial" style="font-size: 11pt">Source</font></b></td>
<td align="center" bgcolor="#E1E1E1" height="50"><b><font face="Arial" style="font-size: 11pt">MVC&NRC</font></b></td>
<td align="center" bgcolor="#E1E1E1" height="50"><b><font face="Arial" style="font-size: 11pt">NPN</font></b></td>
</tr>
<%
rst.close
set rst=nothing
if request("id")=1 then
set conn1 = server.createobject("adodb.connection")
name=trim(request("name"))
FileName="xls\"&name
ConnStr = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source ="&Server.MapPath(FileName)&";Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"""
Conn1.Open ConnStr
set rs = server.createobject("adodb.recordset")
set rs1 = server.createobject("adodb.recordset")
sql = "select * from [sheet1$]"
rs.open sql,conn1,1,1
do While Not Rs.EOF
i=1
for each x in rs.fields
if i=1 then
text1=x.name
end if
if i=2 then
text2=x.name
end if
i=i+1
next
'strpn=trim(rs("pn"))
strpn=trim(rs(text1))
'strquantity=trim(rs("quantity"))
strquantity=trim(rs(text2))
datafrom="None"
description=""
price=""
sql1="select * from active where pn='"&strpn&"'"
rs1.open sql1,conn,1,1
IF Rs1.Eof And Rs1.Bof Then
rs1.close
sql2="select * from master where pn='"&strpn&"'"
rs1.open sql2,conn,1,1
if Rs1.Eof And Rs1.Bof Then
datafrom="None" %>
<tr><td><font face="Arial" style="font-size: 10pt"> <%=strpn%></font></td><td> </td><td><font face="Arial" style="font-size: 10pt"><%=strquantity%></font></td>
<% for diffn=1 to j-2 %><td> </td><% next %><td><font face="Arial" style="font-size: 10pt"><%=datafrom%></font></td> </tr>
<% else
datafrom="Master"
do While Not Rs1.EOF
m=0 %><tr>
<%
for each x in rs1.fields
if m=2 then
xvalue="$"&trim(x.value) %>
<td><%=strquantity%></td>
<% else
xvalue=trim(x.value)
end if
%>
<td><font face="Arial" style="font-size: 10pt"><%=xvalue%></font></td>
<% m=m+1
next
if m<j then
for dif=1 to j-m
%><td> </td>
<%
next
end if
%>
<td><font face="Arial" style="font-size: 10pt"><%=datafrom%></font></td>
</tr>
<% rs1.MoveNext
loop
end if
else
datafrom="Active"
do While Not Rs1.EOF
m=0
%> <tr>
<% for each x in rs1.fields
if m=2 then
xvalue="$"&trim(x.value)
%> <td><%=strquantity%></td>
<% else
xvalue=trim(x.value)
end if
%>
<td><font face="Arial" style="font-size: 10pt"><%=xvalue%></font></td>
<% m=m+1
next %>
<td><font face="Arial" style="font-size: 10pt"><b><font color=#ff0000><%=datafrom%></font></b></font></td>
</tr>
<% rs1.MoveNext
loop
end if
Rs1.Close
rs.MoveNext
Loop
%>
</table>
</form>
<form name="form1" method="post" action="quote.asp?id=1&name=<%=name%>">
<b><font face="Arial" style="font-size: 11pt">Please Input Customer's NAME:</font></b>
<input type="text" name="email" size="20">
<input type="submit" name="continue" value="CONTINUE">
</form>
<form name="form2" method="post" action="quote.asp?id=1&name=<%=name%>">
<b><font face="Arial" style="font-size: 11pt">Select A Customer's Name:</font></b>
<p> </p>
<select name="email">
<%
sql3="select * from customer"
set rs3 = server.createobject("adodb.recordset")
rs3.open sql3,conn,1,1
if rs3.eof and rs3.bof then
response.write "Not record."
else
do while not rs3.eof
response.write "<option " & " value='" + Cstr(rs3("name")) + "'>" + rs3("name") + "</option>"
rs3.MoveNext
Loop
end if
rs3.close
set rs3=nothing
%>
</select>
<input type="submit" name="continue" value="CONTINUE">
</form>
<%
Rs.Close
Set Rs=nothing
Conn1.Close
Set Conn1=Nothing
Set Rs1=nothing
Conn.Close
Set Conn=Nothing
end if
%>
</body>
</html>
|
|
|
|
|
ajax tabcontainer add new tabpanel with close button
i have added the new tabpanel on button click.
and i want to remove the added tab.
i wrote as tabcontainer1.tabs.remove(tabcontainer1.activetab);
error occurs
Specified argument was out of the range of valid values.
Parameter name: value
please help me.
Bharani
|
|
|
|
|
hi,
I am quite fresh to asp.net
At the first begining, gridview will populate all data from database.
when keyword insert into text box and press "search" button, based on the keyword, it will get the data which match the keyword and populate it at gridview. I try it for weeks already but still can't solve it.
May someone help me on this?
|
|
|
|
|
I only can do the search function but at first page loading, i can't populate all the data from database. bbelow is my default3.aspx from northwind database with dbo.products table. Default3.aspx.vb does not has any code.
Default3.aspx
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default3.aspx.vb" Inherits="Default3" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<asp:Button ID="Button1" runat="server" Text="Search" />
</div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="True"
DataKeyNames="ProductID" DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="ProductID" HeaderText="ProductID" ReadOnly="True"
SortExpression="ProductID" />
<asp:BoundField DataField="ProductName" HeaderText="ProductName"
SortExpression="ProductName" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConflictDetection="CompareAllValues"
ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString3 %>"
DeleteCommand="DELETE FROM [Products] WHERE [ProductID] = @original_ProductID AND [ProductName] = @original_ProductName"
InsertCommand="INSERT INTO [Products] ([ProductName]) VALUES (@ProductName)"
OldValuesParameterFormatString="original_{0}"
SelectCommand="SELECT [ProductID], [ProductName] FROM [Products] WHERE ([ProductName] = @ProductName)"
UpdateCommand="UPDATE [Products] SET [ProductName] = @ProductName WHERE [ProductID] = @original_ProductID AND [ProductName] = @original_ProductName">
<SelectParameters>
<asp:ControlParameter ControlID="TextBox1" Name="ProductName"
PropertyName="Text" Type="String" />
</SelectParameters>
<DeleteParameters>
<asp:Parameter Name="original_ProductID" Type="Int32" />
<asp:Parameter Name="original_ProductName" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="ProductName" Type="String" />
<asp:Parameter Name="original_ProductID" Type="Int32" />
<asp:Parameter Name="original_ProductName" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="ProductName" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
</form>
</body>
</html>
|
|
|
|
|
hi all,
It has dropdownlist in gridview.
I face a difficult in update the dropdownlist.selectedvalue into database.
May someone have simple example of source code to help me on this?
|
|
|
|
|
There are lots of ways to update database from gridview.
How you are doing it?
What difficulty you are facing?
|
|
|
|
|
in my gridview, i have linkbutton for add new row. below is the code for add new gridviewrow. but for the edit and update gridviewrow i still no has any idea. may u help me?
Protected Sub GridView1_RowCommand(ByVal sender As Object, ByVal e As GridViewCommandEventArgs)
Dim conn As New SqlConnection("Data Source=localhost;Initial Catalog=Display;Integrated Security=True;")
Try
If e.CommandName.Equals("New") Then
Dim btnNew As LinkButton = TryCast(e.CommandSource, LinkButton)
Dim row As GridViewRow = TryCast(btnNew.NamingContainer, GridViewRow)
If row Is Nothing Then
Return
End If
Dim txtPickTownCity As TextBox = TryCast(row.FindControl("PickTownCityTextBox"), TextBox)
Dim dropdownlistPickState As DropDownList = TryCast(row.FindControl("DropDownList3"), DropDownList)
Dim txtDeliveryTownCity As TextBox = TryCast(row.FindControl("DeliveryTownCityTextBox"), TextBox)
Dim dropdownlistDeliveryState As DropDownList = TryCast(row.FindControl("DropDownList6"), DropDownList)
Dim cmd As New SqlCommand("INSERT INTO [Address] ([Pick_Town_City], [Pick_State], [Delivery_Town_City], [Delivery_State]) VALUES (@Pick_Town_City, @Pick_State, @Delivery_Town_City, @Delivery_State)", conn)
cmd.Parameters.AddWithValue("Pick_Town_City", txtPickTownCity.Text)
cmd.Parameters.AddWithValue("Pick_State", dropdownlistPickState.SelectedValue)
cmd.Parameters.AddWithValue("Delivery_Town_City", txtDeliveryTownCity.Text)
cmd.Parameters.AddWithValue("Delivery_State", dropdownlistDeliveryState.SelectedValue)
conn.Open()
If cmd.ExecuteNonQuery() = 1 Then
GridView1.DataBind()
End If
End If
Catch ex As Exception
Finally
conn.Close()
End Try
End Sub
|
|
|
|
|
|
hi,
i m a beginner in asp.net
i want to ask how to change pictures in adrotator without refreshing the page in a particular way(like screensavers work)
and i dont want to use ajax....
|
|
|
|
|
Try using html maybe with a marquee?
"Sex is not the answer, it's the question and the answer is yes"
|
|
|
|
|
i think the plan will be using ad rotator with datasource then put it into update panel(ajax) then add timer and use code behind to updatepanel.update() method evry fixed time based on the timer events
hope it help
drahmedgalal@hotmail.com
|
|
|
|
|
|
I have a requirement where i need to provide a Search facility to my web application.
Basically i will have a Search text box and a button. User can enter some words and when he clicks the button, the application should search some columns in a couple of tables and the details should be presented to the user. I don't know how to implement this.
Do any of u guys have an idea, i would be very thankful to u if u can share with me.
Thanks & Regards,
Krishna.
|
|
|
|
|
This is not a quite simple as I think.but may be this suggestion helps you
Follow these three steps
Store Procedure
First Step : Create temporary table
CREATE TABLE #TempTable
(
ID int IDENTITY PRIMARY KEY,
Column1 nvarchar(100),
Column2 nvarchar(100),
)
Second Setep: Insert matched records from other tables into temporary table
INSERT INTO #TempTable(column1,column2)
Select column1,column2 from myTable1 where column3=yourSearchingText
INSERT INTO #TempTable(column1,column2)
Select column1,column2 from myTable2 where column3=yourSearchingText
INSERT INTO #TempTable(column1,column2)
Select column1,column2 from myTable3 where column3=yourSearchingText
Third Step : Select all records from temp table
SELECT * FROM #TempTable
Best of luck
Regards
Khan
please don't forget to vote on the post that helped you.
|
|
|
|
|
Or possibly just use a UNION predicate? Better asking this in the SQL forum...
|
|
|
|
|
|
Dear All
Is any one haveing have script wich converts english to french(in a text box)
Thanks
Siva
|
|
|
|
|
Oh god not again!
What makes you think Javascript alone would be capable of this task? Sure javascript could kick of an AJAX call to a server side translation engine... but thats not really javascript "converting english to french".
You dont seem to have much asp.net or web development experience? Try a beginners book on the subject and go from there. start smaller than a translation engine!
|
|
|
|
|
This is easy to write. You just need to send every English word and it's French translation to the client with every page. Your website will obvioulsy be huge and very slow, but you can do it, if you want to.
Christian Graus
No longer a Microsoft MVP, but still happy to answer your questions.
|
|
|
|
|
Hi,
After Logging-in how to store the UserId and Password in session....
If the user clicks the Back or Previous button from the browser tool bar then how to kill the session......?
Please help me.....
Thanking you
Mcmilan.
|
|
|
|
|
mcmilan wrote: After Logging-in how to store the UserId and Password in session....
Why do you want to store password in session?
To store variable in session,
Session["MyKey"]=VariableName;
mcmilan wrote: If the user clicks the Back or Previous button from the browser tool bar then how to kill the session......?
You can't.
Onclick of browser Back or previous button,Just history of browser is change and content of page get back from cache memory.Page is not reloaded so you can not run code.
please don't forget to vote on the post that helped you.
|
|
|
|
|
If you put Session.Abandon(); in the page_load then that should do the trick. The only issue is that it will abandon the session everytime the user goes to that page.
Not a big deal if it's on the Login page though.
Hope this helps.
Cheers
Disgyza
Programmer Analyst
|
|
|
|
|
Session["UserId"]=txtuserid.text.trim();
To clear session
Session.Abandon();
|
|
|
|
|
I used the System.Diagnostics.Process.start method to open an application from an ASP.Net. It works fine when I debug it using VS 2005, but when I put it on a web server and click the button nothing happens. Please help me resolve this issue 
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
