错误-文件已在使用中 [英] Error - File already is in used
本文介绍了错误-文件已在使用中的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
为什么我通过登录表单登录帐户时出现此错误
我的日志记录是
why this error is giving when i am log in to my account through loging form
My cs coading of loging is
void Page_Load(Object s, EventArgs e)
{
Session["a"]=TextBox1.Text;
con=new OleDbConnection();
con.ConnectionString="PROVIDER=Microsoft.Jet.OleDb.4.0;Data Source=" + Server.MapPath("~/cvbank.mdb") + "";
con.Open();
ds= new DataSet();
string sql="select * from cv";
da=new OleDbDataAdapter(sql,con);
da.Fill(ds,"cv");
}
void go(Object s, EventArgs e)
{
string sa=TextBox1.Text.Trim();
string pw=TextBox2.Text.Trim();
int r=0,r1=0;
DataRow []rs;
DataRow []rs1;
rs=ds.Tables["cv"].Select("email='"+sa+"'");
r=rs.Length;
rs1=ds.Tables["cv"].Select("pass='"+pw+"'");
r1=rs1.Length;
if(r>0 && r1>0)
{
Response.Redirect("account.aspx");
}
else
{
System.Web.UI.WebControls.Label lbl1=new System.Web.UI.WebControls.Label();
lbl1.ForeColor=System.Drawing.Color.Yellow;
lbl1.BackColor=System.Drawing.Color.Blue;
lbl1.Text="Please enter a valid user id and password";
ph1.Controls.Add(lbl1);
}
con.Close();
}
帐户的数据在窗体视图中调用.访问数据连接如下所示
And the data of Account is calling in Form View.With access data connection given below
<td><asp:AccessDataSource ID="AccessDataSource1" runat="server"
DataFile="~/cvbank.mdb"
SelectCommand="SELECT [email], [name], [pdob], [psex], [pstatus], [mob], [address], [ploc], [pnat], [eque], [eyear], [etype], [edur], [sind], [sjob], [scom], [sloc], [sdate], [sdur], [cobj] FROM [cv]"> </asp:AccessDataSource></td>
nd Form View given below
<pre lang="c#">
<td width="458"><asp:FormView ID="FormView1" runat="server" BackColor="#DEBA84"
BorderColor="#DEBA84" BorderStyle="None" BorderWidth="1px" CellPadding="3"
CellSpacing="2" DataKeyNames="email" DataSourceID="AccessDataSource1"
GridLines="Both" Width="511px">
<edititemtemplate> email:
<asp:Label ID="emailLabel1" runat="server" Text='<%# Eval("email") %>' />
<br />
name:
<asp:TextBox ID="nameTextBox" runat="server" Text='<%# Bind("name") %>' />
<br />
pdob:
<asp:TextBox ID="pdobTextBox" runat="server" Text='<%# Bind("pdob") %>' />
<br />
psex:
<asp:TextBox ID="psexTextBox" runat="server" Text='<%# Bind("psex") %>' />
<br />
pstatus:
<asp:TextBox ID="pstatusTextBox" runat="server" Text='<%# Bind("pstatus") %>' />
<br />
mob:
<asp:TextBox ID="mobTextBox" runat="server" Text='<%# Bind("mob") %>' />
<br />
address:
<asp:TextBox ID="addressTextBox" runat="server" Text='<%# Bind("address") %>' />
<br />
ploc:
<asp:TextBox ID="plocTextBox" runat="server" Text='<%# Bind("ploc") %>' />
<br />
pnat:
<asp:TextBox ID="pnatTextBox" runat="server" Text='<%# Bind("pnat") %>' />
<br />
eque:
<asp:TextBox ID="equeTextBox" runat="server" Text='<%# Bind("eque") %>' />
<br />
eyear:
<asp:TextBox ID="eyearTextBox" runat="server" Text='<%# Bind("eyear") %>' />
<br />
etype:
<asp:TextBox ID="etypeTextBox" runat="server" Text='<%# Bind("etype") %>' />
<br />
edur:
<asp:TextBox ID="edurTextBox" runat="server" Text='<%# Bind("edur") %>' />
<br />
sind:
<asp:TextBox ID="sindTextBox" runat="server" Text='<%# Bind("sind") %>' />
<br />
sjob:
<asp:TextBox ID="sjobTextBox" runat="server" Text='<%# Bind("sjob") %>' />
<br />
scom:
<asp:TextBox ID="scomTextBox" runat="server" Text='<%# Bind("scom") %>' />
<br />
sloc:
<asp:TextBox ID="slocTextBox" runat="server" Text='<%# Bind("sloc") %>' />
<br />
sdate:
<asp:TextBox ID="sdateTextBox" runat="server" Text='<%# Bind("sdate") %>' />
<br />
sdur:
<asp:TextBox ID="sdurTextBox" runat="server" Text='<%# Bind("sdur") %>' />
<br />
cobj:
<asp:TextBox ID="cobjTextBox" runat="server" Text='<%# Bind("cobj") %>' />
<br />
<asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True"
CommandName="Update" Text="Update" />
<asp:LinkButton ID="UpdateCancelButton" runat="server"
CausesValidation="False" CommandName="Cancel" Text="Cancel" /> </edititemtemplate>
<EditRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="White" />
<footerstyle BackColor="#F7DFB5" ForeColor="#8C4510" />
<headerstyle BackColor="#A55129" Font-Bold="True" ForeColor="White" />
<InsertItemTemplate> email:
<asp:TextBox ID="emailTextBox" runat="server" Text='<%# Bind("email") %>' />
<br />
name:
<asp:TextBox ID="nameTextBox0" runat="server" Text='<%# Bind("name") %>' />
<br />
pdob:
<asp:TextBox ID="pdobTextBox0" runat="server" Text='<%# Bind("pdob") %>' />
<br />
psex:
<asp:TextBox ID="psexTextBox0" runat="server" Text='<%# Bind("psex") %>' />
<br />
pstatus:
<asp:TextBox ID="pstatusTextBox0" runat="server"
Text='<%# Bind("pstatus") %>' />
<br />
mob:
<asp:TextBox ID="mobTextBox0" runat="server" Text='<%# Bind("mob") %>' />
<br />
address:
<asp:TextBox ID="addressTextBox0" runat="server"
Text='<%# Bind("address") %>' />
<br />
ploc:
<asp:TextBox ID="plocTextBox0" runat="server" Text='<%# Bind("ploc") %>' />
<br />
pnat:
<asp:TextBox ID="pnatTextBox0" runat="server" Text='<%# Bind("pnat") %>' />
<br />
eque:
<asp:TextBox ID="equeTextBox0" runat="server" Text='<%# Bind("eque") %>' />
<br />
eyear:
<asp:TextBox ID="eyearTextBox0" runat="server" Text='<%# Bind("eyear") %>' />
<br />
etype:
<asp:TextBox ID="etypeTextBox0" runat="server" Text='<%# Bind("etype") %>' />
<br />
edur:
<asp:TextBox ID="edurTextBox0" runat="server" Text='<%# Bind("edur") %>' />
<br />
sind:
<asp:TextBox ID="sindTextBox0" runat="server" Text='<%# Bind("sind") %>' />
<br />
sjob:
<asp:TextBox ID="sjobTextBox0" runat="server" Text='<%# Bind("sjob") %>' />
<br />
scom:
<asp:TextBox ID="scomTextBox0" runat="server" Text='<%# Bind("scom") %>' />
<br />
sloc:
<asp:TextBox ID="slocTextBox0" runat="server" Text='<%# Bind("sloc") %>' />
<br />
sdate:
<asp:TextBox ID="sdateTextBox0" runat="server" Text='<%# Bind("sdate") %>' />
<br />
sdur:
<asp:TextBox ID="sdurTextBox0" runat="server" Text='<%# Bind("sdur") %>' />
<br />
cobj:
<asp:TextBox ID="cobjTextBox0" runat="server" Text='<%# Bind("cobj") %>' />
<br />
<asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True"
CommandName="Insert" Text="Insert" />
<asp:LinkButton ID="InsertCancelButton" runat="server"
CausesValidation="False" CommandName="Cancel" Text="Cancel" /> </InsertItemTemplate>
<itemtemplate> Name -:
<asp:Label ID="nameLabel" runat="server" Text='<%# Bind("name") %>' />
<br />
<br />
Email ID -:
<asp:Label ID="emailLabel" runat="server" Text='<%# Eval("email") %>' />
DOB -:
<asp:Label ID="pdobLabel" runat="server" Text='<%# Bind("pdob") %>' />
<br />
<br />
Sex -:
<asp:Label ID="psexLabel" runat="server" Text='<%# Bind("psex") %>' />
Marital Status -:
<asp:Label ID="pstatusLabel" runat="server" Text='<%# Bind("pstatus") %>' />
<br />
<br />
Contact Number -:
<asp:Label ID="mobLabel" runat="server" Text='<%# Bind("mob") %>' />
<br />
<br />
Parmament Address -:
<asp:Label ID="addressLabel" runat="server" Text='<%# Bind("address") %>' />
<br />
<br />
City -:
<asp:Label ID="plocLabel" runat="server" Text='<%# Bind("ploc") %>' />
Country:
<asp:Label ID="pnatLabel" runat="server" Text='<%# Bind("pnat") %>' />
<br />
<br />
Career Objective -:
<asp:Label ID="cobjLabel" runat="server" Text='<%# Bind("cobj") %>' />
<br />
<br />
Heighest Qualification -:
<asp:Label ID="equeLabel" runat="server" Text='<%# Bind("eque") %>' />
<br />
<br />
Education Type -:
<asp:Label ID="etypeLabel" runat="server" Text='<%# Bind("etype") %>' />
<br />
<br />
Passing Year -:
<asp:Label ID="eyearLabel" runat="server" Text='<%# Bind("eyear") %>' />
<br />
<br />
Education Duration -:
<asp:Label ID="edurLabel" runat="server" Text='<%# Bind("edur") %>' />
<br />
<br />
Industry -:
<asp:Label ID="sindLabel" runat="server" Text='<%# Bind("sind") %>' />
Job Role -:
<asp:Label ID="sjobLabel" runat="server" Text='<%# Bind("sjob") %>' />
<br />
<br />
Company -:
<asp:Label ID="scomLabel" runat="server" Text='<%# Bind("scom") %>' />
<br />
<br />
Current Location -:
<asp:Label ID="slocLabel" runat="server" Text='<%# Bind("sloc") %>' />
<br />
<br />
Joining Date -:
<asp:Label ID="sdateLabel" runat="server" Text='<%# Bind("sdate") %>' />
Working Duration -:
<asp:Label ID="sdurLabel" runat="server" Text='<%# Bind("sdur") %>' />
<br />
<br />
</itemtemplate>
<pagerstyle ForeColor="#8C4510" HorizontalAlign="Center" />
<RowStyle BackColor="#FFF7E7" ForeColor="#8C4510" />
</asp:FormView></td>
推荐答案
尝试添加
con.Close();
con.Dispose();
到您的Page_Load方法的末尾.
to the end of your Page_Load method.
这篇关于错误-文件已在使用中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文