store word document into sql server - C# Discussion Boards

Tomerland1-Jun-06 20:18

1-Jun-06 20:18

Dear gurus,

my app has a rich user-interface which I have to test extensively by mouse-clicking on all the menus, buttons,.....

My idea now is to create a small tool which sends all this clicks,... automatically to my application for testing the user-interface.

Does anyone have an idea how this can be accomplished?

My best whishes and thankyou for your help ! ! ! !

Delete Image File From folder after save in DataBase

senthiluduuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu1-Jun-06 20:17

senthiluduuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu

1-Jun-06 20:17

I have a image file in folder i take it and store it in database as a Image Format. after stored in database how can i delete that image file from folder?

M.Senthil Rajan

Re: Delete Image File From folder after save in DataBase

krishna191-Jun-06 20:43

krishna19

1-Jun-06 20:43

You can write a batch file to delete the image from the folder and call the batch file using System.Diagonastics.Process.Start();
E.g
In batch file:

Del <file path="">
exit

After saving in database:
System.Diagonastics.Process.Start("C:\<batchfilename>.bat");

Hope this helps.....
Thanks

Re: Delete Image File From folder after save in DataBase

S. Senthil Kumar1-Jun-06 20:52

S. Senthil Kumar

1-Jun-06 20:52

Did you try using File.Delete[^] ?

Regards
Senthil
_____________________________
My Blog | My Articles | WinMacro

Re: Delete Image File From folder after save in DataBase

ranandbe2-Jun-06 0:35

ranandbe

2-Jun-06 0:35

Hi senthilu.,
Try this

using System.IO;

private Button1_Click(.......)
{
try
{
File.Delete(Server.MapPath("..//filename"));
Label1.Text="completed";
}
catch(Exception exe)
{
Label1.Text="error : "+exe.Message;
}
}

best regards.,
ranandbe

Connection problem

Jijo BP1-Jun-06 19:55

Jijo BP

1-Jun-06 19:55

Hi!.
I am developing a web based whois lookup page for my site. But while trying to connect to a remote whois database "whois.wildwest.net" and port "43" its showing the error "A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond". The stack trace is :-

[SocketException (0x274c): A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond]
System.Net.Sockets.TcpClient.Connect(String hostname, Int32 port) +578
giwia.development.temp.whois.Button2_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\giwia\development\temp\whois.aspx.cs:65
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +58
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292

. I am using Framework 1.1.

Please help me to solve this problem. Its working in local host. But it cant on web space.

Thanx in advance

JIJO BABY - Lets Play C#

Re: Connection problem

leppie1-Jun-06 20:52

leppie

1-Jun-06 20:52

It means the host is not responding. Try to: telnet whois.wildwest.net 43 and you will see it fails.

How xacc.ide transforms text to colored words on the screen
Intel PentuimM (aka Centrino) undervolting

store word document into sql server

ayyp1-Jun-06 19:55

ayyp

1-Jun-06 19:55

hi all, i need to store word document into sql server,they are give by the user,and my qustion is how much space it will occupy in the database when i store this word document (using stream reader i read the entire document and pass this value into string and i pass this string value into the database)i feel it will occupy more space on the db.(can any one say how much space will occupyed the 150kb word document?)
is there any way to reduce the size of the document?
very urgent....help me plz.................... Roll eyes | :rolleyes:

Get the properties of the application [modified]

Maddie from Dartford1-Jun-06 19:14

Maddie from Dartford

1-Jun-06 19:14

hello,

In my application i want to diaplay all properties in a control of dialog box and if user modifies it, this should be saved.

So, is there any way to know about the proerties of my applcation which can be displayed in a grid. I want the same user interaction like property window of C# form application.

or it can be explained as

I was looking for a way to access all the available properties of a given object. for ex. I would like to do some thing like

SomeClass obj1;

foreach( property p of obj1 )
{
// Do something with property
}

Is there any thing which any of you can suggest on this.

Thank You.

Gajesh
Pune(india)

-- modified at 2:09 Friday 2nd June, 2006

Re: Get the properties of the application [modified]

stancrm1-Jun-06 20:16

stancrm

1-Jun-06 20:16

See this: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndotnet/html/usingpropgrid.asp

Refresh

Resolver181-Jun-06 19:12

Resolver18

1-Jun-06 19:12

Hi,
I have a VB application using a .Net(C#) dll.I made the application wait for particular time from the .net dll and during the wait if i move between other open windows,the VB application gets hanged or becomes blank screened.

I tried using System.Windows.Forms.Application.DoEvents() to repaint the Vb application but it is that effective but of course makes little difference.

I totally clueless
Confused | :confused:

Do not wait to strike till the iron is hot; but make it hot by striking.

Re: Refresh [modified]

suguimoto1-Jun-06 19:31

suguimoto

1-Jun-06 19:31

I got the same problem, but I made my program wait until another program is loaded.

I´ve overcome this problem by making a loop on a timer, so It checks every 300ms if the program is loaded, so it´s not needed to wait anymore. =D

-- modified at 1:44 Friday 2nd June, 2006

Re: Refresh

S. Senthil Kumar1-Jun-06 20:55

S. Senthil Kumar

1-Jun-06 20:55

Do the waiting operation on a separate thread[^]. That way, the UI will remain responsive while you wait.

Regards
Senthil
_____________________________
My Blog | My Articles | WinMacro

what is assembly

nguyenquang02841-Jun-06 17:38

nguyenquang0284

1-Jun-06 17:38

I'm a begginer programming in C#.I am studing about assembly in C#.
I don't know what is assembly?
how do a file *.dll create?
Using a file .Dll ?
usefull of *.dll, or assemble
Thank you.;)

