I am writing an error log procedure (for security reasons I cannot use log4net / elmah etc), and I wanted to know if it is possible to get the line number of the line where the error occured and / or the procedure name where the error occured?I will be creating try catch finally statement blocks, so I am hoping to get the line number of the errorhandler (or the line that caused the error) and the related procedure name.
View 4 Repliesi have two stored procs. when th 1st stored proc runs i want to be able to use this value returned from the stored into another stored proc.
my first stored proc is:
[Code]....
which returns [Transfer_stations_Authority_name] = 'Blackpool'
now i want to use this value into my second stored proc@
[Code]....
[Code]....
I am using a textbox to populate mySQL database. My problem is when I recall the text it displays without line brakes or line spacing, inserted in the input textbox. I have tried all the field types i.e. Text, Small, Medium Text and Chars. I have tried gridview, repeater and datalist all displaying continuous text without line brakes.
View 4 RepliesIf I have a text file like:
123, joe blow, USA
Where the first values represent:
USERID, NAME, COUNTRY
If my file has 5000 rows, could I update a particular row somehow using C#?
I have a gridview which i want to update line by line.Its for confirmed users.SO i have a list of users and they are confirmed by clicking the checkbox and updating the value in the database.But how can i find the checkbox on the gridview and get the value. Ive tried the following code but no joy
[Code]....
I am trying to read a multilined textBox line by line into a List<String> but with the code below the compiler says that "'System.Environment' does not contain a definition for 'Newline'
[Code]....
If I have a variable that contains text information (say taken from a textarea), how can I read the text content held in a string variable line by line?
The text entered in the text area will have (enter key) to separate the line.
I insert a text box, change the parameters to multi line and then pass the string to sql. Users insert comments etc, using line breaks, however because I just pass this as a string the line breaks are not there when they view the text box after input. Example: Here is a well formatted comment. as I typed in the text box today. Inserted in to sql as a string, returns this on select:
Here is a well formatted comment.as I typed in the text boxtoday. How do I insert the line breaks in the string from a textbox?
I am developing SMS portal in asp.net c# where people register & send sms.I M Using multiline asp:textbox for input message. i want to break line where user hit enter/new line in textbox. if there any textboxeditor which support only <br/>.
View 2 RepliesI m uploading a file and I want to read that file line by line. I have 200 users accessing that application at one time and I have more than 300 lines in a text file to read. If I do it in a normal code, it may crash. So, what are the ways to do this application? Web services or COM+. which is the better way? I dont want my application to crash at any point.
View 5 Replieshow do I loop through, line by line, the contexts from a textarea in asp.net?
streamreader and stream both don't accept a string.
i have insert a text in a textbox with the textmode = multiline.. when i display out the data, i wan the data will be display with the break line. for example, my input is like that
18.0 million effective pixels
Auto lighting optimizer
Full HD video 1920 x 1080
the text is line by line. but when i display out the data i have inserted through textbox it cannot display line by line in the front page.
How to navigate on compatible websites offline and synchronize when going back online. how to do it ?
View 2 Repliesi have a stored proc that uses FOR XML and wanted to know how to load the xml in my asp.net c# code?
View 3 RepliesI have to desing line chart graph in .rdlc report, can you please help me, i have decimal values on Y-Axis and date time values on X-Axis , i have two series of product, according to product value during specific time i need to display line graph for each product.please do needfull to me.
View 2 RepliesMy function isn't returning anything - strReturn is empty:
[Code]....
When I execute this stored proc using 'exec GetMerchantLocationZip (3333, 373773)' I get the correct zipcode in SQL. Why don't I get it in Visual Studio?
[Code]....
I am learning, so apologies if it's a obvious error.
I am attempting to execute a stored proc in asp.net in the code behind. The parameter I am trying to pass is strErrorMessage that contains a value of "The transport failed to connect to the server.; ". The error message when the query gets executed is: The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 1 ("@errMessage"): Data type 0xE7 has an invalid data length or metadata length. Update with code
try
{
...
...
...
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('Email was not sent - " + ex.Message + "');", true);
string strMessage = ex.Message;
string strStackTrace = ex.StackTrace;
strMessage = strMessage.Replace("
", "; ");
strMessage = strMessage.Replace(" ", "");
strStackTrace = strStackTrace.Replace("
", "; ");
strStackTrace = strStackTrace.Replace(" ", "");
AppErrorLog(strMessage, strStackTrace);
return false;
}
protected void AppErrorLog(string strErrorMessage, string strErrorStackTrace)
{
SqlConnection conErrLog = new SqlConnection(strConn);
string sql = "usp_AppErrorLog_AddRecord";
SqlCommand cmdErrLog = new SqlCommand(sql, conErrLog);
conErrLog.Open();
try
{
cmdErrLog.CommandType = CommandType.StoredProcedure;
cmdErrLog.Parameters.Add(new SqlParameter("@errMessage", SqlDbType.NVarChar, 8000));
cmdErrLog.Parameters["@errMessage"].Value = strErrorMessage;
cmdErrLog.Parameters.Add(new SqlParameter("@errStackTrace", SqlDbType.NVarChar, 8000));
cmdErrLog.Parameters["@errStackTrace"].Value = strErrorStackTrace;
cmdErrLog.Parameters.Add(new SqlParameter("@userID", SqlDbType.VarChar, 12));
cmdErrLog.Parameters["@userID"].Value = User.Identity.Name;
SqlDataAdapter ada = new SqlDataAdapter(cmdErrLog);
cmdErrLog.ExecuteNonQuery();
}
catch(Exception e)
{
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('AppErrorLog - " + e.Message + "');", true);
}
finally
{
conErrLog.Close();
}
}
The column datatype in the table is nvarchar(MAX).
i have the following stored proc that inserts data into a database based on a stauts field. the first stored proc inserts into the first table and i am trying to get the identity field out as i need this value for the next stored proc. the first stored proc works fine and inserts the data but the secnd one doesnt, even though there is data there.
[Code]....
We have three web servers in our web farm that are load balanced using the Network Load Balancing Manager in Windows 2003. The sites that run on these boxes use In-Proc ASP.NET session. Our assumption is that the balancing uses a "sticky" session because users seem to be assigned to a given server during their use of the application as well as there doesn't appear to be any session error where the session data is residing on a previous machine. My question is how can I 1) verify that our balancing configuration is using "sticky" sessions and 2) can someone explain the load balancing feature in Windows 2003 relative to ASP.NET web applications?
View 1 RepliesI'm working on locking down some MySQL user accounts. At the moment I typically grant my user accounts execute privileges over the required stored procedures within a schema.Now I'm looking at the proc table in the mysql schema. The common wisdom that's quoted many times on various websites says "Stored procedures require the presence of the proc table in the mysql schema".By granting select access over the proc table stored procedures will work. But if I removed the above select privilege and grant the user execute privilege over the entire mysql schema the procedure will also work.
Does anyone have any ideas about the security issues by choosing one of the above over another?I would prefer to lock the proc table down all together so the user cannot see it cannot select from it.
I am trying to pass stored procedure from a controller to view. In my Home controller, in Index method, I have this. CustOrderHist is my stored procedure from northwind database.
public ActionResult Index()
{
DataClasses1DataContext dc = new DataClasses1DataContext();
var products = dc.CustOrderHist("ALFKI").GetEnumerator();
return View(products);
[Code]....
I have a table with two indexes, PK_WClient (clustered) and SMonths (non-unqiue, non-clustered), we have a data import that works on the .net side, it imports data via C# into the table. Every time we complete the import the sections of the asp.net site that use that table are very slow, just when pulling the new records, old records are fine. so we reindex that table for both indexes and things are fine again. Rather than us having to reindex manually in sql server 2005 each time, is there a way to get this to happen via a stored proc or from the c# side? this way when the client gets the project, we don't need to run the index, they can just use the site to import data and behind the sceens the reindex can happen once the import is done.
View 4 RepliesI have a stored proc that takes a bit long to run. I tried to do this command.CommandTimeout = 200;still gets time out within 200 secs.How is this done?
View 1 Repliesi can't debug the code line by line code, i have break point in form load event, but it skipthe breakpoint , can't able to debug.
View 6 RepliesI'm considering moving our web app session storage from In Proc to State Server. Can anybody give any figures as to the performance difference?
View 1 Replies