my form is having a label and a button, assume that you opened my website in ur system through url and now when u click the button it has to read a text file from the specified path in ur machine and display the data in label. i mean whatever machine is running my program it has to read the data from specific path from current running client machine.
View 1 RepliesHow to set the path to read the file which is in remote machine and display it in TEXTBOX in web browser.
View 2 RepliesI have developed an application where I need to create a page to read data from Excel File and then update it to the database. The code that I wrote works only when the application runs from my machine. When I deployed the application to the server it gave an error- 'C:PRFileIimport_File.xls' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. here is mu code -
protected void InsertData(object sender, EventArgs e)
{
OleDbConnection oConn = new OleDbConnection
(@"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\PuertoRicoFile\Puertorico_Iimport_File.xls ; Extended Properties=Excel 8.0 ");
OleDbCommand oCmd = new OleDbCommand("select * from [Puertorico_Data$]", oConn);
oConn.Open(); //Here [Puertorico_Data$] is the name of the sheet in the Excel file where the data is present
OleDbDataReader oleDbReader = oCmd.ExecuteReader();
string AgentIP = "";
string TagName = "";
string Status = "";
string Severity = "";
int EventCount = 0;
string EarliestEvent = "";
string LatestEvent = "";
while (oleDbReader.Read())
{
AgentIP = (string)oleDbReader[0]; // valid(oleDbReader, 0);//Here we are calling the valid method
TagName = (string)oleDbReader[1]; //valid(oleDbReader, 1);
Status = (string)oleDbReader[2]; //valid(oleDbReader, 2);
Severity = (string)oleDbReader[3]; //valid(oleDbReader, 3);
EventCount = Convert.ToInt32(oleDbReader[4]); //oleDbReader[0]; //valid(oleDbReader, 4);
EarliestEvent = (string)oleDbReader[8]; //validate(oleDbReader, 8);
EarliestEvent = EarliestEvent.Substring(0, 19);
LatestEvent = (string)oleDbReader[9]; //validate(oleDbReader, 9);
LatestEvent = EarliestEvent.Substring(0, 19);
InsertDataIntoSql(AgentIP, TagName, Status, Severity, EventCount, EarliestEvent, LatestEvent);
}
SqlConnection mySQLconnection = new SqlConnection(ConfigurationManager.ConnectionStrings["IssNetworkReportingSystemConnString"].ConnectionString);
mySQLconnection.Open();
SqlCommand cmdSql = new SqlCommand("AddMonth_Event_TotalInfo_for_Puertorico", mySQLconnection);
cmdSql.CommandType = CommandType.StoredProcedure;
dbReader = cmdSql.ExecuteReader();
dbReader.Close();
cmdSql = new SqlCommand("AddQtr_Event_TotalInfo_for_Puertorico", mySQLconnection);
cmdSql.CommandType = CommandType.StoredProcedure;
dbReader = cmdSql.ExecuteReader();
dbReader.Close();
oConn.Close();
lblMsg.Text = "Data Imported Sucessfully";
lblMsg.ForeColor = System.Drawing.Color.Green;
}
public void InsertDataIntoSql(string agentIP, string tagName,
string Stat,string severity,int eventCount, string eEvent, string lEvent)
{//inserting data into the Sql Server
SqlConnection mySQLconnection = new SqlConnection(ConfigurationManager.ConnectionStrings["IssNetworkReportingSystemConnString"].ConnectionString);
mySQLconnection.Open();
SqlCommand sqlSelect = new SqlCommand("SELECT SeverityID from Severity where SeverityDesc=@SeverityDesc",mySQLconnection);
sqlSelect.CommandType = CommandType.Text;
sqlSelect.Parameters.Add("@SeverityDesc", SqlDbType.NVarChar).Value = severity;
dbReader = sqlSelect.ExecuteReader();
int severityId = Convert.ToInt32(dbReader.Read());
dbReader.Close();
SqlCommand sqlInsert = new SqlCommand("Insert into IdsData_Puertorico(AgentIP,TagName,Status,SeverityID,EventCount,EarliestEvent,LatestEvent)" +
" values (@AgentIP,@TagName,@Status,@SeverityID,@EventCount,@EarliestEvent,@LatestEvent )" ,mySQLconnection);
sqlInsert.CommandTimeout = 0; //timeout unlimited
sqlInsert.CommandType = CommandType.Text;
sqlInsert.Parameters.Add("@AgentIP", SqlDbType.NVarChar).Value = agentIP;
sqlInsert.Parameters.Add("@TagName", SqlDbType.NVarChar).Value = tagName;
sqlInsert.Parameters.Add("@Status", SqlDbType.NVarChar).Value = Stat;
sqlInsert.Parameters.Add("@SeverityID", SqlDbType.Int).Value = Convert.ToInt32(severityId);
sqlInsert.Parameters.Add("@EventCount", SqlDbType.Int).Value = Convert.ToInt32(eventCount);
sqlInsert.Parameters.Add("@EarliestEvent", SqlDbType.DateTime).Value = DateTime.Parse(eEvent);
sqlInsert.Parameters.Add("@LatestEvent", SqlDbType.DateTime).Value = DateTime.Parse(lEvent);
sqlInsert.CommandType = CommandType.Text;
sqlInsert.ExecuteNonQuery();
mySQLconnection.Close();
}
My site contain dynamic default page that consist of webparts.When i run my project on local server in my web browser msg gets display page isn't redircted properly.
View 7 Replies1. ASP.Net WEB server.
2. I have PC, on which file to copy to device is located, with Active Sync installed and IE running which has a page in that IE has rendered by server #1.
3. I have a DEVICE connected to desktop #2 via AS.
I would like to copy file from a local machine to the device which is connected to this machine. My application is located in a webserver.
I've created a new ASP.NET Dynamic Data website and have used LINQ-to-SQL for the framework. I start up the application and it displays my tables fine and I can browse them - but it doesn't give me any create/update/delete abilities - all I can do is read? I didn't change anything from the defaults - what gives?
View 1 RepliesHow read data form from other website by asp.net 2.0? I would to read some data from other website.
View 9 RepliesI basically want to transfer a file from the client to the file storage server without actual login to the server so that the client cannot access the storage location on the server directly. I can do this only if i manually login to the storage server through windows login. I dont want to do that. This is a Web-Based Application.
protected void Button1_Click(object sender, EventArgs e)
{
filePath = FileUpload1.FileName;
try
{
WebClient client = new WebClient();
NetworkCredential nc = new NetworkCredential(uName, password);
Uri addy = new Uri("\\192.168.1.3\upload\");
[code]...
I have some shell scripts on a Windows 2003 server. These scripts process some flat files and upload data to Oracle using sqlldr. Currently I'm using telnet to go into the box and run each of these scripts manually. Is there a way that these scripts can be run from a ASP.Net/Winforms application?
View 1 RepliesI'm pretty new in the world of ASP.Net, but not on developing in general. I created a webservice which read data from a SQl-database. This works fine. Now I want to create a customer website which uses the webservice to read those data. I need to do this periodically, say every 10 seconds.
The profiler on the database and debugging the website tells me that the values are read good, even is they are changed in de database. But, I need to display those values on a label, but this won't work, only with a meta-refresh every 10 seconds.Is there a way to use a timer and refreshes labels ?
When I run my application I got this error
Server Error in '/POD/POMLNT' Application.
Runtime Error
Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.
Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
<customErrors mode="Off"/>
</system.web>
</configuration>
Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
<customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>
</system.web>
</configuration>
What is it means , and how can i fix it ?
I am working on an application to read event logs on a remote machine. I tried adding this to the web.config
<identity impersonate="true" user="domainuser" password="password" />
However, when I ran this, I got the following error:
Could not create Windows user token from the credentials specified in the config file. Error from the operating system 'Logon failure: unknown user name or bad password.
I looked at this post
[URL]
It seemed to suggest I would need to create a new account on the remote server. Is there a way I can just use an existing domain account?
My client gave me this web solution, in it various projects, and the problematic project (for me) is the Web Site.
I've copied the code to test web server (2008) and installed VS 2008 so I could step through the code on the server due to some weirdness.
Anyhow, when I open the solution locally on my personal computer, it runs on Cassini [URL] because I'm not on a server OS. However, when I run the app on the web server, when I hit F5, it runs oh [URL].
When I'm running the code on the server, how do I point the web site to use Cassini?
I have a new development machine running windows 7 professional 64 bit. On loading up a website project Im getting this error
'The Web Application Project 'websitename' is configured to use IIS. To access local IIS websites, you must install IIS components:
IIS 6 Metabase and IIS 6 Configuration Compatibilty
ASP.net
Windows Authentication
In addition you must run Visual Studio in the context of an administrator account
As far as Im aware, I am an administrator of my own pc and I have the .net framework installed.
I am trying to access a wcf service hosted on a server running on a virtual machine on a windows 2008 R2 hyperv. When i access this service when running my asp.net website through code everything works fine how ever when i deploy the application on the local IIS , in the deployed mode i am getting an securityaccessdeined exception. My Asp.net app is running on a IIS server on another virtual machine. The stack trace is as given below :
Environment Info: My asp.net app has built on .NET 4.0 framework using VS2010. My WCF services are based on .NET2.0 framework.
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 14-07-2010 13:56:54
Event time (UTC): 14-07-2010 08:26:54
Event ID: dd1986e7e7dc4473beb908754c75a580
Event sequence: 4
Event occurrence: 1
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/ROOT/StratosTest-1-129235696025728041
Trust level: Full
Application Virtual Path: /StratosTest
Application Path: C:inetpubwwwrootStratosTest
Machine name: MC-NEWCODE
Process information:
Process ID: 1752
Process name: w3wp.exe
Account name: IIS APPPOOLASP.NET v4.0 Classic
Exception information:
Exception type: SecurityAccessDeniedException
Exception message: Access is denied.
Server stack trace:
at System.ServiceModel.Channels.ServiceChannel.ThrowIfFaultUnderstood(Message reply, MessageFault fault, String action, MessageVersion version, FaultConverter faultConverter)
at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)
at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at VMMService.IVirtualMachineManagementService.GetAllVirtualMachines()
at Default2.Page_Load(Object sender, EventArgs e)
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Request information:
Request URL: http://localhost/StratosTest/Dashboard.aspx
Request path: /StratosTest/Dashboard.aspx
User host address: ::1
User:
Is authenticated: False
Authentication Type:
Thread account name: IIS APPPOOLASP.NET v4.0 Classic
Thread information:
Thread ID: 4
Thread account name: IIS APPPOOLASP.NET v4.0 Classic
Is impersonating: False
Stack trace: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at VMMService.IVirtualMachineManagementService.GetAllVirtualMachines()
at Default2.Page_Load(Object sender, EventArgs e)
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Custom event details:
Dim sWindowUser As String = ""sWindowUser = ExtractPureUsername(WindowsIdentity.GetCurrent().Name)
and
sWindowUser = ExtractPureUsername(HttpContext.Current.Request.ServerVariables("AUTH_USER"))
It ran properly in my development environment and I deployed it onto my 2008 server. The web site keep promoting me for user windows username and password. I entered my username & password but the site keep prompting me over and over again.
In server side I didn't the Local Machine name.
I would like ask you for some ideas how can I write mechanism that will be automatically read files from folder. I don't know how to schedule the write task. I want to check for new file everyday and if the new file is in the folder read it.
View 2 Repliesi am having my text file data as follows
101011111111101111111111007060540A0941
I would like read this data and place it to the Corresponding cell in data grid.
I am reading data from Excel file using oledbdataadapter and binding to gridview.Every thing working fine.but if the cell is having some text along with bar sysmol ( | ) [Ex : 12345 | 789123] that cell data is not reading from excel file.All fileds in excel sheet is text format only.Some times it's reading correctly & some times it not reading(empty).Is there any problem with bar symbol ( | )
View 1 RepliesMr requirement is i am uploading a .txt file and read that .txt file and bind that data to ASP.NET Gridview control. My .txt file is look like below:
% Compressor type: GT12 C224(38) 55 Trim 0.38 A/R
% Turbine type: GT12 T202(35.5) 72 Trim 0.39 A/R
% Initial data file name:20050669-02.cdt
% Polar inertia: [kg.m2]
% Comment:DATA REDUCTION CODE REV 2.04 RELEASE 03-OCT-2004 (REFERENCE: REPORT 99-0145. REPORT 03-0901. TI-056)
% P reference: 100000Pa - T reference: 298 K
% NC WC PRC ETAC
% RPM KG/S T-T ----
115030.5714 0.0170 1.3398 0.5698
115030.5714 0.0239 1.3209 0.6155
115030.5714 0.0291 1.3020 0.6282
115030.5714 0.0339 1.2822 0.6377
115030.5714 0.0380 1.2576 0.6209
115030.5714 0.0416 1.2311 0.5955
134956.4286 0.0405 1.4045 0.6852
How to read this file and bind data to gridview control.
Right now i am using the following code but it stores whole data in a single column and a single row but i need it in four columns named NC, WC, PRC,ETAC and it's values in respected columns.
Code:
protected void Button1_Click(object sender, EventArgs e)
{
String ext = System.IO.Path.GetExtension(FileUpload1.FileName).ToUpper();
if (ext == ".TXT")
{
String content = System.Text.Encoding.ASCII.GetString(FileUpload1.FileBytes);
String[] ar = content.Split(';');
GridView1.DataSource = ar;
GridView1.DataBind();
}
}
how to get data in four columns in Gridview as a tabular format. I am using technologies Visual Studio 2005, ASP.NET 2.0,C#.NET 2.0 and Windows Xp Operating system.
I have a Stored Procedure
Create procedure selectdata
as
begin
select * from Employee
end
In my front End I Created a Button in default.aspx page
<asp:Button id="btnsave" runat="server" Text="Send to Excel" onclick="btnsave_Click"/> <asp:GridView id="gv" runat="server" > </asp:GridView>
In default.aspx.cs
protected void btnsave_Click(object sender, EventArgs e) {
SqlConnection conn = new SqlConnection();
conn.ConnectionString="User id=aa; password=123; Initial Catalog=abc;Integrated Security=xxxx";
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
[Code].....
Output: It Displays the Data in Grid View but is it possible to store the Data directly in Excel file in my PC
I all of a sudden strated getting the following error when running my website. Can anyone tell me how to fix? I am using VWD 2008 with .net 3.5.
Compilation Error
description:
[Code]....
Source File: vbc : Command line Line: 0
Show Detailed Compiler Output:
[Code]....
Version Information:
Microsoft .NET Framework Version:2.0.50727.3082; ASP.NET Version:2.0.50727.3082 An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.
Compiler Error Message: BC2017: could not find library
'C:WINDOWSassemblyGAC_32System.EnterpriseServices2.0.0.0__b03f5f7f11d50a3aSystem.EnterpriseServices.dll'
Source Error:
This is a general ASP.NET question. I have an asp.net site that is hosted on domain A. The site works fine and uses a session when user login. I have a new empty site on domain B (different server). I tried to load the same site on domain B by calling it in an HTML IFrame site load and works but it seems that user con not login, after some experiments I think his is related to the session not working. Can I run the site on an IFrame? Sessions should work?
View 4 RepliesI'm using VS2010 and need to give my remote server asp .net account (IUSR_istereos) access to my local intpub folder
how do I do that?
I used PopupControl Extender to display row details from a gridview, and need to update the two textboxes, but the changed value in the textboxes did not get picked up when click the update button on the popup window, so I need to get client side javascript to read the new changed value from these text boxes. However, I tried a few way, none worked for me, not sure what is wrong.
1. Add a javascript function in the .aspx file and use onclientclick of the linkbutton control to call the function, I got error of "Microsoft JScript runtime error: Object required".
<script language="javascript" type="text/javascript">
function newTextValue(textbox)
{
var text = document.getElementById("TextBox1").Value;
alert(text);
}
</script)
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("GalleryTemplateName") %>' Height="20px" Width="230px"
style="text-align: left"></asp:TextBox>
<asp:LinkButton ID="LinkButton2" runat="server" Font-Bold="True" CommandArgument='<%# Eval("GalleryTemplateId") %>'
oncommand="LinkButton2_Click" OnClientClick="newTextValue(this)" >Update</asp:LinkButton>
2. Use ScriptManager.RegisterClientScriptBlock in the aspx.cs file, :
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "changevalue", "alert(document.getElementById('TextBox1').value);", true);
but the alert window did not showup, that means the client javascript did not run? I just use an alert window to test to see if the textbox value is picked up. Note, I used Ajax Toolkit PopupControl Extender, all codes are in an update panel.