|
I wanted to upload my pdf files in MySQL and view from datagrid....
I have an error...This is the error..
"
Additional information: Could not find a part of the path 'C:\WSmfgIT\WSmfgIT\WSmfgIT\wsmfgit\wsmfgit\192.168.5.10\fbar\TOOLS\ProbingApps\ProbingSystem\workinstruction "
asp.net:
<asp:Button ID="btn_upload" runat="server" style="z-index: 1; left: 610px; top: 337px; position: absolute; height: 23px; width: 63px" Text="Upload" OnClick="btn_upload_Click" />
<div>
<asp:GridView ID="workinstruc" CssClass="Gridview" runat="server" AutoGenerateColumns="false" DataKeyNames="FileView" >
<HeaderStyle BackColor="#df5015" />
<Columns>
<asp:BoundField DataField="ID" HeaderText="ID" />
<asp:BoundField DataField="FileName" HeaderText="FileName" />
<asp:TemplateField HeaderText="FileView">
<ItemTemplate>
<asp:LinkButton ID="lnkView" runat="server" Text="View" ></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
c#:
<pre lang="cs">using System;
using System.Collections.Generic;
using System.Linq;
using System.IO;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Diagnostics;
using System.Windows.Forms;
using System.Data;
using MySql.Data.MySqlClient;
namespace wsmfgit
{
public partial class workinstruction : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
this.BindGrid();
}
}
private void BindGrid()
{
string constr = @"Data Source=192.168.8.124; Database=pmdb; User ID=client; Password=client";
using (MySqlConnection con = new MySqlConnection(constr))
{
using (MySqlCommand cmd = new MySqlCommand("SELECT ID, FileName, FileView FROM work_inst"))
{
using (MySqlDataAdapter sda = new MySqlDataAdapter())
{
cmd.Connection = con;
sda.SelectCommand = cmd;
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
workinstruc.DataSource = dt;
workinstruc.DataBind();
}
}
}
}
}
protected void imgbtn_home_Click(object sender, ImageClickEventArgs e)
{
Response.Redirect("default.aspx");
}
protected void btn_upload_Click(object sender, EventArgs e)
{
string constr = @"Data Source=192.168.8.124; Database=pmdb; User ID=client; Password=client";
using (MySqlConnection con = new MySqlConnection(constr))
{
string filename = Path.GetFileName(FileUpload1.PostedFile.FileName);
FileUpload1.SaveAs(Server.MapPath(@"\\192.168.5.10\fbar\TOOLS\ProbingApps\ProbingSystem\workinstruction\pdf" + filename));
con.Open();
MySqlCommand cmd = new MySqlCommand("insert into work_inst(FileName,FileView) values(@Name,@Path)");
cmd.Parameters.AddWithValue("@FileName", filename);
cmd.Parameters.AddWithValue(@"\\192.168.5.10\fbar\TOOLS\ProbingApps\ProbingSystem\workinstruction\pdf",filename);
cmd.ExecuteNonQuery();
Response.Write("Pdf File Save in Database");
con.Close();
BindGrid();
}
}
}
}
</pre>
This are my code...could anyone help me...
|
|
|
|
|
Well the error is quite clear - the path
C:\WSmfgIT\WSmfgIT\WSmfgIT\wsmfgit\wsmfgit\192.168.5.10\fbar\TOOLS\ProbingApps\ProbingSystem\workinstruction does not exist or the account that you are running this under does not have access to that folder.
For example, if you are running this on a server you won't have access to "C:\..." - Try using relative pathnames
Are you sure that the path is correctly constructed? The repeated sequence WSmfgIT\WSmfgIT\WSmfgIT\wsmfgit\wsmfgit looks as if something has gone wong
|
|
|
|
|
my actual path is this :
@"\\192.168.5.10\fbar\TOOLS\ProbingApps\ProbingSystem\workinstruction\pdf"
|
|
|
|
|
The reason you're having a problem is because you're using Server.MapPath along with mapping to a specific address. Do one, or the other, and not both.
|
|
|
|
|
this is my path
@"\\192.168.5.10\fbar\TOOLS\ProbingApps\ProbingSystem\workinstruction\pdf" so how should I declare it? can you pls help me..
|
|
|
|
|
Member 12016106 wrote: Server.MapPath(@"\\192.168.5.10\fbar\TOOLS\ProbingApps\ProbingSystem\workinstruction\pdf" + filename)
The Server.MapPath method expects a virtual path within the current application. It should look something like:
Server.MapPath("~/workinstruction/pdf/" + filename)
You've passed in a physical UNC path, which won't work.
If you want to save the file in the UNC path, don't use Server.MapPath :
FileUpload1.SaveAs(@"\\192.168.5.10\fbar\TOOLS\ProbingApps\ProbingSystem\workinstruction\pdf" + filename);
Member 12016106 wrote: cmd.Parameters.AddWithValue(@"\\192.168.5.10\fbar\TOOLS\ProbingApps\ProbingSystem\workinstruction\pdf", filename);
Your query doesn't have a parameter with the name \\192.168.5.10\fbar\TOOLS\ProbingApps\ProbingSystem\workinstruction\pdf . I suspect you meant to pass that as the path:
cmd.Parameters.AddWithValue("@Path", @"\\192.168.5.10\fbar\TOOLS\ProbingApps\ProbingSystem\workinstruction\pdf");
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I have try what you mentioned above but I still have an error...
this is the error:
An exception of type 'System.InvalidOperationException' occurred in MySql.Data.dll but was not handled in user code
Additional information: Connection must be valid and open.
c#:
using System;
using System.Collections.Generic;
using System.Linq;
using System.IO;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Diagnostics;
using System.Windows.Forms;
using System.Data;
using MySql.Data.MySqlClient;
namespace wsmfgit
{
public partial class workinstruction : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
this.BindGrid();
}
}
private void BindGrid()
{
string constr = @"Data Source=192.168.8.124; Database=pmdb; User ID=client; Password=client";
using (MySqlConnection con = new MySqlConnection(constr))
{
using (MySqlCommand cmd = new MySqlCommand("SELECT ID, FileName, FileView FROM work_inst"))
{
using (MySqlDataAdapter sda = new MySqlDataAdapter())
{
cmd.Connection = con;
sda.SelectCommand = cmd;
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
workinstruc.DataSource = dt;
workinstruc.DataBind();
}
}
}
}
}
protected void imgbtn_home_Click(object sender, ImageClickEventArgs e)
{
Response.Redirect("default.aspx");
}
protected void btn_upload_Click(object sender, EventArgs e)
{
string constr = @"Data Source=192.168.8.124; Database=pmdb; User ID=client; Password=client";
using (MySqlConnection con = new MySqlConnection(constr))
{
string filename = Path.GetFileName(FileUpload1.PostedFile.FileName);
FileUpload1.SaveAs(@"\\192.168.5.10\fbar\TOOLS\ProbingApps\ProbingSystem\workinstruction\pdf" + filename);
con.Open();
MySqlCommand cmd = new MySqlCommand("insert into work_inst(FileName,FileView) values(@Name,@Path)");
cmd.Parameters.AddWithValue("@FileName", filename);
cmd.Parameters.AddWithValue("@Path", @"\\192.168.5.10\fbar\TOOLS\ProbingApps\ProbingSystem\workinstruction\pdf");
cmd.ExecuteNonQuery();
Response.Write("Pdf File Save in Database");
con.Close();
BindGrid();
}
}
}
}
|
|
|
|
|
In your btn_upload_Click method, you've not set the command's connection property.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Thank You soo much for your kind explanation..
I got the answer..
|
|
|
|
|
I am developing a instructional aids for school, that should be able to lock student windows tab to one app, and he cannot access other app. This locking is on request sent by server, and the lock/unlock action should be performed in a timely basis.
I have looked into "assigned access", but it seems not suitable, because it require a special user account, and need a reboot to enter the mode.
Do you have any idea or direction to handle this?
Target platform is Windows 10.
|
|
|
|
|
Windows doesn't support this because, well, it's a shared system running many applications at once.
The only way I know of is that you'd have to install an application on the target machines that, on command, installs a global keyboard hook to catch and eat Alt-Tab, Ctrl-Esc and Ctrl-Shift-Esc. You'd also have to set the policy on the machines that prevent users from running Task Manager.
|
|
|
|
|
Have you examine the possibilities of using "kiosk mode" ? There are resources here on CP: [^].
«I want to stay as close to the edge as I can without going over. Out on the edge you see all kinds of things you can't see from the center» Kurt Vonnegut.
|
|
|
|
|
I just cannot seem to figure this out. It is more IDE/XAML question, I realize. I tried
<GridViewColumn x:Name="GridViewColumnTotal" Header="Total"
DisplayMemberBinding="{Binding Total}"
Width="100"
TextBlock.TextAlignment="Right"
TextBlock.FontWeight="ExtraBold"/>
the column is neither bold or Right aligned
Can someone point me to an example on how to do this?
thanks!
|
|
|
|
|
Use the correct forum:
Silverlight/WPF[^]
"Fairy tales do not tell children the dragons exist. Children already know that dragons exist. Fairy tales tell children the dragons can be killed."
- G.K. Chesterton
|
|
|
|
|
I may be off-base as I'm currently learning XAML myself ... but it looks like there is a "layer" missing from the tree... maybe
<GridViewColumn x:Name="GridViewColumnTotal" Header="Total" Width="100">
<GridViewColumn.CellTemplate>
<DataTemplate>
<TextBlock Text="{Binding Total}" TextAlignment="Right" FontWeight="ExtraBold"/>
</DataTemplate>
</GridViewColumn.CellTemplate>
</GridViewColumn> (Not tested!)
modified 8-Oct-15 12:19pm.
|
|
|
|
|
Thanks for the reply. I have a problem that I get an error on the line:
<GridViewColumn.CellTemplate> The error is "An attribute name is missing"
Gawd! This user interface stuff is more complicated than writing an algorithm!
modified 8-Oct-15 12:17pm.
|
|
|
|
|
I edited your response as the code line wasn't showing.
I also missed a closing > from my post - I've edited it
|
|
|
|
|
Wow!, that fixed the bold issue perfectly, big thanks!
Now, I just need to figure out why right alignment is not working...
Really, thanks!
|
|
|
|
|
Cool! I'm obviously getting better with WPF
For the alignment have a look at this post[^]
|
|
|
|
|
I wanted to give alert message when the search result is invalid....
I have a code but its not working. Could anyone help me?
protected void btn_search_Click(object sender, EventArgs e)
{
lstbox_clotho.Items.Clear();
string search=txtbox_clotho.Text;
if (txtbox_clotho.Text != "")
{
string[] licfiles = Directory.GetFiles(@"\\192.168.5.10\fbar\TOOLS\ProbingApps\ProbingSystem\Clotho_License", "*" + txtbox_clotho.Text + "*.lic", SearchOption.AllDirectories);
foreach (string file in licfiles)
{
lstbox_clotho.Items.Add(new ListItem(Path.GetFileName(file), file));
}
{
txtbox_clotho.Text = "";
}
else
{
Response.Write("<script>alert('For this Wafer ID Report is Not Generated');</script>");
}
}
}
|
|
|
|
|
You must be more specific than, "it's not working."
What is it doing wrong? Is there an error message? If yes, what's the message and on what line of code does it happen?
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
|
There is no error. It is not showing any messages..
|
|
|
|
|
Show the entire HTML document as it is passed to the client.
You do know that you can't just send that script snippet as the whole document, right?
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
|
using System;
using System.IO;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Collections;
namespace wsmfgit
{
/// <display files in listbox from directory>
public partial class downloadsoftware : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//Directory.CreateDirectory("C:\\DesktopCopyTemp");
DirectoryInfo info = new DirectoryInfo(@"\\192.168.5.10\fbar\TOOLS\ProbingApps\ProbingSystem\DesktopCopyTemp");
FileInfo[] Files = info.GetFiles("*.*");
foreach (FileInfo file in Files)
{
ListBox1.Items.Add(file.Name);
}
}
///</display>
/// <link to home button>
protected void imgbtn_home_Click(object sender, ImageClickEventArgs e)
{
Response.Redirect("default.aspx");
}
///</link>
///<software download button1>
protected void btn_dwn_Click(object sender, EventArgs e)
{
string File = ListBox1.SelectedValue;
Response.ContentType = ContentType;
Response.AppendHeader("Content-Disposition", "attachment; filename=" + Path.GetFileName(File));
Response.End();
}
/// </software>
protected void btn_search_Click(object sender, EventArgs e)
{
lstbox_clotho.Items.Clear();
string search=txtbox_clotho.Text;
if (txtbox_clotho.Text != "")
{
string[] licfiles = Directory.GetFiles(@"\\192.168.5.10\fbar\TOOLS\ProbingApps\ProbingSystem\Clotho_License", "*" + txtbox_clotho.Text + "*.lic", SearchOption.AllDirectories);
foreach (string file in licfiles)
{
lstbox_clotho.Items.Add(new ListItem(Path.GetFileName(file), file));
}
{
txtbox_clotho.Text = "";
}
}
}
protected void imgbtn_dwn_Click(object sender, ImageClickEventArgs e)
{
string licfiles = lstbox_clotho.SelectedValue;
Response.ContentType = ContentType;
Response.AppendHeader("Content-Disposition", "attachment; filename=" + Path.GetFileName(licfiles));
Response.TransmitFile(Server.MapPath(@"C:\Avago.ATF.Common\License" + "licfiles"));
Response.End();
}
}
}
This is my c# code:
<asp:ListBox ID="ListBox1" runat="server" style="z-index: 1; left: 406px; top: 311px; position: absolute; width: 339px; height: 163px; margin-left: 3px; margin-top: 0px" BackColor="White" Font-Bold="True" ForeColor="#000066" ></asp:ListBox>
gt;
<asp:Button ID="btn_dwn" runat="server" OnClick="btn_dwn_Click" style="z-index: 1; left: 657px; top: 443px; position: absolute; height: 31px; width: 90px;" Text="Download" BackColor="#000066" BorderColor="#CCCCCC" BorderStyle="Groove" Font-Size="Medium" ForeColor="White" />
<asp:Panel ID="Panel2" runat="server" GroupingText="CLOTHO LICENSE" style="z-index: 1; left: 401px; top: 539px; position: absolute; height: 220px; width: 359px; right: 146px" ForeColor="#000066">
<br />
<br />
<asp:TextBox ID="txtbox_clotho" placeholder="Search by Mac Address" runat="server" Height="21px" style="margin-left: 45px" Width="217px" BorderColor="#333333" BorderStyle="Solid" ></asp:TextBox>
<br />
<asp:Button ID="btn_search" runat="server" BackColor="#006699" BorderColor="Black" BorderStyle="Groove" Font-Bold="True" Font-Size="Medium" ForeColor="White" OnClick="btn_search_Click" style="z-index: 1; left: 279px; top: 58px; position: absolute; height: 30px; width: 74px" Text="Search" />
<br />
<br />
<asp:ListBox ID="lstbox_clotho" runat="server" Height="81px" style="margin-left: 47px" Width="245px" ></asp:ListBox>
<asp:ImageButton ID="imgbtn_dwn" runat="server" ImageUrl="~/images/download.png" Height="49px" Width="50px" OnClick="imgbtn_dwn_Click" />
<br />
<br />
this is my asp.net code:
I want to show alert message when the search result invalid..
|
|
|
|
|
Many problems! Let me dissect and show them to you:
First of all, why did you create a variable to hold the text, when you are again going to use the same object's Text property?
string search=txtbox_clotho.Text;
if (txtbox_clotho.Text != "")
Either remove the variable, or use the variable here. Tip: Remove the variable.
Secondly, if you have a look at the block where your alert-dialog's code is present?
else
{
Response.Write("<script>alert('For this Wafer ID Report is Not Generated');</script>");
}
How would you expected it execute when your condition is so wrong? "if (txtbox_clotho.Text != "") ". The condition tells that the script would only be written, if the search term is empty; not invalid. Also, it doesn't work with the search result, it is applied to the search term (if I understand correctly).
Solution to this is, to re-write the code. Who wrote the code, so back? Where he was creating extra scopes (inside the if block), writing an entirely opposite condition and implement a very bad design, writing the script based on a Response.Write is always recommended not to be done. The code seriously needs some rewriting.
Explain the scenario, we can help you put some effort in it.
The sh*t I complain about
It's like there ain't a cloud in the sky and it's raining out - Eminem
~! Firewall !~
|
|
|
|