nguyenquang

Re: what is assembly

Darren_1-Jun-06 22:00

Darren_

1-Jun-06 22:00

Complete tutorial on creating/using an assembled DLL.

http://www.c-sharpcorner.com/2/pr12.asp[^]

Re: what is assembly

nguyenquang02842-Jun-06 17:18

nguyenquang0284

2-Jun-06 17:18

Thank you Darren Marshall.

inheriting from tabPage class

rcwoods1-Jun-06 11:34

rcwoods

1-Jun-06 11:34

Hi
I need some help with coding my class.

I want to create 2 different types of TabPages that will appear on my single TabControl. For eg. a CustomerTabPage and EmployeeTabPage. So I assume I should create 2 customised TabPage classes?
So if im receiving an employees details i will create an instance of Employee and create an instance of EmployeeTabPage(myEmployee) and pass it myEmployee to create a tab page that is unique to employees and adds all myEmployee's data to the labels on that tabPage.

Now the problem I have is how do I add the controls that will appear on my CustomerTabPage or EmployeeTabPage? do I code it in each class of TabPage that I created?

plz help!

Re: inheriting from tabPage class

likefood1-Jun-06 12:05

likefood

1-Jun-06 12:05

Same way you'd add controls to an inherited Form:

<br />
...<br />
this.Controls.Add([some control]);<br />
...<br />
<code> <br />
<br />
-Daniel<br />
Typing too fast fro my owngood

Re: inheriting from tabPage class

rcwoods1-Jun-06 12:43

rcwoods

1-Jun-06 12:43

thanks for the reply.
where do i add that code? do i put it in my TabPage constructor?

Im a beginner,sorry.

Re: inheriting from tabPage class

Ed.Poore1-Jun-06 13:26

Ed.Poore

1-Jun-06 13:26

Are you going to have more than one Employee Tab Page open at any time or likewise more than one Customer tab open. If you're not then it's an overkill to create an inherited tab control.

If you are using more than one instance of each type of tab control then basically you need to do this:

Inherit from a TabPage (easiest way to do this would be to add a UserControl to the current project from VS and then view the source code and change it to inherit from a TabPage).
Add all the code required for these tab pages.
In your event handler / what ever you are using to add tab pages replace: this.tabs.Pages.Add(new TabPage()) with this.tabs.Pages.Add(new CustomerTabPage())

You know you're a Land Rover owner when the best route from point A to point B is through the mud.

Ed

CodeDom question

Pablo Hernandez Valdes1-Jun-06 11:11

Pablo Hernandez Valdes

1-Jun-06 11:11

hello:
I'm trying to generate code using the CodeDom, and I need to know how to get an expression from an assign statement.

I'm using CodeBinaryOperatorExpression but I get the generated code within parenthesis, for example:
( a = 0 );

I'd like to know if I can get the code without parenthesis using the previous class or someone else.

Thanks

Pablo Hernandez Valdes

Re: CodeDom question

Dustin Metzgar1-Jun-06 11:27

Dustin Metzgar

1-Jun-06 11:27

CodeBinaryOperatorExpression is always going to use the parentheses. This way it can always be safe with order of operations. You can't really remove the parentheses using CodeBinaryOperatorExpression. What you may want to try, if you can, is to use a CodeSnippetExpression. If the expression will work in all the languages you're generating, then you're fine. Otherwise, you have to live with the parentheses.

Data Source Wizard for SQL [modified]

PyroManiak1-Jun-06 11:10

PyroManiak

1-Jun-06 11:10

I know how to connect to a database on a networked machine using C# code directly, thats pretty simple. But I'm trying to use things like data grid forms that have to just select the data source. Using the Data Source Wizard I can't figure out how to tell it to connect to machine X, database X, pass X, username X just like I would using code. It keeps insisting I connect it directly to a database file, which isn't shared. Am I missing some REALLY obvious answer?

-- modified at 17:15 Thursday 1st June, 2006

C# Express 2005 Doesn't have this feature?

Re: Data Source Wizard for SQL

Ed.Poore1-Jun-06 13:19

Ed.Poore

1-Jun-06 13:19

What type of database are you connecting to? I'd assume based on your comments so far that it's an access database in which case you must specify the a valid network path to the database, e.g. \\machineX\c\database.mdb in the connection string, the username and password can also be specified in the string if requried.

You know you're a Land Rover owner when the best route from point A to point B is through the mud.

Ed

Re: Data Source Wizard for SQL

PyroManiak1-Jun-06 18:55

PyroManiak

1-Jun-06 18:55

"data source wizard for SQL" is the topic, so I'm not connecting to access =P

I just got a full copy of 2005 from work and solved my problem. I dont think the data objects are predefined and all that in Express for a server connection.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.