I'm a asp.net newbie trying to figure out how to do the following. I have a datatable. I want to extract the first row and perform a certain operation and a different operation on the remaining rows. How would I loop through the datatable to do this?
View 5 RepliesI need to dispay confirm box on server Side.. senario is like Im Trying To upload Image During Upload Im Checking some properties like Image type,image size, etc.. While Uploading i want to check properties like
if(type=="xxxx")
{
confirmbox("Â ");
if(confirmvalue=="yes")
{
next condition
}
else
{
exit ;
}
}
like this i want check different properies of file.. how can i do this
I have a function that finds a files MIME type for download purposes. I use this DllImport:
Code:
[DllImport("urlmon.dll", CharSet = CharSet.Unicode, ExactSpelling = true, SetLastError = false)]
static extern int FindMimeFromData(IntPtr pBC,
[MarshalAs(UnmanagedType.LPWStr)] string pwzUrl,
[MarshalAs(UnmanagedType.LPArray, ArraySubType = UnmanagedType.I1, SizeParamIndex = 3)] byte[] pBuffer,
int cbSize,
[MarshalAs(UnmanagedType.LPWStr)] string pwzMimeProposed,
int dwMimeFlags,
out IntPtr ppwzMimeOut,
int dwReserved);
I use this function:
Code:
#region GetMimeFromFile(string)
public static string GetMimeFromFile(string file)
{
IntPtr mimeout;
if (!File.Exists(file))
{
throw new FileNotFoundException(file + " not found.");
} //if
int maxContent = (int)new FileInfo(file).Length;
if (maxContent > 4096)
{
maxContent = 4096;
} //if
byte[] buff = new byte[maxContent];
using (FileStream fs = new FileStream(file, FileMode.Open))
{
fs.Read(buff, 0, maxContent);
} //using
int result = FindMimeFromData(IntPtr.Zero, file, buff, maxContent, null, 0, out mimeout, 0);
string mime = Marshal.PtrToStringUni(mimeout);
Marshal.FreeCoTaskMem(mimeout);
return mime;
}
#endregion
Locally, it runs fine. However, when I put it on a GoDaddy server, I get the error:
"The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file. "
My stracktrace points to line 256, which is the ending french bracket of my GetMimiFromFile function.
I need to perform update operation in a datatable without using loops. Is there any way to perform update in a datatabel...
View 3 RepliesI use dynamic currency symbol(Doller,£,etc.,) for that the web config is updated in locally but in site I can not modifiy the web config file and I get the following error
"Attempted to perform an unauthorized operation."
I have a website in asp.net 2.0 which write some thing on a file. But at the same time if another user hit that site it does not work till the first one operation on the file completed after that second one can do operation with the files.
AppConfiguration appConfiguration = new AppConfiguration();
string LogFile =String.Empty;
string sLogFormat =string.Empty;
string sErrorTime =string.Empty;
[Code]....
In My Project We Filter Dataview Which Contail Integer and string value
sort data likes this
dvv.RowFilter = filterfor + " Like " + SearchExpression;
but when integer value is encounter Error occurredÂ
Cannot perform 'like' operation on system.int64 and system.string
i have an dll file which is data access layer of my application.
i am getting this exception while accessing databse
Description:
The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission contact your system administrator or change the application's trust level in the configuration file.
Exception Details:
System.Security.SecurityException: Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
Error:Â
Security Exception
Description: The application attempted to perform an operation not allowed by the security policy.  To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file. Exception Details: System.Security.SecurityException: Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.Local its run fine. when i place in iis. it throw this exception.
in my case, It is the windows service which in running the long running insert/update on a table and I need to cancel the operation from my ASP.NET application. In the above link Burnsys suggests that one should kill the Sql server session. Is that really only way and a goood practice to do this? Also, in the same poset can use SqlCommand.Cancel to cancel. However, I am not sure how can I cancel the command from the windows service from ASP.NET application.
View 1 RepliesI want to extract data from pdf form to sql server database. But I don't know how do achieve it?
View 1 RepliesI am having one column named Location in My MS SQL 2008 Database and the values in the Column is like "Region/State/City" region, city and states are saperated by forward slash.
In that column some times City is given and somtime it is not provided means only Region and state.
Now, i need to extract that Region, state and city from one column to a view and in view there should be three columns State ,City and region.
I have tried the SUBString but it works on no. of characters but for different city and regions the no.
One of the fields in a table stores a long article. I just want to extract the beginnig part of it; could be any portion of it, like first one or two or three paragraphs. The vb code shows below:
Imports System.Data.SqlClient
Partial Class _Default
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Try
[Code]....
I really don't want the whole article displaying in the literalBrief. A few paragraphs from that article would be good enough. Is it possible to achieve that? At SQL level, or in VB coding, something like substring function?
hen i run a Pivot query, i receive this error. It looks not harmfull, because query executed successfully and the results arepartially ok. But for some columns, i get NULL values surprisingly. Because i have carefully checked all data in the source for the null values. All NULL values converted to ZERO, so there is no reeason for such error.I do not understand why this error for?
View 3 RepliesI am uploading pdf file... if I click upload.. I will check the pdf file .. PDF file page size .... should show message size checked or else invalid size  if it successful size then it will check landscape or portrait.. and so on operation... but while checking the pdf file i want to show message to client  this operation is going like.. progress bar..
View 1 RepliesI can get my records from my database between days with this query.
[Code]....
but i need filter data between hours..
I want to extract emails that are currently being sent to an exchange Server. I want to extract the emails and then take some actions based on their content.
View 7 RepliesI have a webform which uses a gridview control to show result of a search operation.I wanna to take advantage of using pagination in the webform. But as you all know, gridview pagination is a client-side pagination and it transfers all records have been selected to the client. What I mean by client-side pagination is the client (page) shows records page by page but every time the user clicks on a page link to navigate through records, all the records are selected from Data Source.How can I use gridView with datapager in order to have a server side pagination? Or any other solution to get records page by page by configuring our query?
View 1 RepliesI have created an web based application through which the users can change the server (where the web application is hosted) IPAddress.The problem is that, once i have changed the IPAddress to a new IPAddress, Response.Redirect("MyHome.aspx") is not working any more. I have also tried to redirect the user to the newly updated address but even it doesn't do the trick. No page found message appears after some time.For example: The url while the web application runs in IIS is : http://192.168.0.65/WebDemo/Default.aspx after changing the IPAddress to 192.168.0.66 and redirecting it with the Response.Redirect() method the http://192.168.0.65 is not accessible.Any idea of achieving this task of changing IPAddress of the server and doing an automatic redirect to the newly assigned IPAddress,
View 2 RepliesI have a function which performs a series of time-consuming operations which include querying a large database, customising an excel file and sending an email with a 5MB attachment.
I would like to excute this function in the background, when a button is clicked, and immediately redirect the user to another aspx page. The user should be free to browse to other pages or even close the browser when the background operation is still running on the server. I have tried to implement threading but could not get it to work. The email with attachment does not get sent even though there are no errors.
I have a package which imports several files on a regular bases . For the import I use a staging table. Now I want to split that stagingtable into two other (existing) tables with keeping the relation ( third table??) . In each record there is a dealerID which has to be injected also in the other two tables (the splittables).
How can I use a conditional split to extract the right columns to the right table? I only see that i can enter a expression for each column, but in fact i only want to split the table by "fingerpointing" the right columns. is that possible? And how should i put the relation between them in 'relation' table?
This is my aspx pages button properties:
<asp:Button runat="server" ID="cmdConfirm" Text="Select
Customer"
ValidationGroup="ValidateId" Height="26px" onclick="cmdSave_Click"/
Now on my Page_Load I have:
protected void Page_Load(object sender, System.EventArgs
e)
{
Name = Request.QueryString[0];
LoadCustomer();
cmdConfirm.Attributes.Add("onClick", "update("
+ Name + ");");
Conn.Close();
}
This is my button click for Select Customer button.
protected void cmdSave_Click(object sender, EventArgs
e)
{
RecordChanges();
}
Now I must run cmdSave_Click() before the cmdConfirm.Attributes.Add even though both is for same button anyway. I know that client side script will try to run first but I must run the cmdSave_Click event first to save the data. Aftre that cmdConfirm.Attributes will send the Name to the next page using a Javascript function where the stored values(stored using cmdSave_Click) will be used. I have no other choice. I cannot run the Javascript function first as it will happen before the data is stored. And also I cannot use another page as all has to be performed in one page so that user will not have to click Save twice. Can anyone tell me How I can delay the cmdConfirm.Attributes.Add until the cmdSave_Click is performed.
In below link
http://www.asp.net/ajaxlibrary/act_faq.ashx it has been mentioned that "Also, the ToolkitScriptManager performs automatic script combining on the server."
I have a file delete option for the files uploaded by the user, user can upload many files at a time.The uploaded files will be stored in a folder in server and when its is deleted its is moved to trash folder from where it will be manually cleared.
when a user tries to delete many files in the web page IIS get hangs and all session is expired. This case only present in server,in local host this issue is not available.
ALL the operations is carried out completely ie
Database gets updated. Files is moved from upload folder to trash folder in server.
I cannot determine what is going wrong,I just tried to delete many files totally around 35-36 MB. Is the issue with process taking long or is there any changes have to be made in order to perform large files operation, my project is done on VS2005 which is running in 2008 server.
i have using sql server 2005 express managment studio, i have create my database and every thing just i want to extact Database and attach it to My asp.net 3.5 Project how?
View 1 Replies