如何使用C#在SQL Server中动态创建视图?
像这样的事情,显然您的连接代码会有所不同(更好):
SqlConnection conn = null; conn = new SqlConnection("yourConnectionString"); conn.Open(); string strSQLCommand = "CREATE VIEW vw_YourView AS SELECT YOurColumn FROM YourTable"; SqlCommand command = new SqlCommand(strSQLCommand, conn); string returnvalue = (string)command.ExecuteScalar(); conn.Close();