|
hi.. i have dot NET framework software installed on my computer which includes microsoft SQL sever 2008. Do I have to install MS SQL server software again so as to be able to connect or retrieve data from the database? plz help.
|
|
|
|
|
No you don't need to install anything else, you can connect via code.
What is lacking is the management studio as you only get the express edition with no GUI. This makes setting up/ managing DBs hard-ishbut not impossible as you can always create SQL and execute via a console app or similar. You can download an express (free) version of management studio here[^] to provide a GUI, I don't know how good it is as we've got the full thing at work. I dare say it'll get the basics done.
|
|
|
|
|
THANKS AM GRATEFUL FOR ALL YOUR RESPONSES.
|
|
|
|
|
hello,,
i am not so sure but as i know 2010 and 2012 contain its inbuilt sql server,,,so you don't need to istall again external sql server...you can connect to the databse using code.
modified 18-Feb-13 10:16am.
|
|
|
|
|
They don't contain "inbuilt" SQL servers. They install either SQL Server 2008 Express or 2012 Express with LocalDb, depending on which version of Visual Studio and edition you install.
|
|
|
|
|
We are developing a daily planing system, the system will work like a calender planer with multi clients and servers...
The questions is which c# middleware should we use for this kind of 'distributed system'????
This is a picture of the systems architecture
Uploaded with ImageShack.us
modified 18-Feb-13 6:09am.
|
|
|
|
|
dude - I'd edit this and fix the link - it doesnt go where you think it should !
'g'
|
|
|
|
|
It works now 
|
|
|
|
|
ok .. well, as devvvy says, whats wrong with ASP.NET ? (its one option, certainly less complex than using a message bus)
In this case, tier 1 - Client uses a browser, tier 2 is an ASP.NET app, tier 3 is the data-base
Does it need to be more complicated, or is there some other thought process you're having ?
'g'
|
|
|
|
|
by middleware i presumed you mean some sort of message bus but why you need a message bus for a calendaring app? it's asp.net is it not?
dev
|
|
|
|
|
Because my teacher requires using middleware, the course is about distributed systems and he wants us to use middleware in this system
|
|
|
|
|
but has your teacher given you a definition of 'middleware' ?
|
|
|
|
|
Middleware is a set of services that perform various functions in a distributed computing environment, across a wide set of server and client systems. In essence, middleware is computer software that connects software components.
|
|
|
|
|
great - I dont understand why your teacher thinks a web server, with some ASP.NET programming, and a database back-end, fails to meet that definition - true, the web-server and ASP.Net programming is 'bundling' some of the services, but it does meet the definiton (the protocols and components may be 'limited', but, its there)
Well, then, if you dont want to look at ASP.NET etc, you're going to have to do a fair bit of research, and, start updating your document with possible protocols for each of the different layers/comms
In the commercial world, for example, there's BizTalk, Tibco, which all offer multiple ways of doing things, in addition to 'messaging', like AMQPP, RabbitMQ, MQSeries
I'd start off by looking at what http://www.zeroc.com/[^] offer for example, and see if you can use that to hang a system together
'g'
|
|
|
|
|
there's no place for a simple asp.net calendaring app to use a message bus of any sort - message bus is for apps like real time trading applications where screen flicks (ie real time client server architecture). In this case, WPF/Winform client fetches updates from message bus, which is in turn fed by combination of market data provider (bloomberg, reuters...etc) and calculation servers in the back (for example doing risk, profit and loss, and other model calculation)
- and even in this case, you can simplify things by simply having clients (WPF/Winform) talking directly to database.
dev
|
|
|
|
|
I'm glad you have such rigid/clear-cut definitions of what can do what - I tend to stay away from such rigidity myself 
|
|
|
|
|
i have simple clear cut definitions because i have a corresponding simple mind which prefer spend more thoughts on the beer end of the day - if i am wrnog, someone will offer to correct me i generally don't need to ask for it!
dev
|
|
|
|
|
it's not a webb application so no not asp.net
|
|
|
|
|
it's not a webb application so no not asp.net
|
|
|
|
|
fine - you know - you havnt posted any research youve done yourself
did you look at ZeroC ICE - or WUSTL ACE - or JBOSS - or do a google for open source middleware ?
I challenged your or your teacher's definition of Middleware - you responded - fair enough - so now, do some research of your own
|
|
|
|
|
it's not a webb application so no not asp.net
|
|
|
|
|
|
string[] filePaths = Directory.GetFiles(@"c:\MyDir\", "*.bmp",
SearchOption.AllDirectories);
Is that what you were looking for ? That retrieves a list of bitmap (.bmp) files from c:\mydir\ and all subdirectories under MyDir, into the string array filePaths - you can then use (for example) a 'foreach' on filePaths to process the images
'g'
|
|
|
|
|
The path will be given during run time.we cant say which type of format they will be choosing and also wanted toknow about target path...
Thanks in advance
Sayeed Bagban
|
|
|
|
|
sayeed bagban wrote: and i have inserted images in MySQL server database.
How to retrieve all the images from server,the source path by which i should retrieve the images from server
Did you insert images in the database, or paths to the images? In both cases, you'd fetch the info with a SELECT statement.
sayeed bagban wrote: then giving the Target path where all the images has to be saved.
Wouldn't that be a textbox or some dialog?
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
