本文整理汇总了C#中DBManager.Connect方法的典型用法代码示例。如果您正苦于以下问题:C# DBManager.Connect方法的具体用法?C# DBManager.Connect怎么用?C# DBManager.Connect使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DBManager
的用法示例。
在下文中一共展示了DBManager.Connect方法的9个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Save
public void Save()
{
DBManager db = new DBManager();
db.Connect();
db.Insert(String.Format("insert into product VALUES (null,'{0}','{1}','{2}','{3}')", name, collectionID, price, description));
db.Close();
}
示例2: Save
public void Save()
{
DBManager db = new DBManager();
db.Connect();
db.Insert(String.Format("insert into size_map VALUES (null,'{0}','{1}')", productID, sizeID));
db.Close();
}
示例3: Save
public void Save()
{
DBManager db = new DBManager();
db.Connect();
db.Insert(String.Format("insert into product_image VALUES (null,'{0}','{1}','{2}')", productID, url, orderOfDisplay));
db.Close();
}
示例4: Save
public void Save()
{
DBManager db = new DBManager();
db.Connect();
db.Insert(String.Format("insert into size VALUES (null,'{0}')", sizeLabel));
db.Close();
}
示例5: Save
public void Save()
{
DBManager db = new DBManager();
db.Connect();
db.Insert(String.Format("insert into product_detail VALUES (null,'{0}')", description));
db.Close();
}
示例6: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
if (Application[Constants.FRONT_PAGE_IMG_API_CACHE] == null)
{
DBManager db = new DBManager();
db.Connect();
List<FrontImageDAO> imgList = db.GetAllFrontPageImages();
db.Close();
var serializer = new JavaScriptSerializer();
var serializedResult = serializer.Serialize(imgList);
Application[Constants.FRONT_PAGE_IMG_API_CACHE] = serializedResult;
}
Response.Write(Application[Constants.FRONT_PAGE_IMG_API_CACHE]);
}
示例7: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
DBManager db = new DBManager();
db.Connect();
List<FrontImageDAO> storedImagesList = db.GetAllFrontPageImages();
db.Close();
foreach(FrontImageDAO img in storedImagesList)
{
Panel_UploadedImage ui = (Panel_UploadedImage)LoadControl("~/Panel/UploadedImage.ascx");
ui.fileName = img.fileName;
ui.path = img.path;
ui.link = img.link;
pictureList.Controls.Add(ui);
}
}
示例8: deleteButton_Click
protected void deleteButton_Click(object sender, EventArgs e)
{
try
{
DBManager db = new DBManager();
db.Connect();
db.DeleteFrontPageImage(fileName);
db.Close();
File.Delete(Server.MapPath("~/" + path + "/" + fileName));
Application[Constants.FRONT_PAGE_IMG_API_CACHE] = null;
Response.Redirect(Request.RawUrl);
}
catch (Exception ex)
{
throw ex;
}
}
示例9: UploadButton_Click
protected void UploadButton_Click(object sender, EventArgs e)
{
if (FileUploadControl.HasFile)
{
try
{
string filename = Path.GetFileName(FileUploadControl.FileName);
string path = Server.MapPath("~/uploaded_images/");
//if (File.Exists(path + filename))
//{
// StatusLabel.Text = "File name already exists. Please choose another file name";
// return;
//}
FileUploadControl.SaveAs(path + filename);
DBManager db = new DBManager();
db.Connect();
db.InsertNewPicture(filename, Constants.IMG_FOLDER, "");
db.Close();
StatusLabel.Text = "Upload status: File uploaded!";
Application[Constants.FRONT_PAGE_IMG_API_CACHE] = null;
Response.Redirect(Request.RawUrl);
}
catch (Exception ex)
{
StatusLabel.Text = "Upload status: The file could not be uploaded. The following error occured: " + ex.Message;
}
}
}