|
I would concur with the comments from Luc & Mycroft. Do not store dates and times as strings, it just leads to exactly this sort of problem. A DateTime value is universal and can be displayed in whatever format is required, and in many cases converted to a non-Gregorian calendar.
|
|
|
|
|
Johnkokk wrote: However i might give it one more shot to see what happens.
I would strongly recommend trying. You will almost certainly run into malformed dates already in the field which will produce error but then you will be fixing your data 
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
how to read sms from any gsm mobile. anyone help me
|
|
|
|
|
Using what? c#? vb?W hat have you tried? Have you even looked on google?
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
when use you are application sms can not read from mobile. they give error.plz give solution
|
|
|
|
|
sanjay.gujarkar wrote: plz give solution
Doubtful, based on your question. Please try to be clear on what your problem is, with code and error messages if possible
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
I have a c# application that uses the Office PIAs to enable the application to export data to an Excel file. This works great on my development machine and other desktop machines.
When I run the application on a Terminal Server (which has Office available) I get a SecurityException and the application crashes. The debugger recommends I read up on security permissions and distributing office apps (helpfully providing a link). Going through this documentation, it seems to mostly pertain to writing add-ins for the Office suite instead of using their functionality.
Is there a tutorial that I can follow so I can preserve this functionality or at the very least disable the function and prevent the crash? Due to deployment issues I'd like to avoid modifying the .NET system policies if possible.
modified 12-Jul-20 21:01pm.
|
|
|
|
|
I had a command that inserted two tables, both using identity columns as primary keys. The identity value obtained from the first insert was used in inserting the second table, and two output parameters on the command should reflect the value of the two primary keys after insertion.
The command text was hence something like
INSERT A VALUES (@p1, @p2);
SET @A_ID = SCOPE_IDENTITY();
INSERT B VALUES (@p3, @p4, @A_ID);
SET @B_ID = SCOPE_IDENTITY();
I had added sql parameters for the identity values, and set the parameter direction to Output. After executing the command, I found that cmd.Parameters["@B_ID"].Value had been correctly set, but the @A_ID parameter invariably had the value zero.
Looking at the inserted data however what was really made me wonder what was going on here. The B record contained the correct foreign key, demonstrating that @A_ID had indeed been assigned correctly!
After hours of headscratching I stumbled upon the explanation: The code creating the command first added a parameter @A_ID as an input parameter, then added another parameter also named "@A_ID" as an output parameter. I don't know how exactly the provider communicates the variable declarations to SQL Server, but it appears that the second declaration simply overwrote (redeclared) the already-defined @A_ID. Then, when my code attempted to get the value, the SqlParameterCollection probably did a linear search returning the first parameter with a matching name, which of course was the input parameter.
While not checking for duplicate declarations may save a few microseconds, it would have been nice if by default such validation was performed and could be disabled instead via the ado.net configuration (for production). I certainly lost a lot of time, and probably some hair, before I found out. If it sounds like I was just being slow, let me add it wasn't that easy to check everything when the command had about 100 parameters.
|
|
|
|
|
Good find bro. I would surely try out this and see. If it really happens, it wouldnt be good.
dojohansen wrote: I was just being slow, let me add it wasn't that easy to check everything when the command had about 100 parameters.
Definitely. 
|
|
|
|
|
Hi,
This is what I want to do.
- Want to display an HTML page in a browser, kioskmode.
- Depending on information I get through a webService, I need to change the URL.
Any suggestions/technology how to achieve this ?
Additionally, how can a browser render its HTML 'in the background', and when ready, swap the 'old content' with the newly 'rendered' content.
So, in the kioskmode, we avoid the 'building' being displayed to the viewer. Any idea ?
Thanks in advance !
Dirk
|
|
|
|
|
WinForms has a WebBrowser control[^] that you can use to display a web page on your form.
You could have 2 of the controls and keep one hidden, then do the reloading on the hidden one and switch them around when the rendering is complete.
As your app is just a win forms app you should be able to set it up as the endpoint for a WCF (or webservices or whatever) service and when it receives a message, you can load the appropriate URL in your browser controls.
Simon
|
|
|
|
|
Thanks for your prompt reply !
This indeed works. However, I have two additional questions
1) Can I know when the WebBrowser is finished rendering the page ?
and secondly
2) As being a newbee to WCF... do you have a good link to explain me
2.a) how to design the service
2.b) subscribe as endpoint.
Many thanks !!!
Dirk
|
|
|
|
|
Hi,
I have a website that's running from several months. Most of the web pages contain a common marquee tag. I want to put the tag in a html file and embed the html file wherever needed so that when ever a change is made to the marquee tag it affects all the web pages.
Thanks in advance
|
|
|
|
|
The easiest way is probably with Server Side Includes[^]
You put a tag like this in your main html page
<!--#include virtual="../TheOtherFile.html" --> which points to the other html file that contains the html you want to insert. The server (either IIS or Apache) will insert this file when the page is served.
This is something that I believe is turned on by default on IIS and Apache, but you may have to rename your main html to myfile.shtml to indicate that you want to process SSIs in the file. (This means that you may also have the change the default pages for your directories if you rely on default pages being default.html or something like that). Some of this may vary between providers though, so if in doubt check with your web host.
Simon
|
|
|
|
|
Didn't even know you could turn off server side includes. You definitely do not need to rename the file though. However aspx pages may not process server side includes. Not much point considering what they do.
If you have knowledge, let others light their candles at it.
Margaret Fuller (1810 - 1850)
www.JacksonSoft.co.uk
|
|
|
|
|
The Man from U.N.C.L.E. wrote: Didn't even know you could turn off server side includes. You definitely do not need to rename the file though.
You can[^], and you can also configure them to only be executed for specific file extensions, so it does depend on what your web host has got setup. My web host only processes SSIs on files named .shtml and .shtm. By default I think it's just on for all files, but you can't rely on that when you didn't do the IIS install yourself.
The Man from U.N.C.L.E. wrote: aspx pages may not process server side includes. Not much point considering what they do.
Yup, SSIs are not processed on aspx pages. You could probably hack up an alternative using something like Response.Write(), but like you say, not much point for asp. You'd probably just use something like master pages instead.
Simon
|
|
|
|
|
First, this would probably be better asked in the Web Development or ASP.NET forum since it has nothing to do with .NET Framework.
Have you considered using an asp.net master page?
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Is it possible to write excel UDF with the help of build-in Visual Studio project type "Excel 2007 Add-In"?
|
|
|
|
|
Not that I know of... could be wrong though.
|
|
|
|
|
Google[^] says you can create an Automation Add-in that does the job.
If you have knowledge, let others light their candles at it.
Margaret Fuller (1810 - 1850)
www.JacksonSoft.co.uk
|
|
|
|
|
check this:
http://blogs.msdn.com/eric_carter/archive/2004/12/01/writing-user-defined-functions-for-excel-in-net.aspx
richta
|
|
|
|
|
my first dll is
using System;
namespace myfirst
{
public class demo
{
public string getmessage()
{
return "Hi!How Are You";
}
}
}
in folder e:\prac
and more dll is
using System;
using myfirst;
namespace mysecond
{
public class demo1
{
public string getmessage1()
{
demo d=new demo();
string str1=d.getmessage();
Console.WriteLine(str1);
}
}
}
and now i am using csc /t:library mysecond.cs
then i have following error and problem was same.please help me
mysecond.cs(2,7): error CS0246: The type or namespace name 'myfirst' could not
be found (are you missing a using directive or an assembly reference?)
|
|
|
|
|
vikas shukla wrote: are you missing a using directive or an assembly reference?
that tells you what is missing.
csc.exe has a lot of switches, try "csc /?" to get its help, and discover what "/r" does for you.
FYI: csc is part of .NET, hence look in a folder such as C:\Windows\Microsoft.NET\Framework\v2.0.50727
Luc Pattyn [Forum Guidelines] [My Articles]
I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages
|
|
|
|
|
Just because you have the assemblies in the same folder, C# compiler does not automatically resolve referenced assemblies for you. You have to specify the referenced assemblies using the '/r' switch.
|
|
|
|
|
Hi,
I am using the connected Socket communication to send and receive messages from one application to another application. i will send or receive the messages by serializing the objects.
how can i differentiate the different messages received.
Thank you.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
