|
i dont understand that Conn()
first you try this below code in one page, and if run sucessful then sperate connection on second page.
<%
dim Conn
set Conn = Server.Createobject("ADODB.Connection")
Conn.ConnectionString = "PROVIDER=SQLOLEDB;DATA SOURCE=yourMachine\SQLEXPRESS;UID=sa;PWD=whatever;DATABASE=DB;"
Conn.Open
Dim MyRs
Set MyRs = Server.CreateObject("ADODB.Recordset")
MyRs.CursorLocation = 3
Dim vAuthorID, vName,sql
vAuthorID = Request.Form(txtid)
vName = Request.Form(txtName)
sql="Insert into author(aid,aname) VALUES ('"& vAuthorID &"','" & vName &"')"
conn.Execute(sql)
conn.close
set sql = Nothing
response.Redirect("thankyou.asp")
End If
%>
Let me know if it helps
|
|
|
|
|
<title>
AuthorID
Author Name
<%
dim Conn ' As Object
set Conn = Server.Createobject("ADODB.Connection")
Conn.ConnectionString = "Provider=SQLOLEDB; Data Source = (local); Initial Catalog = Test; User Id = sa; Password=as"
Conn.Open 'an error will occur here if the server/connection info is incorrect.
Dim MyRs 'As ADODB.Recordset
Set MyRs = Server.CreateObject("ADODB.Recordset")
MyRs.CursorLocation = 3 'adUseClient
Dim vAuthorID, vName,sql
vAuthorID = Request.Form(aid)
vName = Request.Form(aname)
' --note this is wide open to SQL injection better to use StoredProcedure instead:
sql="Insert into author(aid,aname) VALUES ('"& vAuthorID &"','" & vName &"')"
conn.Execute(sql)
conn.close
set sql = Nothing
response.Redirect("thankyou.asp")
End If
%>
Hello fri, plz look at my code. Error still happen in my code. Thz
|
|
|
|
|
|
No error was found but I need to encrypt one field (e.g - password). How should I do with Classic ASP?
|
|
|
|
|
Ye Htut wrote: but I need to encrypt one field (e.g - password). How should I do with Classic ASP? Check this article
Encrypting Passwords in ASP[^]
If possible get rid of Classic ASP. Go with ASP.NET
|
|
|
|
|
SubjectUserSid S-1-5-21-3532193094-2589986628-862158326-1002 how do i find the name that goes with this #?
|
|
|
|
|
|
SubjectUserSid S-1-5-21-3532193094-2589986628-862158326-1002
|
|
|
|
|
Please help me...
My Problem is "When my application idle for 20 minutes then they redirect to login page"
Scanerio "
My Boss except to application if application is idle for 30 min then password acceptance popup is open and if application idle for 60 minutes then session timeout
I check all objects there is no Session.Clear () or Session. Abandon () in my application only I use Session. Abandon () in global.aspx page for session out
"
For Solution I perform following task:-
1. <SessionState mode=inproc cookiless=false timeout=60 statenetworktimeout=60>
2. <form name =login defaulturl=login.aspx protection=none timeout=60 slidingexpiration=true>
3. In IIS Perform following task:-
• Clear all recycle
• set ideal time to 120
Thanks in advance.......
singh
|
|
|
|
|
I think you check the associated application pool advance setting 'Idle Timeout (Minuts)' under 'Process Model'
Help people,so poeple can help you.
|
|
|
|
|
Hi everyone
I am trying to create a comment system with ASP.NET,Ajax and Jquery as following:
This system is different from other comment system , in this system user can select a sentence or a paragraph with double click on it and then comment on that , after this a tag appear beside this sentence or paragraph . when a user click on that the related comment appear.I want to know how can create a comment system like this? I do many search but fail . for more information you can visit website www.nowcomment.com , I want a comment system like this
Thanks everyone for his/her help
|
|
|
|
|
Why not create one using your favorite technologies, then post it on the web, so next time people will be able to find your code and use it for free. Could you please do it?
|
|
|
|
|
Dear Peter
Thanks for you replay and suggestion but I try many times to do it but I fail , Have you any idea about it?
Thanks for your help
|
|
|
|
|
Hi,
I have a website that uses some componenets from the Ajax Control Toolkit.
Everything works fine on my computer, but when I upload the solution to my Windows Server 2008 R2 none of the ajax features seem to load.
I dont get any error message or anything, it just doesnt work.
I've tried to add the assembly information to web.config.. actually I've tried every solution I could find on Google, with no luck.
Anybody got any good ideas ??
|
|
|
|
|
I would like to ask if how Linq works in mvc 5 for visual studio? can you post some image or some step or code?
|
|
|
|
|
Hi, I am trying to create a report in Asp.net using report viewer and passing parameters. I have created the report (.rdlc) with Dataset with parameter that points to a function in DomainService. The function returns IQuerable from SQL server. I use that report in an .aspx page. When I launch the page it repeats the first record 5 times (there should be 5 different records). I'm sure I am missing something. Any ideas? Thank you!
here is html for page...
<body>
<form id="form1" runat="server">
<div>
<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana"
Font-Size="8pt" InteractiveDeviceInfos="(Collection)"
WaitMessageFont-Names="Verdana" WaitMessageFont-Size="14pt" Width="650px">
<LocalReport ReportPath="Construction\Reports\Test1.rdlc">
</LocalReport>
</rsweb:ReportViewer>
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
</div>
</form>
</body >
here is vb.net code behind page...
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not IsPostBack Then
Dim projectjey As Integer = Request.QueryString("projectkey")
ReportViewer1.LocalReport.DataSources.Add(New ReportDataSource("DataSet1", New ENGINEERSDevEntities1().spCNSTBidProposalReportByProjectKey(projectjey)))
Dim rptParameters As New ReportParameter()
rptParameters.Name = "projectkey"
rptParameters.Values.Add(projectjey)
ReportViewer1.LocalReport.SetParameters(rptParameters)
ReportViewer1.LocalReport.Refresh()
End If
End Sub
|
|
|
|
|
Got it to work, I needed to set up the datasource on the web page with an asp: EntityDataSource...
<div>
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<rsweb:ReportViewer ID="ReportViewer1" runat="server" Font-Names="Verdana"
Font-Size="8pt" InteractiveDeviceInfos="(Collection)"
WaitMessageFont-Names="Verdana" WaitMessageFont-Size="14pt" Width="636px">
<LocalReport ReportPath="Construction\Reports\CNSTReportProposalByProjectKey.rdlc">
<DataSources>
<rsweb:ReportDataSource DataSourceId="EntityDataSource1" Name="DataSet1" />
</DataSources>
</LocalReport>
</rsweb:ReportViewer>
<asp:EntityDataSource ID="EntityDataSource1" runat="server"
ConnectionString="name=ENGINEERSDevEntities1"
DefaultContainerName="ENGINEERSDevEntities1" EnableFlattening="False"
EntitySetName="vwCNSTBidProposalReportByProjectKeys">
</asp:EntityDataSource>
</div
|
|
|
|
|
hi, i have a hard problem with linq and asp.net
i have 3 table
(table1 = person)(table2 = equipment)(table3= ralation on person and equipment)
i have a page with a search button and a checklistboxthat bind with equpments
i want that user select one or more check list and then show persons that have those equipments
i create this page with elements and attach on this post
technology : Linq
please help
thanks
-------------------------
table 1
p_famil p_code
ali 1
reza 2
mohamad 3
kazem 4
---------------------------------
table 2
e_code e_title
1 home
2 car
3 job
--------------------------------
table 3
er_eq_code er_per_code
2 1
3 1
1 2
1 4
be happy
|
|
|
|
|
Hi,
Can you try the following, I have not tested this.
List<int> selectedEquipments = new List<int>();
//get the the selected values in this list
var query =
from t3 in table3
where t3.er_eq_code.Contains(selectedEquipments)
join t2 in table2 on t3.er_eq_code equals t2.e_code
join t1 in table1 on t3.er_pr_code equals t1.p_code
select new {t1.Name, t2.b, t2.c, t1.d, t1.e}; // Use your column names here
Hope this helps you.
modified 8-May-14 4:25am.
|
|
|
|
|
object[] obj = new object[2];
obj[0] = UserNameTextBox.Text;
//obj[1] = PasswordTextBox.Text;
obj[1] = FormsAuthentication.HashPasswordForStoringInConfigFile(PasswordTextBox.Text, "sha1");
SqlTransaction tran;
if (Business.CN_String.State == ConnectionState.Closed)
Business.CN_String.Open();
tran = Business.CN_String.BeginTransaction();
//business.select(tran, "check_login", obj);
DataSet ds = (DataSet) business.select_pera("check_login", obj);
---------
ERROR HERE
string type = ds.Tables[0].Rows[0]["Type"].ToString();
------------
tran.Commit();
Business.CN_String.Close();
Session.Add("Naitik", UserNameTextBox.Text);
Session.Add("Naitik1", "LoginUser");
if (Session["Naitik2"] == "WithoutLoginUser")
{
Response.Redirect("~/General/Product.aspx");
}
if ((Boolean)ds.Tables[0].Rows[0]["Authentication"] == true)
{
if (type == "admin")
Response.Redirect("~/Admin/Home.aspx");
else
//Response.Redirect("~/User/Home.aspx?userName="+UserNameTextBox.Text);
Response.Redirect("~/User/Home.aspx");
}
else
{
Response.Write("<script>alert('Please Check Your Email For Varification')</script>");
}
|
|
|
|
|
Your check_login procedure is not returning any rows.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
hi, i'm trying to develop dynamic profiles in which, the .aspx page will be created on signup.. i've already done the creating part.. and it is working fine, Now what i want to do is, i want my pages to be extensionless... like..
i want www.myurl.com/Profiles/sample.aspx?id=profilename to be like this www.myurl.com/profilename
where Profiles is folder and sample is an .aspx page residing in Profiles.
i'm using IIS 7, can any 1 tell me what should i do to achieve this? Thank U
|
|
|
|
|
For restful urls, use friendlyurls nuget package.
For your custom url needs like www.myurl.com/profilename, use and configure routing table.
You might wish to google on routing in asp.net.
|
|
|
|
|
how to use nuget package please explain...
|
|
|
|
|