public bool CreateMaterial(BOL.tbl_Material M) { string cmdStr = @"insert into tbl_Material (MaterialPath,WorkShopId) values (@MaterialPath,@WorkShopId)"; SqlConnection con = new SqlConnection(conStr); SqlCommand cmd = new SqlCommand(cmdStr, con); cmd.Parameters.AddWithValue("@MaterialPath", M.MaterialPath); cmd.Parameters.AddWithValue("@WorkShopId", M.WorkShopId); con.Open(); cmd.ExecuteNonQuery(); con.Close(); return(true); }