店铺经理项目 [英] shop managent project

问题描述

兄弟和成员...
我正在做有关商店管理系统的项目.
我正在处理数据库cz，我需要存储客户名称.我希望一个项目对管理数据有一些想法.有人知道一个关于管理的现成项目.意味着将输入存储在数据库中并查看，更新，删除以及许多此类选项
我正在使用大学告诉我的Visual Studio2010.
帮帮我guyz

bro and members...
i am doing a project on shop management system.
i am dealing with database cz i need to store the customer name. i want a project to get some ideas on managing data.does anbody knows a readymade project on managing. means taking the input storing in database and viewing , updating, deleting, and many such options
i am using visual studio 2010 as my university told me.
help me guyz

推荐答案

我们不做作业:这是有原因的.在这里，您可以考虑自己被告知的内容，并尝试理解它.也可以在那里帮助您的导师识别您的弱点，并将更多的注意力放在补救措施上.
自己尝试，您可能会发现它并不像您想的那么难！


我已经创建了一个数据库链接.一个表单应用程序.只是我想通过Windows表单访问数据库.我想要诸如客户数量和许多选项之类的选项.我知道我必须解雇一个SQL查询，以进入数据库.
我不知道该怎么做"


很简单:
读出来:

We do not do your homework: it is set for a reason. It is there so that you think about what you have been told, and try to understand it. It is also there so that your tutor can identify areas where you are weak, and focus more attention on remedial action.
Try it yourself, you may find it is not as difficult as you think!


"i have created a database link up. and a form application. just i want to have access to the database through windows form. and i want options such as no. of customers and many option. i know i have to fire a sql query for that to get into the database.
i donno how to do that"


It''s pretty easy:
Reading out:

using (SqlConnection con = new SqlConnection(strConnect))
    {
    con.Open();
    using (SqlCommand com = new SqlCommand("SELECT iD, description FROM myTable", con))
        {
        using (SqlDataReader reader = com.ExecuteReader())
            {
            while (reader.Read())
                {
                int id = (int) reader["iD"];
                string desc = (string) reader["description"];
                Console.WriteLine("ID: {0}\n    {1}", iD, desc);
                }
            }
        }
    }

插入新记录:

Inserting new records:

using (SqlConnection con = new SqlConnection(strConnect))
    {
    con.Open();
    using (SqlCommand com = new SqlCommand("INSERT INTO myTable (myColumn1, myColumn2) VALUES (@C1, @C2)", con))
        {
        com.Parameters.AddWithValue("@C1", myValueForColumn1);
        com.Parameters.AddWithValue("@C2", myValueForColumn2);
        com.ExecuteNonQuery();
        }
    }

任何学生都应该知道，在大学项目中要做的第一件事就是研究.快速浏览CodeProject文章的数据库部分 [

Any student should know that the first thing to do in a university project is research. A quick scan of the Database section of the CodeProject Articles[^] will provide lots of useful information for you.

这篇关于店铺经理项目的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！