C# Discussion Boards - CodeProject

omegazafer8-Feb-09 21:28

8-Feb-09 21:28

Hi,
How can I create sql database by using Link? Can you give me some links to see and investigate this subject?

Best Regards
Kemal Akkanat

Re: Creating sql database by using Link????

N a v a n e e t h8-Feb-09 21:59

N a v a n e e t h

8-Feb-09 21:59

omegazafer wrote:
How can I create sql database by using Link?

What does that mean? Do you want to create database through code? If yes, read the documentation[^].

Navaneeth

How to use google | Ask smart questions

Re: Creating sql database by using Link????

omegazafer9-Feb-09 0:01

omegazafer

9-Feb-09 0:01

I mean, using some codes(in visual studio not in sql), creating sql database. It is like a nhibernate technology. we make classes in vs and give some attributes to properties . After that, When we start the program, our program will create the sql database in sql server automatically.

Best Regards
Kemal Akkanat

Re: Creating sql database by using Link????

Ken Mazaika9-Feb-09 2:34

Ken Mazaika

9-Feb-09 2:34

Kemel, I think this might help you out.

http://www.codeproject.com/KB/tips/CreateSQLDV.aspx[^]

-Ken

Re: Creating sql database by using Link????

omegazafer10-Feb-09 22:06

omegazafer

10-Feb-09 22:06

Thanks.

data transfer from MsAccess to Mysql

anishkannan8-Feb-09 20:52

anishkannan

8-Feb-09 20:52

Hi

AnyBody help me

In my project do by c#, but existing project did by VisualBasic with MSAcess.
now i am doing C# with MySql database. so previous project MsAccess data's are transfer to the mysql Database through c#. otherwise give any other idea.

Thanks

Re: data transfer from MsAccess to Mysql

N a v a n e e t h8-Feb-09 22:01

N a v a n e e t h

8-Feb-09 22:01

Read data from access to a reader. Loop through the reader and insert each row to MySQL.

Navaneeth

How to use google | Ask smart questions

How to generate XML File using XSD and Excel(XSL) File in C#

am 20098-Feb-09 20:37

am 2009

8-Feb-09 20:37

Hi,Friends

I want to Convert XSL file into XML file by applying XSD file to XSL file. How can I generate Valid XML file according to XSD file.

Thanks
abm

Re: How to generate XML File using XSD and Excel(XSL) File in C#

Ken Mazaika9-Feb-09 2:23

Ken Mazaika

9-Feb-09 2:23

Hi abm,

You might want to look at http://social.msdn.microsoft.com/Forums/en-US/vsto/thread/b6e8a28c-6760-4e86-a1aa-e2ce9ec36380/[^]

After you read in the file you can validate the XML http://www.codeguru.com/csharp/csharp/cs_data/xml/article.php/c6737[^].

If you can export the XSL file to a CSV file, you probably could built an XSLT transformation easier than using the Jet DB provider, depending on your situation.

Hope that helped.

-Ken

The specified path, file name, or both are too long. The fully qualified file name must be less than 260 characters, and the directory name must be less than 248 characters.in C#

ChandrakanthGaddam8-Feb-09 20:16

ChandrakanthGaddam

8-Feb-09 20:16

Hi,

This is from Chandrakanth. working on C# with Asp.net.

Actually i have one problem ,

That is While copying the data from

Copy(Source File,DestinationFile) gettting "Ilegal charcters in a path"

Actually what we are doing is Converting Tiff File To TextFile through OCR.

I am getting data INTO STRING from Conversion from tiff to txt throgu OCR.

And Renaming the file with .txt.

And i want to move the data from STRING to txtFile.

Can any one tell me what to do for that.

That Code and all i am giving here .

