I college students, just contact learned Java programming based directly after the c # and the final project requirement with visual studio 2012 and SQL server2008 design a KTV ge tais project application form is not a problem is how to connect to the database functionality no clue, who can give me about ideas

CodePudding user response:

Search the c # ado.net

CodePudding user response:

http://download.csdn.net/download/JLKEngine001/929352

CodePudding user response:

The bosses can help me with the background

CodePudding user response:

The school teachers teach you KTV classics?

CodePudding user response:

"Finished" Java, now learning the.net/c # is not "how to connect to database", this should be the school didn't teach good, learn knowledge all forget,

CodePudding user response:

Falsehood, application form is not a problem, a connection database how also won't? Application form is much more complicated than the database manipulation,

CodePudding user response:

Connect to the database is the most simple c # console application:

 using System; 
Using System. The Data. SqlClient. 

The namespace ConsoleApp2 
{
Class Program 
{
The static void Main (string [] args) 
{
//VS access available connection string: https://blog.csdn.net/yenange/article/details/77026214 
//connection string it ourselves 
String connString=@ "Data Source=(local) \ sqlserver2014; Initial Catalog=master; Integrated Security=True "; 
String SQL="select count (1) as the from CNT master. The dbo. Spt_values where [type]='P' and [number] & gt;=@ n "; 
Try 
{
Using (SqlConnection conn=new SqlConnection (connString)) 
{
Conn. The Open (); 
SqlCommand CMD=new SqlCommand (SQL, conn); 
CMD. The Parameters. AddWithValue (" @ "n", 0); 
Int CNT=the Convert. ToInt32 (CMD) ExecuteScalar ()); 
Console. WriteLine (" the count: {0} ", CNT); 
} 
} 
The catch (Exception ex) 
{
Console. WriteLine (ex. Message); 
} 
The Console. The Read (); 
} 
} 
} 

CodePudding user response:

There is a problem, the following code database connection is not closed? And catch the direct display an error message

CodePudding user response:

null reference 10 floor also can reply:

there is a problem, the following code database connection is not closed? And catch the direct display an error message

Said database connection didn't shut down, do you know what is using, and directly output error in the console program what's the problem??

CodePudding user response:

College students should not be taught this, shouldn't learn this, no matter what kind of language should not be, would be a partial early,
Tell you what the student to cow force?

Bill Gates said of good, read "computer programming art", and send me your resume, I really not let you read a few books which pere goriot bricks, just say, don't need to dig into primary applications, real learning, who should learn primary application won't it doesn't matter, at most give you three monthly training course, most of these primary application three months can get the 7788, and the tall old man the books you see enough for 3 years, so what is the real deal at a glance

CodePudding user response:

null reference 10 floor also can reply:

there is a problem, the following code database connection is not closed? And catch the direct display an error message

is the somebody else to feed the food to you in the mouth

CodePudding user response:

C # basic implementation is not at the moment, first you have to realize audio track switch function, or all in vain

CodePudding user response:

reference 14 floor warm eyes reply:

c # basic implementation is not at the moment, first you have to realize audio track switch function, or all in vain

Saying the so-called track switch is not difficult, can play with js will play, audio stream is just a bunch of byte [], just know storage format

So take this as a means of attack c #, some weak

CodePudding user response:

Audio stream is easy, the key is you have the whole song file to parse, or you don't know there are several video files in this video, there are several subtitle file, there are a few tracks, such as KTV tracks are now more tracks, rather than the old channel switch,

CodePudding user response:

What database? You can try PostgreSQL
If not enough confidence, you can try the MSSQL

CodePudding user response:

Don't need to think so complicated, upstairs is a final project, also need to involve data flow? The building Lord says is very general, project requirements is not clear, the point of ge tais have specific requirements? Is like the KTV the song will be broadcast on the screen corresponds to MP4 video? Or just play music? I say under simple requirements and ideas, set up a table in database, information storage of songs, such as title, artist, such as links to cover, song is the most main storage location, find the song on the table when the fuzzy query, display the corresponding information, below the table is the table store songs, and then build a table, when you are so, just insert the corresponding information in the table, the table is the jukebox list, direct call when I was playing music Windows related play music have to do is to bring their own software, can go online to check how to use, if you want to do a simple point ge tais, there is no hard, two tables, interface display, song query, songs to recommend what song is to store information table query, so what is the jukebox list to add and delete, play songs and then have to do is call the local software, and jukebox list also can need not in the database creation form, directly in a set, specific want how there are so many ways to achieve,

CodePudding user response:

Can use ADO.NET 5 large object

SqlConnection
SqlCommand
SqlAdpater
The DataSet
The DataTable

Other

SqlParameter

And so on, can the MSDN, a complete example,

CodePudding user response:

Can also be VS F1 health index

CodePudding user response:

refer to 12 floor wanghui0380 reply:

college students shouldn't teach this, shouldn't learn this, no matter what kind of language should not be, would be a partial early,
Tell you what the student to cow force?

Bill Gates said of good, read "computer programming art", and send me your resume, I really not let you read a few books which pere goriot bricks, just say, don't need to dig into primary applications, real learning, who should learn primary application won't it doesn't matter, at most give you three monthly training course, most of these primary application three months can get the 7788, and the tall old man the books you see enough for 3 years, so the be clear at a glance whether that is the real deal

eldest brother, you say this word, I am a look or watch