string strFilePath = FileUpload1.PostedFile.FileName;
Process tessProc = new Process();
tessProc.StartInfo.WorkingDirectory = strFilePath; // @"C:\08122008_NY01_AST_1.0.tif"; // strFileName;
tessProc.StartInfo.FileName = @"D:\Chandrakanth\TesseractOCR08022009\bin.dbg\tesseract.exe";
string strFileName1;
int intLastIndexOfSlash;
if (strFilePath.IndexOf(@"\") == 0)
strFileName1 = strFilePath;
else
{
intLastIndexOfSlash = strFilePath.LastIndexOf(@"\");
strFileName1 = strFilePath.Substring(intLastIndexOfSlash + 1);
}
tessProc.StartInfo.Arguments = strFileName1 + " output"; tessProc.Start();
string output = File.ReadAllText(@"C:\output.txt");
TextBox1.Text = output;

string strOutPutFileName = System.IO.Path.GetFileNameWithoutExtension (strFileName1) + ".TXT";
string strSaveFilePath = Server.MapPath("");
File.Create(strSaveFilePath + @"\" + strOutPutFileName);
string illegal = output;
string regexSearch = string.Format("{0}{1}",
new string(Path.GetInvalidFileNameChars()),
new string(Path.GetInvalidPathChars()));
Regex r = new Regex(string.Format("[{0}]", Regex.Escape(regexSearch)));
illegal = r.Replace(illegal, "");

System.IO.File.Copy(illegal, strOutPutFileName);

Actually that illegal contains data in below format

------------------------------------------------------------------------

JMW -J
'me l^ T
l ii T T ASTER
^ WE INTEGRATE CDMIUIYICJTIOIVS
INVOIC E
ASTER TELE SERVICES FVT. LTD, Invoice No: EMHASDCGSE
Flat na.4 to 7, C/a Krlshna Plaza, Date: 13-Dec417 ,
Opp.WaLer Tanks, Near TATA Garden Busstop, .
Chandan Nagar, PUNE-14
PAN No AACCA54E9L P.O.NG: 4352
CST TIN is 2715000524SC w e.l01 04.2005 Date: MAMGY-W
\lAT TIN is 2715000524GV wel`01 O4 ZODG
ST Regn No. AACCAMSBLSTOUT
Kg Vodafnile Essar Cellular Lid.,
.)Mutropnlltan, F/P Null.
S,No. 21, Old Mumbalrvurla Highway,
Wakzdewadljhivaji Nagar, Site Name: Gad Mudslngi
PUNE 7 411005 TowsrType R1~l
Tower Height: 21 Mts
Natllreof Workmvaition Lamp, Llghting Arrester
EETEHWKJJMS lure lu. a' value la;.
1 Aviation lain 1 @1 avov s woo
Z Li htin Arrester 1 Nas ' 1SD(l 1,600
a Avlaiulun lam came XI arm no la are

1 ** . _
1 ]*__
1 ___ an svo
rli= anuue `rum include sel-vlces tax Amount of ns see _
I `rural niu==i== Value as eve
?
JJ Now Claimed nuowi. of xiivaiue value is slo
(Rupees Thirteen Thousand Slx Hundred and Seventy un!y)
For ASTER TELE SERVICES PVT LTD 7
/ ^ i
Aurlu=rls= slguauiry I
4

ASTER TELESERVICES PVILTD.
4~7 Krlshnla Pbxa, Opp. WalerTarll<, NearTaln Garden Bus Slap, Otlendan Nsgar, Fune -41l 014
2* Phone :(Qll) 020 - 21034495, 323445413, 32,540369, Tetetax : 020 ~ 21034495.

-------------------------------------------------------------------------

System.IO.File.Copy(illegal, strOutPutFileName);

Actually i want to move the data from illegal to strOutPutFileName

here i am getting error

The specified path, file name, or both are too long. The fully qualified file name must be less than 260 characters, and the directory name must be less than 248 characters.

for this line

System.IO.File.Copy(illegal, strOutPutFileName);

Can anyb one tell how to do that ASAP?

Thanks and Regards
Chandrakanth

Re: The specified path, file name, or both are too long. The fully qualified file name must be less than 260 characters, and the directory name must be less than 248 characters.in C#

Christian Graus8-Feb-09 20:24

Christian Graus

8-Feb-09 20:24

chandragaddam wrote:
The specified path, file name, or both are too long. The fully qualified file name must be less than 260 characters, and the directory name must be less than 248 characters.

Can you confirm that your path and filename are NOT that long ? Or does the error mean what it says ?

Christian Graus

Driven to the arms of OSX by Vista.

Re: The specified path, file name, or both are too long. The fully qualified file name must be less than 260 characters, and the directory name must be less than 248 characters.in C#

ChandrakanthGaddam8-Feb-09 20:31

ChandrakanthGaddam

8-Feb-09 20:31

Hi,

Once again from Chandrakanth.

That file name is in the format of (Tiff File)-- 08122008_NY01_AST_3.0.tif

After Conversion the file will be going to change like 08122008_NY01_AST_3.0.txt.

.txt file is going to store in Application directory.

The Application directory is in

"D:\Chandrakanth\TesseractOCR08022009"

That application name is "TesseractOCR08022009"

And that illegal contains Data. I want to move that to "08122008_NY01_AST_3.0.txt." this txtfile.

While moving data i am getting error.

Could u pls give me some response on thar ASAP.

Thanks and Regards
Chandrakanth

Re: The specified path, file name, or both are too long. The fully qualified file name must be less than 260 characters, and the directory name must be less than 248 characters.in C#

Le centriste9-Feb-09 4:56

Le centriste

9-Feb-09 4:56

Looking at the length of the subject of your post, it does not surprise me you have trouble with long names. Poke tongue | ;-P

Extracting outlook pst files in..net application

Member 42634168-Feb-09 20:12

Member 4263416

8-Feb-09 20:12

Hi,

I am working in an application of extracting the outlook.pst file annd export its emails data to an Ms-excel file or any other database like ms-access.I know, how to use outlook dll and extract inbox,outbox etc. folders and save them in disk but unable to export them in excel file.So plz ant one can help me in this application.

Re: Extracting outlook pst files in..net application

Mickey202931-Oct-12 22:50

Mickey2029

31-Oct-12 22:50

Outlook pst file export example:
http://www.independentsoft.de/pst/tutorial/export.html

Web Browser control in C#

Indrajeet_Mukherjee8-Feb-09 19:39

Indrajeet_Mukherjee

8-Feb-09 19:39

I am using webbrowser control in a window application using C# 2.0, its a testing tool, whenever i open a site from within the application, when i click any tab or any button or hyperlink for the fisrt time it give me the error dailog box with,

Run time error has occured
Error:Object doesn't support this property or method.

Please suggest what is the resolution.

The system is having IE 6.0 version.

Re: Web Browser control in C#

EliottA9-Feb-09 2:03

EliottA

9-Feb-09 2:03

Without seeing any code, it will be very hard to tell you what you did wrong. Step through the code and find out exactly what line of code is triggering that error.

Check out the CodeProject forum Guidelines[^]

everything is an object...

swjam8-Feb-09 19:32

swjam

8-Feb-09 19:32

in c#. are primitives such as int (which behind-the-scenes are structs i.e. System.Int32) therefore objects? since primitives are pass by value, it contradicts the fact that objects are pass by reference? please anyone enlighten me. thanks.

----------------------------------------------------------
this is a sig++

Re: everything is an object...

Christian Graus8-Feb-09 19:51

Christian Graus

8-Feb-09 19:51

swjam wrote:
ince primitives are pass by value, it contradicts the fact that objects are pass by reference?

Correct. An int is only an object if it's boxed ( that is, put in an object ) for the purpose of being passed as an object. Otherwise, it is not.

Christian Graus

Driven to the arms of OSX by Vista.

Re: everything is an object...

Guffa8-Feb-09 20:28

Guffa

8-Feb-09 20:28

swjam wrote:
it contradicts the fact that objects are pass by reference?

Well, actually everything is passed by value (unless you specify otherwise). When you pass an object you are actually passing the reference to the object, and as the reference is a value type it's passed by value, i.e. the value of the reference is copied.

Despite everything, the person most likely to be fooling you next is yourself.

Re: everything is an object...

marcosingh22-Jan-11 4:25

marcosingh

22-Jan-11 4:25